🌍
English
Trying to open the "Move" page under Albums in the admin area (admin.php?page=cat_move) results in an error:
Piwigo encountered an unrecoverable error. [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 ',status, uppercats FROM pwg_categories' at line 1 SELECT id,name,rank,status, uppercats FROM pwg_categories ; #1 my_error /usr/local/piwigo/include/dblayer/functions_mysqli.inc.php(132) #2 pwg_query /usr/local/piwigo/include/dblayer/functions_mysqli.inc.php(888) #3 query2array /usr/local/piwigo/admin/cat_move.php(138) #4 include /usr/local/piwigo/admin.php(314)
Seems to be the use of "rank". I had to edit cat_move.php to escape that column with backticks:
// +-----------------------------------------------------------------------+ // | Album display | // +-----------------------------------------------------------------------+ //Get all albums $query = ' SELECT id,name,`rank`,status, uppercats FROM '.CATEGORIES_TABLE.' ;'; $allAlbum = query2array($query);
Offline
I created a pull request.
Offline
Thanks. I gotta remember that I can do that myself next time. :)
Offline
erAck wrote:
I created a pull request.
And it's now merged. Thank you :-)
Offline