Magento News

 

Moving to another Server: Duplicate entry ‘1’ for key 1 [SOLVED]

Hey guys,

I’m putting a Magento-Installation from my local machine to a real web server.

So I export the database via phpMyAdmin in SQL-Compatibility Mode MYSQL400.

Then I go ahead and import this dump at the server (via phpMyAdmin), and there I get this error:


--
-- table `core_store`
--
INSERT INTO `core_store` ( `store_id` , `code` , `website_id` , `group_id` , `name` , `sort_order` , `is_active` )
VALUES ( 0, 'admin', 0, 0, 'Admin', 0, 1 ) , ( 1, 'default', 1, 1, 'OnlineShop Uno', 0, 1 ) , ( 2, 'gewerbe', 2, 2, 'OnlineShop Duo', 1, 1 ) ;

MySQL meldet: 
#1062 - Duplicate entry '1' for key 1

I’ve tried several exporting / importing methods and programs. Via phpMyAdmin, via Shell, via Perlscript, via Magento-Backup, via BigDump, etc..

But I always get the same error.

I even tried to insert the error-statements by hand, then the installation runs but it has kind of weird errors everywhere.

I imported the dump piece by piece and found out that there are “Duplicate Entry” problems for only 3 tables: core_store, core_store_group and core_store_website. Seems like there is a problem with my multiple Store Views!

I am using Magento 1.2.0.3 and two separate Stores / Views.

Would be great if anyone has any idea!

Bye, Michi

Moving to another Server: Duplicate entry ‘1’ for key 1 [SOLVED]

Possibly Related Posts:


 

Leave a Reply