2
> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry
> '12953' for key 'PRIMARY' Trace:
> #0 /data01/virt27417/domeenid/www.kinkeraamat.ee/gizmos/lib/Zend/Db/Statement.php(283):
> Zend_Db_Statement_Pdo->_execute(Array)
> #1 /data01/virt27417/domeenid/www.kinkeraamat.ee/gizmos/lib/Zend/Db/Adapter/Abstract.php(457):
> Zend_Db_Statement->execute(Array)
> #2 /data01/virt27417/domeenid/www.kinkeraamat.ee/gizmos/lib/Zend/Db/Adapter/Pdo/Abstract.php(230):
> Zend_Db_Adapter_Abstract->query('INSERT INTO `lo...', Array)
> #3 /data01/virt27417/domeenid/www.kinkeraamat.ee/gizmos/lib/Varien/Db/Adapter/Pdo/Mysql.php(281):
> Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `lo...', Array)
> #4 /data01/virt27417/domeenid/www.kinkeraamat.ee/gizmos/lib/Zend/Db/Adapter/Abstract.php(535):
> Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `lo...', Array)
> #5 /data01/virt27417/domeenid/www.kinkeraamat.ee/gizmos/app/code/core/Mage/Log/Model/Mysql4/Visitor.php(125):
> Zend_Db_Adapter_Abstract->insert('log_visitor_inf...', Array)
> #6 /data01/virt27417/domeenid/www.kinkeraamat.ee/gizmos/app/code/core/Mage/Log/Model/Mysql4/Visitor.php(79):
> Mage_Log_Model_Mysql4_Visitor->_saveVisitorInfo(Object(Mage_Log_Model_Visitor))
> #7 /data01/virt27417/domeenid/www.kinkeraamat.ee/gizmos/app/code/core/Mage/Core/Model/Mysql4/Abstract.php(373):
> Mage_Log_Model_Mysql4_Visitor->_afterSave(Object(Mage_Log_Model_Visitor))
> #8 /data01/virt27417/domeenid/www.kinkeraamat.ee/gizmos/app/code/core/Mage/Core/Model/Abstract.php(251):
> Mage_Core_Model_Mysql4_Abstract->save(Object(Mage_Log_Model_Visitor))
> #9 /data01/virt27417/domeenid/www.kinkeraamat.ee/gizmos/app/code/core/Mage/Log/Model/Visitor.php(159):
> Mage_Core_Model_Abstract->save()
> #10 /data01/virt27417/domeenid/www.kinkeraamat.ee/gizmos/app/code/core/Mage/Core/Model/App.php(1239):
> Mage_Log_Model_Visitor->initByRequest(Object(Varien_Event_Observer))
> #11 /data01/virt27417/domeenid/www.kinkeraamat.ee/gizmos/app/Mage.php(303):
> Mage_Core_Model_App->dispatchEvent('controller_acti...', Array)
> #12 /data01/virt27417/domeenid/www.kinkeraamat.ee/gizmos/app/code/core/Mage/Core/Controller/Varien/Action.php(454):
> Mage::dispatchEvent('controller_acti...', Array)
> #13 /data01/virt27417/domeenid/www.kinkeraamat.ee/gizmos/app/code/core/Mage/Core/Controller/Front/Action.php(45):
> Mage_Core_Controller_Varien_Action->preDispatch()
> #14 /data01/virt27417/domeenid/www.kinkeraamat.ee/gizmos/app/code/core/Mage/Core/Controller/Varien/Action.php(365):
> Mage_Core_Controller_Front_Action->preDispatch()
> #15 /data01/virt27417/domeenid/www.kinkeraamat.ee/gizmos/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(248):
> Mage_Core_Controller_Varien_Action->dispatch('index')
> #16 /data01/virt27417/domeenid/www.kinkeraamat.ee/gizmos/app/code/core/Mage/Core/Controller/Varien/Front.php(158):
> Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
> #17 /data01/virt27417/domeenid/www.kinkeraamat.ee/gizmos/app/Mage.php(459):
> Mage_Core_Controller_Varien_Front->dispatch()
> #18 /data01/virt27417/domeenid/www.kinkeraamat.ee/gizmos/index.php(65):
> Mage::run()
> #19 {main}
1
  • what happened leading up to this?
    – SR_Magento
    Commented Jan 30, 2015 at 16:55

1 Answer 1

2

user20889,clear truncate all log table from database.it issue foreign key and primary key issue. Please truncate below table:

log_customer
log_quote
log_summary
log_summary_type
log_url
log_url_info
log_visitor
log_visitor_info
log_visitor_online

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.