SQL error

Question

Level 1

19 points

SQL error

I cannot log into the forums in MacFixit with Safari. When I go to the home page, I am logged in. When I go to the forums, I get the following message

SQL ERROR: Unable to do_query: UPDATE w3t_Users SET U_SessionId = 'c064251d2c99adbee465c50f05bda944' WHERE U_Number =
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 3SQL ERROR: Unable to do_query: UPDATE w3t_Users SET U_SessionId = 'de65a3fb6d48ee7cd6f5f9309d16e3fb' WHERE U_Number =
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 3

and am logged out. I cannot log in. This only happens in Safari; I can use Firefox to log in and post. I cannot find any thing in Safari's preferences or in my network preferences about an SQL server. (In fact, I don't know anything about SQL servers, and have never installed one.)

This is a problem with safari only. Any suggestions as to what I can do to avoid this??

Thanks,
Nancy

Powerbook G4/1.67/1 Gb RAM Mac OS X (10.4.8)

Pwerbook G4, Mac OS X (10.4.5)

Posted on Nov 17, 2006 2:21 PM

Reply

Answer 1

iBod

Level 7

29,351 points

Nov 18, 2006 2:26 AM in response to malachite

Hi Nancy,

It's probably something specific to your MacFixit account details - the error is most definitely originating on their side.

Try clearing out your cookies via the Safari Preferences -> Security -> (Show Cookies) option. There's a chance they are performing a query based up some bad information stored in a cookie.

Also, try Safari in another user account if that makes no difference. This will help us to know whether your problem is local to your account or system wide. If you don't have another account you can use System Preferences -> Accounts -> [+] to create a test one (and [-] to remove it if needed).

Reply

Answer 2

iBod

Level 7

29,351 points

Nov 19, 2006 2:34 AM in response to malachite

Hurrah! Fingers crossed 😉

Reply

Answer 3

iBod

Level 7

29,351 points

Nov 17, 2006 2:45 PM in response to malachite

Hi Nancy,

The errors are all coming from the MacFixit site, not your machine. They might be using some information about your browser to make a query that is failing (that might explain why Firefox works normally).

Try checking again tomorrow, if there's still a problem post on the MacFixit forums with Firefox about this issue.

Reply

Answer 4

malachite Author

Level 1

19 points

Nov 17, 2006 5:43 PM in response to iBod

Thanks for your response. This problem has existed for at least 2 weeks, and maybe a couple of months. (I did have a problem a couiple of months ago, and they told me it was fixed. I then went on a vacation and didn't have a chance to see if I indeed could log in.) I did post it on MacFixit (with Firefox) and got several suggestions, none of which helped. I also emailed MacFixit with the problem; they responded by saying that they could log in with my ID with no problem. (I assume that they just logged into the home page, which also works for me.) I answered with this, but they never replied.

Any other ideas? If it's the macfixit site's fault, why does no one else have the problem?

Reply

Answer 5

malachite Author

Level 1

19 points

Nov 18, 2006 7:44 AM in response to iBod

Thanks for your suggestions. I have already tried both of those; in fact I reset Safari, which does a bunch more than just removing the cookies. I also had the same problem with the other user account that I have set up.

Any other suggestions?

Reply

Answer 6

iBod

Level 7

29,351 points

Nov 18, 2006 9:39 AM in response to malachite

Hi again,

Other than using Firefox for the time being, I can't really think of anything else to try. Do you use any internet security type software that might be filtering out some of the information you are sending to MacFixit that is then making it error out?

Reply

Answer 7

malachite Author

Level 1

19 points

Nov 18, 2006 5:29 PM in response to iBod

thanks for your help. I finally got an email from a tech person at macfixit, who said that the problem is from them not changing all files that contained my email address when it was changed. Hopefully, he will fix it.

Nasncy

Reply