| MYSQL ERROR PANEL | |
| Error on this page: | threadview.html |
| sqlstr Number: | 11001 |
| Error Line Number: | 831 |
| 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 edataxer_can' at line 10 |
| mysql_die Query: | SELECT SuppCatID, SuppCatName, LOWER(REPLACE(SuppCatName,' ','-')) AS SuppCatDash, (SELECT COUNT(ThreadID) FROM (SELECT ThreadID FROM edataxer_canadianmoneyadvisor.UserPosts WHERE UserPosts.SuppCatID='' GROUP BY ThreadID LIMIT 1) AS CategoryTable) AS CategoryCount, (SELECT COUNT(*) FROM edataxer_MasterBase.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 edataxer_canadianmoneyadvisor.UserPosts LEFT JOIN edataxer_MasterBase.tblSupplierCategoryList USING (SuppCatID)WHERE tblSupplierCategoryList.SuppCatID='' LIMIT 1) AS TagID, @CompanyID:=(SELECT CompanyID FROM UserPosts WHERE ThreadID= LIMIT 1) AS CompanyID, @CompanyName:=(SELECT Company FROM edataxer_MasterBase.tblCompanyInfo WHERE CompanyID=@CompanyID LIMIT 1) AS CompanyName, IF(@CompanyID=0,'general',@CompanyName) AS CompanyName FROM edataxer_MasterBase.tblSupplierCategoryList AS SuppCatList WHERE SuppCatID='' |
| SITE NAME: | www.canadian-money-advisor.ca |
| Main PHP Script: | /threadview.html |
| REDIRECT_URL: | /threadview/',UserPosts.ThreadID,'.html |
| HTTP_REFERER: | |
| REQUEST_METHOD: | GET |
| QUERY_STRING: | ThreadID=%27,UserPosts.ThreadID,%27 |
| REMOTE_ADDR: | 38.107.179.224 |
| HTTP_USER_AGENT: | CCBot/1.0 (+http://www.commoncrawl.org/bot.html) |
|
We apologize for the error..
Our technician has been sent an email notifying him of this error. It will be fixed very shortly. |
|