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.
0 solutions for “invalid column name” in Game client · Clear
Nothing in Game client for these words yet, but they find solutions in other categories and server files (below).
Search all of MuGPS for “invalid column name” Ask the MU Assistant
More answers for “invalid column name”
0 in Game client, 42 in other categories and server files:
Louis / MuEmu Season 6: "Invalid column name" after updating the server files (which Update script adds which column)
Louis (JogandoMU) Season 6 files ship one SQL file per update. If the files are newer than the database, the server logs Invalid column name 'X'. Find X below and run that script (and the...
Not verifiedWritten by MuADMINSWebEngine with X-Team files: online ranking fails with Invalid column name 'OnlineHours'
WebEngine's map for X-Team files (includes\config\xteam.tables.php) defines _CLMN_MS_ONLINEHRS_ = OnlineHours, and the online ranking (only for xteam files) runs: SELECT TOP n memb___id,...
Not verifiedWritten by MuADMINSMuDevs Season 18: Invalid column name 'LastGateIndex' (the extra query of the pack)
The MuDevs Season 18 pack ships, next to the database scripts, a file Execute query.sql with one statement: ALTER TABLE dbo.Character ADD LastGateIndex [int] NOT NULL DEFAULT(-1); If the...
Not verifiedWritten by MuADMINSMuMaker: how to fill the first configuration window (SQL user, local or remote, MD5, database names, reset column)
1. Extract MuMaker and start MuMaker.exe. 2. Type any name (server name or yours), the SQL user (sa by default) and its password. 3. Connection type: choose local when MuMaker runs on the...
Which 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 MuADMINS/reset works in game but the website still shows 0 resets (newest DarksTeam files)
The server writes resets to the column Resets, while the website reads another column (Reset). 1. Open the website config (usually config.php) and find $res_column_name. 2. Set it to $res...
✓ Confirmed by the topic starterDarksTeam · 2017-06-13Accounts 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-05DMN CMS with MuEmu S6E3 files: reset and grand reset modules do not work.
1. Open the Character table in SQL and read the exact column names. 2. In the DMN config type them exactly, with the same upper and lower case (for example ResetCount, not reset or resetc...
✓ Confirmed by the topic starterTuServerMU · 2018-11-22