The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
What is this database error saying?
hello
for last few days i'm having hundreds of this error reporting to my email but i have not changed anything , i dont know what caused this , please have a look and let me know if u have any clue : Code:
Database error in vBulletin 4.0.6: Invalid SQL: SELECT thread.threadid, thread.title, thread.prefixid, post.attach, thread.postusername, thread.dateline, thread.lastpostid, thread.lastpost, thread.lastposterid, thread.lastposter, thread.replycount, forum.forumid, forum.title_clean as forumtitle, post.pagetext AS message, post.allowsmilie, post.postid, user.* ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight FROM thread AS thread INNER JOIN forum AS forum ON(forum.forumid = thread.forumid) LEFT JOIN post AS post ON (post.postid = thread.firstpostid) LEFT JOIN user AS user ON (thread.postuserid = user.userid) LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) WHERE 1=1 AND thread.forumid IN(46,47,48,74,72,71,76,77,94,75,90,89,91,92,97,99,88,93,87,96,95,64,59,40,43,73,81,80,82,83,63,57,58,56,70,42,69,50,49,51,53,54,52,55,44,78,79,41,45,84,85,86,3,6,4,5,98,7) AND thread.visible = 1 AND post.visible = 1 AND open <> 10 AND thread.lastpost > 1299662410 ORDER BY thread.lastpost DESC LIMIT 0,5; MySQL Error : Incorrect key file for table '/tmp/#sql_502d_1.MYI'; try to repair it Error Number : 126 Request Date : Friday, April 8th 2011 @ 02:20:10 AM Error Date : Friday, April 8th 2011 @ 02:20:10 AM Script : http://www.******.com/ Referrer : IP Address : ****** Username : Unregistered Classname : vB_Database MySQL Version : |
#2
|
||||
|
||||
<a href="http://www.vbulletin.com/forum/showthread.php/38834-Database-error-message-(incorrect-key-file-for-table" target="_blank">http://www.vbulletin.com/forum/showt...file-for-table</a>)
|
#3
|
||||
|
||||
yes that fixes it but i wonder what causes this?
|
#4
|
||||
|
||||
Mostly this error occurrs when there is not enough space for the drive your temporary directory is located at. |
#5
|
||||
|
||||
How does that equate to a corrupted table?
|
#6
|
||||
|
||||
anyway what boofo suggested works fine , repairing tables through admincp
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|