Community AlphaAlpha MUADMINS
ENEnglish
Sign in
On MuADMINSConfig ScannerDrop your files zip: rates, drops, spots, limitsOpenOn MuADMINSMeet us on DiscordAsk for help, share what you are building and talk MU with other server owners.Open

MuADMINS

Solutions

Short fixes for common MU Online server, client and website problems, each with its source and date. “Confirmed” means the person who asked said the fix worked.

49 solutions for “muonline database” in Website · Clear

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

    ✓ Confirmed by the topic starterTuServerMU · 2018-11-19
  2. 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....

    ✓ Confirmed by the topic starterTuServerMU · 2018-04-27
  3. 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...

    ✓ Confirmed by the topic starterTuServerMU · 2020-07-10
  4. 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...

    ✓ Confirmed by the topic starterRaGEZONE · 2023-10-06
  5. 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....

    ✓ Confirmed by the topic starterTUServerMU · 2021-02-07
  6. 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 verifiedWritten by MuADMINS
  7. 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...

    ✓ Confirmed in the issueGitHub (lautaroangelico/WebEngine) · 2017-08-10
  8. Websiteany

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

    ✓ Confirmed by the topic starterRaGEZONE · 2017-09-09
  9. 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...

    ✓ Confirmed by the topic starterRaGEZONE · 2025-02-12
  10. Website

    Which website CMS expects which MU database columns (WebEngine table maps, DmN)

    WebEngine 1.2.7 picks a table map by server files (includes/config): - igcn.tables.php / custom.tables.php: resets = Character.RESETS, grand resets = Character.GrandResets, VIP = T_VIPLis...

    Not verifiedWritten by MuADMINS
  11. Website

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

    ✓ Confirmed by the topic starterDarksTeam · 2019-02-07
  12. Websiteany

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

    ✓ Confirmed by the topic starterTuServerMU · 2020-05-23
  13. Websiteany

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

    ✓ Confirmed by the topic starterTuServerMU · 2019-07-27
  14. Websiteany

    MVCore cannot add credits or gold to accounts: the credits table configured in the web does not match the database

    The credits table name in the MVCore settings had a 'Me_' prefix that the table in the database does not have. 1. Open the MVCore credits configuration where the credits table name is set...

    ✓ Confirmed by the topic starterTUServerMU · 2018-09-29
  15. Website

    Website registration says "Your Account Has Been Created Successfully" but nothing is saved in the database

    The fix given: add the MD5 extension to SQL Server and install the site with MD5 on. 1. Copy the MD5 dll for SQL Server (shared in the thread) into the MSSQL\Binn folder of SQL Server. 2....

    ✓ Confirmed by the topic starterDarksTeam · 2008-11-28
  16. Websiteany

    After switching PHP from 5.6 to 7.x in cPanel my WebEngine lost the connection to the MuOnline database.

    1. Each PHP version in cPanel has its own extension list. 2. Check the new version is supported by your WebEngine release. 3. In cPanel PHP selector, enable the same connection extension...

    ✓ Confirmed by the topic starterTuServerMU · 2021-07-31
  17. Websiteany

    MuCore on a web host cannot connect to the MuOnline database on a Google Cloud VPS (Connection with MuOnline Database Failed), although 1433 is open in Windows.

    1. Enable TCP/IP and Named Pipes for the instance in SQL Server Configuration Manager and restart SQL. 2. Open TCP 1433 in the Windows firewall of the VPS. 3. Also open TCP 1433 in the cl...

    ✓ Confirmed by the topic starterTuServerMU · 2019-03-17
  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....

    ✓ Confirmed by the topic starterTuServerMU · 2017-12-27
  19. Websiteany

    After moving the MU server and WebEngine to a new Windows Server machine (VirtualBox), the site connects to the database but the crons stop updating rankings.

    1. Go to the includes/cache folder of the site and delete the cached data files. 2. If needed, run the cron once by hand with the link shown in AdminCP > Cron Manager. 3. The rankings ref...

    ✓ Confirmed by the topic starterTuServerMU · 2021-03-25
  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...

    ✓ Confirmed by the topic starterRaGEZONE · 2024-02-16

Videos on MUTube

More videos for “muonline database”

Still stuck? Ask the MU Assistant Search MuGPS

MuADMINS Community Alpha: free and community made, in active development.