forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: spikeeds on May 20, 2009, 09:41:53 am

Title: [Solved]: There was an error while processing a database query Please help
Post by: spikeeds on May 20, 2009, 09:41:53 am
Here is the Debug info


While executing query "SELECT * FROM cpg_pictures WHERE approved = 'YES' AND aid IN (1,3,4,5,9)  ORDER BY RAND() LIMIT -1" on 0

mySQL error: 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 '-1' at line 1
Title: Re: There was an error while processing a database query Please help
Post by: Joachim Müller on May 20, 2009, 09:55:10 am
Post even less information - we're mind readers and just need to look into our magic crystal balls... ::)
Title: Re: There was an error while processing a database query Please help
Post by: spikeeds on May 20, 2009, 11:09:32 am
Every time i click a picture it says There was an error while processing a database query.  I already activated the debug mode. And that's what it came out. How to fix it?
Title: Re: There was an error while processing a database query Please help
Post by: Hein Traag on May 20, 2009, 12:35:49 pm
Post some more info such as website URL, which cpg version you are using. What were you doing when you got this error? Were you uploading or what else?
Title: Re: There was an error while processing a database query Please help
Post by: spikeeds on May 21, 2009, 07:26:08 am
Problem solved. There was a problem with the lightbox plugin i remove it and the error was gone. I love that plugin, anyways have you guys experience that problem in lightbox?
Title: Re: There was an error while processing a database query Please help
Post by: Hein Traag on May 21, 2009, 11:57:14 am
Not to my knowledge. Try the EnlargeIT plugin.
Title: Re: There was an error while processing a database query Please help
Post by: Joachim Müller on May 21, 2009, 04:42:34 pm
Problem solved.
Marking as solved then (something that you should have done).
One issue per thread as per board rules - you shouldn't have asked another question in this thread. Locking.