Community AlphaAlpha MUADMINS
PTPortuguês (Brasil)
Entrar
No MuADMINSConfig ScannerEnvie o zip dos seus arquivos: rates, drops, spots, limitesAbrirNo MuADMINSEncontre-nos no DiscordPeça ajuda, mostre o que está criando e converse sobre MU com outros donos de servidores.Abrir
← Todas as soluções

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

Escrita pelo MuADMINS a partir da fonteNot 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).

Escrito pelo MuADMINS
Isso ajudou?

Ainda com problema? Buscar no MuGPS Pergunte ao Assistente MU

MuADMINS Community Alpha: grátis, feito pela comunidade e em desenvolvimento ativo.