Error with datatable in users screen #979

Closed
opened 2026-10-05 00:26:27 +02:00 by adam · 2 comments
Owner

Unable to view/add users.

Please see attached.

I am using latest version.

image

Unable to view/add users. Please see attached. I am using latest version. ![image](https://user-images.githubusercontent.com/13346687/69492221-8e7b1a80-0ec5-11ea-8179-0df12e8295e5.png) <!-- github-sync-id:527667898 -->
adam closed this issue 2026-10-05 00:26:27 +02:00
Author
Owner

groups is a reserved word as of MySQL 8.0.2. To fix this, wrap groups with single backticks ` here https://github.com/Piwigo/Piwigo/blob/master/admin/user_list_backend.php#L204

`groups` is a [reserved word](https://dev.mysql.com/doc/refman/8.0/en/keywords.html) as of MySQL 8.0.2. To fix this, wrap `groups` with single backticks ` here https://github.com/Piwigo/Piwigo/blob/master/admin/user_list_backend.php#L204 <!-- github-comment-id:559233607 -->
Author
Owner

Duplicate of #1095. Fixed by pull request #1117. Please integrate into master.

Duplicate of #1095. Fixed by pull request #1117. Please integrate into master. <!-- github-comment-id:559338025 -->
Sign in to join this conversation.
No labels
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: adam/Piwigo#979