Item Error, please help!

[hail123]

2007-01-22 17:58:49 Loading Items...
2007-01-22 17:59:06 ERROR:Error in `item_template` table, probably sql file format was updated (there should be 119 fields in sql).

I get that error msg... I have Rev 2996 for 2.0.1 patch.
Any fixes?

 

[EvilRyu]

2007-01-22 17:58:49 Loading Items...
2007-01-22 17:59:06 ERROR:Error in `item_template` table, probably sql file format was updated (there should be 119 fields in sql).

I get that error msg... I have Rev 2996 for 2.0.1 patch.
Any fixes?

In the new rev rar file, there will be a folder called update and in it sql folder.
Go into the sql folder, and import the Itemtemplate sql file, then reboot sever, that should do it.

 

[hail123]

nope, no update folder, just sql + patches.
used patches still same error.

please i really need a fix/can you post yours here?

 

[EvilRyu]

goto:

To view the content, you need to sign in or register

There you will see the core releases, download the one thats for your sdb "no idea which one matches which" you would have to find that out.

But each rar files contains a folder called sql in updates, it has lots of small sql files, use the itemtemplate sql in there to fix it, but make sure you get the one for your databse, otherwise it wont work.