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.

239 Lösungen für “sql” · Zurücksetzen

  1. Server-SetupIGCNS9, S12, S16, S17, S18

    How do I set a new password for one account in SQL on IGCN files (plain, WZ_MD5 or md5 text)?

    Use the form that matches PasswordEncryptType in IGCDS.ini and the memb__pwd column type. Keep the account offline and always use WHERE. - Type 0 (varchar(20)): UPDATE MEMB_INFO SET memb_...

    Not verifiedVon MuADMINS geschrieben
  2. ToolsWebZen 97d / 99b

    Reset Generator: how to make the SQL reset script and run it automatically with SQL Server Agent

    1. Tick the options you want for a character reset (the settings of your server) and press Generate Reset. 2. The program writes the SQL code (script) of your reset system. 3. Copy it and...

    Neufassung der Quelle durch MuADMINSNot verifiedDarksTeam · 2008-04-22
  3. ToolsWebZen 97d / 99b97d

    SkynetMU Full Option Cleaner: how do I find and remove full excellent items from warehouses and inventories of a 97/97D SQL database?

    1. Install Python 3.11 or 3.12 on Windows, then run py -m pip install -r requirements.txt and py SkynetMU_FullOption_Cleaner.py. 2. For ODBC install Microsoft ODBC Driver 17 or 18 for SQL...

    Neufassung der Quelle durch MuADMINSNot verifiedGitHub (Azzlaer/Mu_Cleaner_OF) · 2026-08-24
  4. ToolsAndere FilesS6

    BeastMaker admin tool: how to set up the SQL connection and the allowed user (and SQL 2000 without "Edit Top 200 Rows")

    1. Run the table script from the release post to create the BeastMaker table (columns BeastMaker_Allowed, BeastMaker_Logs) in the MuOnline database. 2. Add your allowed entry {"YOURNAME":...

    Neufassung der Quelle durch MuADMINSNot verifiedRaGEZONE · 2015-07-14
  5. ToolsWebZen 97d / 99bS3

    CzF MuEditor 1.05a: the editor freezes or hangs on connect (Windows Vista 64 bit, SQL Server 2005)

    1. Open the ODBC Data Source Administrator. 2. Make a data source for every database the editor uses: the MU database (MuOnline) as well as Ranking and Event. The asker had only made Rank...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2007-08-20
  6. Tools

    MuMaker: cannot connect to SQL Server 2005 Express (SQLEXPRESS)

    1. Open SQL Server Configuration Manager, then Protocols for SQLEXPRESS. 2. Right click TCP/IP, Properties, set Enabled to Yes. 3. In the IP Addresses tab set Active and Enabled to Yes fo...

    Neufassung der Quelle durch MuADMINSNot verifiedRaGEZONE · 2013-10-09
  7. Tools

    MuMaker: how to fill the first configuration window (SQL user, local or remote, MD5, database names, reset column)

    1. Extract MuMaker and start MuMaker.exe. 2. Type any name (server name or yours), the SQL user (sa by default) and its password. 3. Connection type: choose local when MuMaker runs on the...

    Neufassung der Quelle durch MuADMINSNot verifiedRaGEZONE · 2007-12-22
  8. Server-Setup97d+99i

    SQL command to give credits to every account (DarksTeam 97d+99i)

    1. Open SSMS / Query Analyzer on the MuOnline database. 2. For all accounts run UPDATE MEMB_CREDITS SET credits=credits+500. 3. For one account run UPDATE MEMB_CREDITS SET credits=credits...

    ✓ Vom Threadersteller bestätigtDarksTeam · 2021-12-28
  9. Server-Setupany

    Remote tools or the web cannot reach a SQL Express or named instance on port 1433. How do I make SQL listen on a fixed port?

    1. Named instances use dynamic ports by default; only the default instance uses 1433. 2. SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for your instance...

    Neufassung der Quelle durch MuADMINSNot verifiedMicrosoft Learn · 2025-08-26
  10. Toolsany

    I cannot delete a MU database in SQL Server Management Studio, it gives an error because it is in use. How do I remove it?

    1. Stop DataServer, JoinServer, the editors and the web that use the database. 2. In Management Studio right click the database > Delete. 3. In the Delete Object window tick Close existin...

    ✓ Vom Threadersteller bestätigtTuServerMU · 2018-01-06
  11. Server-Setupany

    During SQL Server setup the password for sa is rejected no matter what I type. Why?

    1. Setup enforces the Windows password policy on the sa password. 2. Use at least 8 characters that mix uppercase letters, lowercase letters and numbers (a symbol helps too). 3. Do not us...

    ✓ Vom Threadersteller bestätigtTuServerMU · 2017-07-21
  12. Websiteany

    WebEngine 1.0.9 with a remote SQL Server IP fails with 'Could not connect to database (1)', while MuCore connects to the same server without problems.

    1. In the WebEngine installer select the ODBC driver instead of dblib/sqlsrv. 2. Make sure the matching PHP ODBC extension is enabled and port 1433 is reachable. 3. Finish the install.

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2017-09-09
  13. Server-SetupIGCNS9, S12, S16, S17, S18

    How do I reset a character with SQL on IGCN files (RESETS, GrandResets) with the server closed?

    Columns in IGCN Character: RESETS (int, all seasons), GrandResets (tinyint, Season 16, 17, 18), GRANDRESET (Season 12), plus cLevel, Experience, LevelUpPoint and the stats. 1. Close the G...

    Not verifiedVon MuADMINS geschrieben
  14. ToolsS6

    WebEngine CMS installer: "Could not connect to database (1)" at the database step with MSSQL Server 2008 (PDO ODBC, XAMPP)

    1. In this case the game files connected fine but the WebEngine installer kept failing on the database step, with no error in the SQL logs or the Windows event log. 2. The cause was a con...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2023-10-06
  15. Tools

    MuCore install: "Connection with MuOnline Database Failed" and "Extension php_mssql.dll must be enabled"

    1. MuCore needs a PHP that still has the old php_mssql.dll extension: in php.ini find extension=php_mssql.dll and remove the ; in front of it. 2. If your web server package has no php_mss...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2011-03-05
  16. Tools

    MuCore 1.08 installer: with the MSSQL connection it cannot get past step 3 (MSSQL 2008 R2, XAMPP 1.7.1)

    1. Use XAMPP 1.7.7 for MuCore 1.08 (XAMPP 1.7.1 with MSSQL 2008 works badly). 2. Install the client DLL that supports your MSSQL version (linked in the reply). 3. Open C:/xampp/php/php.in...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2016-05-26
  17. Tools

    MFS Database Tool: the backup gives the same error as other backup managers, even with (local), Windows authentication or 127.0.0.1

    1. Connect to your SQL Server as usual (the tool supports SQL Server 2000 and 2008 style connections). 2. Do not pick the database with the drop down button: type the database name (for e...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2014-02-11
  18. Tools

    Titan Editor: cannot connect to the MU database to create accounts (single MuOnline database)

    1. Open the Titan Editor config. With only one database (MuOnline) both ODBC names point to it: [Connection] ODBC=MuOnline, ODBC_Me=MuOnline, User=sa, Password=yourpass, SQLServer=(local)...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2013-09-25
  19. Server-Setup1.0M, 1.0L

    Accounts do not work after putting a 1.0L database under 1.0M files

    The two versions use different password storage. 1. 1.0M files use MD5 on; 1.0L files use MD5 off. 2. Use the database (and website install option) that matches your files: MD5 on for 1.0...

    ✓ Vom Threadersteller bestätigtDarksTeam · 2008-11-25
  20. Website

    MuWeb 0.9 installer check shows Mssql: NO even after editing php.ini

    1. Install XAMPP 1.7.0 (it includes the mssql extension the site needs). 2. Put MuWeb 0.9 in its htdocs and open the installer again; Mssql now shows YES.

    ✓ Vom Threadersteller bestätigtDarksTeam · 2009-02-12

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