Announcement

#1 2022-06-30 17:23:16

JAK
Member
2013-07-07
59

mysql error 1064

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

Offline

 

#2 2022-06-30 18:13:59

JAK
Member
2013-07-07
59

Re: mysql error 1064

Just to add, the 12.3 update hasn't resolved this issue.

Offline

 

#3 2022-06-30 19:23:55

JAK
Member
2013-07-07
59

Re: mysql error 1064

Pleased to report I've solved this.
The photo had been in an album used by the plugin Back2Front but seems it had lost its album association during the update to 12.2..

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2022 · Contact