[MaNGOS] SQL Table Problem

[serialkillerz]

Hey, does anyone now how to update creature_template without losing any Custom npcs / vendors




Here is the Error that occurs

Error in creature_template table, probably sql file format was updated (there should be 82 fields in sql).

[Reflection]

You can always dump the world database as a backup when you do changes in case an error occurs and then just execute it again and you'll be back to before.

[serialkillerz]

I did take another Creature_template that works

But when i execute back my old creature_template it comes back the error

[Reflection]

Could you post both .sql files to pastebin and link them?

[serialkillerz]

Edit : Fixed it with an SQL

[Reflection]

Edit : Fixed it with an SQL

Ah, nice

[serialkillerz]

Damn or not fixed the SQL updated the old creature_template but it seemd to remove my custom mobs

[Kiev]

You could have added/removed columns yourself, its not that long of a process, just pain grueling annoying. A SQL could have fixed it and for whatever reason shouldn't have deleted your custom mobs...