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

WebEngine register error "String or binary data would be truncated" (sno__numb is shorter than 13 characters)

Escrita pelo MuADMINS a partir da fonteNot verified

WebEngine 1.2.7 fills MEMB_INFO.sno__numb with _defaultAccountSerial = '1111111111111' (13 characters, includes/classes/class.account.php line 16). The column size depends on the files:

  • IGCN S9 to S18: char(13) (fits exactly)
  • X-Team S2 / S17, MuDevs S18: char(18) (fits)
  • a MuEmu based Season 16 pack we read: char(7): every registration fails with "String or binary data would be truncated".

Check yours:

SELECT CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'MEMB_INFO' AND COLUMN_NAME = 'sno__numb';

Fix, pick one:

  1. Website side (no database change): set _defaultAccountSerial in class.account.php to a value that fits, for example 7 characters for char(7).
  2. Database side, backup first:
ALTER TABLE MEMB_INFO ALTER COLUMN sno__numb char(13) NOT NULL;

The same error appears for any value longer than its column (memb___id is varchar(10) in every MSSQL family we read).

Source: WebEngine 1.2.7 includes/classes/class.account.php; MEMB_INFO in the IGCN, X-Team, MuDevs scripts and MuServerS17/S16MuServer/MuOnline.sql (MuEmu based Season 16).

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.