Hi, I have an error when I try to synchronize:
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 ')
AND status = 'private'' at line 4
SELECT
id
FROM piwigo_categories
WHERE id IN ()
AND status = 'private'
; in /var/www/piwigo/include/dblayer/functions_mysql.inc.php on line 654
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/piwigo/include/dblayer/functions_mysql.inc.php on line 200
I started getting this error a short time after installing the plugin, 'Virtual AutoGrant.' I uninstalled it but I still get the same error.
Bill
Offline
Hi Billr,
This is a bug from Piwigo (not Virtual AutoGrant plugin).
[Bugtracker] ticket 2378
The problem only during at the simulation. There is no risk when you synchronize, all photos will be added correctly.
We are sorry for the inconvenience.
Offline
Thanks Gotcha. No inconvenience. I'm just glad it's not something I need to fix. I'm also glad I can reinstall Virtual Autogrant now.
Bill
Offline