Server - DB Mismatch

Not sure why, I've installed fresh 3 times now, and it tells you that you need to update from A to B which goes back to 2019/2020 database updates.

Seems to be the same for Mangos Zero/One/Two etc.

EG From Characters DB: (Add_field_comments is 2019)

2023-11-11 15:30:24 The table `db_version` indicates that your [Character] database does not match the expected structure!
2023-11-11 15:30:24 
2023-11-11 15:30:24   [A] You have database Version: 22
2023-11-11 15:30:24                       Structure: 2
2023-11-11 15:30:24                         Content: 1
2023-11-11 15:30:24                     Description: Add_field_comments
2023-11-11 15:30:24 
2023-11-11 15:30:24   [B] The core needs database Version: 22
2023-11-11 15:30:24                             Structure: 4
2023-11-11 15:30:24                               Content: 1
2023-11-11 15:30:24                           Description: Add_Quest_Tracker_Table

Did you pull the databases recently? There have been permission fixes a couple of days ago, since the updates in character database were only able to be applied as user root.

Your mariadb user needs permissions CREATE ROUTINE and ALTER ROUTINE to apply updates...

@cbuntingde

install the db updates in Character/updates/Rel22
Rel22_03_001_Adjust_Tables.sql
Rel22_04_001_Add_Quest_Tracker_Table.sql 

As a random interjection, I wanted to note that the InstallDatabases (at least with the Bash script) process offers to install updates (and attempts to,) but can not do so as they are all archived in their respective 7zip files.

database/Character/Updates/Rel21/Rel20_to_BaseRel21_Updates/Rel20_to_BaseRel21_Updates.7z
database/Character/Updates/Rel21/Rel21_to_BaseRel22_Updates/Rel21_to_BaseRel22_Updates.7z
database/Character/Updates/Rel22/Rel21_to_BaseRel22_Updates/Rel21_to_BaseRel22_Updates.7z

Just for example. Unpacking these prior to update attempt would be trivial for the bat/sh script, but it is currently not done. I know from reading elsewhere that this process will eventually be depreciated in favor of a more automated update process, so I'm not sure if dumping any time or effort into fixing this here would be worthwhile. However, if we know for a fact that we'll need to always apply the contents of Rel21_to_BaseRel22_Updates.7z after database creation, extracting the contents to Character/Updates/Rel22/ is a no-brainer.

From my experiences with the latest database release and server, these were the only ones needing updated. Though it would be safe to say that it can't be presumed this will always be the case. After initially testing a build from scratch on a new server, I converted and imported an old Rel21 database and needed to update quite a bit from both World and Character, as well as at least one item from Realm.

It occurs to me that one could query the database automatically after install, since we already have the db names and login details to get the current version/structure, and update from there. Though this too is mostly trivial, it would require some knowledge of both Bash and Windows command line (and/or PowerShell if applicable.)

Not saying that I personally have the time to look at this at this point in my life, but IF i do happen to find a way to accomplish some or all of this (during a drunken One Piece marathon while my family is away for the holiday,) I will certainly share my findings with you folks.  XD

Brand new user here ... I could solve the realmd update issues and update but unfortunately not the mangos d version mismatch issue , when trying to apply the updates update 22_03 fails. preventing further updates ... any help would be greatly appreciated as I am in the last bit of the setup for the server.

mysql -u root character0 < Rel22_03_001_Adjust_Tables.sql
===== Status =====    ===== DB is on Version: =====
* UPDATE FAILED *    Add_field_comments
root@X299-DARK:/home/mangos/mangos/zero/db/database/Character/Updates/Rel22# mysql -u root character0 < Rel22_0
Rel22_03_001_Adjust_Tables.sql            Rel22_04_001_Add_Quest_Tracker_Table.sql  
root@X299-DARK:/home/mangos/mangos/zero/db/database/Character/Updates/Rel22# mysql -u root character0 < Rel22_04_001_Add_Quest_Tracker_Table.sql
===== Status =====    === Expected ===    ===== Found Version =====
* UPDATE SKIPPED *    Rel22_03_001 - IS NOT APPLIED    22_2_1 - Add_field_comments
root@X299-DARK:/home/mangos/mangos/zero/db/database/Character/Updates/Rel22#

I had exactly same issue and the solution worked

The trick is you have to find all the "updates" between A and B and apply them one by one.