Deadly mistake.

[Uppercutter]

Hey, a couple of hours ago I saw some random spawned Stormwind city's. I couldnt target them as objects so I started to look in the object database. I saw multiple Stormwind City's and Stormwind's, I deleted them all with display id 471 and map id 14. After my server restart when someone try's to login my server gives an error and restarts, ive tryed like 20x to get the error on screenshot but I always was like a milisecond to late so I made a vid of it and screenshotted the error but when I tryed to upload it it only gives me a black screen, so anyways is there something like an automatic backup from the db? can I fix this?

Ill just write the error lol.:

Server has crashed.

Creating crash dumpfile: Crashdump/\build-in-debug-if-you-want-a-proper-crashdump-ArcEmu-world.exe-3730-2011-5-22-21-40-9-936.dmp
ArcEmu sq;: waiting for all database queries to finish....


-Uppercutter

[stoneharry]

Could try running this:

DELETE FROM `gameobject_spawns` WHERE `entry` IN (SELECT `entry` FROM `gameobject_names` WHERE `displayid` = '471');

Sounds like you have gameobjects spawned that no longer exist in the database, however I could be wrong.

If it fails, go to WhyDB, get the gameobject_names SQL and execute that, which will reset gameobject data.

[Confucius]

dl an unedit copy of whatever db you use and readd the objects you deleted

[Uppercutter]

Wow, thanks for your quick replies. Im going to try stoneharry's idea first if none of it works ill reply again ^^

---------- Post added at 04:13 PM ---------- Previous post was at 03:51 PM ----------

Alright, so stoneharry, I deleted the objects and it works fine. I can login etc but when I teleport to Stormwind the server crashes. When I go to whydb.org I see alot of things, im new in emulation and dont know where to find that table.

[Confucius]

you can find it in their svn i believe, or you can just download whole db and get the files from that

[Uppercutter]

EDIT: I fixed it thanks for all the help, just did as Confucius said, I would rep you if I could

[Confucius]

EDIT: I fixed it thanks for all the help, just did as Confucius said, I would rep you if I could

Glad you got it working again