Item Error, please help!

Results 1 to 4 of 4
  1. #1
    Newbie hail123 is offline
    MemberRank
    Dec 2006 Join Date
    20Posts

    Item Error, please help!

    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?


  2. #2
    Grand Master EvilRyu is offline
    Grand MasterRank
    May 2006 Join Date
    ScotlandLocation
    571Posts
    Quote Originally Posted by hail123 View Post
    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.

  3. #3
    Newbie hail123 is offline
    MemberRank
    Dec 2006 Join Date
    20Posts
    nope, no update folder, just sql + patches.
    used patches still same error.

    please i really need a fix/can you post yours here?
    Last edited by hail123; 22-01-07 at 06:29 PM. Reason: retarded reply

  4. #4
    Grand Master EvilRyu is offline
    Grand MasterRank
    May 2006 Join Date
    ScotlandLocation
    571Posts
    goto:
    Mangos-Files.de
    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.



Advertisement