Hello/Hi/Greetings,

I recently upgraded my V2.4 database to the current version that's used by Piwigo 14.5.  It took me a long time to figure out why some albums wouldn't display and generated an SQL error.  As it turned out, the albums had manual sort orders and "rank" became a keyword in SQL at some point, hence the need to quote the field name.

May I suggest that the upgrade.php also do the following:

UPDATE piwigo_categories SET image_order = "'rank' ASC" WHERE image_order = "rank ASC";

which fixes that problem.

-- Geoff