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. GameplayIGCNS12

    Lowering the stat limit from 65000 to 32000 with a SQL query on IGCN-based S12 files does not work in game.

    1. No SQL query is needed. 2. Edit MuServer/IGCData/IGC_PlayerInfo.xml and change the Max values per class (MaxStrenghtDW, MaxAgilityDW, MaxVitalityDW, MaxEnergyDW, MaxCommandDW and the s...

    ✓ Vom Threadersteller bestätigtTuServerMU · 2018-08-22
  2. Websiteany

    MVCore 1.17.1 and MuCore 1.8 on XAMPP 1.7.1 both fail to connect to SQL Server 2008 R2, even with Named Pipes enabled.

    1. SQL Server was installed as the named instance SQLEXPRESS, so there was no MSSQLSERVER default instance. 2. Reinstall SQL Server with the default instance (MSSQLSERVER) and keep the sa...

    ✓ Vom Threadersteller bestätigtTuServerMU · 2018-07-30
  3. Websiteany

    MuCore on XAMPP on the same VPS as SQL Server cannot connect to the database.

    1. Easiest: in the MuCore config.php change the connection type from MSSQL to ODBC. 2. Or open SQL Server Configuration Manager, enable TCP/IP and Named Pipes, and restart SQL Server. 3....

    ✓ Vom Threadersteller bestätigtTuServerMU · 2017-12-27
  4. Websiteany

    After replacing MuCore 1.0.8 with MVCore 1.17.1 on the host, the installer does not appear and the site cannot connect to SQL.

    1. Delete all old files in public_html (leftover MuCore files and config). 2. Upload MVCore again; the installer then opens. 3. Enter the SQL data in the installer; it connects normally.

    ✓ Vom Threadersteller bestätigtTuServerMU · 2018-06-03
  5. Websiteany

    After the VPS (SQL) IP changed, a WebEngine CMS 1.2.4 site hosted on a separate Linux server shows 'Connection to database failed (MuOnline)' and the installer says the install is already complete.

    1. Open includes/config/webengine.json and set "webengine_cms_installed": false, then upload it. 2. In the web host cPanel open PHP Selector and (re)enable pdo_dblib and pdo_sqlsrv. 3. Ru...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2024-02-16
  6. Websiteany

    Installing WebEngine CMS 1.2.5 with the ODBC driver fails with '[ODBC SQL Server Driver] The data types varchar(max) and text are incompatible in the equal to operator'.

    1. Do not use the old ODBC SQL Server driver for the install. 2. Install the Microsoft PHP SQLSRV / PDO_SQLSRV drivers that match your PHP version and enable them in php.ini. 3. Restart A...

    ✓ Im Issue bestätigtGitHub (lautaroangelico/WebEngine) · 2025-02-20
  7. Website

    Which website CMS expects which MU database columns (WebEngine table maps, DmN)

    WebEngine 1.2.7 picks a table map by server files (includes/config): - igcn.tables.php / custom.tables.php: resets = Character.RESETS, grand resets = Character.GrandResets, VIP = T_VIPLis...

    Not verifiedVon MuADMINS geschrieben
  8. Server-SetupOpenMU

    OpenMU in Docker: how do I back up and restore the PostgreSQL database, and fix 'permission denied for schema config' after a restore?

    1. The openmu-db-backup container of nolt/openmu-docker runs pg_dump -Fc every BACKUP_INTERVAL seconds (default 86400), checks the dump and keeps gzipped files in ./backups/ for RETENTION...

    Neufassung der Quelle durch MuADMINSNot verifiedGitHub (nolt/openmu-docker) · 2026-10-24
  9. Tools

    MuMaker 1.13: how to use a new item database (.mdb) with tier sets, and socket options that do not appear

    1. Replace MuMaker.mdb in the MuMaker folder with the new .mdb and open mumaker.exe. 2. The items only work in game if your server files already have those tier sets. 3. In the shared .md...

    Neufassung der Quelle durch MuADMINSNot verifiedRaGEZONE · 2017-01-12
  10. Tools

    MuWeb 0.8 does not work with XAMPP on Windows 7 and SQL 2008 (php.ini edits do not help)

    1. MuWeb 0.8 needs an old PHP with the MSSQL functions: the newer XAMPP builds do not run it even after php.ini changes. 2. Install XAMPP 1.6.1 (not higher), configure php.ini as the MuWe...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2013-01-23
  11. ToolsWebZen 97d / 99b

    Cash Shop and VIP Editor (Dino): how to connect it to SQL Server and which columns it needs

    1. Enter the SQL Server IP, login, password and port, then click Connect. 2. Leave the filter empty to list all accounts, or type an account name. 3. Choose the VIP type and the amount of...

    Neufassung der Quelle durch MuADMINSNot verifiedImperyus Games Brasil · 2009-10-04
  12. Tools

    MuMaker 1.12: "No connection could be made because the target machine actively refused it, error 0" or "error 40" when connecting

    1. Open SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for MSSQLSERVER. 2. Set TCP/IP to Enabled. 3. In TCP/IP Properties, IP Addresses tab: set Enabled t...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2017-08-08
  13. ToolsIGCN

    IGC.EssentialTools: creating an account fails with "Could not find stored procedure master.dbo.XP_MD5_EncodeKeyVal"

    1. The tool hashes the password with the MD5 extended procedure, which is not installed in your SQL Server. 2. Install the MD5 procedure for your SQL Server: the fix in the thread is the...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2018-10-21
  14. ToolsIGCN

    IGC.EssentialTools crashes after the first-run notice although SQL named pipes and TCP/IP are enabled (crash dump in CrashDumps)

    1. Symptoms: the first-run notice pops up, then the tool crashes on every start; compatibility mode and run as admin do not help; a dump such as IGCN.EssentialTools.exe.5908.dmp appears i...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2020-01-05
  15. Server-SetupMuEmu / LouisSeason 6 (MuEmu)

    How do I change the items new characters start with equipped?

    1. Create a character and equip it with MuEditor as you want. 2. Copy that character's Inventory value in SQL. 3. Run UPDATE DefaultClassType SET Inventory = <copied value> WHERE Class =...

    ✓ Vom Threadersteller bestätigtCreandoMU · 2020-08-15
  16. Server-Setupany (Morpheus web)

    Accounts created on the website get VIP months instead of days (Morpheus web).

    1. The SQL login used by the site had its language changed to Portuguese, which changes the date format. 2. Set the default language of that SQL login back to English (us_english). 3. Cre...

    ✓ Vom Threadersteller bestätigtCreandoMU · 2021-04-12
  17. Server-SetupMuEmu / LouisSeason 6 (Louis)

    How do I make a working online time ranking per character?

    1. Add an int column OnlineTime to the Character table (back up first). 2. Create a SQL Agent job every minute: UPDATE Character SET OnlineTime=OnlineTime+1 joined to MEMB_STAT (ConnectSt...

    ✓ Vom Threadersteller bestätigtCreandoMU · 2021-03-09
  18. Server-Setup

    Every time I leave the game my account is banned (after adding an anti-dupe ban script)

    The ban-dupers SQL script that was added to the database does not work with every version and bans normal accounts. 1. Remove that script (trigger / job) from the MuOnline database. 2. Un...

    ✓ Vom Threadersteller bestätigtDarksTeam · 2010-01-05
  19. GameplayMuEmu / LouisSeason 6

    MuEmu (Emerson repack update 25): new characters get welcome items; where is that removed? It is not a SQL script

    1. The start items are given by the server file MuServer\Data\Custom\CustomStartItem.txt, not by a database script. 2. Remove or comment the item lines there (or switch the system off in...

    ✓ Vom Threadersteller bestätigtTUServerMU · 2021-06-03
  20. GameplayMuEmu / LouisSeason 6 Episode 3

    MuEmu S6 E3 Castle Siege: when the battle starts the defending guild shows as attacker, with no config change

    The Castle Siege data stored in SQL had gone bad. 1. Back up the database first. 2. The asker cleared the SQL tables used by Castle Siege (in MuEmu databases they are the MuCastle_ tables...

    ✓ Vom Threadersteller bestätigtTUServerMU · 2020-11-15

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