adam/Piwigo
1
0 Fork 0
mirror of https://github.com/Piwigo/Piwigo.git synced 2026-10-30 21:52:00 +01:00
Code Issues 657 Packages Projects Releases Wiki Activity

Can't view users #1392

New Issue
Open
opened 2026-10-05 00:42:04 +02:00 by adam · 1 comment
adam commented 2026-10-05 00:42:04 +02:00
Owner
Copy link
Copy source

I just set up a brand-new, self-hosted Piwigo instance (this was shockingly hard, by the way!), and the Users table wasn't loading correctly in the admin interface. There was this error in the network tab:

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 WHERE name LIKE '%%'' at line 1
SELECT id FROM groups WHERE name LIKE '%%'; in /data/www/default/photos/include/dblayer/functions_mysqli.inc.php on line 847
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /data/www/default/photos/include/dblayer/functions_mysqli.inc.php:211 Stack trace: #0 /data/www/default/photos/include/ws_functions/pwg.users.php(49): pwg_db_fetch_assoc(false) #1 /data/www/default/photos/include/ws_core.inc.php(600): ws_users_getList(Array, Object(PwgServer)) #2 /data/www/default/photos/include/ws_protocols/rest_handler.php(41): PwgServer->invoke('pwg.users.getLi...', Array) #3 /data/www/default/photos/include/ws_core.inc.php(281): PwgRestRequestHandler->handleRequest(Object(PwgServer)) #4 /data/www/default/photos/ws.php(22): PwgServer->run() #5 {main} thrown in /data/www/default/photos/include/dblayer/functions_mysqli.inc.php on line 211

After following that stack trace to this line, I fixed it by adding my database name to the query. Should Piwigo USE the database before calling this? Or is there some config I can add so mysqld always USEs the correct database?

I just set up a brand-new, self-hosted Piwigo instance (this was shockingly hard, by the way!), and the Users table wasn't loading correctly in the admin interface. There was this error in the network tab: ``` 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 WHERE name LIKE '%%'' at line 1 SELECT id FROM groups WHERE name LIKE '%%'; in /data/www/default/photos/include/dblayer/functions_mysqli.inc.php on line 847 Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /data/www/default/photos/include/dblayer/functions_mysqli.inc.php:211 Stack trace: #0 /data/www/default/photos/include/ws_functions/pwg.users.php(49): pwg_db_fetch_assoc(false) #1 /data/www/default/photos/include/ws_core.inc.php(600): ws_users_getList(Array, Object(PwgServer)) #2 /data/www/default/photos/include/ws_protocols/rest_handler.php(41): PwgServer->invoke('pwg.users.getLi...', Array) #3 /data/www/default/photos/include/ws_core.inc.php(281): PwgRestRequestHandler->handleRequest(Object(PwgServer)) #4 /data/www/default/photos/ws.php(22): PwgServer->run() #5 {main} thrown in /data/www/default/photos/include/dblayer/functions_mysqli.inc.php on line 211 ``` After following that stack trace to [this line](https://github.com/Piwigo/Piwigo/blob/master/include/ws_functions/pwg.users.php#L47), I fixed it by adding my database name to the query. Should Piwigo USE the database before calling this? Or is there some config I can add so mysqld always USEs the correct database? <!-- github-sync-id:1090093640 -->
adam commented 2026-10-05 00:42:05 +02:00
Author
Owner
Copy link
Copy source

Hello
check at the bottom what the issue really is:
https://github.com/Piwigo/Piwigo/wiki/Technical-changes-in-Piwigo-12

Hello check at the bottom what the issue really is: https://github.com/Piwigo/Piwigo/wiki/Technical-changes-in-Piwigo-12 <!-- github-comment-id:1002258930 -->
Sign in to join this conversation.
No Branch/Tag Specified
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
adam (Adam Wojcieszonek)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: adam/Piwigo#1392