4 replies to this topic

[ding]

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?

[tomerg3]

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

[ding]

really thx, tomerg3.
i have already cleared data before i import csv file. and i reset "id_product" field to make it start 1;

[mhu100]

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.