Louis (JogandoMU) Season 6 files ship one SQL file per update. If the files are newer than the database, the server logs Invalid column name 'X'. Find X below and run that script (and the ones before it you skipped), server closed, backup first:
- MEMB_INFO.Lock: Update 7 "Lock.sql"
- MEMB_INFO.Bloc_Expire, Character.Bloc_Expire: Update 11 "Ban columns.sql"
- Character.Kills, Deads: Update 4 "Kills and Deads.sql"
- Character.ItemStart: Update 14 "Add Item Start column.sql"
- MEMB_INFO.ShowBanner: Update 24
- MEMB_INFO.OnlineRewardTime1 / 2 / 3: Update 26
- AccountCharacter.GameID6 to GameID10: Update 26 "Update AccountCharacter.sql" (with the new WZ_CreateCharacter)
- Character.CustomFlag: Update 26; Character.EffectList varbinary(416): Update 27
- Character.CustomSkin, MEMB_INFO.WarehouseCount: Update 28
New tables come the same way: CustomQuest, CustomGift, RankingKingGuild / RankingKingPlayer (U3), CustomAttack, WarehouseGuild (U11), CustomNpcQuest (U13), CustomJewelBank, RankingBattleRoyale, RankingGvG (U17), CustomStore, CustomAttackOffline (U20), EventAuction, RankingPvpChampionship (U23), EventEntryCount (U25), GremoryCase, CustomFlag (U26), CustomCommandDelay (U27), CustomItemBank, CustomSkin (U28).
Check a column before running anything:
SELECT TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME IN ('Lock', 'Bloc_Expire', 'ShowBanner', 'OnlineRewardTime1', 'WarehouseCount', 'GameID6', 'CustomSkin');Source: Louis (JogandoMU) MuServer Season 6 Update 27 SQL folder (49 files) and V29 Update 28 SQL folder (4 files).