October 3, 2019 in Technical Problems
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()
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.
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.
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
This topic is now archived and is closed to further replies.
Started Tuesday at 09:20 AM
Started 3 hours ago