Topmagento.com|Magento技术交流站

当前位置: 首页 - magento疑难解答 - 安装magento出现entry ’1′ for key ‘PRIMARY’错误

2010-04-24

安装magento出现entry ’1′ for key ‘PRIMARY’错误

有时候安装magento会出现类似这样的错误：SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ’1′ for key ‘PRIMARY’

这个错误经常是在安装magento1.324版本的时候出现的，其它版本很少有这样的问题。

错误完整代码显示为：

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ’1′ for key ‘PRIMARY’
Trace:
#0 D:\Program Files\Zend\Apache2\htdocs\magento\lib\Zend\Db\Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 D:\Program Files\Zend\Apache2\htdocs\magento\lib\Zend\Db\Adapter\Abstract.php(457): Zend_Db_Statement->execute(Array)
#2 D:\Program Files\Zend\Apache2\htdocs\magento\lib\Zend\Db\Adapter\Pdo\Abstract.php(230): Zend_Db_Adapter_Abstract->query(‘INSERT INTO `lo…’, Array)
#3 D:\Program Files\Zend\Apache2\htdocs\magento\lib\Varien\Db\Adapter\Pdo\Mysql.php(281): Zend_Db_Adapter_Pdo_Abstract->query(‘INSERT INTO `lo…’, Array)
#4 D:\Program Files\Zend\Apache2\htdocs\magento\lib\Zend\Db\Adapter\Abstract.php(535): Varien_Db_Adapter_Pdo_Mysql->query(‘INSERT INTO `lo…’, Array)
#5 D:\Program Files\Zend\Apache2\htdocs\magento\app\code\core\Mage\Log\Model\Mysql4\Visitor.php(142): Zend_Db_Adapter_Abstract->insert(‘log_url’, Array)
#6 D:\Program Files\Zend\Apache2\htdocs\magento\app\code\core\Mage\Log\Model\Mysql4\Visitor.php(83): Mage_Log_Model_Mysql4_Visitor->_saveVisitorUrl(Object(Mage_Log_Model_Visitor))
#7 D:\Program Files\Zend\Apache2\htdocs\magento\app\code\core\Mage\Core\Model\Mysql4\Abstract.php(373): Mage_Log_Model_Mysql4_Visitor->_afterSave(Object(Mage_Log_Model_Visitor))
#8 D:\Program Files\Zend\Apache2\htdocs\magento\app\code\core\Mage\Core\Model\Abstract.php(251): Mage_Core_Model_Mysql4_Abstract->save(Object(Mage_Log_Model_Visitor))
#9 D:\Program Files\Zend\Apache2\htdocs\magento\app\code\core\Mage\Log\Model\Visitor.php(179): Mage_Core_Model_Abstract->save()
#10 D:\Program Files\Zend\Apache2\htdocs\magento\app\code\core\Mage\Core\Model\App.php(1239): Mage_Log_Model_Visitor->saveByRequest(Object(Varien_Event_Observer))
#11 D:\Program Files\Zend\Apache2\htdocs\magento\app\Mage.php(303): Mage_Core_Model_App->dispatchEvent(‘controller_acti…’, Array)
#12 D:\Program Files\Zend\Apache2\htdocs\magento\app\code\core\Mage\Core\Controller\Varien\Action.php(483): Mage::dispatchEvent(‘controller_acti…’, Array)
#13 D:\Program Files\Zend\Apache2\htdocs\magento\app\code\core\Mage\Core\Controller\Front\Action.php(56): Mage_Core_Controller_Varien_Action->postDispatch()
#14 D:\Program Files\Zend\Apache2\htdocs\magento\app\code\core\Mage\Core\Controller\Varien\Action.php(380): Mage_Core_Controller_Front_Action->postDispatch()
#15 D:\Program Files\Zend\Apache2\htdocs\magento\app\code\core\Mage\Core\Controller\Varien\Router\Standard.php(248): Mage_Core_Controller_Varien_Action->dispatch(‘index’)
#16 D:\Program Files\Zend\Apache2\htdocs\magento\app\code\core\Mage\Core\Controller\Varien\Front.php(158): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#17 D:\Program Files\Zend\Apache2\htdocs\magento\app\Mage.php(459): Mage_Core_Controller_Varien_Front->dispatch()
#18 D:\Program Files\Zend\Apache2\htdocs\magento\index.php(65): Mage::run()
#19 {main}