MuADMINS
Giải pháp
Các cách sửa ngắn gọn cho những lỗi thường gặp của server, client và website MU Online, mỗi cách đều kèm nguồn và ngày. “Đã xác nhận” nghĩa là người đặt câu hỏi cho biết cách sửa đã hiệu quả.
239 giải pháp cho “sql” · Xóa lọc
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...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2020-08-08SQL 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...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2019-06-19Season 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...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2017-03-23DarksTeam 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...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2018-08-05SQL 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...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2018-11-19SQL 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...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2018-08-06MuEmu 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...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2018-06-06Louis 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.
✓ Được người mở chủ đề xác nhậnTuServerMU · 2018-06-11Louis 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.
✓ Được người mở chủ đề xác nhậnTuServerMU · 2018-11-25MuCore 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...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2019-07-27IGC.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...
✓ Được người mở chủ đề xác nhậnRaGEZONE · 2020-05-17Restoring 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...
✓ Được người mở chủ đề xác nhậnTUServerMU · 2026-09-27What 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 verifiedDo MuADMINS biên soạnI 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 verifiedDo MuADMINS biên soạnHow 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 verifiedDo MuADMINS biên soạnHow 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 verifiedDo MuADMINS biên soạnHow 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 verifiedDo MuADMINS biên soạnHow 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 verifiedDo MuADMINS biên soạnHow 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 verifiedDo MuADMINS biên soạnWhy 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 verifiedDo MuADMINS biên soạn