Community AlphaAlpha MUADMINS
ESEspañol
Iniciar sesión
En MuADMINSConfig ScannerSube el zip de tus archivos: rates, drops, spots, límitesAbrirEn MuADMINSEncuéntranos en DiscordPide ayuda, comparte lo que estás creando y habla de MU con otros dueños de servidores.Abrir

MuADMINS

Soluciones

Arreglos breves para problemas comunes de servidores, clientes y sitios web de MU Online, cada uno con su fuente y su fecha. “Confirmado” significa que la persona que preguntó dijo que el arreglo funcionó.

80 soluciones para “columns” · Limpiar

  1. Sitio web

    Which website CMS expects which MU database columns (WebEngine table maps, DmN)

    WebEngine 1.2.7 picks a table map by server files (includes/config): - igcn.tables.php / custom.tables.php: resets = Character.RESETS, grand resets = Character.GrandResets, VIP = T_VIPLis...

    Not verifiedEscrito por MuADMINS
  2. Instalación del servidorMuDevsS18

    MuDevs Season 18: Invalid column name 'LastGateIndex' (the extra query of the pack)

    The MuDevs Season 18 pack ships, next to the database scripts, a file Execute query.sql with one statement: ALTER TABLE dbo.Character ADD LastGateIndex [int] NOT NULL DEFAULT(-1); If the...

    Not verifiedEscrito por MuADMINS
  3. Sitio webX-TeamS2, S17

    WebEngine with X-Team files: online ranking fails with Invalid column name 'OnlineHours'

    WebEngine's map for X-Team files (includes\config\xteam.tables.php) defines _CLMN_MS_ONLINEHRS_ = OnlineHours, and the online ranking (only for xteam files) runs: SELECT TOP n memb___id,...

    Not verifiedEscrito por MuADMINS
  4. Instalación del servidorMuEmu / LouisS6

    Louis / MuEmu Season 6: "Invalid column name" after updating the server files (which Update script adds which column)

    Louis (JogandoMU) Season 6 files ship one SQL file per update. If the files are newer than the database, the server logs Invalid column name 'X'. Find X below and run that script (and the...

    Not verifiedEscrito por MuADMINS
  5. Herramientas

    MuMaker: how to fill the first configuration window (SQL user, local or remote, MD5, database names, reset column)

    1. Extract MuMaker and start MuMaker.exe. 2. Type any name (server name or yours), the SQL user (sa by default) and its password. 3. Connection type: choose local when MuMaker runs on the...

    Reescrito por MuADMINS a partir de la fuenteNot verifiedRaGEZONE · 2007-12-22
  6. Herramientas

    MuMaker: creating an account fails with "Disallowed implicit conversion from data type varchar to data type varbinary ... column 'memb_pwd'"

    1. The error means MEMB_INFO.memb_pwd is a varbinary column: your database stores MD5 passwords. 2. Enable MD5 in the MuMaker settings and create the account again. 3. A reply also sugges...

    ✓ Confirmado por el autor del temaRaGEZONE · 2011-12-06
  7. Instalación del servidorOpenMUany

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

    ✓ Confirmado en el issueGitHub (MUnique/OpenMU) · 2026-04-11
  8. Instalación del servidorWebZen 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...

    ✓ Confirmado por el autor del temaTuServerMU · 2018-10-15
  9. Sitio web

    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 verifiedEscrito por MuADMINS
  10. HerramientasWebZen 97d / 99b

    Cash Shop and VIP Editor (Dino): how to connect it to SQL Server and which columns it needs

    1. Enter the SQL Server IP, login, password and port, then click Connect. 2. Leave the filter empty to list all accounts, or type an account name. 3. Choose the VIP type and the amount of...

    Reescrito por MuADMINS a partir de la fuenteNot verifiedImperyus Games Brasil · 2009-10-04
  11. HerramientasWebZen 97d / 99b1.07V+ Season 6

    Item.bmd editor shows strange values (Strength 34304 for Explosion Blade) when opening a 1.07V+ Season 6 client item.bmd

    1. The editor reads the file with the old column layout: in Season 6 clients (1.07V+ and newer) item.bmd has more columns, so values land in the wrong fields (Strength shows Agility and s...

    ✓ Confirmado por el autor del temaImperyus Games Brasil · 2010-12-27
  12. Sitio web97d+99i

    /reset works in game but the website still shows 0 resets (newest DarksTeam files)

    The server writes resets to the column Resets, while the website reads another column (Reset). 1. Open the website config (usually config.php) and find $res_column_name. 2. Set it to $res...

    ✓ Confirmado por el autor del temaDarksTeam · 2017-06-13
  13. JugabilidadMuEmu / Louis

    MuEmu: is it possible to give a skill a cooldown?

    1. Yes: the skill delay is a column of the skill data. 2. Open skill_eng.bmd with a skill editor and set the Delay column of that skill. 3. Save, update the client and test the skill.

    ✓ Confirmado por el autor del temaRaGEZONE · 2017-10-06
  14. Jugabilidad

    How do I make a monster drop one specific item with full options and +15 (item drop file columns)?

    1. In the item drop file each line has: Index Level Grade Option0 Option1 Option2 Option3 Option4 Option5 Option6 Duration MapNumber MonsterClass MonsterLevelMin MonsterLevelMax DropRate....

    ✓ Confirmado por el autor del temaRaGEZONE · 2020-01-13
  15. Sitio webMuEmu / LouisS6

    DMN CMS with MuEmu S6E3 files: reset and grand reset modules do not work.

    1. Open the Character table in SQL and read the exact column names. 2. In the DMN config type them exactly, with the same upper and lower case (for example ResetCount, not reset or resetc...

    ✓ Confirmado por el autor del temaTuServerMU · 2018-11-22
  16. Jugabilidad

    What does the Excellent column mean in a Kundun box item bag line?

    1. In the bag line (Section Type MinLevel MaxLevel Skill Luck Option Excellent), the Excellent value is the number of excellent options the item gets. 2. For example 3 gives items with 3...

    ✓ Confirmado por el autor del temaTuServerMU · 2019-01-03
  17. Instalación del servidor

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

    ✓ Confirmado por el autor del temaTUServerMU · 2021-03-24
  18. Instalación del servidorX-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 verifiedEscrito por MuADMINS
  19. HerramientasWebZen 97d / 99b

    ENC MuOnline DB Editor (ENCGames): first setup, and why it cannot open item(kor).txt

    1. Start the .exe and point it to your server item(kor).txt: the editor builds its item list from that file, so custom items show up too. 2. Wait while it loads the items, then fill in yo...

    Reescrito por MuADMINS a partir de la fuenteNot verifiedRaGEZONE · 2011-07-01
  20. HerramientasWebZen 97d / 99b

    CzF Editor 1.5a: creating a new account gives an error although MD5 is disabled in the editor options

    1. With MD5 off in the editor, the password column must be plain text, but in this database memb__pwd was still binary. 2. Open Enterprise Manager (or Management Studio) > Databases > MuO...

    ✓ Confirmado por el autor del temaRaGEZONE · 2007-10-05
¿Sigues atascado? Pregúntale al Asistente MU Buscar en MuGPS Buscar en MUTube

MuADMINS Community Alpha: gratis, hecho por la comunidad y en desarrollo activo.