Community AlphaAlpha MUADMINS
ENEnglish
Sign in
On MuADMINSConfig ScannerDrop your files zip: rates, drops, spots, limitsOpenOn MuADMINSMeet us on DiscordAsk for help, share what you are building and talk MU with other server owners.Open

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” 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” Ask the MU Assistant

More answers for “invalid column”

0 in Game client, 9 in other categories and server files:

  1. Server setupMuEmu / LouisS6

    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 MuADMINS
  2. Server setupMuDevsS18

    MuDevs 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 MuADMINS
  3. WebsiteX-TeamS2, S17

    WebEngine 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 MuADMINS
  4. Website

    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
  5. Server setup

    Characters do not save and the DataServer log shows State (42S22)

    SQL state 42S22 means a column was not found: the server files query a column your database does not have, so the save fails. 1. Open the DataServer log and read which table and column th...

    ✓ Confirmed by the topic starterTUServerMU · 2021-03-24
  6. WebsiteIGCNS6

    How to set up the WebEngine Credit Manager so it gives WCoinC/WCoinP or Goblin Points on IGCN S6 files; adding credits says the account ID is invalid.

    1. Database: MuOnline. Table: T_InGameShop_Point (check the exact name in your DB). 2. Credits column: the currency column you want (WCoinC, WCoinP or GoblinPoint). 3. User column: Accoun...

    ✓ Confirmed by the topic starterRaGEZONE · 2022-07-11
  7. Server setup

    "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 MuADMINS
  8. Server setupMuEmu / LouisS6

    Louis S6 Up13 GameServer window never opens, shows an error and fills the folder with .dmp files after editing configs.

    1. Restore the original Data folder; if the server starts, the bad file is in there. 2. Put your edited files back one by one, starting with the ones you changed, until it fails again. 3....

    ✓ Confirmed by the topic starterTuServerMU · 2021-10-11

See all 9 without filters

Still stuck? Ask the MU Assistant Search MuGPS Search MUTube

MuADMINS Community Alpha: free and community made, in active development.