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

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

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

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.