hello, I'm in 4.4.2 I can't use the search function on my site, or view profiles, it says the core_search_index table is crashed and the automatic repair failed.
when trying to search:
IPS\Db\Exception: Table './mi/forums_core_search_index' is marked as crashed and last (automatic?) repair failed (144)
#0 /home/mi/public_html/forums/system/Db/Db.php(462): IPS\_Db->query('SHOW FULL COLUM...', true, false)
#1 /home/mi/public_html/forums/system/Db/Db.php(1924): IPS\_Db->forceQuery('SHOW FULL COLUM...')
#2 /home/mi/public_html/forums/system/Content/Search/Mysql/Query.php(1413): IPS\_Db->getTableDefinition('core_search_ind...')
#3 /home/mi/public_html/forums/system/Content/Search/Mysql/Query.php(1154): IPS\Content\Search\Mysql\_Query::termAsWordsArray('pre-order')
#4 /home/mi/public_html/forums/system/Content/Search/Mysql/Query.php(921): IPS\Content\Search\Mysql\_Query::matchClause('index_content,i...', 'pre-order', '+')
#5 /home/mi/public_html/forums/system/Content/Search/Mysql/Query.php(1265): IPS\Content\Search\Mysql\_Query->_searchWhereClause('pre-order', NULL, 17, 'and')
#6 /home/mi/public_html/forums/applications/core/modules/front/search/search.php(658): IPS\Content\Search\Mysql\_Query->search('pre-order', NULL, 17, 'and')
#7 /home/mi/public_html/forums/applications/core/modules/front/search/search.php(73): IPS\core\modules\front\search\_search->_results()
#8 /home/mi/public_html/forums/system/Dispatcher/Controller.php(96): IPS\core\modules\front\search\_search->manage()
#9 /home/mi/public_html/forums/system/Dispatcher/Dispatcher.php(152): IPS\Dispatcher\_Controller->execute()
#10 /home/mi/public_html/forums/index.php(13): IPS\_Dispatcher->run()
#11 {main}
when trying to see profiles:
SELECT COUNT(*) FROM `forums_core_search_index` AS `core_search_index` WHERE index_class='IPS\core\Statuses\Status' AND index_container_id=1
IPS\Db\Exception: Table './madonnai_forums2019/forums_core_search_index' is marked as crashed and last (automatic?) repair failed (144)
#0 /home/mi/public_html/forums/system/Db/Select.php(373): IPS\_Db->preparedQuery('/*IPS\\Content\\S...', Array, true)
#1 /home/mi/public_html/forums/system/Db/Select.php(436): IPS\Db\_Select->runQuery()
#2 /home/mi/public_html/forums/system/Db/Select.php(355): IPS\Db\_Select->rewind()
#3 /home/mi/public_html/forums/system/Content/Search/Mysql/Query.php(293): IPS\Db\_Select->first()
#4 /home/mi/public_html/forums/applications/core/modules/front/members/profile.php(240): IPS\Content\Search\Mysql\_Query->filterForProfile(Object(IPS\Member))
#5 /home/mi/public_html/forums/system/Dispatcher/Controller.php(96): IPS\core\modules\front\members\_profile->manage()
#6 /home/mi/public_html/forums/applications/core/modules/front/members/profile.php(73): IPS\Dispatcher\_Controller->execute()
#7 /home/mi/public_html/forums/system/Dispatcher/Dispatcher.php(152): IPS\core\modules\front\members\_profile->execute()
#8 /home/mi/public_html/forums/index.php(13): IPS\_Dispatcher->run()
#9 {main}
when I check my dabatase on cpanel it shows this
[forums_core_search_index] Table is marked as crashed and last repair failed
[forums_core_search_index] 3 clients are using or haven't closed the table properly
[forums_core_search_index] Found 72 keys of 783707
I've tried the Support tool with "Something isn't working correctly" and nothing. This all started with a big server spike because of high traffic.
Any help?
Thank you.