[HELP] Weapons and Armor error

[Ethix]

I just downloaed Johved 3.0.9 repack and the items don't have the stats it should. Only SOME armor/rings/neck have some stats and if I equip a melee weapon it will miss 100%. On weapons it will say something like 0-450 Damage and like 0.02 or 0.00 DPS and it will have a "1" or "2" at the bottom.. And my Death Knight's Starting Gear works.


Heres links to the problem:

http://img15.imageshack.us/img15/7438/weap.jpg

http://img11.imageshack.us/img11/1201/neckg.jpg

Thanks for any help given xD

PS: Someone told me on youtube that I would probably have to update my SQL DB but I am not sure if that would be the case, nor do I know how to.

[LaAevie]

May I ask, by putting LEGENDARY as the thread icon does that mean this is a LEGENDARY FAIL? Haha. I am bugging you. :P Anyways I have seen this problem before, it is pretty simple one. You need to update your database, right now your columns are off in the database making it all screwed up. You may have an extra column, or missing one, or they could be out of order, I am not sure, but I know it is your items table.

[Ethix]

May I ask, by putting LEGENDARY as the thread icon does that mean this is a LEGENDARY FAIL? Haha. I am bugging you. :P Anyways I have seen this problem before, it is pretty simple one. You need to update your database, right now your columns are off in the database making it all screwed up. You may have an extra column, or missing one, or they could be out of order, I am not sure, but I know it is your items table.

Is it a simple task? Or would I need to edit every item in the database..ALL 33k! I dont know how to update my database so that I would be able to see my weapons and armors stats... ;( I just got my server online also, I want to be able to add custom vendors and items xD

Thanks for the help

[LaAevie]

No, you wouldn't need to edit every item lol. You would need to simply execute an update SQL.

[Ethix]

No, you wouldn't need to edit every item lol. You would need to simply execute an update SQL.

Do you have the "Update SQL" LoL. Or do you have a link where I can find this. Or is it built in with MySQL (I'm using Heidisql btw)