DB error

[cykelmyggen]

I'm getting loads of these errors, tried to solve this by posting a ticket to vb, who told me the error was on the server side. Contacted my host who didn't see any errors on their side.
BTW there is no table named : "/tmp/#sql_2f4_5.MYI'" - not that I can find anyway!?
Any help would be much appreciated.

Database Error Notification

Invalid SQL: SELECT [URL="http://p.thread/"]p.thread[/URL]id  AS thread_id, [URL="http://p.postid/"]p.postid[/URL] AS  post_id,
[URL="http://f.forumi/"]f.forumi[/URL]d AS  forum_id, [URL="http://f.title/"]f.title[/URL] AS  forum_name, [URL="http://t.title/"]t.title[/URL] AS title,  [URL="http://t.visibl/"]t.visibl[/URL]e,
[URL="http://p.pagete/"]p.pagete[/URL]xt As message, [URL="http://u.userid/"]u.userid[/URL] as userid, [URL="http://u.userna/"]u.userna[/URL]me as username,
[URL="http://p.dateli/"]p.dateli[/URL]ne AS postdate
    FROM vbpost p
    LEFT JOIN vbthread t ON [URL="http://t.thread/"]t.thread[/URL]id  = [URL="http://p.thread/"]p.thread[/URL]id
    LEFT JOIN vbuser u   ON [URL="http://u.userid/"]u.userid[/URL]    = [URL="http://p.userid/"]p.userid[/URL]
    LEFT JOIN vbforum f  ON [URL="http://f.forumi/"]f.forumi[/URL]d   = [URL="http://t.forumi/"]t.forumi[/URL]d  WHERE ([URL="http://f.forumi/"]f.forumi[/URL]d = 2)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 83)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 43)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 84)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 3)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 85)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 20)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 86)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 15)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 87)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 12)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 4)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 89)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 5)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 96)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 21)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 90)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 17)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 95)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 16)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 92)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 18)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 93)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 29)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 94)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 72)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 19)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 78)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 33)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 9)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 80)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 81)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 11)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 34)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 99)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 75)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 71)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 42)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 36)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 26)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 24)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 14)  OR ([URL="http://f.forumi/"]f.forumi[/URL]d = 98)  AND  [URL="http://t.visibl/"]t.visibl[/URL]e = 1
      AND [URL="http://p.parent/"]p.parent[/URL]id = 0 AND  [URL="http://t.firstp/"]t.firstp[/URL]ostid = [URL="http://p.postid/"]p.postid[/URL]  ORDER BY thread_id  DESC, [URL="http://p.dateli/"]p.dateli[/URL]ne ASC  

Error: Incorrect key file for table '/tmp/#sql_2f4_[URL="http://5.myi/"]5.MYI[/URL]'; try to repair it 

Error number: 126 
Date: 'Friday 7th of May 2010 09:15:01 AM

[a legacy reborn]

hmmmm link plz we need to be able to reproduce same error

[cykelmyggen]

Here you are:

http://www.boggnasker.dk/vbforum/index.php

[borbole]

Can you first rty to run an optimizing/repair of all your db tables at the phpmyadmin?

[cykelmyggen]

Of cause I can - done it a lot of times when getting this error - unfortunately without any effect at all!

[Trevor Hannant]

Run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

AdminCP > Maintenance > Repair/Optimize Tables

If that doesn't work then this may be too damaged to fix with the normal methods. Please check out this thread for other ways to repair a db, particularly items #2 and 3:

http://www.vbulletin.com/forum/showthread.php?s=&threadid=44909

You may have to ask your host to try and repair this for you.

[cykelmyggen]

I'm suspecting a certain Plugin to be the bad guy in this error - I'm investigating if deactivating this Plugin will stop this error. So far I haven't received any error messages since yesterday, so maybe this might be the reason for my troubles.
BTW I have been running the optimize procedure as suggested - I guess if not fixing the errors it wouldn't do any harm!