MuADMINS
Решения
Короткие исправления частых проблем серверов, клиентов и сайтов MU Online, каждое с источником и датой. “Подтверждено” означает, что автор вопроса сообщил, что исправление сработало.
Решений: 13 по запросу “drop database” · Сбросить
Why did IGCN CreateDatabase.sql delete my databases, and what must I change before running it?
Database\1. Full Scripts\CreateDatabase.sql starts with two switches: - DECLARE @DropExistingDatabases INT = 1: with 1 it DROPS existing databases named Me_MuOnline, MuOnline, Events, Ran...
Not verifiedНаписано MuADMINSI 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...
✓ Подтверждено автором темыTuServerMU · 2018-01-06MFS 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...
✓ Подтверждено автором темыRaGEZONE · 2014-02-11OpenMU crashes on startup after a failed data import left the database tables without a GameConfiguration.
1. Older builds crashed when the tables existed but no GameConfiguration row did. 2. Update to a build containing PR #910 (September 2026): the server then starts and the admin panel offe...
✓ Подтверждено в issueGitHub (MUnique/OpenMU) · 2026-08-27What does the DmN CMS setup change in the MU database (columns, Character.id, WZ_CONNECT_MEMB) and what can break?
The DmN CMS 1.2.3 setup does more than create its own tables: 1. It ALTERs the game databases: adds columns from its version files, for example MEMB_INFO Admin, last_login, activated, act...
Not verifiedНаписано MuADMINSUnicode (NVARCHAR) migration of a MuEmu / Louis Season 6 database: what is right and what breaks
Review of a Season 6 Unicode script set (a migration that converts the name columns to NVARCHAR plus new WZ_CreateCharacter, WZ_DeleteCharacter, WZ_CreateGuild procedures). Its table list...
Not verifiedНаписано MuADMINSWhat breaks a MU server database? Safe SQL checklist before you run a query
What breaks MU databases most often, and what the pack files themselves show: 1. UPDATE while the server runs: the server writes online characters back from memory (IGCN maintenance scrip...
Not verifiedНаписано MuADMINSOpenMU admin panel: the Setup page says 'Can't connect to the database, probably not created yet' or 'Update required'
1. Open Setup (/setup). It shows the state of the database. 2. *Can't connect to the database, probably not created yet* or *Not created*: click Create, pick the game version (Season 6 Ep...
Louis (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...
✓ Подтверждено автором темыRaGEZONE · 2024-08-02OpenMU: which start parameters and environment variables exist (-autostart, -reinit, -demo, DB_HOST) and when do I need them?
1. Most of these settings are easier to change in the admin panel under Configuration, System; parameters are for special cases. 2. -autostart initializes the game servers and starts all...
OpenMU starts with -demo but -reinit fails: Postgres says column ExcellentItemDropLevelDelta of GameConfiguration does not exist.
1. Two recent EF migrations were not picked up during a Postgres reinit, so the table was created without the new column. 2. Update your OpenMU checkout or image to a build that contains...
✓ Подтверждено в issueGitHub (MUnique/OpenMU) · 2026-04-11Could 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Написано MuADMINSOpenMU: after an update a game server stays stopped or the admin panel shows pending updates. How do I apply configuration updates?
1. New versions bring changes to the game configuration data (monster stats, drop groups, plugin configurations, quests). They are not applied to your existing database by the software up...