最健全的magento互联网企业

2021-04-08 01:55 jianzhan
magento网络服务器重新启动或后,magento网站出現表毁坏难题的处理

 创作者: 管理方法员  |  2010-10-05 阅读文章频次:749  重要字:最健全的magento互联网企业


Zen Cart 二次开发设计 ************ ************ .ShoppingMars.ComZen Cart 二次开发设计

重新启动网络服务器后或重新启动mysql后有时候候会发觉,magento做的网站开启时出現数据信息库表毁坏的不正确提醒,如:

SQLSTATE[HY000]: General error: 145 Table ./abc /log_visitor is marked as crashed and should be repaired

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

进到mysql数据信息库的数据信息文件目录,一般是/var/lib/mysql,假如你没明确,或是此文件目录不会有,你可以以根据查询mysql的配备文档或其他方法来获得.

随后实行下边的指令

myisamchk -r *.MYI

就可以修补好magento数据信息库文件因为mysql网络服务器重新启动毁坏的表构造.