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.
30 solutions for “installer” in Server setup · Clear
IGCN Season 9 repack: GameServerCS shows an error when Castle Siege is configured, even with correct settings.
1. The SQL Server language caused it. 2. Install SQL Server in English (English instance) and restore the databases there. 3. Start GameServerCS again.
✓ Confirmed by the topic starterTuServerMU · 2017-06-18MSVCP100.DLL is missing when starting ConnectServer, DataServer or JoinServer (MuEmu S6 files).
Install the Microsoft Visual C++ 2010 Redistributable (x86, plus x64 on 64 bit Windows). Prefer the Microsoft download over single DLL sites.
✓ Confirmed by the topic starterTuServerMU · 2018-06-11ODBC test works but JoinServer and DataServer still do not connect (Louis files on a VPS)
The topic starter fixed it by reinstalling SQL Server: it was installed wrong. The helper's diagnosis was a named instance (SQLEXPRESS) while the files expect the default instance. 1. Ope...
✓ Confirmed by the topic starterTUServerMU · 2021-04-26JoinServer and DataServer cannot connect to the database although the backup is restored
These files had the database name MuOnlineS6 in the server configs while the database was restored as MuOnline, so the servers looked for a database that does not exist. 1. In SQL Server...
✓ Confirmed by the topic starterTUServerMU · 2018-09-27What breaks a MU server database? Safe SQL checklist before you run a query
What breaks MU databases most often, and what the pack files themselves show: 1. UPDATE while the server runs: the server writes online characters back from memory (IGCN maintenance scrip...
Not verifiedWritten by MuADMINSI changed a character, coins or a vault with SQL and the change disappeared (UPDATE while the server is on)
The running server keeps its own copy of every online character and account and writes it back to the database, so an UPDATE made while that player is online can be overwritten a moment l...
Not verifiedWritten by MuADMINSCould not find stored procedure 'WZ_CONNECT_MEMB' (or WZ_DISCONNECT_MEMB): what they do and how to restore them
WZ_CONNECT_MEMB and WZ_DISCONNECT_MEMB keep MEMB_STAT up to date (ConnectStat 1 at login, 0 at logout). They must exist in the database the JoinServer / DataServer connects to: - IGCN: in...
Not verifiedWritten by MuADMINSMuDevs: WZ_CONNECT_MEMB has 4 parameters (@HarwareID) and MEMB_STAT has HWID / OnlineHours
MuDevs differs from the other MuEmu based files here: - WZ_CONNECT_MEMB @memb___id varchar(10), @ServerName varchar(50), @IP varchar(20), @HarwareID varchar(74) (4th parameter, spelled Ha...
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 MuADMINSConnectServer Cross-Platform (MuEmu kayito): how do I build and run the ConnectServer natively on Linux?
1. Install the build tools: on Ubuntu or Debian sudo apt install build-essential cmake libboost-all-dev (CentOS: gcc-c++ cmake boost-devel; Arch: base-devel cmake boost). On Windows use V...