Community AlphaAlpha MUADMINS
FILFilipino
Mag-sign in
Sa MuADMINSMag-ambagTumulong at makakuha ng Community PointsBuksanSa MuADMINSIskedyul ng mga eventBlood Castle, Devil Square, mga invasion sa isang lingguhang gridBuksan
← Lahat ng solusyon

Louis / MuEmu Season 6: "Invalid column name" after updating the server files (which Update script adds which column)

Isinulat ng MuADMINS mula sa sourceNot verified

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).

Isinulat ng MuADMINS
Nakatulong ba ito?

Naipit pa rin? Maghanap sa MuGPS Magtanong sa MU Assistant

MuADMINS Community Alpha: libre, gawa ng komunidad, at patuloy na dine-develop.