Hello/Hi/Greetings,

I have a stand-alone freebsd server hosting piwigo 2.10.1,  mysql 8.0, php7.3.  I have another freebsd server hosting piwigo 2.95.  On both, I upgraded from mysql 5.7 to 8.0.  I did this by exporting the mysql 5.7 database (with piwigo 2.95) using phpMyAdmin, then importing the same database to the new server with mysql 8.0 (with piwigo 2.10.1) using phpMyAdmin.  All went well except that the following plugins now give the following errors:

PWG Stuffs:
---------------------Error below:--------------------
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, show_title, id_line, width
FROM pw_stuffs
LEFT JOIN pw_user_group
  O' at line 1

SELECT DISTINCT id, name, path, datas, groups, show_title, id_line, width
FROM pw_stuffs
LEFT JOIN pw_user_group
  ON user_id = 1
WHERE (users IS NULL OR users LIKE "%webmaster%")
  AND (groups IS NULL OR groups REGEXP CONCAT("(^|,)",group_id,"(,|$)"))
  AND level <= 8
  AND on_home = "true"
ORDER BY pos ASC
; in /usr/local/www/piwigo/include/dblayer/functions_mysqli.inc.php on line 854


Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /usr/local/www/piwigo/include/dblayer/functions_mysqli.inc.php:235 Stack trace: #0 /usr/local/www/piwigo/plugins/PWG_Stuffs/class.inc.php(73): pwg_db_fetch_assoc(false) #1 /usr/local/www/piwigo/plugins/PWG_Stuffs/class.inc.php(35): stuffs->get_modules() #2 /usr/local/www/piwigo/plugins/PWG_Stuffs/main.inc.php(53): stuffs->__construct() #3 /usr/local/www/piwigo/include/functions_plugins.inc.php(279): load_stuffs() #4 /usr/local/www/piwigo/index.php(43): trigger_notify('loc_begin_index') #5 {main} thrown in /usr/local/www/piwigo/include/dblayer/functions_mysqli.inc.php on line 235

------------- The error goes away if the plugin is deactivated-------------

Same behavior with plugin Advanced Menu Manager:

--------------Begin Error:--------------------
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
          FROM pw_amm_blocks
          ORDER BY `order`' at line 1
SELECT id, `order`, users, groups
          FROM pw_amm_blocks
          ORDER BY `order`; in /usr/local/www/piwigo/include/dblayer/functions_mysqli.inc.php on line 854

------------The error goes away when I disable the plugin--------------
I have 21 other plugins working properly with mysql8.0.  I suspect the problem comes from new 'reserved' words used by mysql 8, this time 'groups'.  This is a problem recognized and corrected for reserved word 'rank' in piwigo/include/dblayer/functions_mysqli.inc.php.  I have tried mimicking the code for the work 'groups' without success.

Is there a fix for either the code in the plugins or functions_mysqli.inc.php?  Or is this a different problem?



Piwigo version: Piwigo 2.95 and 2.10.1
PHP version: 7.3
MySQL version: Migrating from 5.7 to 8.0
Piwigo URL: http://

Hope to see a fix for PWG Stuffs and for Advanced Menu Manager.  Both are great and have been useful.
All other 21 plugins that I use work well.  Let me know if I can clarify further what I have done so far.

2otherjobs