3 3

As the figure shows.

There are a lot of monsters on the map that shouldn't exist. And tasks cannot interact normally.

Is there a problem with my database?

Version:  Mangos Three v0.22 [SD3] Fix ZG crash 

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

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!

Thanks for answer!

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

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%

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