Duplicate Entry (I've searched and still haven't found an answer)

[JackJack]

I get this message when I try to upload parts of my backup to the database:

SQL-query:

INSERT INTO ibf_admin_logs
VALUES ( 1, 'forum', 'donew', 1, 1090252103, 'Forum \'News\' created', 'IP blocked out')
MySQL said:

#1062 - Duplicate entry '1' for key 1

Then the actual line in the dump would read:

INSERT INTO ibf_admin_logs VALUES (1,'forum','donew',1,1090252103,'Forum \'News\' created','IP blocked out');

(I blocked out my IP in the last part)

I searched the forum and still haven't found an answer. I'm using phpMyAdmin. How would I fix this?

[Roger_Ramjet]

Well, as a piece of SQL it means what it says: You have tried to insert a record into a table that has at least 1 unique index, and the record you are trying to insert would duplicate a value already taken in that index. If there is no record with the value actually in the table then your index is screwed and needs rebuilding. I can see two '1's in your query so it could be either field. Look for the index.

If you want to overwrite the original record then use REPLACE instead of INSERT, the syntax is identical although replace does have some parameters for itself.

[JackJack]

What do you mean the index?

[Roger_Ramjet]

A field in each record that contains a unique number and therefor identifies that record. From this we extract an index of all records in the table. The database engine uses it to locate and match records. You can also build indexes that are not unique, still used to locate and match records.

[shifty18]

i had this problem and what i did was to make my User_id field to be auto incrament so it went up automatically rather then you having to set it in the PHP code

[Roger_Ramjet]

Wow, that's some bump! 8 months infact.