* UPDATE SKIPPED * Rel22_03_007 - IS NOT APPLIED 22_3_6 - Mangos_Strings

[3 3]

World\Updates\Rel22\Rel22_03_008_Fix_GameEvents_attempt2.sql
* UPDATE SKIPPED *      Rel22_03_007 - IS NOT APPLIED   22_3_6 - Mangos_Strings
World\Updates\Rel22\Rel22_03_009_Quest_12092_12096_script.sql
* UPDATE SKIPPED *      Rel22_03_008 - IS NOT APPLIED   22_3_6 - Mangos_Strings
World\Updates\Rel22\Rel22_03_010_Fix_Creature_MovementType.sql
* UPDATE SKIPPED *      Rel22_03_009 - IS NOT APPLIED   22_3_6 - Mangos_Strings
World\Updates\Rel22\Rel22_04_001_Remove_wpguid.sql
* UPDATE SKIPPED *      Rel22_03_010 - IS NOT APPLIED   22_3_6 - Mangos_Strings
World\Updates\Rel22\Rel22_04_002_Remove_areatrigger_involvedrelation_.sql
* UPDATE SKIPPED *      Rel22_04_001 - IS NOT APPLIED   22_3_6 - Mangos_Strings
World\Updates\Rel22\Rel22_04_003_Fix_Furbolg_Ear_Stacking.sql
* UPDATE SKIPPED *      Rel22_04_002 - IS NOT APPLIED   22_3_6 - Mangos_Strings
World\Updates\Rel22\Rel22_04_004_Fix_Quest_26010.sql
* UPDATE SKIPPED *      Rel22_04_003 - IS NOT APPLIED   22_3_6 - Mangos_Strings
World\Updates\Rel22\Rel22_04_005_remove_subname_for_2694.sql
* UPDATE SKIPPED *      Rel22_04_004 - IS NOT APPLIED   22_3_6 - Mangos_Strings

[Fyre]

Okay. I see that it failed on 07 now in that screenshot.

I copied this from a Discord post a while ago. But I believe you could try one of the 2 following things:

Add the following line to the failing update .SQL script:
SET @@sql_mode := REPLACE(@@sql_mode, 'NO_ZERO_DATE', '');

Or you can also resolve it by turning off strict mode.

[3 3]

Using configuration file ./mangosd.conf.
Using SSL version: OpenSSL 1.1.1s  1 Nov 2022 (Library: OpenSSL 1.1.1s  1 Nov 2022)
Using ACE: 6.5.9
World Database total connections: 2
Connected to MySQL database [email protected]:3306/mangos3
MySQL client library: 5.7.43
MySQL server ver: 5.7.43-log
AUTOCOMMIT SUCCESSFULLY SET TO 1
Connected to MySQL database [email protected]:3306/mangos3
MySQL client library: 5.7.43
MySQL server ver: 5.7.43-log
AUTOCOMMIT SUCCESSFULLY SET TO 1
The table `db_version` indicates that your [World] database does not match the expected structure!

  [A] You have database Version: 22
                      Structure: 3
                        Content: 6
                    Description: Mangos_Strings

  [B] The core needs database Version: 22
                            Structure: 4
                              Content: 1
                          Description: Remove_wpguid

You must apply all updates after [A] to [B] to use MaNGOS with this database.
These updates are included in the database/World/Updates folder.

Wait 10 secs for continue.
================                                   = 30%

[Fyre]

Looks like you have Rel 22 03 06. 

And you tried to install the updates at Rel 22 03 08. You need to do Rel 22 03 07 first.

[3 3]

Thanks for answer!

In fact, I'm using "InstallDatabases.bat".Here's the full information:

 

Edited September 30, 2023 by 3 3

[3 3]

11 minutes ago, Fyre said:

Okay. I see that it failed on 07 now in that screenshot.

I copied this from a Discord post a while ago. But I believe you could try one of the 2 following things:

Add the following line to the failing update .SQL script:
SET @@sql_mode := REPLACE(@@sql_mode, 'NO_ZERO_DATE', '');

Or you can also resolve it by turning off strict mode.

Your help is greatly appreciated.

It works!

[Fyre]

Which strategy did you go with? The first one?

[3 3]

Yep,i added "SET @@sql_mode := REPLACE(@@sql_mode, 'NO_ZERO_DATE', '');" to the all failing update .SQL script.Then it works.

[Fyre]

Excellent - thank you for reporting your issue! And I'm glad the fix worked.
Going to get this fix integrated naturally so it doesn't raise again for people in the future.  

Wish you the best - if you need any other support, reach out via the Forums (or Discord)!