Error When Adding Items

[TRTeta]

I get an error when im trying to add an items to the SQL. How can I fix this ? Please help.

[Modamer9]

read the error what he said "Can not insert duplicate key"

it mean you can not insert tow some ID in DB.item.

[ThunderNikk]

Check the ID values in the errors in your database dbo_ItemResource

You either already have the items or you have items in your database the use the same item IDs.

[TRTeta]

what should I do

[ThunderNikk]

You should look at the item IDs in the error.

Find out what items they are in you dbo.ItemResource table and see if they are the same items.

If they are then you don't need to run the script to add the items cause they are...already in there.

If the item IDs are in there for some other items then you're in a pickle.

[TealSky]

You should: not try to insert items that already exist into the database.

So unless you feel like spending a REALLY long time thumbing through 30k+ items, I'd open the script your trying to use (or scroll to the top of the query window) and add TRUNCATE TABLE dbo.ItemResource BEFORE the first INSERT [[WARNING!!! THIS WILL DELETE ALL DATA IN YOUR dbo.ItemResource]]

[TRTeta]

fixed