BrainStorm
Members-
Posts
35 -
Joined
-
Last visited
Never -
Donations
0.00 GBP
Content Type
Profiles
Bug Tracker
Wiki
Release Notes
Forums
Downloads
Blogs
Events
Everything posted by BrainStorm
-
ive learned that im dumb on sql updates ! HELP !
BrainStorm replied to Auntie Mangos's topic in OldGeneral support
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' -
ive learned that im dumb on sql updates ! HELP !
BrainStorm replied to Auntie Mangos's topic in OldGeneral support
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 -
ive learned that im dumb on sql updates ! HELP !
BrainStorm replied to Auntie Mangos's topic in OldGeneral support
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. -
[Python] (Yet Another) Script for SQL Updates
BrainStorm replied to a topic in Old3rd party projects
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 ! -
[REQUEST] Complexed registration.
BrainStorm replied to Auntie Mangos's topic in OldGeneral discussion
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.. -
[REQUEST] Complexed registration.
BrainStorm replied to Auntie Mangos's topic in OldGeneral discussion
Error: Page Not found (Error 404): The requested page showthread.php could not be found.. -
[Python] (Yet Another) Script for SQL Updates
BrainStorm replied to a topic in Old3rd party projects
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 ! -
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..
Contact Us
To contact us
click here
You can also email us at [email protected]
Privacy Policy | Terms & Conditions
You can also email us at [email protected]
Privacy Policy | Terms & Conditions
Copyright © getMaNGOS. All rights Reserved.
This website is in no way associated with or endorsed by Blizzard Entertainment®
This website is in no way associated with or endorsed by Blizzard Entertainment®