tidus666x

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