Hello/Hi/Greetings,
Deleting some photos via batch manager caused the error below
Warning: [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 ')' at line 3
SELECT DISTINCT(image_id)
FROM PG_image_category
WHERE category_id IN ()
; in /home1/refakatc/public_html/medyastok.com/include/dblayer/functions_mysqli.inc.php on line 845
Fatal error: Call to a member function fetch_assoc() on boolean in /home1/refakatc/public_html/medyastok.com/include/dblayer/functions_mysqli.inc.php on line 906
Now I can't start the batch manager. It displays the error above. I need help.
Piwigo version: 2.9.3
PHP version: 5.6.36
MySQL version: 5.6.32-78.1
Piwigo URL: http://www.medyastok.com
Last edited by Fazli (2018-05-22 21:04:09)
Offline
search forum for "SQL syntax error". I found at least 3 people who solved the problem.
Offline
Thanks Executive,
I found out that Clearing the history of Google Chrome browser soved the problem.
Now I can use the batch manager properly.
Offline