Hi recently one of the sites Mysql tables crashed, disabling the search button and ability to edit some items. I've tried looking up solutions on repairing it but wasn't able to come up with anything. Mysql version is 5.5.43
Any help would be greatly appreciated!
Error log is this:
2015-07-21T16:20:55-04:00 ERR (3): exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli prepare error: Table './omeka3/search_texts' is marked as crashed and should be repaired' in /srv/www/htdocs/qcarchives/civilrights/application/libraries/Zend/Db/Statement/Mysqli.php:77
Stack trace:
#0 /srv/www/htdocs/qcarchives/civilrights/application/libraries/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT `search_...')
#1 /srv/www/htdocs/qcarchives/civilrights/application/libraries/Zend/Db/Adapter/Mysqli.php(388): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT `search_...')
#2 /srv/www/htdocs/qcarchives/civilrights/application/libraries/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Adapter_Mysqli->prepare('SELECT `search_...')
#3 /srv/www/htdocs/qcarchives/civilrights/application/libraries/Zend/Db/Adapter/Abstract.php(756): Zend_Db_Adapter_Abstract->query(Object(Omeka_Db_Select), Array)
#4 [internal function]: Zend_Db_Adapter_Abstract->fetchRow(Object(Omeka_Db_Select), Array)
#5 /srv/www/htdocs/qcarchives/civilrights/application/libraries/Omeka/Db.php(79): call_user_func_array(Array, Array)
#6 /srv/www/htdocs/qcarchives/civilrights/application/libraries/Omeka/Db/Table.php(612): Omeka_Db->__call('fetchRow', Array)
#7 /srv/www/htdocs/qcarchives/civilrights/application/libraries/Omeka/Db/Table.php(612): Omeka_Db->fetchRow(Object(Omeka_Db_Select), Array)
#8 /srv/www/htdocs/qcarchives/civilrights/application/models/Table/SearchText.php(26): Omeka_Db_Table->fetchObject(Object(Omeka_Db_Select))
#9 /srv/www/htdocs/qcarchives/civilrights/application/models/Mixin/Search.php(117): Table_SearchText->findByRecord('File', 500)
#10 /srv/www/htdocs/qcarchives/civilrights/application/models/Mixin/Search.php(79): Mixin_Search::saveSearchText('File', 500, NULL, 'RobertRygor_B8F...', 1)
#11 [internal function]: Mixin_Search->afterSave(Array)
#12 /srv/www/htdocs/qcarchives/civilrights/application/libraries/Omeka/Record/AbstractRecord.php(251): call_user_func_array(Array, Array)
#13 /srv/www/htdocs/qcarchives/civilrights/application/libraries/Omeka/Record/AbstractRecord.php(280): Omeka_Record_AbstractRecord->delegateToMixins('afterSave', Array, true)
#14 /srv/www/htdocs/qcarchives/civilrights/application/libraries/Omeka/Record/AbstractRecord.php(550): Omeka_Record_AbstractRecord->runCallbacks('afterSave', Array)
#15 /srv/www/htdocs/qcarchives/civilrights/application/models/Item.php(251): Omeka_Record_AbstractRecord->save()
#16 [internal function]: Item->afterSave(Array)
#17 /srv/www/htdocs/qcarchives/civilrights/application/libraries/Omeka/Record/AbstractRecord.php(277): call_user_func(Array, Array)
#18 /srv/www/htdocs/qcarchives/civilrights/application/libraries/Omeka/Record/AbstractRecord.php(550): Omeka_Record_AbstractRecord->runCallbacks('afterSave', Array)
#19 /srv/www/htdocs/qcarchives/civilrights/application/libraries/Omeka/Controller/AbstractActionController.php(175): Omeka_Record_AbstractRecord->save(false)
#20 /srv/www/htdocs/qcarchives/civilrights/application/controllers/ItemsController.php(88): Omeka_Controller_AbstractActionController->editAction()
#21 /srv/www/htdocs/qcarchives/civilrights/application/libraries/Zend/Controller/Action.php(516): ItemsController->editAction()
#22 /srv/www/htdocs/qcarchives/civilrights/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('editAction')
#23 /srv/www/htdocs/qcarchives/civilrights/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#24 /srv/www/htdocs/qcarchives/civilrights/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#25 /srv/www/htdocs/qcarchives/civilrights/application/libraries/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#26 /srv/www/htdocs/qcarchives/civilrights/application/libraries/Omeka/Application.php(79): Zend_Application->run()
#27 /srv/www/htdocs/qcarchives/civilrights/admin/index.php(28): Omeka_Application->run()
#28 {main}