Error "Syntax"

arial4 :rolleyes:

I receive the following message:
Error No.1064.
" 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 chrStatus'= 1' at line 1.
Can somebody please help me ?

bdhonline

Newbie Poster

5 posts since Sep 2004

Reputation Points: 10

Solved Threads: 0

7 Years Ago

0

Um... can you give us some description of the environment in which this is happening? What version of Windows? What program is barfing the error? When did the problem start happening?

DMR

Wombat At Large

Team Colleague

7,229 posts since Dec 2003

Reputation Points: 221

Solved Threads: 370

7 Years Ago

0

Um... can you give us some description of the environment in which this is happening? What version of Windows? What program is barfing the error? When did the problem start happening?

Hi!Marsupial Moderator.
Thanks for the response. I am using Windows ME,and I only have this problem when I log in to the site www.photographers.com . I only noticed this problem a week ago when I attempted to log in to the site,and there is no specific problem with any others.

bdhonline

Newbie Poster

5 posts since Sep 2004

Reputation Points: 10

Solved Threads: 0

7 Years Ago

0

Ah, OK- that makes things a bit clearer I think. It sounds like the error is actually on the server's side. I'm not going to register with them to see if I can replicate the problem on any of my machines (privacy issues and all that), but does this happen immediately upon you entering your membername and password, or does it happen when you try to go deeper into the site?

DMR

Wombat At Large

Team Colleague

7,229 posts since Dec 2003

Reputation Points: 221

Solved Threads: 370

7 Years Ago

0

Ah, OK- that makes things a bit clearer I think. It sounds like the error is actually on the server's side. I'm not going to register with them to see if I can replicate the problem on any of my machines (privacy issues and all that), but does this happen immediately upon you entering your membername and password, or does it happen when you try to go deeper into the site?

:rolleyes: Hi! This happens when I enter my member' name and password.Thanks.

bdhonline

Newbie Poster

5 posts since Sep 2004

Reputation Points: 10

Solved Threads: 0

7 Years Ago

0

See if you can email a description of your problem to the administrator or webmaster of that site. As I said, since you only get the error at their site, I do think it's related to something specific to their database implementation.

DMR

Wombat At Large

Team Colleague

7,229 posts since Dec 2003

Reputation Points: 221

Solved Threads: 370

7 Years Ago

0

See if you can email a description of your problem to the administrator or webmaster of that site. As I said, since you only get the error at their site, I do think it's related to something specific to their database implementation.

Thank you !

bdhonline

Newbie Poster

5 posts since Sep 2004

Reputation Points: 10

Solved Threads: 0

7 Years Ago

0

You're welcome. Let us know what they have to say- I'd be interested to know what the root of the problem is.

DMR

Wombat At Large

Team Colleague