Navicat Error: Duplicate Entry??

[dragonowner]

Ok i was trying to add vendors back to my server and im getting errors saying that the entrys are duplicated but they arent. When i look in my tables they were added but the server doesnt reconize them. I saw the thread right below mine and it said to update that kid's database how do i update mine without losing everythhing??

[Exacute]

try use other entrys then

[dragonowner]

i did im not that stupid...-.-

:edit: can someone help me??? PLEASE!!!!

[kreegoth]

If your using Arcemu. DOwnload the latest rev and then run all the of the UPdate Sqls. you may need to further edit a few tables if you get errors that popup in the worldserver window. IE Expected 50 fields and got 51.

Just make sure you run all the sqls and post any further errrors here.

[dragonowner]

wait what??

[kreegoth]

DOwnload the latest revision of Arcemu.. Even if you want to download one of the precompiled versions out of releases section from Fantomas.. What rev of Arc emu are you trying to run it on and what Rev did you used to use the Database on?.

If you take a precompiled version of Arcemu say 844.. inside the folder youll find a folder called Sql_update.. Execute those into your database( i suggest making a backup first)
When all are done you should be fine. if you get any errors post them here again.

[Reflection]

If you're executing vendors you have to check creature_names, creature_proto and vendors tables for duplicates, if there is none, give me the ID's for the creature_names and vendors, first one and last one, I will make a sql to delete them for you.

[dragonowner]

i fixed my problem it was that an extra row was added to the sctript in creature_proto the messed everything up.