MuADMINS
Mga Solusyon
Maiikling fix para sa mga karaniwang problema sa MU Online server, client at website, bawat isa ay may source at petsa. Ang ibig sabihin ng “Kinumpirma” ay sinabi ng nagtanong na gumana ang fix.
48 solusyon para sa “SQL Server” sa Website para sa MuDevs at kahit anong files · I-clear
Website error "Fatal error: Call to undefined function mssql_connect()" (XAMPP 1.7.7, SQL Server 2008, DarksWeb 0.3)
New XAMPP builds no longer have the mssql_* functions these old sites use. 1. Install XAMPP 1.7.1 (said to be the last one with mssql_*), or add code that defines those functions to the s...
✓ Kinumpirma ng nagsimula ng topicDarksTeam · 2019-02-07WebEngine on shared hosting cannot reach SQL on my VPS. Port 1433 is open and MuMaker connects from home, but the web install still fails.
1. The hosting company may block outgoing traffic to port 1433. 2. In SQL Server Configuration Manager > TCP/IP > IP Addresses > IPAll set TCP Port to another free port and leave TCP Dyna...
✓ Kinumpirma ng nagsimula ng topicTuServerMU · 2020-05-23MuCore 2.2.0 installer stops with 'SQL Failed' at the connection step.
1. Open TCP port 1433 in the Windows firewall. 2. In SQL Server Configuration Manager enable Named Pipes and TCP/IP, set IPAll TCP Port 1433. 3. Restart SQL Server and run the installer a...
✓ Kinumpirma ng nagsimula ng topicTuServerMU · 2019-07-27WebEngine 1.0.9 with a remote SQL Server IP fails with 'Could not connect to database (1)', while MuCore connects to the same server without problems.
1. In the WebEngine installer select the ODBC driver instead of dblib/sqlsrv. 2. Make sure the matching PHP ODBC extension is enabled and port 1433 is reachable. 3. Finish the install.
✓ Kinumpirma ng nagsimula ng topicRaGEZONE · 2017-09-09MuWeb 0.9 installer check shows Mssql: NO even after editing php.ini
1. Install XAMPP 1.7.0 (it includes the mssql extension the site needs). 2. Put MuWeb 0.9 in its htdocs and open the installer again; Mssql now shows YES.
✓ Kinumpirma ng nagsimula ng topicDarksTeam · 2009-02-12Error #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....
✓ Kinumpirma ng nagsimula ng topicDarksTeam · 2009-10-28How 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...
✓ Kinumpirma ng nagsimula ng topicRaGEZONE · 2020-07-01After 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.
✓ Kinumpirma ng nagsimula ng topicTuServerMU · 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....
✓ Kinumpirma ng nagsimula ng topicTuServerMU · 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...
✓ Kinumpirma ng nagsimula ng topicTuServerMU · 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...
✓ Kinumpirma ng nagsimula ng topicRaGEZONE · 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....
✓ Kinumpirma ng nagsimula ng topicTUServerMU · 2021-02-07WebEngine 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...
✓ Kinumpirma sa issueGitHub (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...
✓ Kinumpirma ng nagsimula ng topicRaGEZONE · 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 verifiedIsinulat ng MuADMINSNo 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...
✓ Kinumpirma ng nagsimula ng topicRaGEZONE · 2017-07-28MVCore 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...
✓ Kinumpirma ng nagsimula ng topicTuServerMU · 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....
✓ Kinumpirma ng nagsimula ng topicTuServerMU · 2017-12-27After 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.
✓ Kinumpirma ng nagsimula ng topicTuServerMU · 2018-06-03After 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...
✓ Kinumpirma ng nagsimula ng topicRaGEZONE · 2024-02-16
Mga video sa MUTube
Paano Mag-setup ng SQL Server 2008 para sa MuOnline
MuADMINS · 4:43 · 2016
Paano Mag-setup ng MSSQL 2000 para sa MuOnline
MuADMINS · 7:20 · 2013
Tutorial SQL Server 2008 R2 MuOnline
LayerGaming · 4:14 · 2021
I-install ang Sql Server 2008 R2 MuOnline
EXProject Mu - Desarrollo de MuOnline · 10:44 · 2024