There was an error while processing a database query

[Goad]

I created a category then an album in that category, now i get this error "There was an error while processing a database query"

I removed the album and category, and the error still exists.

...any ideas?

[Nibbler]

Enable debug mode in config and post the MySQL error message (not the entire debug output) you get when you replicate the error. If you can't get into the config page see http://coppermine-gallery.net/tutorial/debug_mode.php

[Goad]

Code Select Expand

While executing query "SELECT COUNT(*) from cpg1410_pictures WHERE approved = 'YES' AND aid NOT IN ()" 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 ')' at line 1

I also recently installed this plug-in and found out that its related. I didn't notice that cpg was broken after I installed it. I uninstalled it and cpg worked again....so this is a plugin issue.

Link to plugin: http://forum.coppermine-gallery.net/index.php?topic=38999.0