If you don't have a prefix in your table names, there will be a table created called: "groups" which is a SQL keyword and MySQL struggles with the dynamic queries built by PHP. How I got around this is in the PHP code I safely escape all mentions to a table name using back-ticks. I believe this could be an easy patch fix, to add back ticks to escape table names when queries are being constructed.
Sudo code:
<?
$query = 'SELECT * FROM `'.$table.'` ORDER BY 1;';
?>
Otherwise can someone prescribe what needs to be done so if I go and update all my table tables, that my website will know that I added a prefix, post-install?
Offline
In the database change all your tables to have a prefix, like piwigo_... or pwg_... and change/add that in local/config/database.inc.php
$prefixeTable = 'piwigo_';
Offline
https://piwigo.org/forum/viewtopic.php?pid=181860
https://piwigo.org/forum/viewtopic.php? … 78#p181578
Last edited by windracer (2021-11-07 04:14:42)
Offline
[Github] Piwigo issue #1547 apparently fixed for 12.1.0
Offline