This morning we woke to over 10,000 vBulletin database error messages like these:
This is an odd one involving cron
Our db that is almost 1Gb is now 300Mb. Yes, we have backups, but no point restoring and opening the forum if we don't know what happened. Any help will be appreciated.Bob
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open,
postusername, postuserid, thread.iconid AS threadiconid,
thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount,
IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
thread.prefixid, thread.taglist, hiddencount, deletedcount
FROM vb_thread AS thread
LEFT JOIN vb_post AS post ON(post.postid = thread.firstpostid)
WHERE thread.threadid IN
(0,14947,116546,139360,14901,138141,104331,130312,135082,14963,130815,129718,129632,128528 ,18878,128272,128005,113170,102149,41294,120257)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Table './dbname/vb_post' is marked as crashed and last
(automatic?) repair failed
Error Number : 144
Request Date : Wednesday, December 28th 2011 @ 08:20:23 AM
Error Date : Wednesday, December 28th 2011 @ 08:20:23 AM
Script : http://www.volvoforums.org.uk/forumdisplay.php?f=59
Referrer :
IP Address : 83.145.232.94
Username : Unregistered
Classname : vB_Database
MySQL Version :
Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open,
postusername, postuserid, thread.iconid AS threadiconid,
thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount,
IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
thread.prefixid, thread.taglist, hiddencount, deletedcount
FROM vb_thread AS thread
LEFT JOIN vb_post AS post ON(post.postid = thread.firstpostid)
WHERE thread.threadid IN
(0,14947,116546,139360,14901,138141,104331,130312,135082,14963,130815,129718,129632,128528 ,18878,128272,128005,113170,102149,41294,120257)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Table './dbname/vb_post' is marked as crashed and last
(automatic?) repair failed
Error Number : 144
Request Date : Wednesday, December 28th 2011 @ 08:20:23 AM
Error Date : Wednesday, December 28th 2011 @ 08:20:23 AM
Script : http://www.volvoforums.org.uk/forumdisplay.php?f=59
Referrer :
IP Address : 83.145.232.94
Username : Unregistered
Classname : vB_Database
MySQL Version :
Invalid SQL:
DELETE FROM vb_posthash
WHERE dateline < 1325035427;
MySQL Error : Incorrect key file for table './dbname/vb_posthash.MYI'; try to repair it
Error Number : 126
Request Date : Wednesday, December 28th 2011 @ 01:28:47 AM
Error Date : Wednesday, December 28th 2011 @ 01:28:48 AM
Script : http://www.volvoforums.org.uk/cron.php?rand=1325035723
Referrer : http://www.volvoforums.org.uk/index.php
IP Address : 2.223.13.245
Username : Unregistered
Classname : vB_Database
MySQL Version :
DELETE FROM vb_posthash
WHERE dateline < 1325035427;
MySQL Error : Incorrect key file for table './dbname/vb_posthash.MYI'; try to repair it
Error Number : 126
Request Date : Wednesday, December 28th 2011 @ 01:28:47 AM
Error Date : Wednesday, December 28th 2011 @ 01:28:48 AM
Script : http://www.volvoforums.org.uk/cron.php?rand=1325035723
Referrer : http://www.volvoforums.org.uk/index.php
IP Address : 2.223.13.245
Username : Unregistered
Classname : vB_Database
MySQL Version :
Comment