database update fail on mangostwo

[latzl]

project: mangostwo
server version: tag v22.02.57 ; commit e5b92b09f2b4
os: ubuntu 20.04
mysql version: 
$ /home/wow/proj/mysql# dpkg -l | grep mysql
    ii  libmysqlclient-dev                    5.7.41-1ubuntu18.04               amd64        MySQL development headers
    ii  libmysqlclient20:amd64                5.7.41-1ubuntu18.04               amd64        MySQL shared client libraries
    ii  libmysqld-dev                         5.7.41-1ubuntu18.04               amd64        MySQL embedded server library
    ii  mysql-client                          5.7.41-1ubuntu18.04               amd64        MySQL Client meta package depending on latest version
    ii  mysql-common                          5.7.41-1ubuntu18.04               amd64        MySQL Common
    ii  mysql-community-client                5.7.41-1ubuntu18.04               amd64        MySQL Client
    ii  mysql-community-server                5.7.41-1ubuntu18.04               amd64        MySQL Server
    ii  mysql-server                          5.7.41-1ubuntu18.04               amd64        MySQL Server meta package depending on latest version

I use InstallDatabases.sh to install the database. I noticed that the database wasn't updated to the latest version completely. I update manully with command fllowing:

    mysql> source Rel22_02_024_Fix_GameEvent.sql;
    Query OK, 0 rows affected, 1 warning (0.00 sec)

    Query OK, 1 rows affected (0.00 sec)

    Empty set (0.01 sec)

    +--------------------+-------------------------------+
    | ===== Status ===== | ===== DB is on Version: ===== |
    +--------------------+-------------------------------+
    | * UPDATE FAILED *  | Mangos_Strings                |
    +--------------------+-------------------------------+
    1 row in set (0.01 sec)

    Query OK, 0 rows affected (0.01 sec)

    Query OK, 0 rows affected (0.00 sec)

    mysql> show warnings;
    Empty set (0.00 sec)

It was failed to update but no error message.
So that might be the reason why I got error message with my database mismatched with the server. How can I fix it?
 

[latzl]

It seems has the same question on 

 

And it works with mysql on Win by using InstallDatabases.bat rather than mysqldump:

    MySQL client library: 10.5.13

    MySQL server ver: 5.6.47

    MySQL client library: 10.5.13

    MySQL server ver: 5.6.47    

 

the issue haven't fix yet or it just happen on my envirenment?

Edited June 18, 2023 by latzl

[Necrovoice]

Try and clone the database from git again.  The current base install version is Rel22_02_024, and should only be applying Rel22_02_025 and up.

[latzl]

Thanks, everthing works after updating to ubuntu 22