search

plegall / Piwigo-community

11 stars 23 forks source link

[mysql error 1064] after clicking the settings button #75

Closed github-luckow-org closed 7 months ago

github-luckow-org commented 1 year ago

Piwigo version 12.3.0 Community plugin version 12.a MySQL version 8.0.27

Installing and activating works without any problems. After clicking on Settings the following error message is displayed:



SELECT
    id,
    name
  FROM groups
; in /app/code/include/dblayer/functions_mysqli.inc.php on line 847

Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /app/code/include/dblayer/functions_mysqli.inc.php:211 Stack trace: #0 /app/data/plugins/community/admin_permissions.php(314): pwg_db_fetch_assoc() #1 /app/data/plugins/community/admin.php(111): include('/app/data/plugi...') #2 /app/code/admin/plugin.php(53): include_once('/app/data/plugi...') #3 /app/code/admin.php(320): include('/app/code/admin...') #4 {main} thrown in /app/code/include/dblayer/functions_mysqli.inc.php on line 211```
jamaa commented 1 year ago

Same here. This is afaik due to groups being a reserved keyword in MySQL 8