You haven't lived until you've been spanked -- properly -- by a robot. Um. I have yet to experience this problem (touch wood), though it has been much slower to load the last couple of weeks.
Well it happened...while i was at home this morning. Now i am at work and it seems fine, but this is what i get when its down. Error Occurred While Processing Request Error Diagnostic Information Request timed out The time taken to process your request has exceeded the allowable limit of 60 seconds. Please notify the server administrator (using the mail link below) that this error has occurred. Note: You can override the request time limit by adding a 'RequestTimeout' parameter to the URL used to request the page (e.g. page.cfm?RequestTimeout=500). SQL = "SELECT users.user_name, L.link_ID, L.link_url, L.link_urldescription, DATEname(weekday, L.link_date) AS link_day, L.link_date, L.user_ID, L.hide, L.link_description, L.category_ID, (SELECT COUNT(C.comment_ID) AS totComments FROM comment AS C WHERE C.Link_ID = L.Link_ID AND C.hide = 0) AS totComments, categories.category_ID, categories.category_name , (SELECT COUNT(*) AS totNewComments FROM comment AS C2 WHERE C2.Link_ID = L.Link_ID AND C2.hide = 0 AND C2.Comment_date > {ts '2004-12-13 13:59:36'}) AS totNewComments , (SELECT TOP 1 comment_id AS firstNewComment FROM comment AS C WHERE C.Link_ID = L.Link_ID AND C.Comment_date > {ts '2004-12-13 13:59:36'} ORDER BY C.Comment_date ASC) AS firstNewComment FROM link AS L, users, categories WHERE L.link_date > {ts '2004-11-30 07:21:45'} AND users.user_ID = L.user_ID AND L.category_ID = categories.category_ID AND L.hide = 0 ORDER BY L.link_date DESC" Data Source = "SPORTSFILTER" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (70:1) to (70:49) in the template file D:
Inetpubwwwrootsportsfilterspor
tsfilter.comwwwrootindex.cfm. Date/Time: 12/14/04 07:25:01 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322) Remote Address: 67.176.184.47
Hello?
I get the same error as SF every once in awhile, such as just before hitting the refresh button for this reading (it came up the second time, clearly).
It happens to me all the time
Yeah, I get that error almost every day. I thought it was because I is European.
Booyaakasha! Probably don't want to paste all the site's SQL laundry into the site, but that's just the developer in me.
Sorry, i don't know shit about what i posted, i just thought it would help.
The query appears to be a set of select statements that simply grabs the comment count for the threads, as well as the new comments (so it can have that parentheses number like 7 comments (4 new) to take you right to the direct link of the oldest comment in that thread since you last visited the site) It means more generally that the SQL server that hosts all the site data itself was either unreachable (server rebooting/SQL recycling, etc) or that the query was too "expensive" or the db to slow, and as a result the web page timed out on waiting to get the data back so it could format it for you, the user. Instead just presented an error page- one that gives the actual SQL query used, which is bad form on the coder's part as yerfatma noted. It means most directly that, as rcade said, the host for sportsfilter is probably running out of capacity or is otherwise throttling the site (or far simpler, is just is having server issues behind the scenes, since there's probably a handful of servers clustered that handle dozens of databases for dozens of sites).
So does that mean it would just be down for a second and if i tried again it would be okay? Or that it would be down for a half hour up to 8 hours like it is for me sometimes? It happened again at 1pm...couldn't get on till now. Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 08001 (Unable to connect to data source) [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. SQL = "SELECT user_ID, user_name, last_visit FROM dbo.users WHERE users.user_id = 256" Data Source = "SPORTSFILTER" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (15:2) to (15:49) in the template file D:
Inetpubwwwrootsportsfilterspor
tsfilter.comwwwrootindex.cfm. Date/Time: 12/20/04 12:52:11 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322) Remote Address: 67.94.127.3
I got the same error, at about the same time.
