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é.
150 solutions pour “SQL Server” pour IGCN et tous les files · Effacer
Installing WebEngine CMS 1.2.5 with the ODBC driver fails with '[ODBC SQL Server Driver] The data types varchar(max) and text are incompatible in the equal to operator'.
1. Do not use the old ODBC SQL Server driver for the install. 2. Install the Microsoft PHP SQLSRV / PDO_SQLSRV drivers that match your PHP version and enable them in php.ini. 3. Restart A...
✓ Confirmé dans l'issueGitHub (lautaroangelico/WebEngine) · 2025-02-20Which website CMS expects which MU database columns (WebEngine table maps, DmN)
WebEngine 1.2.7 picks a table map by server files (includes/config): - igcn.tables.php / custom.tables.php: resets = Character.RESETS, grand resets = Character.GrandResets, VIP = T_VIPLis...
Not verifiedRédigé par MuADMINSMuMaker 1.13: how to use a new item database (.mdb) with tier sets, and socket options that do not appear
1. Replace MuMaker.mdb in the MuMaker folder with the new .mdb and open mumaker.exe. 2. The items only work in game if your server files already have those tier sets. 3. In the shared .md...
MuWeb 0.8 does not work with XAMPP on Windows 7 and SQL 2008 (php.ini edits do not help)
1. MuWeb 0.8 needs an old PHP with the MSSQL functions: the newer XAMPP builds do not run it even after php.ini changes. 2. Install XAMPP 1.6.1 (not higher), configure php.ini as the MuWe...
✓ Confirmé par l'auteur du sujetRaGEZONE · 2013-01-23MuMaker 1.12: "No connection could be made because the target machine actively refused it, error 0" or "error 40" when connecting
1. Open SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for MSSQLSERVER. 2. Set TCP/IP to Enabled. 3. In TCP/IP Properties, IP Addresses tab: set Enabled t...
✓ Confirmé par l'auteur du sujetRaGEZONE · 2017-08-08Accounts created on the website get VIP months instead of days (Morpheus web).
1. The SQL login used by the site had its language changed to Portuguese, which changes the date format. 2. Set the default language of that SQL login back to English (us_english). 3. Cre...
✓ Confirmé par l'auteur du sujetCreandoMU · 2021-04-12Every time I leave the game my account is banned (after adding an anti-dupe ban script)
The ban-dupers SQL script that was added to the database does not work with every version and bans normal accounts. 1. Remove that script (trigger / job) from the MuOnline database. 2. Un...
✓ Confirmé par l'auteur du sujetDarksTeam · 2010-01-05DarksTeam 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...
✓ Confirmé par l'auteur du sujetTUServerMU · 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...
✓ Confirmé par l'auteur du sujetTUServerMU · 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...
✓ Confirmé par l'auteur du sujetRaGEZONE · 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...
✓ Confirmé par l'auteur du sujetTuServerMU · 2019-03-17MuMaker 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...
✓ Confirmé par l'auteur du sujetRaGEZONE · 2021-04-11MVCore 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...
✓ Confirmé par l'auteur du sujetTUServerMU · 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...
✓ Confirmé par l'auteur du sujetTuServerMU · 2019-10-09How 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 verifiedRédigé par MuADMINSWebEngine 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 verifiedRédigé par MuADMINSWebEngine: 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 verifiedRédigé par MuADMINSODBC / 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 verifiedRédigé par MuADMINSA 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 verifiedRédigé par MuADMINS