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

MuADMINS

Решения

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

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

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

    A character exists in the Character table but does not appear (AccountCharacter slots)

    The character list of an account is kept in AccountCharacter (Id = account, GameID1 to GameID5, or to GameID10 on newer files, plus GameIDC). The packs' WZ_CreateCharacter writes the new...

    Not verifiedНаписано MuADMINS
  3. Настройка сервераДругие файлыS5.5

    PerfectZone Season 5.5 files: MSVCP110.dll error and players cannot enter the game (copying the DLL does not help)

    1. Copying MSVCP110.dll by hand is not enough: install the Visual C++ 2012 Redistributable. 2. Install both the x86 and the x64 packages (the x86 one is the one these files need, even on...

    ✓ Подтверждено автором темыRaGEZONE · 2019-06-28
  4. Настройка сервера

    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
  5. Настройка сервераX-TeamS2, S15, S17, S18

    What is in the X-Team MuOnline database (password column, VIP, coins, resets, gens, master level)?

    X-Team uses one database, MuOnline, with the MuEmu procedure set. - Accounts: MEMB_INFO.memb__pwd varchar(10) (plain; no MD5 function in the scripts), sno__numb char(18), AccountLevel / A...

    Not verifiedНаписано MuADMINS
  6. Настройка сервера

    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
  7. Настройка сервераWebZen 97d / 99b97d

    DarksTeam 97d: accounts created on the web show NULL columns in the database and characters do not show up properly. How to fix it?

    1. Back up the MuOnline database first. 2. Open a new query on MuOnline in SQL Server Management Studio. 3. Run: UPDATE Character SET CtlCode = 0 WHERE CtlCode IS NULL 4. Restart the serv...

    ✓ Подтверждено автором темыTuServerMU · 2018-10-15
  8. Настройка сервераMuEmu / LouisSeason 6 (MuEmu update 22)

    New characters show 65535 kills and deaths.

    1. Fix existing ones: UPDATE dbo.Character SET Kills=0 WHERE Kills=65535 and the same for Deads. 2. In SSMS design the Character table and set the Default Value of Kills and Deads to 0. 3...

    ✓ Подтверждено автором темыCreandoMU · 2020-08-20
  9. Настройка сервераMuEmu / 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...

    ✓ Подтверждено автором темыCreandoMU · 2021-03-09
  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. Настройка сервераany

    SQL query to delete only characters and guilds but keep the accounts and their warehouse

    1. Make a full backup of the database first. 2. In SQL Server Management Studio run: USE MuOnline; DELETE Character (characters). 3. For guilds run: DELETE Guild; DELETE GuildMember. 4. M...

    ✓ Подтверждено автором темыTUServerMU · 2021-03-30
  12. Настройка сервераany

    How to back up only the accounts and characters (inventory, warehouse, stats) instead of the whole MU database

    1. First make a full backup of the current database as it is (SQL Server Management Studio > Tasks > Back Up). 2. To move players to a clean database, copy over only the tables that hold...

    ✓ Подтверждено автором темыTUServerMU · 2020-07-23
  13. Настройка сервераMuEmu / LouisSeason 6 Episode 3

    Creating a character fails with 'Nombre de personaje incorrecto o ya existe' after installing a SQL script that gives points and zen to new characters (MuEmu S6 EP3 Louis Update 13)

    The new character script wrote to columns that do not exist in this database. 1. Open the script (trigger) you added in SQL Server Management Studio. 2. Compare its column names with your...

    ✓ Подтверждено автором темыTUServerMU · 2020-05-04
  14. Настройка сервера

    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
  15. Настройка сервера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
  16. Настройка сервера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
  17. Настройка сервераMuEmu / Louisany

    After moving from TitansTech to MuEmu, characters roll back on relog: items and position are not saved. The database was converted. What fixed it?

    1. Character data is saved by the DataServer, so check that first, not the tables. 2. Do not reuse the DataServer from your old TitansTech files: it did not work with MuEmu. 3. Use the Da...

    ✓ Подтверждено автором темыTuServerMU · 2017-11-02
  18. Настройка сервера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
  19. Настройка сервераMuEmu / LouisS6

    MSVCP100.DLL is missing when starting ConnectServer, DataServer or JoinServer (MuEmu S6 files).

    Install the Microsoft Visual C++ 2010 Redistributable (x86, plus x64 on 64 bit Windows). Prefer the Microsoft download over single DLL sites.

    ✓ Подтверждено автором темыTuServerMU · 2018-06-11
  20. Настройка сервера

    Characters do not save and the DataServer log shows State (42S22)

    SQL state 42S22 means a column was not found: the server files query a column your database does not have, so the save fails. 1. Open the DataServer log and read which table and column th...

    ✓ Подтверждено автором темыTUServerMU · 2021-03-24

Видео на MUTube

Ещё видео по запросу «tables»

Всё ещё не получается? Спросить Помощника MU Поиск в MuGPS

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