[Solved]: There was an error while processing a database query Please help

[spikeeds]

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

[Joachim Müller]

Post even less information - we're mind readers and just need to look into our magic crystal balls...

[spikeeds]

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?

[Hein Traag]

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?

[spikeeds]

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?

[Hein Traag]

Not to my knowledge. Try the EnlargeIT plugin.

[Joachim Müller]

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.