Hallo
I am still on MySql 5.6 and Piwigo 2.9.4 with theme Modus

Piwigo 2.9.4
Betriebssystem: Linux
PHP: 5.6.40 (Info anzeigen) [2019-04-04 02:30:15]
MySQL: 5.6.43 [2019-04-04 10:30:15]
Grafikbibliothek: External ImageMagick 6.7.2-7

My provider urges me to update to MySQL 5.7.

I am little insecure because I was reading some issues with MySQL 5.7 and Piwigo. Are they solved now or do you recommend to wait with the update.

Thank you for a short feedback.
daniel

PS: of couse i have a backup of the whole system ;-)

Shoot ... I just ran into this after upgrading my server to Ubuntu 19.10, which included MySQL 8.0. Lots of errors because 'groups' is a reserved word so it looks like any SELECT against that 'groups' table throws the warning:

Warning:  [mysql error 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 'groups ORDER BY name' at line 1
SELECT id, name FROM groups ORDER BY name in /usr/local/piwigo/include/dblayer/functions_mysqli.inc.php on line 856

Is there a quick fix to this? My problem seems related, but different, than the Github issue since it's the actual table name causing the problem (and not a 'group AS groups' syntax).

Thanks for the tip.

In addition to GrumPluginClasses I also found the problem in plugins/AMenuManager/amm_root.class.inc.php (lines 532 and 556) and also line 170 in plugins/AdditionalPages/admin/add_page.inc.php.

That fixed the errors.

Just ran into this again after updating to Advanced Menu Manager 3.2.13. Had to put the backticks around GROUPS_TABLE and groups again.