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

239 soluciones para “sql” · Limpiar

  1. Sitio web

    Error #123 Loading php_mssql.dll Failed when installing DarksWeb, although the dll is in the ext folder

    1. Install AppServ 2.5.9 instead of the XAMPP / VertrigoServ builds that failed. 2. Edit C:\Windows\php.ini (the php.ini AppServ really uses) and enable extension=php_mssql.dll there. 3....

    ✓ Confirmado por el autor del temaDarksTeam · 2009-10-28
  2. Instalación del servidorany

    How to get the list of e-mail addresses of all registered accounts from the MU database

    1. Open SQL Server Management Studio and connect to the server that holds your MU database. 2. Run: USE MuOnline; SELECT mail_addr FROM MEMB_INFO; 3. The result is the e-mail of every acc...

    ✓ Confirmado por el autor del temaTUServerMU · 2021-03-17
  3. Instalación del servidorany

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

    ✓ Confirmado por el autor del temaTUServerMU · 2020-07-23
  4. Sitio web

    How do I show the guild logo (G_Mark) of a guild, for example the Castle Siege owner, on a PHP website with MSSQL?

    1. G_Mark in the Guild table is binary: turn it into text with bin2hex(). You get 64 hex digits, one per cell of an 8x8 grid. 2. Map each digit to a color: 0 transparent, 1 #000000, 2 #8c...

    ✓ Confirmado por el autor del temaRaGEZONE · 2020-07-01
  5. Instalación del servidorMuEmu / LouisS8

    MuEmu Season 8 Episode 3 asks for a Me_MuOnline database; where do I get it?

    1. There is no separate Me_MuOnline download: for these files it is the same database as MuOnline. 2. Point the Me_MuOnline connection (ODBC data source or config entry) to your MuOnline...

    ✓ Confirmado por el autor del temaRaGEZONE · 2017-03-09
  6. Instalación del servidorany

    JoinServer and DataServer show Could not connect to database on start.

    1. Restore the MuOnline database correctly in SQL Server (from the backup shipped with your files). 2. Create the ODBC data source the servers expect, pointing to that database. 3. Make s...

    ✓ Confirmado por el autor del temaTuServerMU · 2017-07-05
  7. Instalación del servidorOpenMUany

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

    ✓ Confirmado en el issueGitHub (MUnique/OpenMU) · 2026-08-27
  8. Instalación del servidorMuEmu / LouisS6

    MuEmu S6 by Louis: DataServer and JoinServer say 'Could not connect to database' with both included databases, even with correct IPs and open ports.

    1. The included ODBC .reg created a data source named MuOnlineS6 pointing to database MuOnlineS6. 2. Edit the ODBC data source (or the .reg) so the name and database match what the server...

    ✓ Confirmado por el autor del temaTuServerMU · 2017-10-10
  9. Sitio webany

    After switching to new server files with a new database, the MuCore site no longer detects the database and players cannot register.

    1. The new database does not contain the MuCore tables. 2. Run the MuCore installer again against the new database so it creates its tables. 3. Check config.SQL.php points to the new DB.

    ✓ Confirmado por el autor del temaTuServerMU · 2018-11-19
  10. Sitio webany

    DMN MuCMS 1.1.8 installer fails at the database selection step (both on a host and on XAMPP).

    1. Use a separate database for the web (for example dmncms). 2. The MU game database must be named MuOnline (plus Me_MuOnline if your files use it); the install failed with a custom name....

    ✓ Confirmado por el autor del temaTuServerMU · 2018-04-27
  11. Sitio webany

    WebEngine AdminCP suddenly shows: 'The following errors occurred: [Not Found] logs/database_errors.log (re-upload file)'.

    1. Create the folder logs inside the includes folder. 2. Upload an empty database_errors.log file into includes/logs. 3. Give the folder and file write permission (777 was used in the thr...

    ✓ Confirmado por el autor del temaTuServerMU · 2020-07-10
  12. Sitio webS6

    WebEngine CMS install keeps saying 'Could not connect to database (1)' with SQL Server 2008 and XAMPP (PDO ODBC), even though SSMS connects fine.

    1. The thread found a conflict between SQL Server 2008 and WebEngine's connection. 2. Install a newer SQL Server (2012 worked for the topic starter; another user had 2019 working). 3. Res...

    ✓ Confirmado por el autor del temaRaGEZONE · 2023-10-06
  13. Instalación del servidorMuEmu / LouisSeason 6 (Louis update 13)

    Nothing is saved in game and editors say the database is read-only

    The database that came with a repack can be damaged or incomplete. Here the fix was to use the clean database of the package the files are based on. 1. Download the original package the r...

    ✓ Confirmado por el autor del temaTUServerMU · 2024-01-28
  14. Sitio webSeason 6

    WebEngine on web hosting says "Could not connect to database (1)"

    Shared web hosting often blocks outgoing connections to port 1433, the default SQL Server port, so the website cannot reach the database on your VPS even when tools on your own PC can. 1....

    ✓ Confirmado por el autor del temaTUServerMU · 2021-02-07
  15. Instalación del servidor

    JoinServer and DataServer cannot connect to the database although the backup is restored

    These files had the database name MuOnlineS6 in the server configs while the database was restored as MuOnline, so the servers looked for a database that does not exist. 1. In SQL Server...

    ✓ Confirmado por el autor del temaTUServerMU · 2018-09-27
  16. Instalación del servidorOpenMUany

    OpenMU: after a restart all my configuration and data were gone and the database was initialized again.

    1. With Docker the Postgres data must live in a volume. 2. The provided docker-compose files persist it in volumes, so the data was lost because the volumes were deleted or the setup did...

    ✓ Confirmado en el issueGitHub (MUnique/OpenMU) · 2023-11-11
  17. Instalación del servidor

    Event server (Devil Square ranking) error: it looks for the wrong database

    1. Open the event server config svconfig.ini. 2. Change mu2003_dsn = Ranking to mu2003_dsn = MuOnline (the data source that really exists). 3. Restart the event server.

    ✓ Confirmado por el autor del temaDarksTeam · 2009-10-08
  18. Instalación del servidorIGCNS9

    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
  19. Sitio webany

    WebEngine shows a PDOException with my SQL Server host, user and password on screen when the database is down. How do I hide it?

    1. The full stack trace is printed only because debug mode is turned on in your WebEngine configuration. 2. Turn debug mode off on the live site so visitors only see a generic error. 3. I...

    ✓ Confirmado en el issueGitHub (lautaroangelico/WebEngine) · 2017-08-10
  20. Sitio webany

    WebEngine CMS on a web host cannot reach the SQL Server on a VPS: 'Could not connect to database (1)', even after opening port 1433 in the firewall and enabling TCP/IP.

    1. Check the usual items first: inbound rule for TCP 1433 in Windows Defender Firewall on the VPS, TCP/IP enabled in SQL Server Configuration Manager. 2. If it still fails, test whether t...

    ✓ Confirmado por el autor del temaRaGEZONE · 2025-02-12

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