i import CSV to upload my products but PS warns me ：
Duplicate entry '0-1' for key 1
"test" (ID 2) cannot be saved
anyone have the same problem?
Welcome to the PrestaShop Forum! We hope you'll share your comments and suggestions with us. We ask that you please post in English to the main sections of the PrestaShop Forum. If you want to write in another language, please post in the corresponding PrestaShop Community section below.
Please note that PrestaShop Community sections are largely self-moderated. PrestaShop team members may or may not participate in non-English sections. To improve the chances of receiving feedback to your question or comment, please post it in English to the main sections of our Forum.
Vous parlez français ? par ici !
Please note that PrestaShop Community sections are largely self-moderated. PrestaShop team members may or may not participate in non-English sections. To improve the chances of receiving feedback to your question or comment, please post it in English to the main sections of our Forum.
Vous parlez français ? par ici !
0
[HELP] Duplicate entry '0-1' for key 1 ??
Started by Guest_ding_*, Mar 18 2010 03:24 AM
[HELP] Duplicate entry '0-1' for key 1 ??
#2 Guest__*
-
- --
- Guests
Posted 18 March 2010 - 08:58 PM
This error means that there is already a record with the same ID which needs to be unique.
You are either trying to import to a table that already has data, or you are trying to import identical records from your csv file
You are either trying to import to a table that already has data, or you are trying to import identical records from your csv file
#3 Guest__*
-
- --
- Guests
Posted 19 March 2010 - 01:02 AM
really thx, tomerg3.
i have already cleared data before i import csv file. and i reset "id_product" field to make it start 1;
i have already cleared data before i import csv file. and i reset "id_product" field to make it start 1;
#4 Guest__*
-
- --
- Guests
Posted 19 March 2010 - 05:58 PM
Let the database fix it by itself.
Login in phpadmin select "all" the tables at the bottom of the database's first page, choose "repair"in the dropdown menu,then the problem is fixed.
Login in phpadmin select "all" the tables at the bottom of the database's first page, choose "repair"in the dropdown menu,then the problem is fixed.
#5 Guest__*
-
- --
- Guests
Posted 13 February 2011 - 06:48 PM
I'm having the same problem. I used both methodes 1. the backup database function in PS and 2. Export via phpmyadmin. Next I tried to import this file via phpmyadmin in an other database (local test database) and I'm getting messages like this:
#1062 - Duplicate entry '3-klettverschluß' for key 'id_lang'
The table that causes this problems is always the Search_Word table
I have checked everything and I'm sure that this entry is not an duplicate. What is going wrong?
It should be a simple Export --> Import procedure, but I'm not getting it done!
Is there anyone who can help me out? It's driving me crazy after hours and hours of searching and trying.
#1062 - Duplicate entry '3-klettverschluß' for key 'id_lang'
The table that causes this problems is always the Search_Word table
I have checked everything and I'm sure that this entry is not an duplicate. What is going wrong?
It should be a simple Export --> Import procedure, but I'm not getting it done!
Is there anyone who can help me out? It's driving me crazy after hours and hours of searching and trying.
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users