got a databse query error got a databse query error
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

got a databse query error

Started by kahuamo, September 06, 2004, 09:50:46 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

kahuamo

Some user, and some nto got this error:
There was an error while processing a database query.
If i put debug mode and log in as a user with this error i got this:

While executing query "SELECT count(*) FROM cpg11d_albums as a WHERE category = '0' and AND a.aid NOT IN (244) " 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 'AND a.aid NOT IN (244)' at line 1

Do you know what is wrong?

Thanks

Joachim Müller

please post a link to your site and a test user account (non-admin).

Joachim

kahuamo

#2
EDITED


Thanks in advance



kegobeer

I keep getting Login incorrect.  Can you verify the user/pass you posted?
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

kahuamo

#4
Upppps sorry...... my mistake...... dumb of me



Thanks in advance

kahuamo

I knew what happen, i applyed this hack:
http://forum.coppermine-gallery.net/index.php?topic=9540.0
and this error happened, so no i disable the anycontent and everything works the most strage thing is that only some users got the error and some not