Jump to content

Error while Runing Mangos


Guest tidus666x

Recommended Posts

Hello

When I try to run mangos I got this error :

  [A] You have: --> `9763_01_mangos_battleground_template.sql`
[0 ms] SQL: SET NAMES `utf8`
 [b] You need: --> `9899_01_mangos_spell_bonus_data.sql`[0 ms] SQL: SET CHARACT
ER SET `utf8`

My Database Version is :

UDB 0.12.0 (390) for MaNGOS 9763 with SD2 SQL for rev. 1677

So, I say to myself that I will do the uodate but when I try to Restore the file

9767_01_mangos_mangos_string.sql

SQLyLog send me :


Query:
/*  */
/* AREATRIGGER */
DELETE FROM areatrigger_scripts WHERE entry=4591
Error occured at:2010-05-16 17:52:57
Line no.:4
Error Code: 1146 - Table 'scriptdev2.areatrigger_scripts' doesn't exist
Query:
UPDATE creature_template SET faction_A=1733, faction_H=1733, npcflag=npcflag|1, unit_flags=768, baseattacktime=2000, rangeattacktime=0, dynamicflags=0, scale=1.000000, unit_class=1, speed_walk=1.000000, speed_run=1.428571 WHERE entry=39371
Error occured at:2010-05-16 18:05:33
Line no.:274
Error Code: 1054 - Unknown column 'speed_walk' in 'field list'
Query:
ALTER TABLE character_db_version CHANGE COLUMN required_9250_01_characters_character required_9339_01_characters_group bit
Error occured at:2010-05-16 18:06:47
Line no.:2
Error Code: 1054 - Unknown column 'required_9250_01_characters_character' in 'character_db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_9310_01_mangos_spell_elixir required_9312_01_mangos_quest_template bit
Error occured at:2010-05-16 20:56:48
Line no.:2
Error Code: 1054 - Unknown column 'required_9310_01_mangos_spell_elixir' in 'db_version'
Query:
UPDATE creature_template SET faction_A=1733, faction_H=1733, npcflag=npcflag|1, unit_flags=768, baseattacktime=2000, rangeattacktime=0, dynamicflags=0, scale=1.000000, unit_class=1, speed_walk=1.000000, speed_run=1.428571 WHERE entry=39371
Error occured at:2010-05-16 20:57:11
Line no.:274
Error Code: 1054 - Unknown column 'speed_walk' in 'field list'
Query:
ALTER TABLE db_version CHANGE COLUMN required_9622_01_mangos_gameobject required_9636_01_mangos_item_template bit
Error occured at:2010-05-16 20:57:23
Line no.:2
Error Code: 1054 - Unknown column 'required_9622_01_mangos_gameobject' in 'db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_9891_02_mangos_creature_movement_scripts required_9899_01_mangos_spell_bonus_data bit
Error occured at:2010-05-16 21:00:16
Line no.:1
Error Code: 1054 - Unknown column 'required_9891_02_mangos_creature_movement_scripts' in 'db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_9690_01_mangos_spell_proc_event required_9692_03_mangos_spell_proc_event bit
Error occured at:2010-05-16 21:00:51
Line no.:1
Error Code: 1054 - Unknown column 'required_9690_01_mangos_spell_proc_event' in 'db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_9136_02_mangos_quest_poi required_9136_04_mangos_spell_chain bit
Error occured at:2010-05-16 21:01:11
Line no.:1
Error Code: 1054 - Unknown column 'required_9136_02_mangos_quest_poi' in 'db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_9663_01_mangos_mangos_string required_9690_01_mangos_spell_proc_event bit
Error occured at:2010-05-16 21:10:21
Line no.:1
Error Code: 1054 - Unknown column 'required_9663_01_mangos_mangos_string' in 'db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_9690_01_mangos_spell_proc_event required_9692_03_mangos_spell_proc_event bit
Error occured at:2010-05-16 21:10:51
Line no.:1
Error Code: 1054 - Unknown column 'required_9690_01_mangos_spell_proc_event' in 'db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_9716_01_mangos_npc_vendor required_9716_02_mangos_mangos_string bit
Error occured at:2010-05-16 21:12:28
Line no.:1
Error Code: 1054 - Unknown column 'required_9716_01_mangos_npc_vendor' in 'db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_9854_01_mangos_spell_bonus_data required_9881_01_mangos_scripts bit
Error occured at:2010-05-16 21:18:18
Line no.:1
Error Code: 1054 - Unknown column 'required_9854_01_mangos_spell_bonus_data' in 'db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_9854_01_mangos_spell_bonus_data required_9881_01_mangos_scripts bit
Error occured at:2010-05-16 21:18:32
Line no.:1
Error Code: 1054 - Unknown column 'required_9854_01_mangos_spell_bonus_data' in 'db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_9883_01_mangos_scripts required_9886_01_mangos_mangos_string bit
Error occured at:2010-05-16 21:19:21
Line no.:1
Error Code: 1054 - Unknown column 'required_9883_01_mangos_scripts' in 'db_version'
Query:
ALTER TABLE character_db_version CHANGE COLUMN required_9375_01_characters_character_glyphs required_9611_01_characters bit
Error occured at:2010-05-16 21:19:42
Line no.:1
Error Code: 1054 - Unknown column 'required_9375_01_characters_character_glyphs' in 'character_db_version'
Query:
ALTER TABLE character_db_version CHANGE COLUMN required_9611_01_characters required_9630_01_characters_characters bit
Error occured at:2010-05-16 21:19:50
Line no.:1
Error Code: 1054 - Unknown column 'required_9611_01_characters' in 'character_db_version'
Query:
ALTER TABLE character_db_version CHANGE COLUMN required_9630_01_characters_characters required_9632_01_characters_characters bit
Error occured at:2010-05-16 21:19:57
Line no.:1
Error Code: 1054 - Unknown column 'required_9630_01_characters_characters' in 'character_db_version'
Query:
ALTER TABLE character_db_version CHANGE COLUMN required_9634_01_characters_corpse required_9635_01_characters_characters bit
Error occured at:2010-05-16 21:20:10
Line no.:1
Error Code: 1054 - Unknown column 'required_9634_01_characters_corpse' in 'character_db_version'
Query:
ALTER TABLE character_db_version CHANGE COLUMN required_9646_01_characters_characters required_9661_01_characters_character_talent bit
Error occured at:2010-05-16 21:20:20
Line no.:1
Error Code: 1054 - Unknown column 'required_9646_01_characters_characters' in 'character_db_version'
Query:
ALTER TABLE character_db_version CHANGE COLUMN required_9692_01_characters_mail required_9692_02_characters_mail bit
Error occured at:2010-05-16 21:20:37
Line no.:1
Error Code: 1054 - Unknown column 'required_9692_01_characters_mail' in 'character_db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_9881_01_mangos_scripts required_9883_01_mangos_scripts bit
Error occured at:2010-05-16 21:21:06
Line no.:1
Error Code: 1146 - Table 'characters.db_version' doesn't exist
Query:
ALTER TABLE db_version CHANGE COLUMN required_9881_01_mangos_scripts required_9883_01_mangos_scripts bit
Error occured at:2010-05-16 21:21:28
Line no.:1
Error Code: 1146 - Table 'characters.db_version' doesn't exist
Query:
ALTER TABLE db_version CHANGE COLUMN required_9881_01_mangos_scripts required_9883_01_mangos_scripts bit
Error occured at:2010-05-16 21:22:50
Line no.:1
Error Code: 1146 - Table 'characters.db_version' doesn't exist
Query:
ALTER TABLE db_version CHANGE COLUMN required_9891_01_mangos_creature_movement required_9891_02_mangos_creature_movement_scripts bit
Error occured at:2010-05-16 21:23:33
Line no.:1
Error Code: 1146 - Table 'characters.db_version' doesn't exist
Query:
ALTER TABLE db_version CHANGE COLUMN required_9881_01_mangos_scripts required_9883_01_mangos_scripts bit
Error occured at:2010-05-16 21:23:37
Line no.:1
Error Code: 1146 - Table 'characters.db_version' doesn't exist
Query:
ALTER TABLE db_version CHANGE COLUMN required_9766_01_mangos_spell_proc_event required_9767_01_mangos_mangos_string bit
Error occured at:2010-05-17 07:31:44
Line no.:1
Error Code: 1054 - Unknown column 'required_9766_01_mangos_spell_proc_event' in 'db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_9766_01_mangos_spell_proc_event required_9767_01_mangos_mangos_string bit
Error occured at:2010-05-17 07:38:20
Line no.:1
Error Code: 1054 - Unknown column 'required_9766_01_mangos_spell_proc_event' in 'db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_9755_01_mangos_instance_template required_9761_01_mangos_mangos_string bit
Error occured at:2010-05-17 07:38:31
Line no.:1
Error Code: 1054 - Unknown column 'required_9755_01_mangos_instance_template' in 'db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_9767_01_mangos_mangos_string required_9767_02_mangos_command bit
Error occured at:2010-05-17 07:39:31
Line no.:1
Error Code: 1054 - Unknown column 'required_9767_01_mangos_mangos_string' in 'db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_9767_02_mangos_command required_9768_01_mangos_command bit
Error occured at:2010-05-17 07:39:43
Line no.:1
Error Code: 1054 - Unknown column 'required_9767_02_mangos_command' in 'db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_9755_01_mangos_instance_template required_9761_01_mangos_mangos_string bit
Error occured at:2010-05-17 07:39:53
Line no.:1
Error Code: 1054 - Unknown column 'required_9755_01_mangos_instance_template' in 'db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_9755_01_mangos_instance_template required_9761_01_mangos_mangos_string bit
Error occured at:2010-05-17 07:39:57
Line no.:1
Error Code: 1054 - Unknown column 'required_9755_01_mangos_instance_template' in 'db_version'
Query:
DELETE FROM sd2_db_version
Error occured at:2010-05-17 07:45:19
Line no.:5
Error Code: 1146 - Table 'scriptdev2.sd2_db_version' doesn't exist
Query:
ALTER TABLE db_version CHANGE COLUMN required_9766_01_mangos_spell_proc_event required_9767_01_mangos_mangos_string bit
Error occured at:2010-05-17 07:49:01
Line no.:1
Error Code: 1054 - Unknown column 'required_9766_01_mangos_spell_proc_event' in 'db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_9766_01_mangos_spell_proc_event required_9767_01_mangos_mangos_string bit
Error occured at:2010-05-17 08:20:17
Line no.:1
Error Code: 1054 - Unknown column 'required_9766_01_mangos_spell_proc_event' in 'db_version'


Thanks

Link to comment
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use