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

14.0.0.beta3 Backend “Settings”-“Options” page shows SQL statement error #1764

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

Hello, I tried to upgrade from 13.8.0 to 14.0.0.beta2 and 14.0.0.beta3 according to the method of https://piwigo.org/guides/update/manual. I encountered the same problem when upgrading these two versions, that is, after the upgrade, an SQL error occurred when accessing the “Settings”-“Options” page in the administrator background. I did not find any related posts about this error. I will paste the error information output after accessing admin.php?page=configuration below. Please tell me what I did wrong?Thank you.

My environment:
PHP: 8.1.25
MySQL: 8.0.35-0ubuntu0.22.04.1

Error message:

Fatal error: Uncaught mysqli_sql_exception: 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' at line 4 in example.com/include/dblayer/functions_mysqli.inc.php:132 Stack trace:

#0 example.com/include/dblayer/functions_mysqli.inc.php(132): mysqli->query()
#1 example.com/include/dblayer/functions_mysqli.inc.php(888): pwg_query()
#2 example.com/admin/configuration.php(407): query2array()
#3 example.com/admin.php(346): include('...')
#4 {main} thrown in example.com/include/dblayer/functions_mysqli.inc.php on line 132

Hello, I tried to upgrade from 13.8.0 to 14.0.0.beta2 and 14.0.0.beta3 according to the method of https://piwigo.org/guides/update/manual. I encountered the same problem when upgrading these two versions, that is, after the upgrade, an SQL error occurred when accessing the “Settings”-“Options” page in the administrator background. I did not find any related posts about this error. I will paste the error information output after accessing admin.php?page=configuration below. Please tell me what I did wrong?Thank you. My environment: PHP: 8.1.25 MySQL: 8.0.35-0ubuntu0.22.04.1 Error message: > Fatal error: Uncaught mysqli_sql_exception: 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' at line 4 in example.com/include/dblayer/functions_mysqli.inc.php:132 Stack trace: > > #0 example.com/include/dblayer/functions_mysqli.inc.php(132): mysqli->query() > #1 example.com/include/dblayer/functions_mysqli.inc.php(888): pwg_query() > #2 example.com/admin/configuration.php(407): query2array() > #3 example.com/admin.php(346): include('...') > #4 {main} thrown in example.com/include/dblayer/functions_mysqli.inc.php on line 132 <!-- github-sync-id:1985097636 -->
adam closed this issue 2026-10-05 00:55: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#1764