Tweet
I upgraded to Gold last week and haven't had any problems at all UNTIL last night when my ISP moved our dedicated server to a new database center.
As soon as they brought our server back online I began receiving the following error e-mails:
Database error in vBulletin 3.0.0:
Invalid SQL:
SELECT NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid,
deletionlog.username AS del_username, deletionlog.reason AS del_reason,
threadrate.vote,
thread.*
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid = thread.threadid AND deletionlog.type = 'thread')
LEFT JOIN threadrate AS threadrate ON (threadrate.threadid = thread.threadid AND threadrate.userid = 27)
WHERE thread.threadid = 20379
mysql error: Can't find file: 'thread.MYI' (errno: 2)
mysql error number: 1017
And when I go to our forums I can see the forum index, but when I enter an individual forum in order to view threads I get this browser error:
Database error in vBulletin 3.0.0:
Invalid SQL:
SELECT COUNT(*) AS threads,
SUM(IF(lastpost>=1080805552 AND open<>10,1,0)) AS newthread
FROM thread AS thread
WHERE forumid = 112
AND sticky = 0
AND visible = 1
AND lastpost >= 1078213923
mysql error: Can't find file: 'thread.MYI' (errno: 2)
mysql error number: 1017
Finally, when I run optimize/repair from the Admin CP I get the following errors:
postindex Check Error: Can't find file: 'postindex.MYI' (errno: 2)
thread Check Error: Can't find file: 'thread.MYI' (errno: 2)
So what happened to "postindex.MYI" and "thread.MYI" ??.
What can I do to fix this situation?
As soon as they brought our server back online I began receiving the following error e-mails:
Database error in vBulletin 3.0.0:
Invalid SQL:
SELECT NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid,
deletionlog.username AS del_username, deletionlog.reason AS del_reason,
threadrate.vote,
thread.*
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid = thread.threadid AND deletionlog.type = 'thread')
LEFT JOIN threadrate AS threadrate ON (threadrate.threadid = thread.threadid AND threadrate.userid = 27)
WHERE thread.threadid = 20379
mysql error: Can't find file: 'thread.MYI' (errno: 2)
mysql error number: 1017
And when I go to our forums I can see the forum index, but when I enter an individual forum in order to view threads I get this browser error:
Database error in vBulletin 3.0.0:
Invalid SQL:
SELECT COUNT(*) AS threads,
SUM(IF(lastpost>=1080805552 AND open<>10,1,0)) AS newthread
FROM thread AS thread
WHERE forumid = 112
AND sticky = 0
AND visible = 1
AND lastpost >= 1078213923
mysql error: Can't find file: 'thread.MYI' (errno: 2)
mysql error number: 1017
Finally, when I run optimize/repair from the Admin CP I get the following errors:
postindex Check Error: Can't find file: 'postindex.MYI' (errno: 2)
thread Check Error: Can't find file: 'thread.MYI' (errno: 2)
So what happened to "postindex.MYI" and "thread.MYI" ??.
What can I do to fix this situation?
Comment