| Adrian Schneider |
07-12-2007 05:35 AM |
DB Error When Searching
You guys are probably aware, but if not:
Code:
Database error in vBulletin 3.6.7:
Invalid SQL:
SELECT thread.threadid
FROM thread AS thread
LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 59835)
INNER JOIN forum AS forum ON (forum.forumid = thread.forumid)
LEFT JOIN forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 59835)
WHERE thread.forumid IN(1, 2, 203, 94, 26, 92, 111, 15, 168, 172, 197, 173, 12, 7, 13, 14, 112, 30, 184, 219, 210, 218, 211, 187, 188, 221, 217, 189, 198, 191, 194, 192, 109, 113, 155, 32, 33, 34, 134, 3, 4, 5, 139, 99, 101, 102, 104, 105, 170, 174, 171, 182, 223, 224, 31, 202, 185, 6, 107, 106, 103, 100, 164, 212, 195, 196, 161, 162, 135, 137, 140, 141, 213, 216, 124, 123, 215, 214, 125)
AND thread.lastpost > IF(threadread.readtime IS NULL, 1183361560, threadread.readtime)
AND thread.lastpost > IF(forumread.readtime IS NULL, 1183361560, forumread.readtime)
AND thread.lastpost > 1183361560
AND thread.visible IN (0,1,2)
AND thread.sticky IN (0,1)
AND thread.open < 10
ORDER BY thread.lastpost DESC
LIMIT 500;
MySQL Error : Table 'thread' is marked as crashed and should be repaired
Error Number : 1194
Date : Thursday, July 12th 2007 @ 02:32:40 AM
Script : https://vborg.vbsupport.ru/search.php?do=getnew
Referrer : https://vborg.vbsupport.ru/
IP Address : x.x.x.x
Username : SirAdrian
Classname : vB_Database
|
More Information