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

29 solutions pour “database editor” dans Installation du serveur · Effacer

  1. Installation du serveurDV-TeamS19

    Where are accounts, VIP, credits, resets and bans in the DV-Team Season 19 database (MySQL / MariaDB)?

    DV-Team does not use SQL Server: the database is a MySQL / MariaDB dump (Navicat), databases muonline (127 tables) and log (22 tables). There is no MEMB_INFO and no stored procedure, so S...

    Not verifiedRédigé par MuADMINS
  2. Installation du serveurMuEmu / LouisSeason 6 (Louis update 15)

    MuEditor cannot connect to SQL Server (Louis S6 update 15).

    1. Follow the Louis setup video for SQL and ODBC. 2. The missing part was opening the SQL port (1433 by default) in the firewall. 3. Open it and connect again.

    ✓ Confirmé par l'auteur du sujetCreandoMU · 2020-08-14
  3. Installation du serveurMuEmu / LouisSeason 6 (Louis update 13)

    Nothing is saved in game and editors say the database is read-only

    The database that came with a repack can be damaged or incomplete. Here the fix was to use the clean database of the package the files are based on. 1. Download the original package the r...

    ✓ Confirmé par l'auteur du sujetTUServerMU · 2024-01-28
  4. Installation du serveur97d+99i

    SQL command to give credits to every account (DarksTeam 97d+99i)

    1. Open SSMS / Query Analyzer on the MuOnline database. 2. For all accounts run UPDATE MEMB_CREDITS SET credits=credits+500. 3. For one account run UPDATE MEMB_CREDITS SET credits=credits...

    ✓ Confirmé par l'auteur du sujetDarksTeam · 2021-12-28
  5. Installation du serveurWebZen 97d / 99b97d

    DarksTeam 97d+99i on Windows 10 64-bit: servers say they cannot connect to SQL after installing SQL 2008. Editing the ODBC .reg did not help.

    1. Uninstall the SQL Server 2008 instance that was installed with Windows authentication only. 2. Reinstall it choosing Mixed Mode and give sa a password. 3. Restore the MuOnline database...

    ✓ Confirmé par l'auteur du sujetTuServerMU · 2018-08-05
  6. Installation du serveurMuEmu / LouisS6

    MuEmu S6 by Louis: DataServer and JoinServer say 'Could not connect to database' with both included databases, even with correct IPs and open ports.

    1. The included ODBC .reg created a data source named MuOnlineS6 pointing to database MuOnlineS6. 2. Edit the ODBC data source (or the .reg) so the name and database match what the server...

    ✓ Confirmé par l'auteur du sujetTuServerMU · 2017-10-10
  7. Installation du serveurMSPro

    Restoring the MuOnline database fails in SQL Server 2022 (MSPro v17 files)

    1. In SQL Server Management Studio right click Databases > Restore Database, choose Device and pick the .bak file that came with the files. 2. Open the Options page. 3. Tick "Overwrite th...

    ✓ Confirmé par l'auteur du sujetTUServerMU · 2026-09-27
  8. Installation du serveurIGCNS9, S12, S16, S17, S18

    How do I add WCoin or Goblin Points to an account with a SQL query on IGCN files?

    The table is T_InGameShop_Point, but the columns changed between seasons: - Season 9 and 12: AccountID, WCoinC, WCoinP, GoblinPoint (float) - Season 16, 17, 18: AccountID, WCoin, GoblinPo...

    Not verifiedRédigé par MuADMINS
  9. Installation du serveurany

    Remote tools or the web cannot reach a SQL Express or named instance on port 1433. How do I make SQL listen on a fixed port?

    1. Named instances use dynamic ports by default; only the default instance uses 1433. 2. SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for your instance...

    Réécriture de la source par MuADMINSNot verifiedMicrosoft Learn · 2025-08-26
  10. Installation du serveur

    "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 verifiedRédigé par MuADMINS
  11. Installation du serveurWebZen 97d / 99b97d, 99b, S2, S3

    Which databases and procedures do WebZen 97d, Season 2 and Season 3 files use?

    - 97d (RaGEZONE pack): MuOnline.bak and Ranking.bak, SQL Server 2000 backups (restore them on 2005, 2008 or 2008 R2 first: 2012 and newer cannot restore a SQL 2000 backup). WZ_CONNECT_MEM...

    Not verifiedRédigé par MuADMINS
  12. Installation du serveurMSProS2, S3, S6

    What are the MSPro database settings (ODBC, MD5Encryption, DisconnectOnlineAccount) and the update queries?

    MSPro files connect through the ODBC DSN named MuOnline: - JoinServer\JoinServer.ini: JoinServerODBC = MuOnline, CaseSensitive = 0, MD5Encryption = 0, MaxIPLimit = 0, MaxHwIDLimit = 0, Di...

    Not verifiedRédigé par MuADMINS
  13. Installation du serveurIGCNS16, S17, S18

    Why did IGCN CreateDatabase.sql delete my databases, and what must I change before running it?

    Database\1. Full Scripts\CreateDatabase.sql starts with two switches: - DECLARE @DropExistingDatabases INT = 1: with 1 it DROPS existing databases named Me_MuOnline, MuOnline, Events, Ran...

    Not verifiedRédigé par MuADMINS
  14. Installation du serveurMuEmu / LouisSeason 6

    MuEmu (Louis) files: where do I enter the SQL user and password? I cannot find it in any server config

    MuEmu servers do not keep the SQL login in their config files: JoinServer and DataServer reach the database through ODBC. 1. Run the ODBC .reg file that comes with the files, or create th...

    ✓ Confirmé par l'auteur du sujetTUServerMU · 2020-07-12
  15. Installation du serveurMuEmu / LouisS4

    MuEmu S4: the server and MuMaker do not see the databases on SQL Server 2008 R2 even with remote connections and TCP/IP enabled.

    1. Check how SQL Server was installed: it had been set up as a named instance. 2. The files and MuMaker expect the default instance, reached as (local) or the PC name. 3. Reinstall SQL Se...

    ✓ Confirmé par l'auteur du sujetTuServerMU · 2017-11-11
  16. Installation du serveurany

    During SQL Server setup the password for sa is rejected no matter what I type. Why?

    1. Setup enforces the Windows password policy on the sa password. 2. Use at least 8 characters that mix uppercase letters, lowercase letters and numbers (a symbol helps too). 3. Do not us...

    ✓ Confirmé par l'auteur du sujetTuServerMU · 2017-07-21
  17. Installation du serveur

    I changed a character, coins or a vault with SQL and the change disappeared (UPDATE while the server is on)

    The running server keeps its own copy of every online character and account and writes it back to the database, so an UPDATE made while that player is online can be overwritten a moment l...

    Not verifiedRédigé par MuADMINS
  18. Installation du serveurMuEmu / LouisSeason 8 Episode 3

    JoinServer and DataServer stopped connecting to the database (MuEmu Season 8)

    Restoring the database and the ODBC data sources again did not help: the SQL login the servers use did not have the rights it needs. 1. Open SQL Server Management Studio and go to Securit...

    ✓ Confirmé par l'auteur du sujetTUServerMU · 2018-10-06
  19. Installation du serveur

    How do I fix a vault (warehouse): forgotten vault password, or a broken vault that must be emptied safely?

    Every MSSQL family we read has warehouse (AccountID, Items varbinary, Money, EndUseDate, pw ...); the Items size differs (IGCN S17 7680 bytes, MuDevs 6000, X-Team S17 4800, WebZen S2 1920...

    Not verifiedRédigé par MuADMINS
  20. Installation du serveurMuEmu / LouisSeason 6 (MuEmu)

    How do I change the items new characters start with equipped?

    1. Create a character and equip it with MuEditor as you want. 2. Copy that character's Inventory value in SQL. 3. Run UPDATE DefaultClassType SET Inventory = <copied value> WHERE Class =...

    ✓ Confirmé par l'auteur du sujetCreandoMU · 2020-08-15

Vidéos sur MUTube

Plus de vidéos pour « database editor »

Toujours bloqué ? Demander à l'Assistant MU Rechercher sur MuGPS

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