Community AlphaAlpha MUADMINS
RUРусский
Войти
На MuADMINSConfig ScannerЗагрузите zip своих файлов: рейты, дропы, споты, лимитыОткрытьНа MuADMINSПрисоединяйтесь к нам в DiscordПросите помощи, показывайте свои проекты и общайтесь о MU с другими владельцами серверов.Открыть

MuADMINS

Решения

Короткие исправления частых проблем серверов, клиентов и сайтов MU Online, каждое с источником и датой. “Подтверждено” означает, что автор вопроса сообщил, что исправление сработало.

Решений: 122 по запросу “database” в категории «Настройка сервера» · Сбросить

  1. Настройка сервераOpenMUSeason 6 (OpenMU 0.8.x)

    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-21
  2. Настройка сервераMuEmu / LouisSeason 6 (Louis free)

    Items 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-31
  3. Настройка сервераMuEmu / LouisSeason 6 (Louis)

    Louis 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-02
  4. Настройка сервераS4

    SCFdb (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-16
  5. Настройка сервера

    The 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-03
  6. Настройка сервераS3E2

    DarksTeam 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-09
  7. Настройка сервера

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

    ✓ Подтверждено автором темыDarksTeam · 2010-01-05
  8. Настройка сервера

    Guild 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-03
  9. Настройка сервера

    How 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-11
  10. Настройка сервераSeason 6

    How 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-09
  11. Настройка сервера

    Replacing 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-30
  12. Настройка сервераIGCNS9

    IGCN 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-14
  13. Настройка сервераOpenMUany

    OpenMU 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-21
  14. Настройка сервераany

    After 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-23
  15. Настройка сервераIGCNS12

    IGCN 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-08
  16. Настройка сервераMuEmu / LouisS4

    DataServer 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-09
  17. Настройка сервераIGCNS16, S17, S18

    IGCN: 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Написано MuADMINS
  18. Настройка сервера

    How 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Написано MuADMINS
  19. Настройка сервера

    ODBC / 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Написано MuADMINS
  20. Настройка сервера

    Could 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

MuADMINS Community Alpha: бесплатно, создаётся сообществом, в активной разработке.