MYSQL ERROR PANEL | |
Error on this page: | threadview.html |
sqlstr Number: | 11001 |
Error Line Number: | 925 |
Function Name: | GetThreadviewInfo |
mysql_die Error Number: | 1064 |
mysql_die Error: | 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 'ORDER BY PostID ASC LIMIT 1) AS PostSubject, (SELECT TagID FROM UserPosts LE' at line 10 |
mysql_die Query: | SELECT SuppCatID, SuppCatName, LOWER(REPLACE(SuppCatName,' ','-')) AS SuppCatDash, (SELECT COUNT(ThreadID) FROM (SELECT ThreadID FROM UserPosts WHERE UserPosts.SuppCatID='' GROUP BY ThreadID LIMIT 1) AS CategoryTable) AS CategoryCount, (SELECT COUNT(*) FROM tblSupplierCategories WHERE SuppCatID='' GROUP BY CompanyID LIMIT 1) AS SuppCatCount, (SELECT PostSubject FROM UserPosts WHERE ThreadID= ORDER BY PostID ASC LIMIT 1) AS PostSubject, (SELECT TagID FROM UserPosts LEFT JOIN tblSupplierCategoryList USING (SuppCatID)WHERE tblSupplierCategoryList.SuppCatID='' LIMIT 1) AS TagID, @CompanyID:=(SELECT UserPosts.CompanyID FROM UserPosts WHERE ThreadID= LIMIT 1) AS CompanyID, @CompanyName:=(SELECT Company FROM tblCompanyInfo WHERE tblCompanyInfo.CompanyID=@CompanyID LIMIT 1) AS CompanyName, IF(@CompanyID=0,'general',@CompanyName) AS CompanyName FROM tblSupplierCategoryList AS SuppCatList WHERE SuppCatID='' |
SITE NAME: | www.canadian-money-advisor.ca |
Main PHP Script: | /threadview.html |
REDIRECT_URL: | /threadview/547.html |
HTTP_REFERER: | /site-map-posts.html |
REQUEST_METHOD: | GET |
QUERY_STRING: | ThreadID=547 |
REMOTE_ADDR: | 207.241.237.102 |
HTTP_USER_AGENT: | Mozilla/5.0 (compatible; archive.org_bot +http://www.archive.org/details/archive.org_bot) |
We apologize for the error..
Our technician has been sent an email notifying him of this error. It will be fixed very shortly. |