Now i come pass that by skipping the file and taking another newer..
no my problem is 11117_02_characters_world.sql
it gives me errors
the dm charecter database require it it says
and its the only one that exists...
i get this :
Query:
ALTER TABLE character_db_version CHANGE COLUMN required_10503_02_characters_gameobject_respawn required_10568_01_characters_character_tutorial bit
Error occured at:2011-03-18 21:16:52
Line no.:2
Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist
Query:
CREATE FUNCTION `ConvertAuras`(`auras` varchar(1024))
RETURNS varchar(1024) CHARSET utf8
BEGIN
DECLARE tmp VARCHAR(1024);
DECLARE curr VARCHAR(10);
DECLARE k INT;
DECLARE pos INT;
DECLARE startp INT;
SET @k = 0;
SET @tmp = '';
SET @startp = 1;
SET @pos = LOCATE(' ', auras);
DELETE FROM temp_auras;
WHILE @pos > 0 DO
IF @k = 0 THEN
SET @curr = SUBSTR(auras, @startp, @pos - @startp);
IF NOT EXISTS(SELECT spell FROM temp_auras WHERE spell = @curr) THEN
SET @tmp = CONCAT(@tmp, @curr, ' ');
INSERT INTO temp_auras VALUES(@curr);
END IF;
END IF;
SET @k = 1-@k;
SET @startp = @pos+1;
SET @pos = LOCATE(' ', auras, @startp);
END WHILE;
SET @tmp = RTRIM(@tmp);
RETURN @tmp;
END
Error occured at:2011-03-18 21:38:32
Line no.:147
Error Code: 1146 - Table 'mysql.proc' doesn't exist
Query:
ALTER TABLE db_version CHANGE COLUMN required_11117_01_mangos_world_template required_11169_01_mangos_mangos_string bit
Error occured at:2011-03-18 21:39:27
Line no.:2
Error Code: 1054 - Unknown column 'required_11117_01_mangos_world_template' in 'db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_10503_04_mangos_gameobject_respawn required_10537_01_mangos_command bit
Error occured at:2011-03-19 14:46:28
Line no.:1
Error Code: 1054 - Unknown column 'required_10503_04_mangos_gameobject_respawn' in 'db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_10503_04_mangos_gameobject_respawn required_10537_01_mangos_command bit
Error occured at:2011-03-19 14:52:09
Line no.:1
Error Code: 1054 - Unknown column 'required_10503_04_mangos_gameobject_respawn' in 'db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_10503_04_mangos_gameobject_respawn required_10537_01_mangos_command bit
Error occured at:2011-03-19 15:25:06
Line no.:1
Error Code: 1054 - Unknown column 'required_10503_04_mangos_gameobject_respawn' in 'db_version'
Query:
ALTER TABLE character_db_version CHANGE COLUMN required_10503_02_characters_gameobject_respawn required_10568_01_characters_character_tutorial bit
Error occured at:2011-03-19 15:30:52
Line no.:1
Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist
Query:
ALTER TABLE db_version CHANGE COLUMN required_10679_01_mangos_npc_vendor_template required_10679_02_mangos_creature_template bit
Error occured at:2011-03-19 15:32:55
Line no.:1
Error Code: 1054 - Unknown column 'required_10679_01_mangos_npc_vendor_template' in 'db_version'
Query:
CREATE FUNCTION `ConvertAuras`(`auras` varchar(1024))
RETURNS varchar(1024) CHARSET utf8
BEGIN
DECLARE tmp VARCHAR(1024);
DECLARE curr VARCHAR(10);
DECLARE k INT;
DECLARE pos INT;
DECLARE startp INT;
SET @k = 0;
SET @tmp = '';
SET @startp = 1;
SET @pos = LOCATE(' ', auras);
DELETE FROM temp_auras;
WHILE @pos > 0 DO
IF @k = 0 THEN
SET @curr = SUBSTR(auras, @startp, @pos - @startp);
IF NOT EXISTS(SELECT spell FROM temp_auras WHERE spell = @curr) THEN
SET @tmp = CONCAT(@tmp, @curr, ' ');
INSERT INTO temp_auras VALUES(@curr);
END IF;
END IF;
SET @k = 1-@k;
SET @startp = @pos+1;
SET @pos = LOCATE(' ', auras, @startp);
END WHILE;
SET @tmp = RTRIM(@tmp);
RETURN @tmp;
END
Error occured at:2011-03-19 15:42:26
Line no.:42
Error Code: 1146 - Table 'mysql.proc' doesn't exist
Query:
ALTER TABLE character_db_version CHANGE COLUMN required_10973_01_characters_game_event_status required_11117_02_characters_world bit
Error occured at:2011-03-19 15:47:02
Line no.:1
Error Code: 1054 - Unknown column 'required_10973_01_characters_game_event_status' in 'character_db_version'
Query:
ALTER TABLE character_db_version CHANGE COLUMN required_10973_01_characters_game_event_status required_11117_02_characters_world bit
Error occured at:2011-03-19 15:47:38
Line no.:1
Error Code: 1054 - Unknown column 'required_10973_01_characters_game_event_status' in 'character_db_version'
Query:
ALTER TABLE character_db_version CHANGE COLUMN required_10254_01_characters_auctionhouse required_10312_01_characters_character_aura bit
Error occured at:2011-03-19 15:48:25
Line no.:2
Error Code: 1054 - Unknown column 'required_10254_01_characters_auctionhouse' in 'character_db_version'
Query:
ALTER TABLE character_db_version CHANGE COLUMN required_10503_02_characters_gameobject_respawn required_10568_01_characters_character_tutorial bit
Error occured at:2011-03-19 15:48:30
Line no.:2
Error Code: 1054 - Unknown column 'required_10503_02_characters_gameobject_respawn' in 'character_db_version'
Query:
ALTER TABLE character_db_version CHANGE COLUMN required_10664_01_characters_arena_team_stats required_10862_01_characters_mail bit
Error occured at:2011-03-19 15:48:39
Line no.:2
Error Code: 1054 - Unknown column 'required_10664_01_characters_arena_team_stats' in 'character_db_version'
Query:
ALTER TABLE character_db_version CHANGE COLUMN required_10862_01_characters_mail required_10973_01_characters_game_event_status bit
Error occured at:2011-03-19 15:48:45
Line no.:2
Error Code: 1054 - Unknown column 'required_10862_01_characters_mail' in 'character_db_version'
Query:
ALTER TABLE character_db_version CHANGE COLUMN required_10973_01_characters_game_event_status required_11117_02_characters_world bit
Error occured at:2011-03-19 15:48:51
Line no.:2
Error Code: 1054 - Unknown column 'required_10973_01_characters_game_event_status' in 'character_db_version'
Query:
ALTER TABLE character_db_version CHANGE COLUMN required_10862_01_characters_mail required_10973_01_characters_game_event_status bit
Error occured at:2011-03-19 15:49:43
Line no.:1
Error Code: 1054 - Unknown column 'required_10862_01_characters_mail' in 'character_db_version'
Query:
ALTER TABLE character_db_version CHANGE COLUMN required_10973_01_characters_game_event_status required_11117_02_characters_world bit
Error occured at:2011-03-19 15:51:41
Line no.:1
Error Code: 1054 - Unknown column 'required_10973_01_characters_game_event_status' in 'character_db_version'
Query:
ALTER TABLE character_db_version CHANGE COLUMN required_10973_01_characters_game_event_status required_11117_02_characters_world bit
Error occured at:2011-03-19 15:54:20
Line no.:1
Error Code: 1054 - Unknown column 'required_10973_01_characters_game_event_status' in 'character_db_version'