Community AlphaAlpha MUADMINS
ENEnglish
Sign in
On MuADMINSConfig ScannerDrop your files zip: rates, drops, spots, limitsOpenOn MuADMINSMeet us on DiscordAsk for help, share what you are building and talk MU with other server owners.Open

MuADMINS

Solutions

Short fixes for common MU Online server, client and website problems, each with its source and date. “Confirmed” means the person who asked said the fix worked.

127 solutions for “SQL Server” for DV-Team and any files · Clear

  1. Server setupS3E1

    DarkMaster Season 3 Episode 1: every login says the account is invalid, although all IPs are changed

    The JoinServer password mode (MD5 or plain) did not match how the accounts were created. 1. Delete the test accounts. 2. Put the JoinServer build with MD5 enabled and create the account a...

    ✓ Confirmed by the topic starterDarksTeam · 2010-03-09
  2. Server setup

    How do I fix a vault (warehouse): forgotten vault password, or a broken vault that must be emptied safely?

    Every MSSQL family we read has warehouse (AccountID, Items varbinary, Money, EndUseDate, pw ...); the Items size differs (IGCN S17 7680 bytes, MuDevs 6000, X-Team S17 4800, WebZen S2 1920...

    Not verifiedWritten by MuADMINS
  3. ToolsEX803

    IzsMuEditor 2.1.2 (EX803): the editor does not connect to the database

    1. By default IzsMuEditor connects through an ODBC DSN. 2. If it does not connect, open Data\IzsConfig.ini, set Use_ODBC to 0 and fill in your SQL connection data (server, user, password)...

    MuADMINS rewrite of the sourceNot verifiedRaGEZONE · 2016-11-19
  4. Server setup

    How to protect the server from attackers with the firewall

    Only the ConnectServer and GameServer must be reachable from outside. 1. In the firewall block outside access for: MySQL (mysqld.exe), the DataServer(s), ExDB, EventServer, RankingServer,...

    ✓ Confirmed by the topic starterDarksTeam · 2008-06-30
  5. Website97d+99i

    Characters stop at level 350 (max level) but the website reset asks for level 400 (97d+99i)

    On 97d+99i the max level cannot be raised, so lower the reset level on the website instead. 1. Open SQL Server Enterprise Manager > MuOnline > Tables. 2. Find the MuWeb table, right click...

    ✓ Confirmed by the topic starterDarksTeam · 2009-10-31
  6. Website

    DarksWeb 0.1: the news cannot be deleted from the site admin

    The news and admin data of DarksWeb are stored in the database, not in the PHP files. 1. Open SQL Server and go to Databases > MuOnline > table MuWeb_admin. 2. Edit or delete the news row...

    ✓ Confirmed by the topic starterDarksTeam · 2011-04-14
  7. Website97d

    MuCore website Exchange System always shows 0 Online Hours although the character was online for hours (DarkMaster 97d server)

    The MuCore module reads the column OnlineMinutes, which did not exist in the database. 1. Take the online-time SQL script from the thread (it adds a column to MEMB_STAT and changes the st...

    ✓ Confirmed by the topic starterDarksTeam · 2019-07-25
  8. Website

    MuCore 1.0.6 admin panel: 'Edit module' and 'Edit pages' are broken

    1. The helper's advice was to use MuCore 1.0.8 (and XAMPP 1.7.1 for SQL 2000/2005, or XAMPP 1.7.7 with MSSQL enabled for SQL 2008 or newer). 2. Replacing the whole folder caused other pro...

    ✓ Confirmed by the topic starterRaGEZONE · 2017-08-03
  9. Website

    MuCore 2.2.0: the add and edit buttons for modules do not show in the admin panel

    1. MuCore 2.2.0 does not work properly on PHP 7.x. 2. Run it on PHP 5.6: the topic starter installed XAMPP with PHP 5.6.40 plus the PDO fix for SQL Server. 3. On a web host, switch the PH...

    ✓ Confirmed by the topic starterRaGEZONE · 2019-03-05
  10. Website

    MuCore 1.08 rankings show only one character (or none) while players are online

    1. MuCore only ranks characters whose CtlCode is 0 in the Character table; characters with another value are left out. 2. In SQL Server set CtlCode to 0 for the normal player characters....

    ✓ Confirmed by the topic starterRaGEZONE · 2017-11-03
  11. Server setupSeason 8

    DataServer and JoinServer do not connect after running the ODBC file that came with the files

    The .reg or .bat ODBC file bundled with many server files does not always create the data source on your Windows. Create it by hand: 1. Open the ODBC Data Source Administrator (on 64-bit...

    ✓ Confirmed by the topic starterTUServerMU · 2021-06-08
  12. Server setup

    Characters do not save and the DataServer log shows State (42S22)

    SQL state 42S22 means a column was not found: the server files query a column your database does not have, so the save fails. 1. Open the DataServer log and read which table and column th...

    ✓ Confirmed by the topic starterTUServerMU · 2021-03-24
  13. Tools

    MuWeb 0.8: accounts registered on the website say "Incorrect password" in game (the account count goes up)

    1. The website saves the password in a different format than the server expects: the MD5 option chosen in the MuWeb 0.8 install does not match your files. 2. Run the MuWeb 0.8 install aga...

    ✓ Confirmed by the topic starterRaGEZONE · 2008-04-17
  14. Tools

    MuMaker: creating an account fails with "Disallowed implicit conversion from data type varchar to data type varbinary ... column 'memb_pwd'"

    1. The error means MEMB_INFO.memb_pwd is a varbinary column: your database stores MD5 passwords. 2. Enable MD5 in the MuMaker settings and create the account again. 3. A reply also sugges...

    ✓ Confirmed by the topic starterRaGEZONE · 2011-12-06
  15. Tools

    MuMaker: an error says tables are missing and asks where to create them (incomplete MuMaker.mdb)

    1. The tables are not missing in your MU database: the mumaker.mdb of that MuMaker copy is incomplete. 2. Reinstall MuMaker, or use MuMaker 1.11 or 1.10 as suggested in the thread. 3. Ope...

    ✓ Confirmed by the topic starterImperyus Games Brasil · 2014-08-14
  16. Tools

    MuMaker: an error box appears every time after adding new sets to MuMaker.mdb, although the items still get added after Continue

    1. The error comes from a wrong row you added to MuMaker.mdb, for example an item id or an option value that does not exist (Louis gives 56 as the example). 2. Open MuMaker.mdb and check...

    ✓ Confirmed by the topic starterCreandoMU · 2021-03-19
  17. WebsiteIGCN Season 9 and later

    WebEngine 1.0.9.x: the VIP system throws an error with IGCN files.

    1. The IGCN VIP class only loaded the MuOnline database even when Me_MuOnline is used. 2. It was fixed in patch 1.0.9.7. 3. Update WebEngine (current releases include the fix).

    ✓ Confirmed in the issueGitHub (lautaroangelico/WebEngine) · 2017-08-06
  18. WebsiteSeason 4 (Louis Premium) with Morpheus web

    Morpheus web install stops with error 47.

    1. Back up the database first. 2. Delete the columns Credits, indocation and indicated from MEMB_INFO. 3. Run the Morpheus installer again.

    ✓ Confirmed by the topic starterCreandoMU · 2020-08-08
  19. Websiteany

    MuCore Premium 2.2.0: after adding a VIP module, the lower half of the template turns white on that page

    The module carries its own style code, written for MuCore 1.8, which overrides the template CSS. 1. Open the module file and look at the start: it has a style block (CSS) of its own. 2. R...

    ✓ Confirmed by the topic starterTUServerMU · 2020-09-24
  20. WebsiteS4

    MuCore 1.0.6 with RMST 7.01.10c (Season 4.5-4.6): registration says 'server error'

    1. The site and the server did not use the same password method (MD5 on one side, plain on the other). 2. The topic starter restored the database version without MD5 and replaced the Join...

    ✓ Confirmed by the topic starterRaGEZONE · 2011-06-01

MuADMINS Community Alpha: free and community made, in active development.