Community AlphaAlpha MUADMINS
FILFilipino
Mag-sign in
Sa MuADMINSConfig ScannerI-upload ang zip ng mga file mo: rate, drop, spot, limitBuksanSa MuADMINSMakipagkita sa amin sa DiscordHumingi ng tulong, ibahagi ang ginagawa mo at makipag-usap tungkol sa MU sa ibang may-ari ng server.Buksan
← Lahat ng solusyon

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

Isinulat ng MuADMINS mula sa sourceNot 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).

Isinulat ng MuADMINS
Nakatulong ba ito?

Naipit pa rin? Maghanap sa MuGPS Magtanong sa MU Assistant

MuADMINS Community Alpha: libre, gawa ng komunidad, at patuloy na dine-develop.