Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: There was an error while processing a database query  (Read 2050 times)

0 Members and 1 Guest are viewing this topic.

Goad

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
There was an error while processing a database query
« on: December 04, 2007, 07:13:39 pm »

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?
Logged

Nibbler

  • Guest
Re: There was an error while processing a database query
« Reply #1 on: December 04, 2007, 07:16:20 pm »

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
Logged

Goad

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
Re: There was an error while processing a database query
« Reply #2 on: December 04, 2007, 07:48:50 pm »

Code: [Select]
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

Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 20 queries.