mangos three pb with a quest + updates error in sqlyog....

[dragonlord]

hello !

 

while my mangotwo server runs almost fine i got a problem with mangosthree

 

i dumped all the fullDB .sql............ (by the way, if u know how to apply all .sql "in one" click u'll help me greatly clicking one-by-one is long & fatidious ! )

 

so i launch game and, at begin 3rd elf quest druid, i must "use rejuvanation on wounded sentinel" and it stays at 0/1 in quest panel/log........

(is it a known issue, should i stay with mangos two ??)

 

so i tested applying the updates this time... and got an error at "Rel21_02_03_start_up_error_fixes.sql" -> and all other .sql applying but this one...

 

and so when i launch mangos it says that i'm at :

Quote

[A] You have database Version: 21
2017-09-14 19:46:16 ERROR:                      Structure: 2
2017-09-14 19:46:16 ERROR:                        Content: 2
2017-09-14 19:46:16 ERROR:                    Description: creature_template changes
2017-09-14 19:46:16 ERROR:
2017-09-14 19:46:16 ERROR:  You need database Version: 21
2017-09-14 19:46:16 ERROR:                      Structure: 7
2017-09-14 19:46:16 ERROR:                        Content: 8
2017-09-14 19:46:16 ERROR:                    Description: kodo_roundup_tidyup
2017-09-14 19:46:16 ERROR:

.... but i can't apply updates, or fix the questn nor launch again the mangos.exe..

 

Can you help me please ?

 

 

[dragonlord]

(this has must taken some ages... i mean, to developp and fix all those quests and make em live.)

 

Merci Antz !

 

(i will try to get down.... to mangos Two....) just kiddin.. ;p

 

"i wanted to try WRATH off MOON AND SUN as almost all evil droods, of the alliance, just to BE THE BEST !!!"

 

 

edit: it's not finish between those fkin kids and us*.........\/\-(^.^)-\/\/

[antz]

This is relatively simple to sort out.....

From the message above you have update 21_2_2 installed and you need 21_7_8

You have two options.....

1) If you have not made any changed to the world database (characters are stored elsewhere), then I would suggest reloading just the world database.

2) Apply each of the updates from World\Updates\Rel21\Rel20_to_BaseRel21_Updates

Rel21_02_03_many_cmangos_updates.sql
Rel21_02_03_start_up_error_fixes.sql
Rel21_03_00_new_tables_added.sql
Rel21_03_01_many_cmangos_updates.sql
Rel21_03_02_burster_worms.sql
Rel21_03_03_npc_shaheen.sql
Rel21_04_00_player_exiting_battleground.sql
Rel21_04_01_missing_script_assignments.sql
Rel21_04_02_npc_trainer_template.sql
Rel21_04_03_creature_ai_scripts.sql
Rel21_04_04_start_up_error_fixes.sql
Rel21_04_05_BRD_updates.sql
Rel21_04_06_Remove_field_from_dbDocs_Subtable.sql
Rel21_04_07_dbdocs_update.sql
Rel21_04_08_Majordomo_Executus_Ragnaros_text.sql
Rel21_04_09_item_cub_first_toy.sql
Rel21_04_10_NPC_trainer_template_clean-up.sql
Rel21_04_11_Remove_Obsolete_quests.sql
Rel21_04_12_More_Quest_cleanup.sql
Rel21_04_13_NPC_movement_update.sql
Rel21_04_14_Return_to_Razor_hill_q.sql
Rel21_04_15_script_bind_updates.sql
Rel21_04_16_Battle_Worg_movement.sql
Rel21_04_17_Blackrock_spy_NPC.sql
Rel21_04_18_Fix_gossip_for_creature_6669.sql
Rel21_05_001_dbscripts_refactor.sql
Rel21_06_001_autobroadcast.sql
Rel21_06_002_Lunar_Firework_credit_marker.sql
Rel21_06_003_Verog_increase_spawn_chance.sql
Rel21_07_001_dbscripts_refactor.sql
Rel21_07_002_Gizrul_the_Slavene.sql
Rel21_07_003_NPC_9568_SD3_support.sql
Rel21_07_004_remove_obsolete_tables.sql
Rel21_07_005_Populate_missing_item_descriptions.sql
Rel21_07_006_Populate_missing_GO_desc.sql
Rel21_07_007_kodo_roundup_fix.sql
Rel21_07_008_kodo_roundup_tidyup.sql

 

 

[dragonlord]

hi antz & thx for support, do you know something (sqlyog or navicat) where and HOW you can load all .SQL dump in mangos database in one time ? (instead of everytime, loading each .sql dumps one-by-one please.)

 

EDIT: I FOUND "MySQL WORKBENCH" (Free) THAT DOES IT PERFECT no more one-by-one clicks

https://dev.mysql.com/downloads/file/?id=468295

 

 

[dragonlord]

tried your solution 1)- : the quest is bugued (i do rejuvenation on the npc and it does not count in quest log as 1/1 ...)

 

then applied updates 2)- : the mangos.exe won't start i (still) got this :
 

Quote

 

 

[A] You have database Version: 21
2017-09-17 18:40:22 ERROR:                      Structure: 2
2017-09-17 18:40:22 ERROR:                        Content: 1
2017-09-17 18:40:22 ERROR:                    Description: script_binding populated
2017-09-17 18:40:22 ERROR:
2017-09-17 18:40:22 ERROR:  You need database Version: 21
2017-09-17 18:40:22 ERROR:                      Structure: 7
2017-09-17 18:40:22 ERROR:                        Content: 8
2017-09-17 18:40:22 ERROR:                    Description: kodo_roundup_tidyup

 

  ->

18:44:56 Restoring N:\wow_server\mangosthree\database\World\Updates\Rel21\Rel20_to_BaseRel21_Updates\Rel21_02_03_start_up_error_fixes.sql
Running: mysql.exe --defaults-file="c:\tmp\tmpfj0sga.cnf"  --protocol=tcp --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments --database=mangos3  < "N:\\wow_server\\mangosthree\\database\\World\\Updates\\Rel21\\Rel20_to_BaseRel21_Updates\\Rel21_02_03_start_up_error_fixes.sql"
ERROR 1265 (01000) at line 264: Data truncated for column 'attr' at row 1

Operation failed with exitcode 1

 

, plz help ! (bugued quest ? can ignore it ?)

[antz]

Do you use skype at all ?, i'd like to connect to your pc and help sort this out for you !!

If you do, please PM your ID !!

Antz

[dragonlord]

i have teamviewer, pm me.

[antz]

done