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: got a databse query error  (Read 4862 times)

0 Members and 1 Guest are viewing this topic.

kahuamo

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 27
got a databse query error
« 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
« Last Edit: September 08, 2004, 07:21:47 am by GauGau »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: got a databse query error
« Reply #1 on: September 07, 2004, 06:34:58 am »
please post a link to your site and a test user account (non-admin).

Joachim
Logged

kahuamo

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 27
Re: got a databse query error
« Reply #2 on: September 07, 2004, 04:34:25 pm »
EDITED


Thanks in advance


« Last Edit: September 08, 2004, 04:24:03 pm by kahuamo »
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: got a databse query error
« Reply #3 on: September 07, 2004, 04:58:00 pm »
I keep getting Login incorrect.  Can you verify the user/pass you posted?
Logged
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

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 27
Re: got a databse query error
« Reply #4 on: September 07, 2004, 05:05:28 pm »
Upppps sorry...... my mistake...... dumb of me



Thanks in advance
« Last Edit: September 08, 2004, 04:24:22 pm by kahuamo »
Logged

kahuamo

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 27
Re: got a databse query error
« Reply #5 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
 
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.022 seconds with 19 queries.