Sea Shepherd
08-12-2010, 12:59 AM
Hi All,
Our forum Suddenly went down and displays this error:
Please help! Any Ideas?
EDIT: Home Page opens but every forum and link displays a SQL error...
__________________________________________________ _____
Database error in vBulletin 4.0.3:
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.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
thread.prefixid, thread.taglist, hiddencount, deletedcount,
user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadredirect.expires
FROM vb_thread AS thread
LEFT JOIN vb_user AS user ON (user.userid = thread.lastposterid)
LEFT JOIN vb_userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 1)
LEFT JOIN vb_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN vb_subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
LEFT JOIN vb_post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN vb_threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
WHERE thread.threadid IN (0,10702,10781,10796,10680,10618,10605,10576,7972, 10403,10330,9761,9532,8448,8694,9506,9508,9507,934 6,9332,8643,9505,14)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Incorrect key file for table './og_forum/vb_post.MYI'; try to repair it
Error Number : 126
Request Date : Thursday, August 12th 2010 @ 11:56:54 AM
Error Date : Thursday, August 12th 2010 @ 11:56:55 AM
Script : http://www.oceanguardians.org/forum/forumdisplay.php?20-Welcome
Referrer : http://www.oceanguardians.org/forum/forum.php
IP Address : 203.***********
Username : *****
Classname : vB_Database
MySQL Version : 5.0.32-Debian_7etch10-log
--------------- Added 1281579338 at 1281579338 ---------------
Hmmm.
Seems to be fixed.
Getting random SQL Errors.
I repaired all the tables and reset counters.
Deactivated the less important addons and now updating to latest V.
Seems to have fixed it.
Will wait and see.
Our forum Suddenly went down and displays this error:
Please help! Any Ideas?
EDIT: Home Page opens but every forum and link displays a SQL error...
__________________________________________________ _____
Database error in vBulletin 4.0.3:
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.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
thread.prefixid, thread.taglist, hiddencount, deletedcount,
user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadredirect.expires
FROM vb_thread AS thread
LEFT JOIN vb_user AS user ON (user.userid = thread.lastposterid)
LEFT JOIN vb_userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 1)
LEFT JOIN vb_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN vb_subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
LEFT JOIN vb_post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN vb_threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
WHERE thread.threadid IN (0,10702,10781,10796,10680,10618,10605,10576,7972, 10403,10330,9761,9532,8448,8694,9506,9508,9507,934 6,9332,8643,9505,14)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Incorrect key file for table './og_forum/vb_post.MYI'; try to repair it
Error Number : 126
Request Date : Thursday, August 12th 2010 @ 11:56:54 AM
Error Date : Thursday, August 12th 2010 @ 11:56:55 AM
Script : http://www.oceanguardians.org/forum/forumdisplay.php?20-Welcome
Referrer : http://www.oceanguardians.org/forum/forum.php
IP Address : 203.***********
Username : *****
Classname : vB_Database
MySQL Version : 5.0.32-Debian_7etch10-log
--------------- Added 1281579338 at 1281579338 ---------------
Hmmm.
Seems to be fixed.
Getting random SQL Errors.
I repaired all the tables and reset counters.
Deactivated the less important addons and now updating to latest V.
Seems to have fixed it.
Will wait and see.