MuADMINS
Решения
Короткие исправления частых проблем серверов, клиентов и сайтов MU Online, каждое с источником и датой. “Подтверждено” означает, что автор вопроса сообщил, что исправление сработало.
Решений: 122 по запросу “database” в категории «Настройка сервера» · Сбросить
OpenMU (Docker all-in-one) after updating the server: the client stays on the login screen after entering the password.
1. Open the admin panel and run every pending update; the maintainer notes you cannot enter the game without them. 2. In this case the database upgrade had not completed, and an old impor...
✓ Подтверждено в issueGitHub (MUnique/OpenMU) · 2024-07-21Items ask for more stats than shown and only equip after relogging (Louis free S6).
1. Louis first advice: item.bmd (client) and Item.txt (server) must match. 2. Here the asker had changed the starting stats of the classes directly in the database, which caused the confl...
✓ Подтверждено автором темыCreandoMU · 2021-08-31Louis files: after testing the auction system no new auction starts (or it starts and ends at once).
1. A finished auction does not run again. 2. Back up the database, then run on MuOnline: DELETE FROM EventAuction and DELETE FROM EventAuctionReward. 3. Restart the GameServer to start ne...
✓ Подтверждено автором темыCreandoMU · 2020-12-02SCFdb (SCF Season 4 database manager) shows an error at start
1. Reinstall Microsoft .NET Framework 2.0, or better install .NET Framework 3.0. 2. Start SCFdb again.
✓ Подтверждено автором темыDarksTeam · 2008-10-16The website always shows 2 players online even when the server is off
Stale rows in MEMB_STAT still say the accounts are connected. 1. Open Query Analyzer / SSMS on the MuOnline database. 2. Run UPDATE MEMB_STAT SET ConnectStat='0' WHERE ConnectStat>0. 3. R...
✓ Подтверждено автором темыDarksTeam · 2009-03-03DarksTeam Season 3 Episode 2 (Beta 19) Cash Shop: a bought Seal disappears after reconnect
The seal was saved with a wrong date format in t_perioditem_info. 1. Open the stored procedure t_perioditem_insert in the MuOnline database. 2. Fix the datetime format it uses when insert...
✓ Подтверждено автором темыDarksTeam · 2009-08-09Every 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...
✓ Подтверждено автором темыDarksTeam · 2010-01-05Guild war gives no points: the website shows a negative score and the in-game G Score stays 0
The Guild table column G_Score had no default value, so new guilds got NULL. 1. Open SQL Server > MuOnline database > Tables > Guild > Design Table. 2. Select the column G_Score and set i...
✓ Подтверждено автором темыDarksTeam · 2010-05-03How to protect Game Master characters (give them the protected GM status)
The GM status is the CtlCode column of the character. 1. Open the MuOnline database in SQL Server. 2. Run UPDATE Character SET CtlCode = '8' WHERE Name='<GM name>' (the asker confirmed 8...
✓ Подтверждено автором темыDarksTeam · 2012-05-11How to remove the master skill tree skills from every character at once (S6 Up15 GamingMaster files); DELETE MasterSkillTree did not remove them
The learned skills are stored in the MagicList column of the Character table. 1. Back up the database and close the server. 2. Run: USE MuOnline; UPDATE Character SET [MagicList] = CONVER...
✓ Подтверждено автором темыTUServerMU · 2021-05-09Replacing WZ_DISCONNECT_MEMB for MuCore gives 'Msg 468 ... Cannot resolve the collation conflict between Latin1_General_CS_AS and SQL_Latin1_General_CP1_CI_AS'
1. The procedure compares memb___id from MEMB_INFO with memb___id from MEMB_STAT, and the two columns use different collations. 2. In SQL Server Management Studio set the same collation o...
✓ Подтверждено автором темыRaGEZONE · 2015-11-30IGCN S9 E2 repack: DataServer says 'Login failed for user ...' (SQLSTATE 28000) and 'DATA SERVER CANNOT CONNECT TO MSSQL'
1. The repack DataServer config came with a SQL login that does not exist on your SQL Server (here a random name like D2a78Rtko0), so the login fails. 2. Open the database settings of the...
✓ Подтверждено автором темыRaGEZONE · 2019-07-14OpenMU docker compose: the database container exits with a PostgreSQL 18 PGDATA notice and openmu crashes too.
1. Postgres 18 images moved PGDATA to a version specific folder, so the old mount at /var/lib/postgresql/data no longer fits. 2. Pull the current OpenMU deploy files (PR #666, November 20...
✓ Подтверждено в issueGitHub (MUnique/OpenMU) · 2025-11-21After enabling TCP/IP in SQL Server for the web, DataServer, JoinServer and GameServerCS lost the database connection. How was it fixed?
1. In SQL Server Configuration Manager keep Named Pipes and TCP/IP enabled for the instance. 2. Open the ODBC DSNs used by the server files. 3. Change the Server field from the LAN IP to...
✓ Подтверждено автором темыTuServerMU · 2020-05-23IGCN Season 12: DataServer is not responding although TCP/IP is enabled in SQL Server
1. Open DataServer.ini and check SQLServerName. 2. When SQL Server runs on the same machine use SQLServerName = (local) or the exact PC name as shown in SQL Server Management Studio (for...
✓ Подтверждено автором темыRaGEZONE · 2020-01-08DataServer floods '[QueryManager] State (24000) ... [ODBC SQL Server Driver] Invalid' when a character gets PK status (MuEmu S4 with the Ferrarezi website)
1. The cause was not ODBC: the Ferrarezi website adds a trigger Z_PK_HERO on dbo.Character that fires when PkCount changes, and its old version broke the DataServer queries. 2. In SQL Ser...
✓ Подтверждено автором темыRaGEZONE · 2018-04-09IGCN: players have negative WCoin or Goblin Points (shipped maintenance script)
IGCN ships 2. Update Scripts\Maintenance Scripts\Check & Fix negative Coins.sql. It works in two runs and says "Take server offline before proceeding with the script": 1. With @Update = 0...
Not verifiedНаписано MuADMINSHow 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 verifiedНаписано MuADMINSODBC / DSN: the DataServer or JoinServer cannot connect to MuOnline (DSN name, 32 bit or 64 bit)
MuEmu, Louis, MSPro, X-Team and MuDevs files connect through an ODBC System DSN: - JoinServer.ini JoinServerODBC = MuOnline, DataServer.ini DataServerODBC = MuOnline (MSPro: ODBC = MuOnli...
Not verifiedНаписано MuADMINSCould not find stored procedure 'WZ_CONNECT_MEMB' (or WZ_DISCONNECT_MEMB): what they do and how to restore them
WZ_CONNECT_MEMB and WZ_DISCONNECT_MEMB keep MEMB_STAT up to date (ConnectStat 1 at login, 0 at logout). They must exist in the database the JoinServer / DataServer connects to: - IGCN: in...
Not verifiedНаписано MuADMINS