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

MuADMINS

Решения

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

Решений: 13 по запросу “drop database” · Сбросить

  1. Настройка сервераIGCNS16, S17, S18

    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Написано MuADMINS
  2. Инструментыany

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

    ✓ Подтверждено автором темыTuServerMU · 2018-01-06
  3. Инструменты

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

    ✓ Подтверждено автором темыRaGEZONE · 2014-02-11
  4. Настройка сервераOpenMUany

    OpenMU 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-27
  5. Сайт

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

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

    What 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Написано MuADMINS
  8. ИнструментыOpenMUS6E3

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

    Пересказ источника от MuADMINSNot verifiedGitHub (MUnique/OpenMU) · 2026-10-26
  9. Настройка сервераMuEmu / Louis

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

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

    Пересказ источника от MuADMINSNot verifiedGitHub (MUnique/OpenMU) · 2026-10-17
  11. Настройка сервераOpenMUany

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

    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
  13. ИнструментыOpenMU

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

    Пересказ источника от MuADMINSNot verifiedGitHub (MUnique/OpenMU) · 2026-10-27
Всё ещё не получается? Спросить Помощника MU Поиск в MuGPS Искать на MUTube

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