MuADMINS
Rozwiązania
Krótkie poprawki częstych problemów z serwerem, klientem i stroną MU Online, każda ze źródłem i datą. “Potwierdzone” oznacza, że osoba, która pytała, potwierdziła, że poprawka zadziałała.
Rozwiązania: 130 dla “SQL Server” dla Inne pliki i dowolnych plików · Wyczyść
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.
✓ Potwierdzone przez autora tematuTuServerMU · 2018-11-19DMN 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....
✓ Potwierdzone przez autora tematuTuServerMU · 2018-04-27WebEngine 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...
✓ Potwierdzone przez autora tematuTuServerMU · 2020-07-10WebEngine 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...
✓ Potwierdzone przez autora tematuRaGEZONE · 2023-10-06WebEngine 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....
✓ Potwierdzone przez autora tematuTUServerMU · 2021-02-07JoinServer 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...
✓ Potwierdzone przez autora tematuTUServerMU · 2018-09-27Event 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.
✓ Potwierdzone przez autora tematuDarksTeam · 2009-10-08WebEngine 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...
✓ Potwierdzone w zgłoszeniuGitHub (lautaroangelico/WebEngine) · 2017-08-10WebEngine 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...
✓ Potwierdzone przez autora tematuRaGEZONE · 2025-02-12What 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 verifiedNapisane przez MuADMINSKorean, 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 verifiedNapisane przez MuADMINSHow 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 verifiedNapisane przez MuADMINS"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 verifiedNapisane przez MuADMINSHow 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 verifiedNapisane przez MuADMINSMU 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...
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...
✓ Potwierdzone przez autora tematuRaGEZONE · 2017-07-28Replacing 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...
✓ Potwierdzone przez autora tematuRaGEZONE · 2015-11-30After 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...
✓ Potwierdzone przez autora tematuTuServerMU · 2020-05-23MVCore 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...
✓ Potwierdzone przez autora tematuTuServerMU · 2018-07-30MuCore 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....
✓ Potwierdzone przez autora tematuTuServerMU · 2017-12-27