I have Gallery 1.7.1-pl and MODX Revolution 2.6.5-pl installed, Ubuntu 18.04 and MySQL 8.0 if it matters.
So, I've successfully installed Gallery and can upload files, but they do not show up in album view. "No files match the specified filter."
I've double checked that files do exist in file manager and correctly shown in assets/gallery
ModX Error log shows the following line when I open the album page in manager:
[2018-09-21 18:43:18] (ERROR @ /usr/share/nginx/artroilencom/core/xpdo/om/xpdoobject.class.php : 240) Error 42000 executing statement:
 => 42000
 => 1064
 => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC LIMIT 20' at line 4
This line is for error debug information, nothing to do with the error itself.