SVTCobraLTD
02-19-2010, 11:26 AM
Database error in vBulletin 3.6.10:
Invalid SQL: SELECT post.pagetext AS preview, thread.threadid, thread.threadid AS postid, thread.title AS threadtitle, thread.iconid AS threadiconid, thread.dateline, thread.forumid, thread.replycount, IF(thread.views=0, thread.replycount+1, thread.views) as views, thread.sticky, thread.pollid, thread.open, thread.lastpost AS postdateline, thread.visible, thread.hiddencount, thread.deletedcount, thread.lastpost, thread.lastposter, thread.lastpostid, thread.attach, thread.postusername, thread.forumid, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason, user.userid AS postuserid , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed FROM thread AS thread LEFT JOIN user AS user ON(user.userid = thread.postuserid) LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread') LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1) LEFT JOIN post AS post ON(post.postid = thread.firstpostid) WHERE thread.threadid IN (12217, 12227, 12277, 12282, 12272, 12259, 11576, 9764, 12254, 12122, 12232, 12241, 12257, 12268, 12280, 12278, 12279, 12265, 12262, 11656, 7757, 12140, 12266, 8323, 6737);
MySQL Error : Table './[/post' is marked as crashed and last (automatic?) repair failedError
Number : 144
Date : Friday, February 19th 2010 @ 07:12:39 AM
Script : http://www.website.com/forums/search.php?searchid=211777
Referrer : http://www.website.com/forums/search.php?do=getnew
IP Address : XXXXXXXX
Username : Administrator
Classname : vB_Database
To restore it I optimized and repaired the tables. That seemed to fix it but the "post" table was giving me a lot of errors.
Invalid SQL: SELECT post.pagetext AS preview, thread.threadid, thread.threadid AS postid, thread.title AS threadtitle, thread.iconid AS threadiconid, thread.dateline, thread.forumid, thread.replycount, IF(thread.views=0, thread.replycount+1, thread.views) as views, thread.sticky, thread.pollid, thread.open, thread.lastpost AS postdateline, thread.visible, thread.hiddencount, thread.deletedcount, thread.lastpost, thread.lastposter, thread.lastpostid, thread.attach, thread.postusername, thread.forumid, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason, user.userid AS postuserid , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed FROM thread AS thread LEFT JOIN user AS user ON(user.userid = thread.postuserid) LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread') LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1) LEFT JOIN post AS post ON(post.postid = thread.firstpostid) WHERE thread.threadid IN (12217, 12227, 12277, 12282, 12272, 12259, 11576, 9764, 12254, 12122, 12232, 12241, 12257, 12268, 12280, 12278, 12279, 12265, 12262, 11656, 7757, 12140, 12266, 8323, 6737);
MySQL Error : Table './[/post' is marked as crashed and last (automatic?) repair failedError
Number : 144
Date : Friday, February 19th 2010 @ 07:12:39 AM
Script : http://www.website.com/forums/search.php?searchid=211777
Referrer : http://www.website.com/forums/search.php?do=getnew
IP Address : XXXXXXXX
Username : Administrator
Classname : vB_Database
To restore it I optimized and repaired the tables. That seemed to fix it but the "post" table was giving me a lot of errors.