Greetings,
I'm using the Community plug-in in a testing environment - adding various users and working to get groups and permissions set up etc. Then I invariably hit a point where the program explodes:
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 '18)' at line 3
SELECT id, name, permalink
FROM piwigo_categories
WHERE id IN (,18)
; in /home/tommytdl/foto.rocktumblinghobby.com/include/dblayer/functions_mysqli.inc.php on line 845
Fatal error: Call to a member function fetch_assoc() on boolean in /home/tommytdl/foto.rocktumblinghobby.com/include/dblayer/functions_mysqli.inc.php on line 898
This explosion is always followed by mulltiple error messages at the top of the screen:
Notice: Undefined index: in /home/tommytdl/foto.rocktumblinghobby.com/include/functions_html.inc.php on line 140
Piwigo 2.9.0
Operating system: Linux
PHP: 5.6.29 (Show info) [2017-05-23 13:59:41]
MySQL: 5.6.34-log [2017-05-23 13:59:41]
Graphics Library: ImageMagick 6.6.9-7
Last edited by tommytdl (2017-05-24 00:18:54)
Offline
I should add that I can't pin down specifically when it happens but THIS time when it happened the album I was selecting from the drop down list had a slash in front of the name that I did not put in.
See screenshot attached.
Offline
author notified
Offline
Thank you. I seem to have narrowed the problem down to the "Piwigo automatically creates an album..." feature and have developed a work around. If anyone is interested in the work around please let me know and I'll list the steps.
Offline