why i am getting this error?

Henry Kuo

Platinum Member
Mar 3, 2000
2,248
0
0
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

Diamond Member
Oct 9, 1999
5,071
2
81
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! :D
 

Henry Kuo

Platinum Member
Mar 3, 2000
2,248
0
0
Thanks DaZ. Now for once, when i click on your profile I got that error :)

I am sure Zuni sees this, hee...
 

Henry Kuo

Platinum Member
Mar 3, 2000
2,248
0
0
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 :D
 

Henry Kuo

Platinum Member
Mar 3, 2000
2,248
0
0
yeah, it is much better now, thanks!

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

WeirdZen

Senior member
May 18, 2000
207
0
0
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