[Bungee 2.8.4] SQLException on start : column ‘home_server’ not found

[auremarc]

Help request

Problem
Paper 1.21.10-112
Bungee 1.21-R0.5-SNAPSHOT:5916f08:2007
MarriageMaster 2.8.4 (Bungee jar)

On first start the Bungee plugin prints:
java.sql.SQLException: Column 'home_server' not found
at com.mysql.cj.jdbc.result.ResultSetImpl.findColumn(ResultSetImpl.java:572)
…
at at.pcgamingfreaks.MarriageMasterStandalone.Database.Backend.SQL.loadHomes(SQL.java:391)

The table “marry_home” (MySQL) was created by an earlier 2.6.x install and does not contain the new column “home_server”.
Setting “Database.UpdateTables: true” is ignored because the option does not exist in the Bungee config (only in the Bukkit one).

Work-around : manually execute
ALTER TABLE marry_home ADD home_server VARCHAR(255) NULL AFTER home_world;
After that homes load normally.

Could the Bungee edition either:

• respect Database.UpdateTables, or
• ship the missing ALTER in the updater, or
• document the required manual change?

Thanks!

What I have tried
I can't really do something because I don't know what this home_server column refers about

[GeorgH93]

Please ensure that ALL servers using that database have the same DB and Bungee related settings, then the column should be autogenerated on startup, though if one server is misconfigured, it might remove the column.