X-Forums

Computer, Games, and Technology

Error in creature_template table

2 posts

  1. Reeseyboy

    Member
    Joined: Feb '08
    Posts: 20

    Ok, so i got my server working with maps updated e.t.c, got past the vmap/map wrong directory issue, but now i get new error, heres the DB and server log reports

    DB:

    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('533','1934576448')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('534','1934576448')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('540','1841544000')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('542','1841544000')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('543','1841544000')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('544','1934576448')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('545','1841544000')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('546','1841544000')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('547','1841544000')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('548','1934576448')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('550','1934576448')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('552','1841544000')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('553','1841544000')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('554','1841544000')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('555','1841544000')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('556','1841544000')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('557','1841544000')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('558','1841544000')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('560','1841544000')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('564','1934576448')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('565','1934576448')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('568','2139507520')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('580','1934576448')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: INSERT INTO instance_reset VALUES ('585','1841544000')
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 SQL: DELETE FROM group_instance USING group_instance LEFT JOIN instance ON group_instance.instance = instance.id WHERE instance.id IS NULL
    2008-08-23 14:10:54 SQL ERROR: Table 'characters.group_instance' doesn't exist
    2008-08-23 14:11:01 Spell 33280 listed in spell_proc_event does not exist
    2008-08-23 14:11:01 Spell 35092 listed in spell_proc_event does not exist
    2008-08-23 14:11:01 Spell 35093 listed in spell_proc_event does not exist
    2008-08-23 14:11:01 Spell 35094 listed in spell_proc_event does not exist
    2008-08-23 14:11:10 Item (Entry: 849 8) not correct 20655 display id, must be 44666 (using it).
    2008-08-23 14:11:10 Item (Entry: 10822) not correct 20655 display id, must be 51621 (using it).
    2008-08-23 14:11:10 Item (Entry: 27515) not correct 38900 display id, must be 50502 (using it).
    2008-08-23 14:11:10 Item (Entry: 27516) not correct 38895 display id, must be 50501 (using it).
    2008-08-23 14:11:10 Item (Entry: 3380 8) not correct 47014 display id, must be 51920 (using it).
    2008-08-23 14:11:10 Item (Entry: 3386 8) not correct 47131 display id, must be 51758 (using it).
    2008-08-23 14:11:10 Item (Entry: 33955) not correct 47136 display id, must be 7744 (using it).

    Server.log

    2008-08-23 14:10:53 Loading InstanceTemplate
    2008-08-23 14:10:53 >> Loaded 51 Instance Template definitions
    2008-08-23 14:10:53
    2008-08-23 14:10:53 Loading SkillLineAbilityMultiMap Data...
    2008-08-23 14:10:53
    2008-08-23 14:10:53 >> Loaded 7025 SkillLineAbility MultiMap
    2008-08-23 14:10:53 Cleaning up instances...
    2008-08-23 14:10:54 ERROR:SQL: SELECT mapid, resettime FROM instance_reset
    2008-08-23 14:10:54 ERROR:query ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: DELETE FROM instance USING instance LEFT JOIN instance_reset ON mapid = map WHERE (instance.resettime < '1219497053' AND instance.resettime > '0') OR (NOT instance_reset.resettime IS NULL AND instance_reset.resettime < '1219497053')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('249','4184525632')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: DELETE FROM group_instance USING group_instance LEFT JOIN characters ON group_instance.leaderGuid = characters.guid LEFT JOIN groups ON group_instance.leaderGuid = groups.leaderGuid WHERE characters.guid IS NULL OR groups.leaderGuid IS NULL
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.group_instance' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('269','1841544000')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: DELETE FROM instance USING instance LEFT JOIN character_instance ON character_instance.instance = id LEFT JOIN group_instance ON group_instance.instance = id WHERE character_instance.instance IS NULL AND group_instance.instance IS NULL
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.group_instance' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('309','2139507520')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('409','1934576448')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('469','1934576448')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('509','2139507520')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('531','1934576448')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('532','1934576448')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('533','1934576448')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('534','1934576448')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('540','1841544000')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('542','1841544000')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('543','1841544000')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('544','1934576448')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54
    2008-08-23 14:10:54 >> Initialized 0 instances
    2008-08-23 14:10:54 Packing instances...
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('545','1841544000')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('546','1841544000')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('547','1841544000')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('548','1934576448')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('550','1934576448')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('552','1841544000')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('553','1841544000')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('554','1841544000')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('555','1841544000')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('556','1841544000')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('557','1841544000')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('558','1841544000')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('560','1841544000')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('564','1934576448')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('565','1934576448')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('568','2139507520')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54
    2008-08-23 14:10:54 >> Instance numbers remapped, next instance id is 600
    2008-08-23 14:10:54 Loading Localization strings...
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('580','1934576448')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: INSERT INTO instance_reset VALUES ('585','1841544000')
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-23 14:10:54 ERROR:SQL: DELETE FROM group_instance USING group_instance LEFT JOIN instance ON group_instance.instance = instance.id WHERE instance.id IS NULL
    2008-08-23 14:10:54 ERROR:SQL ERROR: Table 'characters.group_instance' doesn't exist
    2008-08-23 14:10:54
    2008-08-23 14:10:54 >> Loaded 0 MaNGOS locale strings. DB table mangos_string contains no localization.
    2008-08-23 14:10:54
    2008-08-23 14:10:54 >> Loaded 0 creature locale strings. DB table locales_creature is empty.
    2008-08-23 14:10:54
    2008-08-23 14:10:54 >> Loaded 0 gameobject locale strings. DB table locales_gameobject is empty.
    2008-08-23 14:10:54
    2008-08-23 14:10:54 >> Loaded 0 Item locale strings. DB table locales_item is empty.
    2008-08-23 14:10:54
    2008-08-23 14:10:54 >> Loaded 0 Quest locale strings. DB table locales_quest is empty.
    2008-08-23 14:10:54
    2008-08-23 14:10:54 >> Loaded 0 Quest locale strings. DB table locales_npc_text is empty.
    2008-08-23 14:10:54
    2008-08-23 14:10:54 >> Loaded 0 PageText locale strings. DB table locales_page_text is empty.
    2008-08-23 14:10:54 Loading Page Texts...
    2008-08-23 14:10:55 >> Loaded 1389 page texts
    2008-08-23 14:10:55
    2008-08-23 14:10:55 Loading Game Object Templates...
    2008-08-23 14:11:01 >> Loaded 13616 game object templates
    2008-08-23 14:11:01
    2008-08-23 14:11:01 Loading Spell Chain Data...
    2008-08-23 14:11:01
    2008-08-23 14:11:01 >> Loaded 1919 spell chain records
    2008-08-23 14:11:01 Loading Spell Elixir types...
    2008-08-23 14:11:01
    2008-08-23 14:11:01 >> Loaded 98 spell elixir definitions
    2008-08-23 14:11:01 Loading Spell Learn Skills...
    2008-08-23 14:11:01
    2008-08-23 14:11:01 >> Loaded 78 Spell Learn Skills from DBC
    2008-08-23 14:11:01 Loading Spell Learn Spells...
    2008-08-23 14:11:01
    2008-08-23 14:11:01 >> Loaded 14 spell learn spells + 500 found in DBC
    2008-08-23 14:11:01 Loading Spell Proc Event conditions...
    2008-08-23 14:11:01 ERROR:Spell 33280 listed in spell_proc_event does not exist
    2008-08-23 14:11:01 ERROR:Spell 35092 listed in spell_proc_event does not exist
    2008-08-23 14:11:01 ERROR:Spell 35093 listed in spell_proc_event does not exist
    2008-08-23 14:11:01 ERROR:Spell 35094 listed in spell_proc_event does not exist
    2008-08-23 14:11:01
    2008-08-23 14:11:01 >> Loaded 959 spell proc event conditions
    2008-08-23 14:11:01 Loading Aggro Spells Definitions...
    2008-08-23 14:11:01 >> Loaded 89 aggro generating spells
    2008-08-23 14:11:01
    2008-08-23 14:11:01 Loading NPC Texts...
    2008-08-23 14:11:02
    2008-08-23 14:11:02 >> Loaded 4357 npc texts
    2008-08-23 14:11:02 Loading Item Random Enchantments Table...
    2008-08-23 14:11:03
    2008-08-23 14:11:03 >> Loaded 28408 Item Enchantment definitions
    2008-08-23 14:11:03 Loading Items...
    2008-08-23 14:11:10 >> Loaded 23788 item prototypes
    2008-08-23 14:11:10
    2008-08-23 14:11:10 ERROR:Item (Entry: 849 8) not correct 20655 display id, must be 44666 (using it).
    2008-08-23 14:11:10 ERROR:Item (Entry: 10822) not correct 20655 display id, must be 51621 (using it).
    2008-08-23 14:11:10 ERROR:Item (Entry: 27515) not correct 38900 display id, must be 50502 (using it).
    2008-08-23 14:11:10 ERROR:Item (Entry: 27516) not correct 38895 display id, must be 50501 (using it).
    2008-08-23 14:11:10 ERROR:Item (Entry: 3380 8) not correct 47014 display id, must be 51920 (using it).
    2008-08-23 14:11:10 ERROR:Item (Entry: 3386 8) not correct 47131 display id, must be 51758 (using it).
    2008-08-23 14:11:10 ERROR:Item (Entry: 33955) not correct 47136 display id, must be 7744 (using it).
    2008-08-23 14:11:10 Loading Item Texts...
    2008-08-23 14:11:10
    2008-08-23 14:11:10 >> Loaded 0 item pages
    2008-08-23 14:11:10 Loading Creature Model Based Info Data...
    2008-08-23 14:11:10 >> Loaded 16891 creature model based info
    2008-08-23 14:11:10
    2008-08-23 14:11:10 Loading Equipment templates...
    2008-08-23 14:11:10 >> Loaded 1874 equipment template
    2008-08-23 14:11:10
    2008-08-23 14:11:10 Loading Creature templates...
    2008-08-23 14:11:13 ERROR:Error in creature_template table, probably sql file format was updated (there should be 65 fields in sql).

    Anyone help please. my server wont run because of this error:

    2008-08-23 14:11:13 ERROR:Error in creature_template table, probably sql file format was updated (there should be 65 fields in sql).

    Posted 1 year ago » Permalink

  2. Pitje

    Regular
    Joined: Aug '08
    Posts: 178

    there is a fix on the AF site, download an apply by running the bat file. will probably fix it.

    Posted 1 year ago » Permalink

RSS feed for this topic

Reply

You must log in to post.

Topic Info

Tags

Forums

General

Discuss about anything else

1,272 Topics – 6,703 Posts

Copyright © 2008 X-Forums All Rights Reserved

Design by 1234.info | Ported by Aditya | Reaper-X Blog | Reaper-X Forums | Store | 0.092 - 9 queries