Ive beeen getting this lately my webshop is offline i printed the error log thhis is what it says can please someone help me out
a:5:{i:0;s:118:"SQLSTATE[HY000]: General error: 145 Table './m1_25b94ca6/log_visitor_info' is marked as crashed and should be repaired";i:1;s:3609:"#0 /home/vhosts/familiask8shop.nl/httpdocs/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/vhosts/familiask8shop.nl/httpdocs/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/vhosts/familiask8shop.nl/httpdocs/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /home/vhosts/familiask8shop.nl/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('DESCRIBE `log_v...', Array)
#4 /home/vhosts/familiask8shop.nl/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(389): Zend_Db_Adapter_Pdo_Abstract->query('DESCRIBE `log_v...', Array)
#5 /home/vhosts/familiask8shop.nl/httpdocs/lib/Zend/Db/Adapter/Pdo/Mysql.php(156): Varien_Db_Adapter_Pdo_Mysql->query('DESCRIBE `log_v...')
#6 /home/vhosts/familiask8shop.nl/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(1566): Zend_Db_Adapter_Pdo_Mysql->describeTable('log_visitor_inf...', NULL)
#7 /home/vhosts/familiask8shop.nl/httpdocs/app/code/core/Mage/Core/Model/Resource/Abstract.php(206): Varien_Db_Adapter_Pdo_Mysql->describeTable('log_visitor_inf...')
#8 /home/vhosts/familiask8shop.nl/httpdocs/app/code/core/Mage/Log/Model/Resource/Visitor.php(152): Mage_Core_Model_Resource_Abstract->_prepareDataForTable(Object(Varien_Object), 'log_visitor_inf...')
#9 /home/vhosts/familiask8shop.nl/httpdocs/app/code/core/Mage/Log/Model/Resource/Visitor.php(108): Mage_Log_Model_Resource_Visitor->_saveVisitorInfo(Object(Mage_Log_Model_Visitor))
#10 /home/vhosts/familiask8shop.nl/httpdocs/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(458): Mage_Log_Model_Resource_Visitor->_afterSave(Object(Mage_Log_Model_Visitor))
#11 /home/vhosts/familiask8shop.nl/httpdocs/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Object(Mage_Log_Model_Visitor))
#12 /home/vhosts/familiask8shop.nl/httpdocs/app/code/core/Mage/Log/Model/Visitor.php(167): Mage_Core_Model_Abstract->save()
#13 /home/vhosts/familiask8shop.nl/httpdocs/app/code/core/Mage/Core/Model/App.php(1303): Mage_Log_Model_Visitor->initByRequest(Object(Varien_Event_Observer))
#14 /home/vhosts/familiask8shop.nl/httpdocs/app/code/core/Mage/Core/Model/App.php(1284): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Log_Model_Visitor), 'initByRequest', Object(Varien_Event_Observer))
#15 /home/vhosts/familiask8shop.nl/httpdocs/app/Mage.php(416): Mage_Core_Model_App->dispatchEvent('controller_acti...', Array)
#16 /home/vhosts/familiask8shop.nl/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(505): Mage::dispatchEvent('controller_acti...', Array)
#17 /home/vhosts/familiask8shop.nl/httpdocs/app/code/core/Mage/Core/Controller/Front/Action.php(59): Mage_Core_Controller_Varien_Action->preDispatch()
#18 /home/vhosts/familiask8shop.nl/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(409): Mage_Core_Controller_Front_Action->preDispatch()
#19 /home/vhosts/familiask8shop.nl/httpdocs/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('index')
#20 /home/vhosts/familiask8shop.nl/httpdocs/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#21 /home/vhosts/familiask8shop.nl/httpdocs/app/code/core/Mage/Core/Model/App.php(349): Mage_Core_Controller_Varien_Front->dispatch()
#22 /home/vhosts/familiask8shop.nl/httpdocs/app/Mage.php(640): Mage_Core_Model_App->run(Array)
#23 /home/vhosts/familiask8shop.nl/httpdocs/index.php(75): Mage::run('', 'store')
#24 {main}";s:3:"url";s:1:"/";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:7:"default";}
Hi @familiask8
Try to run following command on the mysql console.
repair table log_visitor_info;
It should fix the problem for you.
log_ tables can be simply truncated and optimized. this will save your database size also.