Print Page - got a databse query error

Title: got a databse query error
Post by: kahuamo on September 06, 2004, 09:50:46 PM

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

Title: Re: got a databse query error
Post by: Joachim Müller on September 07, 2004, 06:34:58 AM

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

Joachim

Title: Re: got a databse query error
Post by: kahuamo on September 07, 2004, 04:34:25 PM

EDITED

Thanks in advance

Title: Re: got a databse query error
Post by: kegobeer on September 07, 2004, 04:58:00 PM

I keep getting Login incorrect. Can you verify the user/pass you posted?

Title: Re: got a databse query error
Post by: kahuamo on September 07, 2004, 05:05:28 PM

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

Thanks in advance

Title: Re: got a databse query error
Post by: kahuamo on September 07, 2004, 05:22:46 PM

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

coppermine-gallery.com/forum

Support => Older/other versions => cpg1.3.x Support => Topic started by: kahuamo on September 06, 2004, 09:50:46 PM