Help with Gallery problem if anyone can please?

- 197 Posts
jonahnaylor Reply #1, 10 years, 1 month ago

Hi I'm having a problem with galleries no longer showing images in the modx manager.

I posted here but haven't had a reply back yet:

https://github.com/modxcms/Gallery/issues/72

The Modx Gallery seems to break with PHP7 and MySQL 5.7

Thanks again for any help.
Yorkshire UK based hosting provider: https://www.simulant.uk
- 197 Posts
jonahnaylor Reply #2, 10 years ago

Hi again, Jako seems to have identified the issue with the following:

This is a MySQL 5.7 issue and could be fixed by adding the column siteusername.AlbumItems.rank to the SELECT query.

but I still don't know how to actually fix this? Can anyone help at all? How do I add that to the SELECT query? Thanks for any help.
Yorkshire UK based hosting provider: https://www.simulant.uk