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

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]

Originally Posted by Paul M

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
Jelsoft will get the problem solve.