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

[12.1] user manager loads forever with MySQL 8 #1365

New Issue
Closed
opened 2026-10-05 00:40:57 +02:00 by adam · 0 comments
adam commented 2026-10-05 00:40:57 +02:00
Owner
Copy link
Copy source

If you have no prefix on table names, your groups table is groups, which is, as we all know now, a reserved keyword in MySQL 8.

In the user manager, the frontend performs an AJAX query on pwg.users.getList and it fails because:

[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 include/dblayer/functions_mysqli.inc.php on line 847

  1. the "groups" word should be escaped by backticks
  2. why do we send a filter "%%" by default?
If you have no prefix on table names, your groups table is `groups`, which is, as we all know now, a reserved keyword in MySQL 8. In the user manager, the frontend performs an AJAX query on `pwg.users.getList` and it fails because: > [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 include/dblayer/functions_mysqli.inc.php on line 847 1) the "groups" word should be escaped by backticks 2) why do we send a filter "%%" by default? <!-- github-sync-id:1051756972 -->
adam closed this issue 2026-10-05 00:40:57 +02:00
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#1365