Community AlphaAlpha MUADMINS
VITiếng Việt
Đăng nhập
Trên MuADMINSConfig ScannerTải lên zip file của bạn: rate, rơi đồ, spot, giới hạnMởTrên MuADMINSGặp chúng tôi trên DiscordNhờ giúp đỡ, chia sẻ những gì bạn đang làm và trò chuyện về MU với các chủ server khác.Mở

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ả.

42 giải pháp cho “invalid column name” · Xóa lọc

  1. Cài đặt serverMuEmu / LouisS6

    Louis / MuEmu Season 6: "Invalid column name" after updating the server files (which Update script adds which column)

    Louis (JogandoMU) Season 6 files ship one SQL file per update. If the files are newer than the database, the server logs Invalid column name 'X'. Find X below and run that script (and the...

    Not verifiedDo MuADMINS biên soạn
  2. WebsiteX-TeamS2, S17

    WebEngine with X-Team files: online ranking fails with Invalid column name 'OnlineHours'

    WebEngine's map for X-Team files (includes\config\xteam.tables.php) defines _CLMN_MS_ONLINEHRS_ = OnlineHours, and the online ranking (only for xteam files) runs: SELECT TOP n memb___id,...

    Not verifiedDo MuADMINS biên soạn
  3. Cài đặt serverMuDevsS18

    MuDevs Season 18: Invalid column name 'LastGateIndex' (the extra query of the pack)

    The MuDevs Season 18 pack ships, next to the database scripts, a file Execute query.sql with one statement: ALTER TABLE dbo.Character ADD LastGateIndex [int] NOT NULL DEFAULT(-1); If the...

    Not verifiedDo MuADMINS biên soạn
  4. Công cụ

    MuMaker: how to fill the first configuration window (SQL user, local or remote, MD5, database names, reset column)

    1. Extract MuMaker and start MuMaker.exe. 2. Type any name (server name or yours), the SQL user (sa by default) and its password. 3. Connection type: choose local when MuMaker runs on the...

    MuADMINS viết lại từ nguồnNot verifiedRaGEZONE · 2007-12-22
  5. Website

    Which 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 verifiedDo MuADMINS biên soạn
  6. Website97d+99i

    /reset works in game but the website still shows 0 resets (newest DarksTeam files)

    The server writes resets to the column Resets, while the website reads another column (Reset). 1. Open the website config (usually config.php) and find $res_column_name. 2. Set it to $res...

    ✓ Được người mở chủ đề xác nhậnDarksTeam · 2017-06-13
  7. Website

    Accounts registered on the website exist in MEMB_INFO, but the game says 'Your account is invalid'

    1. Compare how the website stores passwords with what the JoinServer expects: look at the password column of the new accounts in MEMB_INFO. 2. If the website saves MD5 hashed passwords, e...

    ✓ Được người mở chủ đề xác nhậnRaGEZONE · 2026-04-05
  8. WebsiteMuEmu / LouisS6

    DMN CMS with MuEmu S6E3 files: reset and grand reset modules do not work.

    1. Open the Character table in SQL and read the exact column names. 2. In the DMN config type them exactly, with the same upper and lower case (for example ResetCount, not reset or resetc...

    ✓ Được người mở chủ đề xác nhậnTuServerMU · 2018-11-22
  9. Cài đặt server

    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...

    ✓ Được người mở chủ đề xác nhậnTUServerMU · 2021-03-24
  10. WebsiteIGCNS6

    How to set up the WebEngine Credit Manager so it gives WCoinC/WCoinP or Goblin Points on IGCN S6 files; adding credits says the account ID is invalid.

    1. Database: MuOnline. Table: T_InGameShop_Point (check the exact name in your DB). 2. Credits column: the currency column you want (WCoinC, WCoinP or GoblinPoint). 3. User column: Accoun...

    ✓ Được người mở chủ đề xác nhậnRaGEZONE · 2022-07-11
  11. Website

    What does the DmN CMS setup change in the MU database (columns, Character.id, WZ_CONNECT_MEMB) and what can break?

    The DmN CMS 1.2.3 setup does more than create its own tables: 1. It ALTERs the game databases: adds columns from its version files, for example MEMB_INFO Admin, last_login, activated, act...

    Not verifiedDo MuADMINS biên soạn
  12. Cài đặt server

    Korean, Cyrillic, Greek or other character names turn into ?? (collation and Unicode in MU databases)

    In every MSSQL files family we read, names are VARCHAR: Character.Name varchar(10), AccountCharacter.GameID1 ... varchar(10), Guild.G_Name varchar(8), MEMB_INFO.memb___id varchar(10). A V...

    Not verifiedDo MuADMINS biên soạn
  13. Công cụWebZen 97d / 99b

    Cash Shop and VIP Editor (Dino): how to connect it to SQL Server and which columns it needs

    1. Enter the SQL Server IP, login, password and port, then click Connect. 2. Leave the filter empty to list all accounts, or type an account name. 3. Choose the VIP type and the amount of...

    MuADMINS viết lại từ nguồnNot verifiedImperyus Games Brasil · 2009-10-04
  14. Công cụIGCN

    IGC.ToolKit: how to add a custom item to the IGCN client (Item.bmd sub group, model file name, ItemTRSData in Lang.mpr)

    1. Edit the BMD files in \Data\Local\ of the client with IGC.ToolKit (Free or Premium). ToolKit Premium can add the item on the client first and export it to the server format, and its It...

    MuADMINS viết lại từ nguồnNot verifiedIGCN · 2022-09-16
  15. Công cụWebZen 97d / 99b1.07V+ Season 6

    Item.bmd editor shows strange values (Strength 34304 for Explosion Blade) when opening a 1.07V+ Season 6 client item.bmd

    1. The editor reads the file with the old column layout: in Season 6 clients (1.07V+ and newer) item.bmd has more columns, so values land in the wrong fields (Strength shows Agility and s...

    ✓ Được người mở chủ đề xác nhậnImperyus Games Brasil · 2010-12-27
  16. Cài đặt server

    "Account does not exist" or the login fails although the account is in MEMB_INFO: what to check in the database

    Check these in order (all read only, nothing changes): 1. Is the server reading the same database? MuEmu, Louis, MSPro, X-Team, MuDevs use the ODBC DSN in JoinServer.ini (JoinServerODBC =...

    Not verifiedDo MuADMINS biên soạn
  17. Cài đặt serverX-TeamS2, S15, S17, S18

    What is in the X-Team MuOnline database (password column, VIP, coins, resets, gens, master level)?

    X-Team uses one database, MuOnline, with the MuEmu procedure set. - Accounts: MEMB_INFO.memb__pwd varchar(10) (plain; no MD5 function in the scripts), sno__numb char(18), AccountLevel / A...

    Not verifiedDo MuADMINS biên soạn
  18. Công cụ1.04D (S6)

    ItemToolTip.bmd (MagicHand): where to add new custom items when Tipo 1 has no free lines, and "file corrupted" after saving

    1. Open your ItemToolTip.bmd with MagicHand (on a 1.04D client it is in Data\Local\Eng, or Por / Spn). 2. Find the LAST original item, normally on Tipo 2, and add your items on the lines...

    MuADMINS viết lại từ nguồnNot verifiedRaGEZONE · 2012-04-02
  19. Cài đặt serverMuEmu / LouisS6

    How do I ban and unban accounts or characters with an end date on Louis / MuEmu Season 6 files (bloc_code, CtlCode, Bloc_Expire)?

    Louis Season 6 Update 11 added the ban columns: MEMB_INFO.Bloc_Expire and Character.Bloc_Expire (smalldatetime). The procedure WZ_DesblocAccount @Account lifts a block only when it expire...

    Not verifiedDo MuADMINS biên soạn
  20. Công cụS4.5

    MuMaker 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-11
Vẫn còn vướng mắc? Hỏi Trợ lý MU Tìm trên MuGPS Tìm trên MUTube

MuADMINS Community Alpha: miễn phí, do cộng đồng xây dựng, đang được phát triển tích cực.