Announcement

#1 2015-05-14 18:13:37

Michael950
Member
2012-07-14
5

mysql error 1064 - You have an error in your SQL syntax

I received an error, and have posted what I did to correct the matter.  I'm not sure if this is something that you'd want to add as a control or autocheck to validate things before/after done:

Error:
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 '17)' at line 3

  SELECT id, name, permalink
    FROM piwigo_categories
    WHERE id IN (,17)
  ; in /home2/public_html/photos/include/dblayer/functions_mysqli.inc.php on line 830


Fatal error: Call to a member function fetch_assoc() on a non-object in /home2/mhealey7/public_html/photos/include/dblayer/functions_mysqli.inc.php on line 883

Cause:
Deleted all albums from site after configuring community plugin

Logged in as user and Uploading new photos via site (not as admin)

admin tools lists:
Undefined index: in /home2/public_html/photos/include/functions_html.inc.php on line 133

Piwigo version:
        Operating system: Linux
        PHP: 5.4.38 (Show info) [2015-05-14 11:06:07]
        MySQL: 5.5.42-37.1 [2015-05-14 11:06:07]
        Graphics Library: ImageMagick 6.7.6-8

Resolution:
I corrected this by reconfiguring community albums.
reCreated community album, moved users album under community.

Offline

 

Board footer

Powered by FluxBB

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