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.
127 solutions for “SQL Server” for DV-Team and any files · Clear
DarkMaster Season 3 Episode 1: every login says the account is invalid, although all IPs are changed
The JoinServer password mode (MD5 or plain) did not match how the accounts were created. 1. Delete the test accounts. 2. Put the JoinServer build with MD5 enabled and create the account a...
✓ Confirmed by the topic starterDarksTeam · 2010-03-09How do I fix a vault (warehouse): forgotten vault password, or a broken vault that must be emptied safely?
Every MSSQL family we read has warehouse (AccountID, Items varbinary, Money, EndUseDate, pw ...); the Items size differs (IGCN S17 7680 bytes, MuDevs 6000, X-Team S17 4800, WebZen S2 1920...
Not verifiedWritten by MuADMINSIzsMuEditor 2.1.2 (EX803): the editor does not connect to the database
1. By default IzsMuEditor connects through an ODBC DSN. 2. If it does not connect, open Data\IzsConfig.ini, set Use_ODBC to 0 and fill in your SQL connection data (server, user, password)...
How to protect the server from attackers with the firewall
Only the ConnectServer and GameServer must be reachable from outside. 1. In the firewall block outside access for: MySQL (mysqld.exe), the DataServer(s), ExDB, EventServer, RankingServer,...
✓ Confirmed by the topic starterDarksTeam · 2008-06-30Characters stop at level 350 (max level) but the website reset asks for level 400 (97d+99i)
On 97d+99i the max level cannot be raised, so lower the reset level on the website instead. 1. Open SQL Server Enterprise Manager > MuOnline > Tables. 2. Find the MuWeb table, right click...
✓ Confirmed by the topic starterDarksTeam · 2009-10-31DarksWeb 0.1: the news cannot be deleted from the site admin
The news and admin data of DarksWeb are stored in the database, not in the PHP files. 1. Open SQL Server and go to Databases > MuOnline > table MuWeb_admin. 2. Edit or delete the news row...
✓ Confirmed by the topic starterDarksTeam · 2011-04-14MuCore website Exchange System always shows 0 Online Hours although the character was online for hours (DarkMaster 97d server)
The MuCore module reads the column OnlineMinutes, which did not exist in the database. 1. Take the online-time SQL script from the thread (it adds a column to MEMB_STAT and changes the st...
✓ Confirmed by the topic starterDarksTeam · 2019-07-25MuCore 1.0.6 admin panel: 'Edit module' and 'Edit pages' are broken
1. The helper's advice was to use MuCore 1.0.8 (and XAMPP 1.7.1 for SQL 2000/2005, or XAMPP 1.7.7 with MSSQL enabled for SQL 2008 or newer). 2. Replacing the whole folder caused other pro...
✓ Confirmed by the topic starterRaGEZONE · 2017-08-03MuCore 2.2.0: the add and edit buttons for modules do not show in the admin panel
1. MuCore 2.2.0 does not work properly on PHP 7.x. 2. Run it on PHP 5.6: the topic starter installed XAMPP with PHP 5.6.40 plus the PDO fix for SQL Server. 3. On a web host, switch the PH...
✓ Confirmed by the topic starterRaGEZONE · 2019-03-05MuCore 1.08 rankings show only one character (or none) while players are online
1. MuCore only ranks characters whose CtlCode is 0 in the Character table; characters with another value are left out. 2. In SQL Server set CtlCode to 0 for the normal player characters....
✓ Confirmed by the topic starterRaGEZONE · 2017-11-03DataServer and JoinServer do not connect after running the ODBC file that came with the files
The .reg or .bat ODBC file bundled with many server files does not always create the data source on your Windows. Create it by hand: 1. Open the ODBC Data Source Administrator (on 64-bit...
✓ Confirmed by the topic starterTUServerMU · 2021-06-08Characters 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-24MuWeb 0.8: accounts registered on the website say "Incorrect password" in game (the account count goes up)
1. The website saves the password in a different format than the server expects: the MD5 option chosen in the MuWeb 0.8 install does not match your files. 2. Run the MuWeb 0.8 install aga...
✓ Confirmed by the topic starterRaGEZONE · 2008-04-17MuMaker: 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-06MuMaker: an error says tables are missing and asks where to create them (incomplete MuMaker.mdb)
1. The tables are not missing in your MU database: the mumaker.mdb of that MuMaker copy is incomplete. 2. Reinstall MuMaker, or use MuMaker 1.11 or 1.10 as suggested in the thread. 3. Ope...
✓ Confirmed by the topic starterImperyus Games Brasil · 2014-08-14MuMaker: an error box appears every time after adding new sets to MuMaker.mdb, although the items still get added after Continue
1. The error comes from a wrong row you added to MuMaker.mdb, for example an item id or an option value that does not exist (Louis gives 56 as the example). 2. Open MuMaker.mdb and check...
✓ Confirmed by the topic starterCreandoMU · 2021-03-19WebEngine 1.0.9.x: the VIP system throws an error with IGCN files.
1. The IGCN VIP class only loaded the MuOnline database even when Me_MuOnline is used. 2. It was fixed in patch 1.0.9.7. 3. Update WebEngine (current releases include the fix).
✓ Confirmed in the issueGitHub (lautaroangelico/WebEngine) · 2017-08-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-08MuCore Premium 2.2.0: after adding a VIP module, the lower half of the template turns white on that page
The module carries its own style code, written for MuCore 1.8, which overrides the template CSS. 1. Open the module file and look at the start: it has a style block (CSS) of its own. 2. R...
✓ Confirmed by the topic starterTUServerMU · 2020-09-24MuCore 1.0.6 with RMST 7.01.10c (Season 4.5-4.6): registration says 'server error'
1. The site and the server did not use the same password method (MD5 on one side, plain on the other). 2. The topic starter restored the database version without MD5 and replaced the Join...
✓ Confirmed by the topic starterRaGEZONE · 2011-06-01