Gallery icon indicating copy to clipboard operation
Gallery copied to clipboard

Published 20 hours ago • verified publisher icon modxcms

Fix SQL queries with "rank" in MySQL 8

Open halftrainedharry opened this issue 2 years ago • 4 comments

In MySQL 8 RANK is a reserved keyword. Because both classes galAlbum and galAlbumItem have a field called "rank", there are SQL queries that fail. This PR should fix it.

Related forum topic: https://community.modx.com/t/solved-problem-persists-with-gallery-2-0-0-not-displaying-images-in-manager/5558

halftrainedharry avatar Jul 31 '22 20:07 halftrainedharry

This pull request has been mentioned on MODX Community. There might be relevant details there:

https://community.modx.com/t/gallery-manager-does-not-show-images/5618/16

rthrash avatar Aug 03 '22 11:08 rthrash

This pull request has been mentioned on MODX Community. There might be relevant details there:

https://community.modx.com/t/gallery-not-showing-prettyphoto-inlet-after-upgrading-modx-to-2-8-4-and-gallery-to-2-0-0/5622/4

rthrash avatar Aug 04 '22 11:08 rthrash

This pull request has been mentioned on MODX Community. There might be relevant details there:

https://community.modx.com/t/gallery-with-mysql8-0/6506/2

rthrash avatar Mar 09 '23 20:03 rthrash

@opengeek Is it possible to merge this PR? It will bring MySQL 8 compatibility to this package.

LitvK avatar Jun 11 '23 11:06 LitvK