- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-18-2015
05:28 AM
05-18-2015
05:28 AM
error after moving site to other hosting but same domain name
Hi everyone.
I'm trying to get ny site working on antoher hosting company. Evenrything works but i have the following error when opening the site. Can someone help me. Im looking on the internet for a solution but cannot find one.
There has been an error processing your request SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '396652' for key 'PRIMARY' Trace: #0 /home/wlbs/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/wlbs/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #2 /home/wlbs/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /home/wlbs/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `mg...', Array) #4 /home/wlbs/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `mg...', Array) #5 /home/wlbs/public_html/lib/Zend/Db/Adapter/Abstract.php(576): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `mg...', Array) #6 /home/wlbs/public_html/app/code/core/Mage/Log/Model/Resource/Visitor.php(174): Zend_Db_Adapter_Abstract->insert('mgnt_log_visito...', Array) #7 /home/wlbs/public_html/app/code/core/Mage/Log/Model/Resource/Visitor.php(108): Mage_Log_Model_Resource_Visitor->_saveVisitorInfo(Object(Mage_Log_Model_Visitor)) #8 /home/wlbs/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(463): Mage_Log_Model_Resource_Visitor->_afterSave(Object(Mage_Log_Model_Visitor)) #9 /home/wlbs/public_html/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Object(Mage_Log_Model_Visitor)) #10 /home/wlbs/public_html/app/code/core/Mage/Log/Model/Visitor.php(168): Mage_Core_Model_Abstract->save() #11 /home/wlbs/public_html/app/code/core/Mage/Core/Model/App.php(1338): Mage_Log_Model_Visitor->initByRequest(Object(Varien_Event_Observer)) #12 /home/wlbs/public_html/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Log_Model_Visitor), 'initByRequest', Object(Varien_Event_Observer)) #13 /home/wlbs/public_html/app/Mage.php(448): Mage_Core_Model_App->dispatchEvent('controller_acti...', Array) #14 /home/wlbs/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(527): Mage::dispatchEvent('controller_acti...', Array) #15 /home/wlbs/public_html/app/code/core/Mage/Core/Controller/Front/Action.php(64): Mage_Core_Controller_Varien_Action->preDispatch() #16 /home/wlbs/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(407): Mage_Core_Controller_Front_Action->preDispatch() #17 /home/wlbs/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('index') #18 /home/wlbs/public_html/app/code/community/ArtsOnIT/OfflineMaintenance/Controller/Router/Standard.php(46): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #19 /home/wlbs/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): ArtsOnIT_OfflineMaintenance_Controller_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #20 /home/wlbs/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch() #21 /home/wlbs/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array) #22 /home/wlbs/public_html/index.php(87): Mage::run('', 'store') #23 {main}
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-18-2015
07:14 AM
05-18-2015
07:14 AM
Re: error after moving site to other hosting but same domain name
It looks like there's a duplicate row in your MySQL database.
I suggest that you move the database over again and make sure to import it into a fresh and empty database.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-18-2015
07:28 AM
05-18-2015
07:28 AM
Re: error after moving site to other hosting but same domain name
I allready did it but the problem stays
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-18-2015
11:50 AM
05-18-2015
11:50 AM
Re: error after moving site to other hosting but same domain name
According to the stack trace, the script tries to add new rows to your log table. What happens when you truncate those tables?
If this response was helpful to you, consider giving kudos to this post.
If this response solved your problem, click accept as solution to help others solve this
If this response solved your problem, click accept as solution to help others solve this