The problem

I can't access the store front but I can enter the backend.

What I want to achieve and what I did

I installed WAMP and wanted to create a local environment which has a copy of the Magento shop on the Production environment.

I have followed these steps:

  1. Backuped files
  2. Created a database dump of the production server
  3. Moved every file from "public_html" to the local webserver
  4. Created the database and imported the database dump on the local MySQL Server.
  5. Made sure if I had every permission needed.
  6. Updated the database-settings in app/etc/local.xml
  7. Update the URLs in core_config_data:
  8. Checked the .htaccess file.
  9. Emptied the var/cache, var/session, var/report, var/log.
  10. Logged in the backend. Reindexed the data.

Now I have the following problem. I can log in to the backend. But when I try to get the store front then I get an error message: "There has been an error processing your request". So I went to "var/report" and red the error log number.

It said "a:5:{i:0;s:96:"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '275374' for key 'PRIMARY'";i:1;s:2648:"#0 D:\wamp\www\lib\Varien\Db\Statement\Pdo\Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)".

What does this mean? And why can I log into the backend but the storefront isn't displayed?


1 Answer 1


The solution was to execute this:

 TRUNCATE dataflow_batch_export ;
 TRUNCATE dataflow_batch_import ;
 TRUNCATE log_customer ;
 TRUNCATE log_quote ;
 TRUNCATE log_summary ;
 TRUNCATE log_summary_type ;
 TRUNCATE log_url ;
 TRUNCATE log_url_info ;
 TRUNCATE log_visitor ;
 TRUNCATE log_visitor_info ;
 TRUNCATE log_visitor_online ;
 TRUNCATE report_event ;

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.