MuADMINS
Solutions
Short fixes for common MU Online server, client and website problems, each with its source and date. “Confirmed” means the person who asked said the fix worked.
33 solutions for “memb_info” · Clear
Accounts registered on the website exist in MEMB_INFO, but the game says 'Your account is invalid'
1. Compare how the website stores passwords with what the JoinServer expects: look at the password column of the new accounts in MEMB_INFO. 2. If the website saves MD5 hashed passwords, e...
✓ Confirmed by the topic starterRaGEZONE · 2026-04-05"Account does not exist" or the login fails although the account is in MEMB_INFO: what to check in the database
Check these in order (all read only, nothing changes): 1. Is the server reading the same database? MuEmu, Louis, MSPro, X-Team, MuDevs use the ODBC DSN in JoinServer.ini (JoinServerODBC =...
Not verifiedWritten by MuADMINSCzF Editor 1.5a: creating a new account gives an error although MD5 is disabled in the editor options
1. With MD5 off in the editor, the password column must be plain text, but in this database memb__pwd was still binary. 2. Open Enterprise Manager (or Management Studio) > Databases > MuO...
✓ Confirmed by the topic starterRaGEZONE · 2007-10-05MuMaker: creating an account fails with "Disallowed implicit conversion from data type varchar to data type varbinary ... column 'memb_pwd'"
1. The error means MEMB_INFO.memb_pwd is a varbinary column: your database stores MD5 passwords. 2. Enable MD5 in the MuMaker settings and create the account again. 3. A reply also sugges...
✓ Confirmed by the topic starterRaGEZONE · 2011-12-06Morpheus web install stops with error 47.
1. Back up the database first. 2. Delete the columns Credits, indocation and indicated from MEMB_INFO. 3. Run the Morpheus installer again.
✓ Confirmed by the topic starterCreandoMU · 2020-08-08How to get the list of e-mail addresses of all registered accounts from the MU database
1. Open SQL Server Management Studio and connect to the server that holds your MU database. 2. Run: USE MuOnline; SELECT mail_addr FROM MEMB_INFO; 3. The result is the e-mail of every acc...
✓ Confirmed by the topic starterTUServerMU · 2021-03-17How to back up only the accounts and characters (inventory, warehouse, stats) instead of the whole MU database
1. First make a full backup of the current database as it is (SQL Server Management Studio > Tasks > Back Up). 2. To move players to a clean database, copy over only the tables that hold...
✓ Confirmed by the topic starterTUServerMU · 2020-07-23Replacing WZ_DISCONNECT_MEMB for MuCore gives 'Msg 468 ... Cannot resolve the collation conflict between Latin1_General_CS_AS and SQL_Latin1_General_CP1_CI_AS'
1. The procedure compares memb___id from MEMB_INFO with memb___id from MEMB_STAT, and the two columns use different collations. 2. In SQL Server Management Studio set the same collation o...
✓ Confirmed by the topic starterRaGEZONE · 2015-11-30WebEngine 1.0.9 with IGCN tables: account registration fails.
1. Open the IGCN table definitions file of WebEngine. 2. Change define('_CLMN_SNONUMBER_', 'sno_numb'); to define('_CLMN_SNONUMBER_', 'sno__numb'); (two underscores, as in MEMB_INFO). 3....
✓ Confirmed by the topic starterRaGEZONE · 2017-05-18WebEngine register error "String or binary data would be truncated" (sno__numb is shorter than 13 characters)
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: -...
Not verifiedWritten by MuADMINSHow do I turn MD5 passwords on or off (enable / disable) on IGCN files (PasswordEncryptType, memb__pwd)?
On IGCN files the password mode is chosen in the DataServer and the database column must be of the matching type. If they do not match, nobody can log in. 1. Close the whole server and ba...
Not verifiedWritten by MuADMINSCash Shop and VIP Editor (Dino): how to connect it to SQL Server and which columns it needs
1. Enter the SQL Server IP, login, password and port, then click Connect. 2. Leave the filter empty to list all accounts, or type an account name. 3. Choose the VIP type and the amount of...
Mu Launcher v1.3 (RJ launcher, harlcreeds): how to set the server IP, the patch link and the registration
1. Run rjdllcreator.exe and type your server IP: it builds rjconnect.dll, the connector the launcher uses. 2. Install a web server (WAMP www, XAMPP htdocs, nginx html) and copy the rjlaun...
MuWeb 0.8 registration says the account has been created, but it is not created
1. Run the MuWeb 0.8 installer again. 2. When it asks whether MD5 is on, choose off (it must match the server; these files do not use MD5). 3. Register a new account.
✓ Confirmed by the topic starterDarksTeam · 2009-03-07SQL query to delete only characters and guilds but keep the accounts and their warehouse
1. Make a full backup of the database first. 2. In SQL Server Management Studio run: USE MuOnline; DELETE Character (characters). 3. For guilds run: DELETE Guild; DELETE GuildMember. 4. M...
✓ Confirmed by the topic starterTUServerMU · 2021-03-30Creating a character fails with 'Nombre de personaje incorrecto o ya existe' after installing a SQL script that gives points and zen to new characters (MuEmu S6 EP3 Louis Update 13)
The new character script wrote to columns that do not exist in this database. 1. Open the script (trigger) you added in SQL Server Management Studio. 2. Compare its column names with your...
✓ Confirmed by the topic starterTUServerMU · 2020-05-04Which website CMS expects which MU database columns (WebEngine table maps, DmN)
WebEngine 1.2.7 picks a table map by server files (includes/config): - igcn.tables.php / custom.tables.php: resets = Character.RESETS, grand resets = Character.GrandResets, VIP = T_VIPLis...
Not verifiedWritten by MuADMINSWhat does the DmN CMS setup change in the MU database (columns, Character.id, WZ_CONNECT_MEMB) and what can break?
The DmN CMS 1.2.3 setup does more than create its own tables: 1. It ALTERs the game databases: adds columns from its version files, for example MEMB_INFO Admin, last_login, activated, act...
Not verifiedWritten by MuADMINSWebEngine: accounts made on the website cannot log in (password encryption must match memb__pwd)
WebEngine 1.2.7 has four password modes (install/definitions.php PDO_PWD_ENCRYPT) and writes MEMB_INFO differently for each: - none: memb__pwd = :password (plain), for varchar columns (IG...
Not verifiedWritten by MuADMINSUnicode (NVARCHAR) migration of a MuEmu / Louis Season 6 database: what is right and what breaks
Review of a Season 6 Unicode script set (a migration that converts the name columns to NVARCHAR plus new WZ_CreateCharacter, WZ_DeleteCharacter, WZ_CreateGuild procedures). Its table list...
Not verifiedWritten by MuADMINS