DB Error When Searching

[Adrian Schneider]

You guys are probably aware, but if not:

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

[Guest190829]

Thanks, I ran a repair on the table. :up:

[G0F0RBR0KE]

Lately vB.org is having database issue. Don't worry, our belove-it admin will solve this issue.

[Paul M]

I'm afraid we won't - we are in the hands of Jelsoft as far as server issues are concerned.

[G0F0RBR0KE]

I'm afraid we won't - we are in the hands of Jelsoft as far as server issues are concerned.

Than it's time for me to step in :confused:
Jelsoft will get the problem solve.