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.

145 solutions for “cannot open database” · Clear

  1. Server setupS2, S6, S16, S17, S18, S20

    How do I give VIP (AccountLevel) to an account with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files?

    In MuEmu based files VIP is MEMB_INFO.AccountLevel (0 = normal, the AL1 / AL2 / AL3 levels of your configs) with MEMB_INFO.AccountExpireDate. Use the shipped procedure, account offline: E...

    Not verifiedWritten by MuADMINS
  2. Server setupIGCNS9, S12, S16, S17, S18

    How do I give or extend VIP for an account with SQL on IGCN files (IGC_VipAdd, T_VIPList)?

    IGCN keeps the active VIP in T_VIPList (AccountID, Date, Type); MEMB_INFO also has VipType, VipStart, VipDays. The shipped procedure is IGC_VipAdd @szCharName, @DayAdd, @VipType. Despite...

    Not verifiedWritten by MuADMINS
  3. Tools

    Mu Launcher v1.3 (RJ launcher, harlcreeds): how to set the server IP, the patch link and the registration

    1. Run rjdllcreator.exe and type your server IP: it builds rjconnect.dll, the connector the launcher uses. 2. Install a web server (WAMP www, XAMPP htdocs, nginx html) and copy the rjlaun...

    MuADMINS rewrite of the sourceNot verifiedRaGEZONE · 2017-11-18
  4. ToolsIGCNS9

    IGCN Essential Tools (S9 E2 repack) shows an error pop-up as soon as it is opened.

    1. Open SQL Server Configuration Manager > SQL Server Network Configuration > Protocols. 2. Enable Named Pipes and TCP/IP. 3. In TCP/IP properties > IP Addresses set TCP Port 1433 (IPAll)...

    ✓ Confirmed by the topic starterRaGEZONE · 2018-06-18
  5. GameplayIGCNS13

    IGCN Season 13 files: how to give new characters a starting amount of zen.

    1. In SSMS run on MuOnline a query that creates an INSERT trigger on dbo.Character (named Bonus in the thread). 2. The trigger reads the new Name from INSERTED and runs UPDATE Character S...

    ✓ Confirmed by the topic starterTuServerMU · 2018-10-15
  6. Server setupIGCNS9, S12, S16, S17, S18

    How do I reset a character with SQL on IGCN files (RESETS, GrandResets) with the server closed?

    Columns in IGCN Character: RESETS (int, all seasons), GrandResets (tinyint, Season 16, 17, 18), GRANDRESET (Season 12), plus cLevel, Experience, LevelUpPoint and the stats. 1. Close the G...

    Not verifiedWritten by MuADMINS
  7. Server setup

    The website always shows 2 players online even when the server is off

    Stale rows in MEMB_STAT still say the accounts are connected. 1. Open Query Analyzer / SSMS on the MuOnline database. 2. Run UPDATE MEMB_STAT SET ConnectStat='0' WHERE ConnectStat>0. 3. R...

    ✓ Confirmed by the topic starterDarksTeam · 2009-03-03
  8. Server setupS3E2

    DarksTeam Season 3 Episode 2 (Beta 19) Cash Shop: a bought Seal disappears after reconnect

    The seal was saved with a wrong date format in t_perioditem_info. 1. Open the stored procedure t_perioditem_insert in the MuOnline database. 2. Fix the datetime format it uses when insert...

    ✓ Confirmed by the topic starterDarksTeam · 2009-08-09
  9. Server setup

    Guild war gives no points: the website shows a negative score and the in-game G Score stays 0

    The Guild table column G_Score had no default value, so new guilds got NULL. 1. Open SQL Server > MuOnline database > Tables > Guild > Design Table. 2. Select the column G_Score and set i...

    ✓ Confirmed by the topic starterDarksTeam · 2010-05-03
  10. Server setup

    How to protect Game Master characters (give them the protected GM status)

    The GM status is the CtlCode column of the character. 1. Open the MuOnline database in SQL Server. 2. Run UPDATE Character SET CtlCode = '8' WHERE Name='<GM name>' (the asker confirmed 8...

    ✓ Confirmed by the topic starterDarksTeam · 2012-05-11
  11. 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...

    ✓ Confirmed by the topic starterRaGEZONE · 2019-07-14
  12. 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...

    ✓ Confirmed by the topic starterTuServerMU · 2020-05-23
  13. 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
  14. 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
  15. Server setupMuEmu / LouisSeason 6 (Louis free)

    Items ask for more stats than shown and only equip after relogging (Louis free S6).

    1. Louis first advice: item.bmd (client) and Item.txt (server) must match. 2. Here the asker had changed the starting stats of the classes directly in the database, which caused the confl...

    ✓ Confirmed by the topic starterCreandoMU · 2021-08-31
  16. GameplayMuEmu / LouisSeason 6 (MuEmu)

    MuEmu: how do I set Castle Siege so registration opens by itself on Monday and the siege runs on Sunday?

    1. Edit GameServerCS/Data/Event/MuCastleData.dat: state 7 sets the siege day and start hour, state 8 sets the end hour. 2. In GameServerCS/Data/GameServerInfo - Event.dat set CastleSiegeE...

    ✓ Confirmed by the topic starterCreandoMU · 2020-09-28
  17. ToolsMuEmu / LouisSeason 6

    Cash Editor gives an error when editing credits, although the SQL user and password are set

    The cash table and column names in the editor config were wrong. 1. Open the editor config file (XTRMu in the thread). 2. [SQLConnection]: SQLHost = (local), SQLUser = your SQL user, SQLP...

    ✓ Confirmed by the topic starterTUServerMU · 2020-07-10
  18. Server setupSeason 6

    How to remove the master skill tree skills from every character at once (S6 Up15 GamingMaster files); DELETE MasterSkillTree did not remove them

    The learned skills are stored in the MagicList column of the Character table. 1. Back up the database and close the server. 2. Run: USE MuOnline; UPDATE Character SET [MagicList] = CONVER...

    ✓ Confirmed by the topic starterTUServerMU · 2021-05-09
  19. Server setupX-TeamSeason 15

    X-Team Season 15 files (update 5): GameServer shows a message that something 'does not exist' and will not start

    The error is about the server code and the GameServer common file of the update. 1. Check the ServerCode is the same in ConnectServer\ConnectServer.txt, Data\MapServerInfo and the GameSer...

    ✓ Confirmed by the topic starterTUServerMU · 2020-08-15
  20. Server setupIGCNS12

    IGCN Season 12: DataServer is not responding although TCP/IP is enabled in SQL Server

    1. Open DataServer.ini and check SQLServerName. 2. When SQL Server runs on the same machine use SQLServerName = (local) or the exact PC name as shown in SQL Server Management Studio (for...

    ✓ Confirmed by the topic starterRaGEZONE · 2020-01-08

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