XF 1.1 Profile error when logged into admin account

[Akela]

I only get this error when accessing user profiles while logged into my admin account and not the test regular one:

An exception occurred: Mysqli statement execute error : Incorrect key file for table './folder/xf_route_prefix.MYI'; try to repair it in /home/folder/library/Zend/Db/Statement/Mysqli.php on line 214
Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
XenForo_Model->fetchAllKeyed() in XenForo/Model/RoutePrefix.php at line 41
XenForo_Model_RoutePrefix->getPrefixesByRouteType() in XenForo/Model/RoutePrefix.php at line 54
XenForo_Model_RoutePrefix->getPrefixesForRouteCache() in XenForo/Link.php at line 441
XenForo_Link::_loadHandlerInfoForGroup() in XenForo/Link.php at line 358
XenForo_Link::_getPrefixHandler() in XenForo/Link.php at line 324
XenForo_Link::_buildLink() in XenForo/Link.php at line 162
XenForo_Link::buildAdminLink() in XenForo/Template/Helper/Core.php at line 562
XenForo_Template_Helper_Core::adminLink() in XenForo/Template/Abstract.php(265) : eval()'d code at line 541
eval() in XenForo/Template/Abstract.php at line 265
XenForo_Template_Abstract->_renderInternal() in XenForo/Template/Abstract.php at line 191
XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
XenForo_Template_Public->render() in XenForo/ViewRenderer/HtmlPublic.php at line 119
XenForo_ViewRenderer_HtmlPublic->renderContainer() in XenForo/FrontController.php at line 565
XenForo_FrontController->renderView() in XenForo/FrontController.php at line 156
XenForo_FrontController->run() in /home/folder/index.php at line 13

I have just started getting the error and I haven't made any changes recently that I can recall...

 

[Jake Bunce]

1) The xf_route_prefix table is supposed to be InnoDB, not MyISAM. Apparently your server doesn't support InnoDB (or didn't when XF was installed). You should contact your host or server person about using InnoDB tables in MySQL.

2) To fix that error you need to run a repair on that table. You can run a repair in phpmyadmin which is preinstalled by most web hosts.

 

[Akela]

The error seems to have fixed itself.... This is all so very odd... I guess, I need to seriously consider a different host...