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 server” · Xóa lọc
DarksTeam 97d+99i moved to a VPS (Windows Server 2012 R2, SQL 2008 R2): RankingServer shows an error although the config did not change
The VPS firewall was blocking the RankingServer connections. 1. In Windows Firewall (and the VPS provider firewall, if any) allow the RankingServer program, or open the port it uses, for...
✓ Được người mở chủ đề xác nhậnTUServerMU · 2020-07-08Aminyuz 97d files: GameServer gives a conexion.ini connection error at start although all IPs are right (EventServer and Ranking open fine)
The SQL login in the Aminyuz connection file was wrong. 1. Open C:\MuServer\Aminyuz\Conexion (the connection ini of these files). 2. In the [SQL] block set Usuario = sa (your SQL user), C...
✓ Được người mở chủ đề xác nhậnTUServerMU · 2020-02-21Anyone can log in with a random account name and password, and the login creates that account in SQL
1. This is not a database bug: the server has automatic account registration switched on, so an unknown login is created on the spot. 2. Open the JoinServer config (in some files the opti...
✓ Được người mở chủ đề xác nhậnRaGEZONE · 2021-04-15"Login failed for user 'sa'" (SQLSTATE 28000) from DataServer or the web right after installing SQL Server. How do I enable sa?
1. If setup used Windows authentication only, sa is disabled. 2. In Management Studio right click the server > Properties > Security and pick SQL Server and Windows Authentication mode. 3...
MuCore on a web host cannot connect to the MuOnline database on a Google Cloud VPS (Connection with MuOnline Database Failed), although 1433 is open in Windows.
1. Enable TCP/IP and Named Pipes for the instance in SQL Server Configuration Manager and restart SQL. 2. Open TCP 1433 in the Windows firewall of the VPS. 3. Also open TCP 1433 in the cl...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2019-03-17DarksTeam 97d: accounts created on the web show NULL columns in the database and characters do not show up properly. How to fix it?
1. Back up the MuOnline database first. 2. Open a new query on MuOnline in SQL Server Management Studio. 3. Run: UPDATE Character SET CtlCode = 0 WHERE CtlCode IS NULL 4. Restart the serv...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2018-10-15IGCN Season 9 repack: GameServerCS shows an error when Castle Siege is configured, even with correct settings.
1. The SQL Server language caused it. 2. Install SQL Server in English (English instance) and restore the databases there. 3. Start GameServerCS again.
✓ Được người mở chủ đề xác nhậnTuServerMU · 2017-06-18IGC DataServer stays on its loading window and never finishes starting.
1. Check the ODBC/SQL settings of the DataServer. 2. The SQL instance name was wrong. When SQL Server is on the same PC use (local) as the instance/host. 3. Start the DataServer again.
✓ Được người mở chủ đề xác nhậnTuServerMU · 2017-04-21JoinServer 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...
✓ Được người mở chủ đề xác nhậnTUServerMU · 2018-10-06MuMaker 1.12 / 1.13: warehouse and inventory items do not load on a Season 4.5 database (other MuMaker builds fail too)
1. The cause is the database layout of these files, not the MuMaker install: reinstalling, MSSQL 2005 vs 2014, an Items column set to varbinary(1920) and five other MuMaker builds gave th...
✓ Được người mở chủ đề xác nhậnRaGEZONE · 2021-04-11CzF Editor: after restoring the databases the editor login fails with 'ID not authenticated or banned' (1.02n + S2)
1. The editor login you created on the first run was lost when the databases were restored. 2. Close the editor and open its folder. 3. Delete (or edit) CzFMuEditor.ini. Its [ODBCConnecti...
✓ Được người mở chủ đề xác nhậnImperyus Games Brasil · 2011-06-03MVCore cannot add credits or gold to accounts: the credits table configured in the web does not match the database
The credits table name in the MVCore settings had a 'Me_' prefix that the table in the database does not have. 1. Open the MVCore credits configuration where the credits table name is set...
✓ Được người mở chủ đề xác nhậnTUServerMU · 2018-09-29I run one server on my VPS and want a second one with its own database on the same VPS, but it does not connect. What must change?
1. Give the second server its own database and create a new ODBC data source pointing to it (same driver, Server = (local), Database = new name). 2. Point the second JoinServer and DataSe...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2019-10-09After moving from TitansTech to MuEmu, characters roll back on relog: items and position are not saved. The database was converted. What fixed it?
1. Character data is saved by the DataServer, so check that first, not the tables. 2. Do not reuse the DataServer from your old TitansTech files: it did not work with MuEmu. 3. Use the Da...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2017-11-02IGCN: players have negative WCoin or Goblin Points (shipped maintenance script)
IGCN ships 2. Update Scripts\Maintenance Scripts\Check & Fix negative Coins.sql. It works in two runs and says "Take server offline before proceeding with the script": 1. With @Update = 0...
Not verifiedDo MuADMINS biên soạnHow do I set up WebEngine credits (WCoin, Goblin Points, web credits) for my server files?
WebEngine keeps each currency in a row of WEBENGINE_CREDITS_CONFIG: config_database, config_table, config_credits_col, config_user_col, config_user_col_id (userid, username or email), con...
Not verifiedDo MuADMINS biên soạnWebEngine register error "String or binary data would be truncated" (sno__numb is shorter than 13 characters)
WebEngine 1.2.7 fills MEMB_INFO.sno__numb with _defaultAccountSerial = '1111111111111' (13 characters, includes/classes/class.account.php line 16). The column size depends on the files: -...
Not verifiedDo MuADMINS biên soạnWebEngine: accounts made on the website cannot log in (password encryption must match memb__pwd)
WebEngine 1.2.7 has four password modes (install/definitions.php PDO_PWD_ENCRYPT) and writes MEMB_INFO differently for each: - none: memb__pwd = :password (plain), for varchar columns (IG...
Not verifiedDo MuADMINS biên soạnODBC / DSN: the DataServer or JoinServer cannot connect to MuOnline (DSN name, 32 bit or 64 bit)
MuEmu, Louis, MSPro, X-Team and MuDevs files connect through an ODBC System DSN: - JoinServer.ini JoinServerODBC = MuOnline, DataServer.ini DataServerODBC = MuOnline (MSPro: ODBC = MuOnli...
Not verifiedDo MuADMINS biên soạnA character exists in the Character table but does not appear (AccountCharacter slots)
The character list of an account is kept in AccountCharacter (Id = account, GameID1 to GameID5, or to GameID10 on newer files, plus GameIDC). The packs' WZ_CreateCharacter writes the new...
Not verifiedDo MuADMINS biên soạn