Hi,

On selecting one of the photos I get this error message. Other photos seem unaffected.

Warning:  [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 3

SELECT id, name, permalink
  FROM piwigo_categories
  WHERE id IN () in /share/CACHEDEV1_DATA/Web/piwigoupd/include/dblayer/functions_mysqli.inc.php on line 847

Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /share/CACHEDEV1_DATA/Web/piwigoupd/include/dblayer/functions_mysqli.inc.php:900 Stack trace: #0 /share/CACHEDEV1_DATA/Web/piwigoupd/include/functions.inc.php(1530): query2array('\nSELECT id, nam...', 'id') #1 /share/CACHEDEV1_DATA/Web/piwigoupd/picture.php(965): hash_from_query('\nSELECT id, nam...', 'id') #2 {main} thrown in /share/CACHEDEV1_DATA/Web/piwigoupd/include/dblayer/functions_mysqli.inc.php on line 900


This is with v 12.2, it was fine using v 11.5.
Thanks for any assistance in resolving this.

(Copy here your environment details, found on your Piwigo page [Administration > Tools > Maintenance])

    Piwigo 12.2.0 Check for upgrade
    Operating system: Linux
    PHP: 7.3.7 (Show info) [2022-06-30 16:17:02]
    MySQL: 5.5.68-MariaDB [2022-06-30 16:17:02]
    Graphics Library: ImageMagick 6.9.4-8
    Cache size N/A   never calculated Refresh