[SOLVED] Duplicate item entries

[Noven]

I found my old item database sql. and executed it, took me 3 hours and 29 min to get it done, but when I checked the database, all my custom items were there, but a lot of the items was duplicated with same entry id,

Anyone knows how this could of happened?

 

[Tommy]

I found my old item database sql. and executed it, took me 3 hours and 29 min to get it done, but when I checked the database, all my custom items were there, but a lot of the items was duplicated with same entry id, View attachment 466

Anyone knows how this could of happened?

Bad export? Honestly, I'm not entirely sure. Pretty weird.

 

[Noven]

Because usually, if something has the same ID as an item which is already in the database, you'll receive an error about duplicate entry, but I received no errors what so ever ..

 

[Tommy]

Because usually, if something has the same ID as an item which is already in the database, you'll receive an error about duplicate entry, but I received no errors what so ever ..

It only does that when importing. It beats me though. Solution would probably be: write a program, get the duplicated lines and remove them.

 

[Noven]

Found out the problem

When I hit alter table on item_template, it did not have this structure;