MuADMINS
Решения
Короткие исправления частых проблем серверов, клиентов и сайтов MU Online, каждое с источником и датой. “Подтверждено” означает, что автор вопроса сообщил, что исправление сработало.
Решений: 169 по запросу “SQL Server” для MuEmu / Louis и любых файлов · Сбросить
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...
✓ Подтверждено автором темыTuServerMU · 2017-07-21WebEngine 1.0.9 with a remote SQL Server IP fails with 'Could not connect to database (1)', while MuCore connects to the same server without problems.
1. In the WebEngine installer select the ODBC driver instead of dblib/sqlsrv. 2. Make sure the matching PHP ODBC extension is enabled and port 1433 is reachable. 3. Finish the install.
✓ Подтверждено автором темыRaGEZONE · 2017-09-09WebEngine CMS installer: "Could not connect to database (1)" at the database step with MSSQL Server 2008 (PDO ODBC, XAMPP)
1. In this case the game files connected fine but the WebEngine installer kept failing on the database step, with no error in the SQL logs or the Windows event log. 2. The cause was a con...
✓ Подтверждено автором темыRaGEZONE · 2023-10-06MuCore install: "Connection with MuOnline Database Failed" and "Extension php_mssql.dll must be enabled"
1. MuCore needs a PHP that still has the old php_mssql.dll extension: in php.ini find extension=php_mssql.dll and remove the ; in front of it. 2. If your web server package has no php_mss...
✓ Подтверждено автором темыRaGEZONE · 2011-03-05MuCore 1.08 installer: with the MSSQL connection it cannot get past step 3 (MSSQL 2008 R2, XAMPP 1.7.1)
1. Use XAMPP 1.7.7 for MuCore 1.08 (XAMPP 1.7.1 with MSSQL 2008 works badly). 2. Install the client DLL that supports your MSSQL version (linked in the reply). 3. Open C:/xampp/php/php.in...
✓ Подтверждено автором темыRaGEZONE · 2016-05-26MFS Database Tool: the backup gives the same error as other backup managers, even with (local), Windows authentication or 127.0.0.1
1. Connect to your SQL Server as usual (the tool supports SQL Server 2000 and 2008 style connections). 2. Do not pick the database with the drop down button: type the database name (for e...
✓ Подтверждено автором темыRaGEZONE · 2014-02-11Titan Editor: cannot connect to the MU database to create accounts (single MuOnline database)
1. Open the Titan Editor config. With only one database (MuOnline) both ODBC names point to it: [Connection] ODBC=MuOnline, ODBC_Me=MuOnline, User=sa, Password=yourpass, SQLServer=(local)...
✓ Подтверждено автором темыRaGEZONE · 2013-09-25How 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 =...
✓ Подтверждено автором темыCreandoMU · 2020-08-15How do I make a working online time ranking per character?
1. Add an int column OnlineTime to the Character table (back up first). 2. Create a SQL Agent job every minute: UPDATE Character SET OnlineTime=OnlineTime+1 joined to MEMB_STAT (ConnectSt...
✓ Подтверждено автором темыCreandoMU · 2021-03-09Accounts do not work after putting a 1.0L database under 1.0M files
The two versions use different password storage. 1. 1.0M files use MD5 on; 1.0L files use MD5 off. 2. Use the database (and website install option) that matches your files: MD5 on for 1.0...
✓ Подтверждено автором темыDarksTeam · 2008-11-25MuWeb 0.9 installer check shows Mssql: NO even after editing php.ini
1. Install XAMPP 1.7.0 (it includes the mssql extension the site needs). 2. Put MuWeb 0.9 in its htdocs and open the installer again; Mssql now shows YES.
✓ Подтверждено автором темыDarksTeam · 2009-02-12Error #123 Loading php_mssql.dll Failed when installing DarksWeb, although the dll is in the ext folder
1. Install AppServ 2.5.9 instead of the XAMPP / VertrigoServ builds that failed. 2. Edit C:\Windows\php.ini (the php.ini AppServ really uses) and enable extension=php_mssql.dll there. 3....
✓ Подтверждено автором темыDarksTeam · 2009-10-28MuEmu (Emerson repack update 25): new characters get welcome items; where is that removed? It is not a SQL script
1. The start items are given by the server file MuServer\Data\Custom\CustomStartItem.txt, not by a database script. 2. Remove or comment the item lines there (or switch the system off in...
✓ Подтверждено автором темыTUServerMU · 2021-06-03MuEmu S6 E3 Castle Siege: when the battle starts the defending guild shows as attacker, with no config change
The Castle Siege data stored in SQL had gone bad. 1. Back up the database first. 2. The asker cleared the SQL tables used by Castle Siege (in MuEmu databases they are the MuCastle_ tables...
✓ Подтверждено автором темыTUServerMU · 2020-11-15How to get the list of e-mail addresses of all registered accounts from the MU database
1. Open SQL Server Management Studio and connect to the server that holds your MU database. 2. Run: USE MuOnline; SELECT mail_addr FROM MEMB_INFO; 3. The result is the e-mail of every acc...
✓ Подтверждено автором темыTUServerMU · 2021-03-17How to back up only the accounts and characters (inventory, warehouse, stats) instead of the whole MU database
1. First make a full backup of the current database as it is (SQL Server Management Studio > Tasks > Back Up). 2. To move players to a clean database, copy over only the tables that hold...
✓ Подтверждено автором темыTUServerMU · 2020-07-23How do I show the guild logo (G_Mark) of a guild, for example the Castle Siege owner, on a PHP website with MSSQL?
1. G_Mark in the Guild table is binary: turn it into text with bin2hex(). You get 64 hex digits, one per cell of an 8x8 grid. 2. Map each digit to a color: 0 transparent, 1 #000000, 2 #8c...
✓ Подтверждено автором темыRaGEZONE · 2020-07-01JoinServer and DataServer show Could not connect to database on start.
1. Restore the MuOnline database correctly in SQL Server (from the backup shipped with your files). 2. Create the ODBC data source the servers expect, pointing to that database. 3. Make s...
✓ Подтверждено автором темыTuServerMU · 2017-07-05After switching to new server files with a new database, the MuCore site no longer detects the database and players cannot register.
1. The new database does not contain the MuCore tables. 2. Run the MuCore installer again against the new database so it creates its tables. 3. Check config.SQL.php points to the new DB.
✓ Подтверждено автором темыTuServerMU · 2018-11-19DMN MuCMS 1.1.8 installer fails at the database selection step (both on a host and on XAMPP).
1. Use a separate database for the web (for example dmncms). 2. The MU game database must be named MuOnline (plus Me_MuOnline if your files use it); the install failed with a custom name....
✓ Подтверждено автором темыTuServerMU · 2018-04-27