Jump to content

BrainStorm

Members
  • Posts

    35
  • Joined

  • Last visited

    Never
  • Donations

    0.00 GBP 

Everything posted by BrainStorm

  1. 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'
  2. im asking for help to get help !? is that so hard to understand ? ive tryed read all the guides but cant figure it out i have the db required version for mangos required_10537_01_mangos_command ive tryede to find it and i found it but it gives me error so i cant uppdate it PLEASE HELP
  3. Hi and thanx for looking in ! Ive got error starting my server and i realy dont know howto fix this. i have read the instruction but i gues im to dumb to understand. can someone maby help me uppdate my data base to the newest ? or maby send me one big file that has the newest. here is the errors: 2011-03-19 10:37:43 ERROR:SQL: SELECT required_11234_01_mangos_command FROM db_version LIMIT 1 2011-03-19 10:37:43 ERROR:query ERROR: Unknown column 'required_11234_01_mangos_command' in 'field list' 2011-03-19 10:37:43 ERROR:The table `db_version` in your [WORLD] database indicates that this database is out of date! 2011-03-19 10:37:43 ERROR: 2011-03-19 10:37:43 ERROR: [A] You have: --> `10537_01_mangos_command.sql` 2011-03-19 10:37:43 ERROR: 2011-03-19 10:37:43 ERROR: [b] You need: --> `11234_01_mangos_command.sql` 2011-03-19 10:37:43 ERROR: 2011-03-19 10:37:43 ERROR:You must apply all updates after [A] to [b] to use mangos with this database. 2011-03-19 10:37:43 ERROR:These updates are included in the sql/updates folder. 2011-03-19 10:37:43 ERROR:Please read the included [README] in sql/updates for instructions on updating.
  4. well sorry i dident know that that was an rule.. as you see ive changed that now but my mail ? do i have to disable users from seing my mejl therefor not being able to email me ? if so i think the rules is to hard.. (NOTE) I saw now that it has the function : Hide your email address but allow form email. so ive done that.. PEASE OUT !
  5. Error: Page Not found (Error 404): The requested page showthread.php could not be found.. What are you talking about? ye sry i just sedd that youre link dosent work..
  6. Error: Page Not found (Error 404): The requested page showthread.php could not be found..
  7. Hi there !.. im not so good on this but ehm is this an update toll that uppdates the updates for the client ???? in other words.. does it fetch uppdates from the real wow and buts them to work on the P Server ? if so this is exactly what ive been looking for ! im goin to start an swedish sever that hopfully gonna be the best wow swedish server in sweden.. if you want to conterbute help then you re more the welcome to do so.. if this is what im hoping it is please pm me directly or post an mejl to me GREATINGS form John !
  8. I think i understand youre text now.. so now i get this message from what i understand that youre saying to do... I get this : cat: d:/pigpow/.git/rebase-apply/next: No such file or directory previous rebase directory d:/pigpow/.git/rebase-apply still exist but mbox given. i thuagt i would be making this server without any problem but now it will take longer time so i gues il not be in time befor my work starts well..
  9. • Right click on C:\\Mangos and choose “Git Bash” WHAT THE HELL IS THAT !?!?!? Right click on “Git Bash” !?!?!?!? I REALY DONT UNDERSTAND U !? and I dont see no “At revision: 1643” !? i only see at reversion "number" HEEEEELP !
×
×
  • 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