Community AlphaAlpha MUADMINS
FRFrançais
Connexion
Sur MuADMINSConfig ScannerDéposez le zip de vos fichiers : rates, drops, spots, limitesOuvrirSur MuADMINSRetrouvez-nous sur DiscordDemandez de l'aide, partagez ce que vous créez et parlez de MU avec d'autres propriétaires de serveurs.Ouvrir

MuADMINS

Solutions

Des correctifs courts pour les problèmes courants de serveur, de client et de site web MU Online, chacun avec sa source et sa date. “Confirmé” signifie que la personne qui a posé la question a indiqué que le correctif a fonctionné.

145 solutions pour “cannot open database” · Effacer

  1. Installation du serveurS2, 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 verifiedRédigé par MuADMINS
  2. Installation du serveurIGCNS9, 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 verifiedRédigé par MuADMINS
  3. Outils

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

    Réécriture de la source par MuADMINSNot verifiedRaGEZONE · 2017-11-18
  4. OutilsIGCNS9

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

    ✓ Confirmé par l'auteur du sujetRaGEZONE · 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...

    ✓ Confirmé par l'auteur du sujetTuServerMU · 2018-10-15
  6. Installation du serveurIGCNS9, 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 verifiedRédigé par MuADMINS
  7. Installation du serveur

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

    ✓ Confirmé par l'auteur du sujetDarksTeam · 2009-03-03
  8. Installation du serveurS3E2

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

    ✓ Confirmé par l'auteur du sujetDarksTeam · 2009-08-09
  9. Installation du serveur

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

    ✓ Confirmé par l'auteur du sujetDarksTeam · 2010-05-03
  10. Installation du serveur

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

    ✓ Confirmé par l'auteur du sujetDarksTeam · 2012-05-11
  11. Installation du serveurIGCNS9

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

    ✓ Confirmé par l'auteur du sujetRaGEZONE · 2019-07-14
  12. Installation du serveurany

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

    ✓ Confirmé par l'auteur du sujetTuServerMU · 2020-05-23
  13. Site webany

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

    ✓ Confirmé par l'auteur du sujetTuServerMU · 2017-12-27
  14. Site webany

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

    ✓ Confirmé par l'auteur du sujetRaGEZONE · 2024-02-16
  15. Installation du serveurMuEmu / 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...

    ✓ Confirmé par l'auteur du sujetCreandoMU · 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...

    ✓ Confirmé par l'auteur du sujetCreandoMU · 2020-09-28
  17. OutilsMuEmu / 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...

    ✓ Confirmé par l'auteur du sujetTUServerMU · 2020-07-10
  18. Installation du serveurSeason 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...

    ✓ Confirmé par l'auteur du sujetTUServerMU · 2021-05-09
  19. Installation du serveurX-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...

    ✓ Confirmé par l'auteur du sujetTUServerMU · 2020-08-15
  20. Installation du serveurIGCNS12

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

    ✓ Confirmé par l'auteur du sujetRaGEZONE · 2020-01-08

MuADMINS Community Alpha : gratuit, fait par la communauté, en développement actif.