php - magento SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '606078' for key 'PRIMARY -


i working on live site http://spectnlens.com/. when tack backup , unzip files on localhost 1 error

there has been error processing request  sqlstate[23000]: integrity constraint violation: 1062 duplicate entry '606078' key 'primary'  trace: #0 d:\xampp\htdocs\spect\lib\varien\db\statement\pdo\mysql.php(110):     zend_db_statement_pdo->_execute(array) #1 d:\xampp\htdocs\spect\lib\zend\db\statement.php(300): varien_db_statement_pdo_mysql->_execute(array) #2 d:\xampp\htdocs\spect\lib\zend\db\adapter\abstract.php(479): zend_db_statement->execute(array) #3 d:\xampp\htdocs\spect\lib\zend\db\adapter\pdo\abstract.php(238): zend_db_adapter_abstract->query('insert `lo...', array) #4 d:\xampp\htdocs\spect\lib\varien\db\adapter\pdo\mysql.php(419): zend_db_adapter_pdo_abstract->query('insert `lo...', array) #5 d:\xampp\htdocs\spect\lib\zend\db\adapter\abstract.php(574): varien_db_adapter_pdo_mysql->query('insert `lo...', array) #6 d:\xampp\htdocs\spect\app\code\core\mage\log\model\resource\visitor.php(174): zend_db_adapter_abstract->insert('log_visitor_inf...', array) #7 d:\xampp\htdocs\spect\app\code\core\mage\log\model\resource\visitor.php(108): mage_log_model_resource_visitor->_savevisitorinfo(object(mage_log_model_visitor)) #8 d:\xampp\htdocs\spect\app\code\core\mage\core\model\resource\db\abstract.php(463): mage_log_model_resource_visitor->_aftersave(object(mage_log_model_visitor)) #9 d:\xampp\htdocs\spect\app\code\core\mage\core\model\abstract.php(318): mage_core_model_resource_db_abstract->save(object(mage_log_model_visitor)) #10 d:\xampp\htdocs\spect\app\code\core\mage\log\model\visitor.php(167): mage_core_model_abstract->save() #11 d:\xampp\htdocs\spect\app\code\core\mage\core\model\app.php(1338): mage_log_model_visitor->initbyrequest(object(varien_event_observer)) #12 d:\xampp\htdocs\spect\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 d:\xampp\htdocs\spect\app\mage.php(447): mage_core_model_app->dispatchevent('controller_acti...', array) #14 d:\xampp\htdocs\spect\app\code\core\mage\core\controller\varien\action.php(528): mage::dispatchevent('controller_acti...', array) #15 d:\xampp\htdocs\spect\app\code\core\mage\core\controller\front\action.php(64): mage_core_controller_varien_action->predispatch() #16 d:\xampp\htdocs\spect\app\code\core\mage\core\controller\varien\action.php(408): mage_core_controller_front_action->predispatch() #17 d:\xampp\htdocs\spect\app\code\core\mage\core\controller\varien\router\standard.php(250): mage_core_controller_varien_action->dispatch('index') #18 d:\xampp\htdocs\spect\app\code\core\mage\core\controller\varien\front.php(176):    mage_core_controller_varien_router_standard->match(object(mage_core_controller_request_http)) #19 d:\xampp\htdocs\spect\app\code\core\mage\core\model\app.php(354): mage_core_controller_varien_front->dispatch() #20 d:\xampp\htdocs\spect\app\mage.php(683): mage_core_model_app->run(array) #21 d:\xampp\htdocs\spect\index.php(87): mage::run('', 'store') #22 {main} 

error log record number: 1097527033

i dont know whats going on please me database uploaded , admin working fine.

try clearing visitors log first system > configuration > advanced > system > log cleaning

or if importing , looks trying import data existing database , record(s) exist, can either drop entire database , import empty or follow 1 of option shown here when importing sql file. note if 1 doing export, have options have statements included selecting either drop if exist or insert ignore


Comments