Mysql table in need of repair

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}

REPAIR TABLE is a statement that repairs tables in MySQL. Most graphical or web interfaces to MySQL will also have options for repairing tables that do the same thing.

Sorry for taking so long to reply, but I tried the Repair Table statement using MySQL Workbench, the script ran successfully, but the table is still "marked as crashed and should be repaired".

After running a Check Table I get a message saying "Key in wrong position at page 1387520". Any advice on how to fix this?

Was there any message returned when you tried to REPAIR the search_texts table?

Only a green check mark next to the script in the "Action Output" section. Otherwise no message

I guess the next thing I'd try would be REPAIR search_texts EXTENDED.

Otherwise you'll have to look at options like shutting down the database server and using myisamchk on the data file with the server offline. Or, since this is just the search index, you have the option of dropping the whole table and re-adding one with the same structure, then having Omeka rebuild the index.

Ah ok, a REPAIR search_texts EXTENDED followed by using the "Index Records" function in the Settings section on Omeka seems to have solved the problem. Thanks!