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ó.
1 solución para “state (24000)” en Instalación del servidor · Limpiar
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...
✓ Confirmado por el autor del temaRaGEZONE · 2018-04-09
Coincidencias con algunas de tus palabras
Estas soluciones tienen algunas de las palabras de “state (24000)”:
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...
✓ Confirmado por el autor del temaRaGEZONE · 2019-07-14"Login failed for user 'sa'" (SQLSTATE 28000) from DataServer or the web right after installing SQL Server. How do I enable sa?
1. If setup used Windows authentication only, sa is disabled. 2. In Management Studio right click the server > Properties > Security and pick SQL Server and Windows Authentication mode. 3...
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-24OpenMU: a player stays 'already connected' after a dropped connection and cannot log in again, even with the right password
1. The old session stays registered while the TCP connection to OpenMU is still open. With the web client the WebSocket proxy keeps that connection alive, so every new login gets AccountA...
✓ Confirmado en el issueGitHub (MUnique/OpenMU) · 2026-10-07Two accounts always say they are already logged in, but they are not in game and cannot be disconnected.
1. The online state is kept by the JoinServer. 2. Use the JoinServer option to disconnect accounts. 3. Then the account can log in again.
✓ Confirmado por el autor del temaCreandoMU · 2021-01-31OpenMU 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...
✓ Confirmado en el issueGitHub (MUnique/OpenMU) · 2026-08-27Where are accounts, VIP, credits, resets and bans in the DV-Team Season 19 database (MySQL / MariaDB)?
DV-Team does not use SQL Server: the database is a MySQL / MariaDB dump (Navicat), databases muonline (127 tables) and log (22 tables). There is no MEMB_INFO and no stored procedure, so S...
Not verifiedEscrito por MuADMINSMuDevs 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