Since upgrading my beta/test site to Piwigo 13.0.0beta1, I am encountering SQL errors on a physical album at the root level of my gallery. When I try to open the album, I get:
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 'ASC' at line 7 SELECT DISTINCT(image_id) FROM pwg_image_category INNER JOIN pwg_images ON id = image_id WHERE category_id = 37 ORDER BY rank ASC ; #1 my_error /usr/local/piwigo-beta/include/dblayer/functions_mysqli.inc.php(132) #2 pwg_query /usr/local/piwigo-beta/include/dblayer/functions_mysqli.inc.php(888) #3 query2array /usr/local/piwigo-beta/include/section_init.inc.php(317) #4 include /usr/local/piwigo-beta/index.php(12)
If I edit the album from the admin pages and then click "Manage album photos", I get this:
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 'ASC LIMIT 20 OFFSET 0' at line 6 SELECT id,path,representative_ext,file,filesize,level,name,width,height,rotation FROM pwg_images JOIN pwg_image_category ON id = image_id WHERE id IN (428,429,430,431,434,955,956) AND category_id = 37 ORDER BY rank ASC LIMIT 20 OFFSET 0 ; #1 my_error /usr/local/piwigo-beta/include/dblayer/functions_mysqli.inc.php(132) #2 pwg_query /usr/local/piwigo-beta/admin/batch_manager_global.php(721) #3 include /usr/local/piwigo-beta/admin/batch_manager.php(814) #4 include /usr/local/piwigo-beta/admin.php(320)
There are physical sub-albums under that high-level album and I can directly navigate to them just fine.
I'm running MySQL: 8.0.28-0ubuntu0.21.10.3.
Last edited by windracer (2022-04-04 22:56:00)
Offline
I was able to figure this out since it was only happening on one root-level physical album. I had to change the "Photos sort order" from "Manual order" to "Use the default photo sort order" and I was then able to navigate to the album from the root gallery. After that, I was able to switch back to "Manual order" and re-sort the photos. Not sure what got messed up there.
Offline