Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Help!  Error after hard rebooting server, crashed table?? 
 
BodleyTunes
Jr. Member
 
Total Posts:  13
Joined:  2008-06-20
 

Get this error accessing my site after I hard rebooted as it was not responding properly.

Can anyone help?

Thanks,
Jon.

SQLSTATE[HY000]: General error: 145 Table ‘./magento-supercamper/log_visitor’ is marked as crashed and should be repaired

Trace:
#0 /shares/websites/www.supercamper.co.uk/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /shares/websites/www.supercamper.co.uk/lib/Zend/Db/Adapter/Abstract.php(406): Zend_Db_Statement->execute(Array)
#2 /shares/websites/www.supercamper.co.uk/lib/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query(’INSERT INTO `lo...’, Array)
#3 /shares/websites/www.supercamper.co.uk/lib/Zend/Db/Adapter/Abstract.php(484): Zend_Db_Adapter_Pdo_Abstract->query(’INSERT INTO `lo...’, Array)
#4 /shares/websites/www.supercamper.co.uk/app/code/core/Mage/Core/Model/Mysql4/Abstract.php(343): Zend_Db_Adapter_Abstract->insert(’log_visitor’, Array)
#5 /shares/websites/www.supercamper.co.uk/app/code/core/Mage/Core/Model/Abstract.php(235): Mage_Core_Model_Mysql4_Abstract->save(Object(Mage_Log_Model_Visitor))
#6 /shares/websites/www.supercamper.co.uk/app/code/core/Mage/Log/Model/Visitor.php(136): Mage_Core_Model_Abstract->save()
#7 /shares/websites/www.supercamper.co.uk/app/code/core/Mage/Core/Model/App.php(1032): Mage_Log_Model_Visitor->initByRequest(Object(Varien_Event_Observer))
#8 /shares/websites/www.supercamper.co.uk/app/Mage.php(278): Mage_Core_Model_App->dispatchEvent(’controller_acti...’, Array)
#9 /shares/websites/www.supercamper.co.uk/app/code/core/Mage/Core/Controller/Varien/Action.php(377): Mage::dispatchEvent(’controller_acti...’, Array)
#10 /shares/websites/www.supercamper.co.uk/app/code/core/Mage/Core/Controller/Front/Action.php(40): Mage_Core_Controller_Varien_Action->preDispatch()
#11 /shares/websites/www.supercamper.co.uk/app/code/core/Mage/Core/Controller/Varien/Action.php(335): Mage_Core_Controller_Front_Action->preDispatch()
#12 /shares/websites/www.supercamper.co.uk/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(159): Mage_Core_Controller_Varien_Action->dispatch(’index’)
#13 /shares/websites/www.supercamper.co.uk/app/code/core/Mage/Core/Controller/Varien/Front.php(146): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#14 /shares/websites/www.supercamper.co.uk/app/Mage.php(427): Mage_Core_Controller_Varien_Front->dispatch()
#15 /shares/websites/www.supercamper.co.uk/index.php(40): Mage::run(’default’)
#16 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
 
BodleyTunes
Jr. Member
 
Total Posts:  13
Joined:  2008-06-20
 

tried repairing with myisamchk -r but still no joy!!

 
Magento Community Magento Community
Magento Community
Magento Community
 
BodleyTunes
Jr. Member
 
Total Posts:  13
Joined:  2008-06-20
 

fixed it with this :

“myisamchk -r <DatabaseName>\*.MYI”

smile

 
Magento Community Magento Community
Magento Community
Magento Community
 
ale acuna
Jr. Member
 
Total Posts:  4
Joined:  2008-06-18
Paraguay
 

I had a problem with a database with the same error message when I try to open my webpage.

I have get inside my directory. I use Debian

cd /var/lib/mysql/magento/

Then I typed

myisamchk -r *.MYI

it is fixed!!! Working good now

 
Magento Community Magento Community
Magento Community
Magento Community
 
Unixversal
Sr. Member
 
Avatar
Total Posts:  80
Joined:  2008-04-23
Cologne, Germany
 

works indeed. thx for sharing smile

 
Magento Community Magento Community
Magento Community
Magento Community
 
mpartsch
Jr. Member
 
Total Posts:  7
Joined:  2009-10-06
 

I recently had this happen twice in 2 weeks.  Does anyone know the root cause?  Can I fix it without using Debian?  ‘magentolog_visitor’ is marked as crashed and should be repaired

 
Magento Community Magento Community
Magento Community
Magento Community
 
jack pott
Jr. Member
 
Total Posts:  21
Joined:  2010-02-15
 

Puhhhh!
Thank you!!

 
Magento Community Magento Community
Magento Community
Magento Community
 
guillaume7684
Sr. Member
 
Total Posts:  241
Joined:  2008-10-20
 

Thank you so much!!!!
I tried during 3 hours to find a solution.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top