Community AlphaAlpha MUADMINS
DEDeutsch
Anmelden
Auf MuADMINSConfig ScannerZip deiner Dateien hochladen: Rates, Drops, Spots, LimitsÖffnenAuf MuADMINSTriff uns auf DiscordFrag nach Hilfe, zeig, woran du arbeitest, und sprich mit anderen Serverbetreibern über MU.Öffnen

MuADMINS

Lösungen

Kurze Fixes für häufige Probleme mit Server, Client und Website bei MU Online, jeweils mit Quelle und Datum. “Bestätigt” heißt: Die Person, die gefragt hat, hat gesagt, dass der Fix funktioniert hat.

128 Lösungen für “SQL Server” für MuDevs und alle Files · Zurücksetzen

  1. Server-Setup0.97d

    0.97d: every item (even shop items) gets serial 00000000.

    1. The trigger that creates item serials was deleted when the server was reset. 2. Recreate the serial trigger (run its script with the server off) and check the item serial counter is no...

    ✓ Vom Threadersteller bestätigtImperyus Games Brasil · 2013-05-26
  2. 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...

    ✓ Vom Threadersteller bestätigtDarksTeam · 2010-03-09
  3. 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 verifiedVon MuADMINS geschrieben
  4. 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)...

    Neufassung der Quelle durch MuADMINSNot verifiedRaGEZONE · 2016-11-19
  5. 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,...

    ✓ Vom Threadersteller bestätigtDarksTeam · 2008-06-30
  6. 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...

    ✓ Vom Threadersteller bestätigtDarksTeam · 2009-10-31
  7. 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...

    ✓ Vom Threadersteller bestätigtDarksTeam · 2011-04-14
  8. 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...

    ✓ Vom Threadersteller bestätigtDarksTeam · 2019-07-25
  9. 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...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2017-08-03
  10. 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...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2019-03-05
  11. 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....

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2017-11-03
  12. 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...

    ✓ Vom Threadersteller bestätigtTUServerMU · 2021-06-08
  13. 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...

    ✓ Vom Threadersteller bestätigtTUServerMU · 2021-03-24
  14. 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...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2008-04-17
  15. 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...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2011-12-06
  16. 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...

    ✓ Vom Threadersteller bestätigtImperyus Games Brasil · 2014-08-14
  17. 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...

    ✓ Vom Threadersteller bestätigtCreandoMU · 2021-03-19
  18. 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).

    ✓ Im Issue bestätigtGitHub (lautaroangelico/WebEngine) · 2017-08-06
  19. 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.

    ✓ Vom Threadersteller bestätigtCreandoMU · 2020-08-08
  20. 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...

    ✓ Vom Threadersteller bestätigtTUServerMU · 2020-09-24

MuADMINS Community Alpha: kostenlos, von der Community gemacht, in aktiver Entwicklung.