Community AlphaAlpha MUADMINS
DEDeutsch
Anmelden
Auf MuADMINSConfig ScannerZip deiner Dateien hochladen: Rates, Drops, Spots, LimitsÖffnenAuf MuADMINSTriff uns auf DiscordFrag nach Hilfe, zeig, woran du arbeitest, und sprich mit anderen Serverbetreibern über MU.Öffnen

MuADMINS

Lösungen

Kurze Fixes für häufige Probleme mit Server, Client und Website bei MU Online, jeweils mit Quelle und Datum. “Bestätigt” heißt: Die Person, die gefragt hat, hat gesagt, dass der Fix funktioniert hat.

239 Lösungen für “sql” · Zurücksetzen

  1. Website

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

    ✓ Vom Threadersteller bestätigtDarksTeam · 2009-10-28
  2. Server-Setupany

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

    ✓ Vom Threadersteller bestätigtTUServerMU · 2021-03-17
  3. Server-Setupany

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

    ✓ Vom Threadersteller bestätigtTUServerMU · 2020-07-23
  4. Website

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

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2020-07-01
  5. Server-SetupMuEmu / 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...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2017-03-09
  6. Server-Setupany

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

    ✓ Vom Threadersteller bestätigtTuServerMU · 2017-07-05
  7. Server-SetupOpenMUany

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

    ✓ Im Issue bestätigtGitHub (MUnique/OpenMU) · 2026-08-27
  8. Server-SetupMuEmu / 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...

    ✓ Vom Threadersteller bestätigtTuServerMU · 2017-10-10
  9. Websiteany

    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.

    ✓ Vom Threadersteller bestätigtTuServerMU · 2018-11-19
  10. Websiteany

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

    ✓ Vom Threadersteller bestätigtTuServerMU · 2018-04-27
  11. Websiteany

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

    ✓ Vom Threadersteller bestätigtTuServerMU · 2020-07-10
  12. WebsiteS6

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

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2023-10-06
  13. Server-SetupMuEmu / 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...

    ✓ Vom Threadersteller bestätigtTUServerMU · 2024-01-28
  14. WebsiteSeason 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....

    ✓ Vom Threadersteller bestätigtTUServerMU · 2021-02-07
  15. Server-Setup

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

    ✓ Vom Threadersteller bestätigtTUServerMU · 2018-09-27
  16. Server-SetupOpenMUany

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

    ✓ Im Issue bestätigtGitHub (MUnique/OpenMU) · 2023-11-11
  17. Server-Setup

    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.

    ✓ Vom Threadersteller bestätigtDarksTeam · 2009-10-08
  18. Server-SetupIGCNS9

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

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2019-07-14
  19. Websiteany

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

    ✓ Im Issue bestätigtGitHub (lautaroangelico/WebEngine) · 2017-08-10
  20. Websiteany

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

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2025-02-12

MuADMINS Community Alpha: kostenlos, von der Community gemacht, in aktiver Entwicklung.