why i am getting this error?

[Henry Kuo]

after switching to the new version, when i check on the status of people (by clicking on the profile icon on the post), i got this error sometimes, anyone knows why?

Error Occurred While Processing Request

Error Diagnostic Information

ODBC Error Code = 37000 (Syntax error or access violation)

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.

SQL = "select * from stateprovince where istateprovid ="

Data Source = "ANANDTECHFORUMS"

The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (108:14) to (108:61) in the template file
D:\INETPUB\WWWROOT\ANANDFORUMS\TOMBSTONE.CFM.

Date/Time: 09/09/00 20:56:15
Browser: Mozilla/4.72 [en] (X11; U; Linux 2.2.14-5.0 i586)
Remote Address: 4.xxx.xx.xxx
HTTP Referer: http://forums.anandtech.com/messageview.cfm?start=41&catid=38&threadid=230342
Query String: ProfileID=9266&catid=38&threadid=230342

 

[dawks]

Probably just a little bug in the new code that needs to be fixed, im sure it will be soon. Nice of you to point it out! 😀

 

[Henry Kuo]

Thanks DaZ. Now for once, when i click on your profile I got that error 🙂

I am sure Zuni sees this, hee...

 

[Mr.IncrediblyBored]

Yea ditto on the error. I've been getting it for the past few hours.

 

[JimMc]

I get it randomly also.

 

[Jason Clark]

Thanks guys will look at it.

 

[Jason Clark]

K that should do it.

 

[Henry Kuo]

Zuni, not really. i just clicked on your profile and Paulson's, and still got this error:

Error Occurred While Processing Request

Error Diagnostic Information

ODBC Error Code = 37000 (Syntax error or access violation)

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.

SQL = "select * from stateprovince where istateprovid ="

Data Source = "ANANDTECHFORUMS"

The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (107:13) to (107:60) in the template file
D:\INETPUB\WWWROOT\ANANDFORUMS\TOMBSTONE.CFM.

Date/Time: 09/09/00 22:00:00
Browser: Mozilla/4.72 [en] (X11; U; Linux 2.2.14-5.0 i586)
Remote Address: 4.xxx.xxx.xxx
HTTP Referer: http://forums.anandtech.com/messageview.cfm?catid=42&threadid=230478
Query String: ProfileID=572&catid=42&threadid=230478

Seems to be the same errror as before. Take your time though, this is not that important, and you are definitely doing a great job 😀

 

[Jason Clark]

Try Now.

 

[Henry Kuo]

yeah, it is much better now, thanks!

I can finally look at Paulson's profile, wahaha!!!

 

[WeirdZen]

i havn't had a problem for a couple of days now. Good job, It seems to load faster too, it could just be the local backbone too. who knows