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

MuDevs Season 18: Invalid column name 'LastGateIndex' (the extra query of the pack)

Escrita pelo MuADMINS a partir da fonteNot verified

The MuDevs Season 18 pack ships, next to the database scripts, a file Execute query.sql with one statement:

ALTER TABLE dbo.Character ADD LastGateIndex [int] NOT NULL DEFAULT(-1);

If the DataServer or GameServer complains about LastGateIndex, that query was not run. Run it once on MuOnline (server closed, backup first). Safe form that does nothing when the column already exists:

IF COL_LENGTH('dbo.Character', 'LastGateIndex') IS NULL
  ALTER TABLE dbo.Character ADD LastGateIndex int NOT NULL DEFAULT(-1);

MuDevs creates the databases with "MuOnline DB Create Script.sql" and "BattleCore DB Create Script.sql" (recommended over the .bak) and needs SQL Server 2012 or newer.

Source: MuDevs Season 18 Files/Execute query.sql and Files/DB/Create with query; MuDevs install notes as summarised in the MuADMINS SQL guide research.

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.