Hi
I'm getting this one frequently and can't figure out how to fix it. I'm on a hosted server and I haven't got access to any tmp-based tables.
Anyone experienced a similar error and found a cure. Any help would be appreciated:
Database Error Notification
Invalid SQL: SELECT p.threadid AS thread_id, p.postid AS post_id,
f.forumid AS forum_id, f.title AS forum_name, t.title AS title, t.visible,
p.pagetext As message, u.userid as userid, u.username as username,
p.dateline AS postdate
FROM vbpost p
LEFT JOIN vbthread t ON t.threadid = p.threadid
LEFT JOIN vbuser u ON u.userid = p.userid
LEFT JOIN vbforum f ON f.forumid = t.forumid WHERE (f.forumid = 2) OR (f.forumid = 43) OR (f.forumid = 3) OR (f.forumid = 20) OR (f.forumid = 15) OR (f.forumid = 12) OR (f.forumid = 4) OR (f.forumid = 5) OR (f.forumid = 21) OR (f.forumid = 17) OR (f.forumid = 16) OR (f.forumid = 18) OR (f.forumid = 29) OR (f.forumid = 72) OR (f.forumid = 19) OR (f.forumid = 78) OR (f.forumid = 33) OR (f.forumid = 9) OR (f.forumid = 11) OR (f.forumid = 34) OR (f.forumid = 75) OR (f.forumid = 71) OR (f.forumid = 59) OR (f.forumid = 42) OR (f.forumid = 36) OR (f.forumid = 24) OR (f.forumid = 14) OR (f.forumid = 53) OR (f.forumid = 54) OR (f.forumid = 55) AND t.visible = 1
AND p.parentid = 0 AND t.firstpostid = p.postid ORDER BY thread_id DESC, p.dateline ASC
Error: Incorrect key file for table '/tmp/#sql_3de1_7.MYI'; try to repair it
Error number: 126
Date: 'Tuesday 19th of May 2009 05:05:46 PM
Filename: /index.php
URI (cleaned): /
I'm getting this one frequently and can't figure out how to fix it. I'm on a hosted server and I haven't got access to any tmp-based tables.
Anyone experienced a similar error and found a cure. Any help would be appreciated:
Database Error Notification
Invalid SQL: SELECT p.threadid AS thread_id, p.postid AS post_id,
f.forumid AS forum_id, f.title AS forum_name, t.title AS title, t.visible,
p.pagetext As message, u.userid as userid, u.username as username,
p.dateline AS postdate
FROM vbpost p
LEFT JOIN vbthread t ON t.threadid = p.threadid
LEFT JOIN vbuser u ON u.userid = p.userid
LEFT JOIN vbforum f ON f.forumid = t.forumid WHERE (f.forumid = 2) OR (f.forumid = 43) OR (f.forumid = 3) OR (f.forumid = 20) OR (f.forumid = 15) OR (f.forumid = 12) OR (f.forumid = 4) OR (f.forumid = 5) OR (f.forumid = 21) OR (f.forumid = 17) OR (f.forumid = 16) OR (f.forumid = 18) OR (f.forumid = 29) OR (f.forumid = 72) OR (f.forumid = 19) OR (f.forumid = 78) OR (f.forumid = 33) OR (f.forumid = 9) OR (f.forumid = 11) OR (f.forumid = 34) OR (f.forumid = 75) OR (f.forumid = 71) OR (f.forumid = 59) OR (f.forumid = 42) OR (f.forumid = 36) OR (f.forumid = 24) OR (f.forumid = 14) OR (f.forumid = 53) OR (f.forumid = 54) OR (f.forumid = 55) AND t.visible = 1
AND p.parentid = 0 AND t.firstpostid = p.postid ORDER BY thread_id DESC, p.dateline ASC
Error: Incorrect key file for table '/tmp/#sql_3de1_7.MYI'; try to repair it
Error number: 126
Date: 'Tuesday 19th of May 2009 05:05:46 PM
Filename: /index.php
URI (cleaned): /
Comment