Piwigo.org

windracer · 2022-03-26 02:48:24

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:

Code:

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:

Code:

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)

windracer · 2022-04-04 23:04:00

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.

Piwigo.org

Announcement

#1 2022-03-26 02:48:24

13.0.0beta1: unrecoverable SQL error - root-level physical album

Code:

Code:

#2 2022-04-04 23:04:00

Re: 13.0.0beta1: unrecoverable SQL error - root-level physical album

Board footer