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
14.0.0.beta3 Backend “Settings”-“Options” page shows SQL statement error
This is a GitHub Issue
repo:Piwigo
owner:Piwigo
Title : 14.0.0.beta3 Backend “Settings”-“Options” page shows SQL statement error
Issue date:

--- start body ---
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
--- end body ---
