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:
- Backuped files
- Created a database dump of the production server
- Moved every file from "public_html" to the local webserver
- Created the database and imported the database dump on the local MySQL Server.
- Made sure if I had every permission needed.
- Updated the database-settings in app/etc/local.xml
- Update the URLs in core_config_data:
- Checked the .htaccess file.
- Emptied the var/cache, var/session, var/report, var/log.
- 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?