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.
145 Lösungen für “cannot open database” · 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-26How do I give GoblinPoints each time a character resets (Season 6 MuEmu)?
1. In SSMS edit the procedure WZ_SetResetInfo. 2. Below the line that starts with UPDATE Character add UPDATE CashShopData SET GoblinPoint=GoblinPoint+100 WHERE AccountID=@Account. 3. Exe...
✓ Vom Threadersteller bestätigtCreandoMU · 2021-01-21"Login failed for user 'sa'" (SQLSTATE 28000) from DataServer or the web right after installing SQL Server. How do I enable sa?
1. If setup used Windows authentication only, sa is disabled. 2. In Management Studio right click the server > Properties > Security and pick SQL Server and Windows Authentication mode. 3...
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.
✓ Vom Threadersteller bestätigtTuServerMU · 2017-06-18Louis (MuEmu) server ran out of item serials: every new item gets serial FFFFFFFF and is flagged as a dupe.
1. Serials come from the stored procedure WZ_GetItemSerial, which increments ItemCount in table GameServerInfo for every created item (drops, bags, commands). 2. Edit that existing proced...
✓ Vom Threadersteller bestätigtRaGEZONE · 2024-08-02How do I enable the SQL Server PDO driver in php.ini and check it is really loaded?
1. Copy the matching php_sqlsrv and php_pdo_sqlsrv DLLs into the PHP ext folder (run php -i to see extension_dir). 2. Add extension= lines for both files in php.ini. 3. On Linux, load pdo...
CzF Editor 1.5a: creating a new account gives an error although MD5 is disabled in the editor options
1. With MD5 off in the editor, the password column must be plain text, but in this database memb__pwd was still binary. 2. Open Enterprise Manager (or Management Studio) > Databases > MuO...
✓ Vom Threadersteller bestätigtRaGEZONE · 2007-10-05MuMaker: 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-19DarksWeb 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-14MuEmu S6 client: how to remove WCoinP and Goblin Points from the game window title and rename WCoinC
That text is not in the text.bmd files nor in the database: it is written by the client main.dll. 1. If you have the main source, change it there and rebuild. 2. Without source, open main...
✓ Vom Threadersteller bestätigtTUServerMU · 2021-02-16MuCore install on a web host: after the serial number step, step_1 of the installer shows nothing (Season 6 repack)
1. Open the MuCore configuration file that holds the database settings. 2. Find $core['connection_type'] = "MSSQL";. 3. Change the value to lower case: $core['connection_type'] = "mssql";...
✓ Vom Threadersteller bestätigtRaGEZONE · 2018-03-23DataServer 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-08ODBC 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...
✓ Vom Threadersteller bestätigtTUServerMU · 2021-04-26Characters 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-24Characters 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-31MuCore 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...
✓ Vom Threadersteller bestätigtRaGEZONE · 2011-06-01DMN CMS with MuEmu S6E3 files: reset and grand reset modules do not work.
1. Open the Character table in SQL and read the exact column names. 2. In the DMN config type them exactly, with the same upper and lower case (for example ResetCount, not reset or resetc...
✓ Vom Threadersteller bestätigtTuServerMU · 2018-11-22MuCore 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-05