Community AlphaAlpha MUADMINS
DEDeutsch
Anmelden
Auf MuADMINSConfig ScannerZip deiner Dateien hochladen: Rates, Drops, Spots, LimitsÖffnenAuf MuADMINSTriff uns auf DiscordFrag nach Hilfe, zeig, woran du arbeitest, und sprich mit anderen Serverbetreibern über MU.Öffnen

MuADMINS

Lösungen

Kurze Fixes für häufige Probleme mit Server, Client und Website bei MU Online, jeweils mit Quelle und Datum. “Bestätigt” heißt: Die Person, die gefragt hat, hat gesagt, dass der Fix funktioniert hat.

9 Lösungen für “invalid column” · Zurücksetzen

  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 verifiedVon MuADMINS geschrieben
  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 verifiedVon MuADMINS geschrieben
  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 verifiedVon MuADMINS geschrieben
  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...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 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...

    ✓ Vom Threadersteller bestätigtTUServerMU · 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...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 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 verifiedVon MuADMINS geschrieben
  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....

    ✓ Vom Threadersteller bestätigtTuServerMU · 2021-10-11
  9. Server-SetupMuEmu / LouisS6

    How do I ban and unban accounts or characters with an end date on Louis / MuEmu Season 6 files (bloc_code, CtlCode, Bloc_Expire)?

    Louis Season 6 Update 11 added the ban columns: MEMB_INFO.Bloc_Expire and Character.Bloc_Expire (smalldatetime). The procedure WZ_DesblocAccount @Account lifts a block only when it expire...

    Not verifiedVon MuADMINS geschrieben
Kommst du immer noch nicht weiter? Frag den MU-Assistenten MuGPS durchsuchen Auf MUTube suchen

MuADMINS Community Alpha: kostenlos, von der Community gemacht, in aktiver Entwicklung.