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.

127 Lösungen für “SQL Server” für DV-Team und alle Files · Zurücksetzen

  1. 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
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. Website

    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 verifiedVon MuADMINS geschrieben
  9. Server-Setup

    Korean, Cyrillic, Greek or other character names turn into ?? (collation and Unicode in MU databases)

    In every MSSQL files family we read, names are VARCHAR: Character.Name varchar(10), AccountCharacter.GameID1 ... varchar(10), Guild.G_Name varchar(8), MEMB_INFO.memb___id varchar(10). A V...

    Not verifiedVon MuADMINS geschrieben
  10. Server-Setup

    How do I back up and restore MU databases: which ones, in which order, and moving to a new PC?

    Back up every database of the server at the same moment (server closed), and restore them together: - IGCN: MuOnline, Me_MuOnline (if used), Events, Ranking, BattleCore - MuEmu, Louis, MS...

    Not verifiedVon MuADMINS geschrieben
  11. Server-Setup

    "Account does not exist" or the login fails although the account is in MEMB_INFO: what to check in the database

    Check these in order (all read only, nothing changes): 1. Is the server reading the same database? MuEmu, Louis, MSPro, X-Team, MuDevs use the ODBC DSN in JoinServer.ini (JoinServerODBC =...

    Not verifiedVon MuADMINS geschrieben
  12. Server-SetupS6, S16

    How do I turn MD5 on (MD5Encryption in JoinServer.ini) on MuEmu, Louis, MSPro, X-Team or MuDevs files, and what does the database need?

    In MuEmu based files the switch is JoinServer\JoinServer.ini, MD5Encryption = 0/1 (next to CaseSensitive = 0). Every pack we read ships 0. What the databases have: - X-Team Season 2 and 1...

    Not verifiedVon MuADMINS geschrieben
  13. ToolsEx702 to S8E2

    MU DB Helper: how do I install the item, inventory and vault database editor for Ex702 and newer servers?

    1. Requirements: Visual Studio 2013, SQL Server 2012 or newer, ODBC Driver 13 and a MU Online Ex702+ database. 2. Clone the repository and make sure a MuOnline database exists (CREATE DAT...

    Neufassung der Quelle durch MuADMINSNot verifiedGitHub (kyleruss/mu-db-helper) · 2018-04-30
  14. Website

    No MU website works on XAMPP (Windows 7 64-bit): SQL connection errors and php.ini extension errors although the extension is enabled

    1. Turn User Account Control (UAC) back on if you had disabled it. 2. Install XAMPP again (version 1.7.1, the one these old MSSQL based sites need). 3. Put the site back and test; the SQL...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2017-07-28
  15. Server-Setup

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

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2015-11-30
  16. Server-Setupany

    After enabling TCP/IP in SQL Server for the web, DataServer, JoinServer and GameServerCS lost the database connection. How was it fixed?

    1. In SQL Server Configuration Manager keep Named Pipes and TCP/IP enabled for the instance. 2. Open the ODBC DSNs used by the server files. 3. Change the Server field from the LAN IP to...

    ✓ Vom Threadersteller bestätigtTuServerMU · 2020-05-23
  17. Websiteany

    MVCore 1.17.1 and MuCore 1.8 on XAMPP 1.7.1 both fail to connect to SQL Server 2008 R2, even with Named Pipes enabled.

    1. SQL Server was installed as the named instance SQLEXPRESS, so there was no MSSQLSERVER default instance. 2. Reinstall SQL Server with the default instance (MSSQLSERVER) and keep the sa...

    ✓ Vom Threadersteller bestätigtTuServerMU · 2018-07-30
  18. Websiteany

    MuCore on XAMPP on the same VPS as SQL Server cannot connect to the database.

    1. Easiest: in the MuCore config.php change the connection type from MSSQL to ODBC. 2. Or open SQL Server Configuration Manager, enable TCP/IP and Named Pipes, and restart SQL Server. 3....

    ✓ Vom Threadersteller bestätigtTuServerMU · 2017-12-27
  19. Websiteany

    After replacing MuCore 1.0.8 with MVCore 1.17.1 on the host, the installer does not appear and the site cannot connect to SQL.

    1. Delete all old files in public_html (leftover MuCore files and config). 2. Upload MVCore again; the installer then opens. 3. Enter the SQL data in the installer; it connects normally.

    ✓ Vom Threadersteller bestätigtTuServerMU · 2018-06-03
  20. Websiteany

    After the VPS (SQL) IP changed, a WebEngine CMS 1.2.4 site hosted on a separate Linux server shows 'Connection to database failed (MuOnline)' and the installer says the install is already complete.

    1. Open includes/config/webengine.json and set "webengine_cms_installed": false, then upload it. 2. In the web host cPanel open PHP Selector and (re)enable pdo_dblib and pdo_sqlsrv. 3. Ru...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2024-02-16

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