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
← All solutions

Could not find stored procedure 'WZ_CONNECT_MEMB' (or WZ_DISCONNECT_MEMB): what they do and how to restore them

Written by MuADMINS from the sourceNot verified

WZ_CONNECT_MEMB and WZ_DISCONNECT_MEMB keep MEMB_STAT up to date (ConnectStat 1 at login, 0 at logout). They must exist in the database the JoinServer / DataServer connects to:

  • IGCN: in MuOnline AND in Me_MuOnline: (@memb___id varchar(10), @ServerName varchar(20), @IP varchar(15))
  • MuEmu, Louis, MSPro, X-Team: in MuOnline: (@memb___id varchar(10), @ServerName varchar(50), @IP varchar(20))
  • MuDevs: 4 parameters, the 4th is @HarwareID varchar(74)
  • WebZen 97d: (@uid varchar(20), @server varchar(20), @uip varchar(20))
  1. Check the database you are really connected to (DSN "Database" or IGCDS.ini) and whether the procedure is there:
SELECT DB_NAME() AS current_db, name, modify_date FROM sys.procedures WHERE name IN ('WZ_CONNECT_MEMB', 'WZ_DISCONNECT_MEMB');
  1. Missing: take only the CREATE PROCEDURE block of that procedure from YOUR pack's MuOnline script and run it on that database. Never re-run the whole MuOnline script on a database with players: it creates tables again.
  2. Installed a website lately? DmN setup drops and replaces both procedures with versions that write to the web database (DmN_IP_Log, DmN_OnlineCheck). If that database was renamed or removed, re-create the pack's original procedures.

Note: no procedure named WZ_DesignateFriend exists in any of the scripts or backups we read; the friend system uses WZ_FriendAdd, WZ_FriendDel, WZ_WaitFriendAdd, WZ_WaitFriendDel and the tables T_FriendMain, T_FriendList, T_WaitFriend, T_FriendMail, T_CGuid.

Source: IGCN S17 MuOnline / Me_MuOnline scripts, X-Team S2 / S17 DB/MuOnline.sql, MuDevs S18 script, 97d MuOnline.bak (module text), DmN CMS 1.2.3 setup.

Written by MuADMINS
Did this help?

Still stuck? Search MuGPS Ask the MU Assistant

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