Community AlphaAlpha MUADMINS
ITItaliano
Accedi
Su MuADMINSConfig ScannerCarica lo zip dei tuoi file: rates, drop, spot, limitiApriSu MuADMINSIncontraci su DiscordChiedi aiuto, condividi quello che stai creando e parla di MU con altri proprietari di server.Apri
← Tutte le soluzioni

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

Scritto da MuADMINS a partire dalla 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).

Scritto da MuADMINS
Ti è stato utile?

Non hai ancora risolto? Cerca su MuGPS Chiedi all'Assistente MU

MuADMINS Community Alpha: gratuito, fatto dalla community, in sviluppo attivo.