Community AlphaAlpha MUADMINS
PLPolski
Zaloguj się
Na MuADMINSConfig ScannerWgraj zip swoich plików: rates, dropy, spoty, limityOtwórzNa MuADMINSSpotkajmy się na DiscordziePoproś o pomoc, pokaż, nad czym pracujesz, i rozmawiaj o MU z innymi właścicielami serwerów.Otwórz
← Wszystkie rozwiązania

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

Napisane przez MuADMINS na podstawie źródłaNot 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).

Napisane przez MuADMINS
Czy to pomogło?

Nadal masz problem? Szukaj w MuGPS Zapytaj Asystenta MU

MuADMINS Community Alpha: za darmo, tworzone przez społeczność, w aktywnym rozwoju.