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.
128 Lösungen für “SQL Server” für MuDevs und alle Files · Zurücksetzen
0.97d: every item (even shop items) gets serial 00000000.
1. The trigger that creates item serials was deleted when the server was reset. 2. Recreate the serial trigger (run its script with the server off) and check the item serial counter is no...
✓ Vom Threadersteller bestätigtImperyus Games Brasil · 2013-05-26DarkMaster 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...
✓ Vom Threadersteller bestätigtDarksTeam · 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 verifiedVon MuADMINS geschriebenIzsMuEditor 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,...
✓ Vom Threadersteller bestätigtDarksTeam · 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...
✓ Vom Threadersteller bestätigtDarksTeam · 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...
✓ Vom Threadersteller bestätigtDarksTeam · 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...
✓ Vom Threadersteller bestätigtDarksTeam · 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...
✓ Vom Threadersteller bestätigtRaGEZONE · 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...
✓ Vom Threadersteller bestätigtRaGEZONE · 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....
✓ Vom Threadersteller bestätigtRaGEZONE · 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...
✓ Vom Threadersteller bestätigtTUServerMU · 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...
✓ Vom Threadersteller bestätigtTUServerMU · 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...
✓ Vom Threadersteller bestätigtRaGEZONE · 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...
✓ Vom Threadersteller bestätigtRaGEZONE · 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...
✓ Vom Threadersteller bestätigtImperyus 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...
✓ Vom Threadersteller bestätigtCreandoMU · 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).
✓ Im Issue bestätigtGitHub (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.
✓ Vom Threadersteller bestätigtCreandoMU · 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...
✓ Vom Threadersteller bestätigtTUServerMU · 2020-09-24