Error importing sql

[theory18]

Sometomes when i want to import an sql in my world database i get this error.
It doesn't happen every time though...
I have a friend with the same problem does anybody have that problem to?
It's for arcemu, doesn't matter what rev db cause it still happens with the latest core to.

Query:
   
UPDATE `loot_gameobjects` SET `itemid`='39362' WHERE (`entryid`='190947') AND (`itemid`='190947')

Error occured at:2009-05-27 13:00:47
Line no.:70
Error Code: 1062 - Duplicate entry '190947-39362' for key 'PRIMARY'

Query:
/*Data for the table `creature_names` */
insert  into `creature_names`(`entry`,`name`,`subname`

Thanks in advance +rep for helper!

[Claiver]

You always have the entry, since it says it's duplicated, means it's double --> already present.
It works the first time, or second time too sometimes?

[theory18]

haven't really tried running the same sql everytime...
But i know it's because of the entry or more entries i don't know that
i get errors sometimes when importing custom stuff...

And i don't think it's THAT good for your server when your queries aren't ran 100%.
Do you have that to perhaps Claiver?

[Choices]

if its custom stuff just raise the entryid's to a bigger number :P

[theory18]

still doesn't fix the problem cause entries are 99000000 etc.
no its not that like when i upgraded my core to the latest arcemu
there are sql updates to ex "104_rituals_objects.sql",
event with those i have that sometimes,
not all...

Does no one have this problem to?:s
Thought this was just a problem in the main world.sql lol.

[Claiver]

Hmm no I do not have these kind of problems :|!
Sorry but I have no clue on how to fix this on this one .

[theory18]

hi claiver if you have the latest arcemu core could you just upload a clean version of your database then? perhaps i only get bad sources or something, cause i worked with 3 different cores of arcemu all clean installs and i kept having this problem...
thanks in advance. the update sql's i have just need the worlddb.sql for revision 2670 pls.

Thanks in advance for the uploader +rep!
(pls just clean sql's no repack/fun sqls)