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

SQLSTATE[23000]: Integrity constraint violation when clicking on “add to cart” button ( tested on 1.2.0 and 1.0.2.1 )
 
Thierry S.
Sr. Member
 
Total Posts:  94
Joined:  2008-03-19
Paris
 

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘48’ for key 1
Trace:
#0 /var/www/test/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/test/lib/Zend/Db/Adapter/Abstract.php(457): Zend_Db_Statement->execute(Array)
#2 /var/www/test/lib/Zend/Db/Adapter/Pdo/Abstract.php(230): Zend_Db_Adapter_Abstract->query(’INSERT INTO `lo...’, Array)
#3 /var/www/test/lib/Varien/Db/Adapter/Pdo/Mysql.php(258): Zend_Db_Adapter_Pdo_Abstract->query(’INSERT INTO `lo...’, Array)
#4 /var/www/test/lib/Zend/Db/Adapter/Abstract.php(535): Varien_Db_Adapter_Pdo_Mysql->query(’INSERT INTO `lo...’, Array)
#5 /var/www/test/app/code/core/Mage/Log/Model/Mysql4/Visitor.php(184): Zend_Db_Adapter_Abstract->insert(’log_quote’, Array)
#6 /var/www/test/app/code/core/Mage/Log/Model/Mysql4/Visitor.php(88): Mage_Log_Model_Mysql4_Visitor->_saveQuoteInfo(Object(Mage_Log_Model_Visitor))
#7 /var/www/test/app/code/core/Mage/Core/Model/Mysql4/Abstract.php(353): Mage_Log_Model_Mysql4_Visitor->_afterSave(Object(Mage_Log_Model_Visitor))
#8 /var/www/test/app/code/core/Mage/Core/Model/Abstract.php(251): Mage_Core_Model_Mysql4_Abstract->save(Object(Mage_Log_Model_Visitor))
#9 /var/www/test/app/code/core/Mage/Log/Model/Visitor.php(177): Mage_Core_Model_Abstract->save()
#10 /var/www/test/app/code/core/Mage/Core/Model/App.php(1150): Mage_Log_Model_Visitor->saveByRequest(Object(Varien_Event_Observer))
#11 /var/www/test/app/Mage.php(301): Mage_Core_Model_App->dispatchEvent(’controller_acti...’, Array)
#12 /var/www/test/app/code/core/Mage/Core/Controller/Varien/Action.php(409): Mage::dispatchEvent(’controller_acti...’, Array)
#13 /var/www/test/app/code/core/Mage/Core/Controller/Front/Action.php(56): Mage_Core_Controller_Varien_Action->postDispatch()
#14 /var/www/test/app/code/core/Mage/Core/Controller/Varien/Action.php(350): Mage_Core_Controller_Front_Action->postDispatch()
#15 /var/www/test/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(163): Mage_Core_Controller_Varien_Action->dispatch(’add’)
#16 /var/www/test/app/code/community/Mage/OfflineMaintenance/Controller/Router/Standard.php(44): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#17 /var/www/test/app/code/core/Mage/Core/Controller/Varien/Front.php(174): Mage_OfflineMaintenance_Controller_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#18 /var/www/test/app/Mage.php(450): Mage_Core_Controller_Varien_Front->dispatch()
#19 /var/www/test/index.php(52): Mage::run()

 
Magento Community Magento Community
Magento Community
Magento Community
 
Thierry S.
Sr. Member
 
Total Posts:  94
Joined:  2008-03-19
Paris
 

I used the “solution” that was into this thread.

http://www.magentocommerce.com/boards/viewthread/22665/

“cleaned all log_* except for log_summary_type “

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