Announcement

  •  » Extensions
  •  » Fatal errors using Community plug-in

#1 2017-05-24 00:17:14

tommytdl
Member
2017-05-23
20

Fatal errors using Community plug-in

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

 

#2 2017-05-24 00:22:14

tommytdl
Member
2017-05-23
20

Re: Fatal errors using Community plug-in

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

 

#3 2017-05-28 23:10:31

flop25
Piwigo Team
2006-07-06
7037

Re: Fatal errors using Community plug-in

author notified


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#4 2017-05-29 22:14:17

tommytdl
Member
2017-05-23
20

Re: Fatal errors using Community plug-in

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

 
  •  » Extensions
  •  » Fatal errors using Community plug-in

Board footer

Powered by FluxBB

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