Community AlphaAlpha MUADMINS
PTPortuguês (Brasil)
Entrar
No MuADMINSConfig ScannerEnvie o zip dos seus arquivos: rates, drops, spots, limitesAbrirNo MuADMINSEncontre-nos no DiscordPeça ajuda, mostre o que está criando e converse sobre MU com outros donos de servidores.Abrir

MuADMINS

Soluções

Correções curtas para problemas comuns de servidor, cliente e site de MU Online, cada uma com a fonte e a data. “Confirmado” significa que quem perguntou disse que a correção funcionou.

239 soluções para “sql” · Limpar

  1. Configuração do servidorMuEmu / LouisS6

    MuEmu S6 (KoshGames/Louis) on SQL Server Express 2012: JoinServer says "Could not connect to database" although MuOnline is restored and the .reg files were run.

    1. SQL Express installs a named instance, usually SQLEXPRESS, so (local) alone does not reach it. 2. Open the ODBC admin for your Windows bits and create the DSNs by hand. 3. In the serve...

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2020-08-08
  2. Ferramentasany

    SQL Server Management Studio shows "Value cannot be null. Parameter name: viewInfo" when opening Databases on the MU server. What causes it?

    1. Check the free space on the drive where Windows, SQL Server and its temp folder live. 2. In this case the disk was full. 3. Free space: clear temp folders, old server logs and old back...

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2019-06-19
  3. Configuração do servidorOutros server filesS2

    Season 2 files on SQL Server 2000: after creating the MuOnline database with the query, DataServer shows a database error. What was wrong?

    1. Run the database creation query in Query Analyzer logged in as sa, without selecting another database first. 2. Check the ODBC admin: the files' ODBC.reg had created the entries under...

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2017-03-23
  4. Configuração do servidorWebZen 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...

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2018-08-05
  5. Configuração do servidorany

    SQL Server 2012 installed without errors but SQL Server Agent will not start (Browser starts fine) when preparing MU files. What fixed it?

    1. In services.msc set SQL Server Agent to Automatic and try to start it. 2. If it still fails, the instance was installed with the wrong authentication choice. 3. Reinstall SQL Server an...

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2018-11-19
  6. Configuração do servidorWebZen 97d / 99b97d

    SQL 2000 will not install on Windows 7, so how do I run DarksTeam 97d files on SQL Server 2008 R2 instead?

    1. Install SQL Server 2008 R2 and set a password for sa during setup (do not skip it). 2. Restore the MuOnline database from the files. 3. Open the ODBC admin (32-bit one on 64-bit Window...

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2018-08-06
  7. Configuração do servidorMuEmu / LouisS6

    MuEmu S6 DataServer and JoinServer show "Could not connect to database" on SQL 2008 R2 even after renaming MuOnlineS6 to MuOnline. What fixed it?

    1. In the DataServer and JoinServer config files make sure the database name is the one you restored (MuOnline, not MuOnlineS6). 2. Delete the old or duplicate MuOnline DSNs and create th...

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2018-06-06
  8. Configuração do servidorMuEmu / LouisS4

    Louis S4 (TSM FirePremium) local server worked for one day, then shows SQL connection errors.

    1. Create the ODBC data sources by hand in the ODBC administrator (instead of the .reg file). 2. Point them to the right SQL server and database and restart the servers.

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2018-06-11
  9. Configuração do servidorMuEmu / LouisS6

    Louis S6E3 server suddenly stops saving player data and seems to restart; SQL reports 'The transaction log for database MuOnline is full'.

    1. The disk had no free space for the SQL transaction log. 2. Free or add disk space on the VPS (the topic starter added more GB). 3. Restart SQL Server and the MU servers.

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2018-11-25
  10. Siteany

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

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2019-07-27
  11. FerramentasIGCNS9, S12

    IGC.EssentialTools opens and closes by itself after about 3 seconds, even with the SQL user, password and server filled in.

    1. In the EssentialTools config set IP = (local) when SQL Server is on the same PC (it does not accept DNS names). 2. Port = 1433. 3. SQLInstance empty when there is a single SQL instance...

    ✓ Confirmado pelo autor do tópicoRaGEZONE · 2020-05-17
  12. Configuração do servidorMSPro

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

    ✓ Confirmado pelo autor do tópicoTUServerMU · 2026-09-27
  13. Configuração do servidor

    What breaks a MU server database? Safe SQL checklist before you run a query

    What breaks MU databases most often, and what the pack files themselves show: 1. UPDATE while the server runs: the server writes online characters back from memory (IGCN maintenance scrip...

    Not verifiedEscrito pelo MuADMINS
  14. Configuração do servidor

    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 verifiedEscrito pelo MuADMINS
  15. Configuração do servidorS2, S6, S16, S17, S18, S20

    How do I reset a character with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files (ResetCount) with the server closed?

    Columns: Character.ResetCount and MasterResetCount (X-Team also ResetDay, ResetWek, ResetMon and MasterResetDay / Wek / Mon for the daily, weekly and monthly limits). The server reads and...

    Not verifiedEscrito pelo MuADMINS
  16. Configuração do servidorS6, S16, S17, S18, S20

    How do I add WCoinC, WCoinP or Goblin Points with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files (CashShopData)?

    The table is CashShopData (AccountID, WCoinC, WCoinP, GoblinPoint). 1. Account offline (best: server closed), backup first, look at the row: SELECT AccountID, WCoinC, WCoinP, GoblinPoint...

    Not verifiedEscrito pelo MuADMINS
  17. Configuração do servidorS2, 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 verifiedEscrito pelo MuADMINS
  18. Configuração do servidorIGCNS9, 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 verifiedEscrito pelo MuADMINS
  19. Configuração do servidorIGCNS9, 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 verifiedEscrito pelo MuADMINS
  20. Configuração do servidorIGCNS16, 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 verifiedEscrito pelo MuADMINS

MuADMINS Community Alpha: grátis, feito pela comunidade e em desenvolvimento ativo.