Since your database is broken the best thing to do is to drop the database and start new.
Then create your database again. When sourcing you must use only one source code to source it. You can't then use another code and try to source over the exsisting one, is simply wont work. The only time you can source over your current database is when the source code does a update.
I reccomend getting the MW_052_053_alpha2 and source that. Then you need to run all the updates for it and it should run fine. If for some reason it does not work then you dont have all the updates for it. Updates are: Jan24_Update.sql, update-feb-20.sql, then the updates in the 5.5 release which are 1.sql, 2.sql, 3.sql. If you want to add the loot to all mobs check out the other post. I am currently recompiling my sql database =(
Hope that helps!
|