Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Soluna16 Posted October 3, 2019 Posted October 3, 2019 My site went down a few days ago with the following error, can anyone who can read this point me in the right direction? SELECT MIN(forums_posts.pid) FROM `x_utf_forums_posts` AS `forums_posts` WHERE forums_posts.topic_id=27925 AND forums_posts.post_date>1569938170 AND forums_posts.queued!=-2 AND forums_posts.queued!=-3 IPS\Db\Exception: Table './andrew09_cfbhc_forum/x_utf_forums_posts' is marked as crashed and last (automatic?) repair failed (144) #0 /var/www/cfbhc/system/Db/Select.php(373): IPS\_Db->preparedQuery('/*IPS\\Content\\_...', Array, true) #1 /var/www/cfbhc/system/Db/Select.php(436): IPS\Db\_Select->runQuery() #2 /var/www/cfbhc/system/Db/Select.php(355): IPS\Db\_Select->rewind() #3 /var/www/cfbhc/system/Content/Item.php(3694): IPS\Db\_Select->first() #4 /var/www/cfbhc/applications/forums/sources/Topic/Topic.php(1861): IPS\Content\_Item->_comments('IPS\\forums\\Topi...', 1, 0, 'post_date asc', NULL, true, Object(IPS\DateTime), NULL, NULL, false, NULL) #5 /var/www/cfbhc/system/Content/Controller.php(1480): IPS\forums\_Topic->comments(1, NULL, 'date', 'asc', NULL, NULL, Object(IPS\DateTime)) #6 /var/www/cfbhc/system/Dispatcher/Controller.php(85): IPS\Content\_Controller->getNewComment() #7 /var/www/cfbhc/system/Content/Controller.php(50): IPS\Dispatcher\_Controller->execute() #8 /var/www/cfbhc/applications/forums/modules/front/forums/topic.php(39): IPS\Content\_Controller->execute() #9 /var/www/cfbhc/system/Dispatcher/Dispatcher.php(152): IPS\forums\modules\front\forums\_topic->execute() #10 /var/www/cfbhc/index.php(14): IPS\_Dispatcher->run() #11 {main} I tried repairing all the tables in my MySQL database but it did nothing. I can access the site but the last thread is showing -1 posts if that's related.
Soluna16 Posted October 3, 2019 Author Posted October 3, 2019 I tried repairing that table through ubuntu and it seemingly worked but crashed another table. Posts are now possible but every post is duplicated 4-5 times on posting.
Rhett Posted October 3, 2019 Posted October 3, 2019 This is a hosting side item, get with your host to, one, fix the crashed tables, and two, to correct why it's crashing causing table corruption. Table './andrew09_cfbhc_forum/x_utf_forums_posts' is marked as crashed
Recommended Posts
Archived
This topic is now archived and is closed to further replies.