SourceBans icon indicating copy to clipboard operation
SourceBans copied to clipboard

Can't unban with sm_unban as console.

Open WildCard65 opened this issue 11 years ago • 2 comments

Title explains all.

WildCard65 avatar Mar 01 '14 22:03 WildCard65

What errors or messages (debug info from sourcebans) in server (not game) console you see at this moment?

ppalex7 avatar Mar 02 '14 07:03 ppalex7

I'll test ban myself then try to unban myself with console. Edit: Here it is: sm_unban STEAM_0:1:61441373 L 03/02/2014 - 10:24:37: [sb_bans.smx] "Console<0><Console><Console>" removed ban (filter "STEAM_0:1:61441373") L 03/02/2014 - 10:24:37: [sb_bans.smx] Failed to unban the ban from the database: Cannot add or update a child row: a foreign key constraint fails (Flexcraft_SourceBans.sb_bans, CONSTRAINT ban_unban_admin FOREIGN KEY (unban_admin_id) REFERENCES sb_admins (id) ON DELETE SET NULL) [SourceBans] Failed to unban STEAM_0:1:61441373.

Edit 2: The version I'm using is updated from github(latest) Edit 3: I had someone else with root access and it worked for em: [SM] Added info_observer_point: 549 L 03/02/2014 - 10:26:36: [sb_bans.smx] "Flex (LUModder)<4><STEAM_0:0:58178275><>" removed ban (filter "STEAM_0:1:61441373") L 03/02/2014 - 10:27:33: "Flex (LUModder)<4><STEAM_0:0:58178275><Blue>" disconnected (reason "Disconnect by user.") Dropped Flex (LUModder) from server (Disconnect by user.) L 03/02/2014 - 10:28:24: "WildCard65 the Joker Card<5><STEAM_0:1:61441373><>" connected, address "99.250.46.87:27006" Client "WildCard65 the Joker Card" connected (99.250.46.87:27006). L 03/02/2014 - 10:28:24: "WildCard65 the Joker Card<5><STEAM_0:1:61441373><>" STEAM USERID validated [SourceBans] Sending admin query: SELECT ad.id, ad.name, ad.auth, ad.identity, ad.server_password, COUNT(ag.group_id) FROM {{admins}} AS ad LEFT JOIN {{admins_server_groups}} AS ag ON ag.admin_id = ad.id LEFT JOIN {{servers_server_groups}} AS gs ON gs.group_id = ag.group_id WHERE ((ad.auth = 'steam' AND ad.identity REGEXP '^STEAM_[0-9]:1:61441373$') OR (ad.auth = 'ip' AND '99.250.46.87' REGEXP REPLACE(REPLACE(ad.identity, '.', '.') , '.0', '..{1,3}')) OR (ad.auth = 'name' AND ad.identity = 'WildCard65 the Joker Card')) AND gs.server_id = 1 AND ad.login_time IS NOT NULL GROUP BY ad.id L 03/02/2014 - 10:28:33: "WildCard65 the Joker Card<5><STEAM_0:1:61441373><>" entered the game [SourceBans] Found SQL admin (1,steam,STEAM_0:1:61441373,,WildCard65):434:1 [SourceBans] Binding client (2, 7) resulted in: (1, 434, 1) [SourceBans] Binding admin group (2, 7, 434, Server-Host, 92) L 03/02/2014 - 10:28:33: [sourcecomms.smx] VerifyPlayer for AccountID: 122882747. QUERY: SELECT IF(c.length, c.create_time + c.length * 60 - UNIX_TIMESTAMP(), 0) as remaining , c.length, c.create_time, c.type, c.reason, IFNULL(c.server_id,0) , IFNULL(a.id, 0), IFNULL(a.name, 'CONSOLE'), MAX(IFNULL(IF(c.server_id, sgs.immunity, sgw.immunity), 0)) AS immunity FROM {{comms}} AS c LEFT JOIN {{admins}} AS a ON a.id = c.admin_id LEFT JOIN {{admins_server_groups}} AS asg ON asg.admin_id = c.admin_id LEFT JOIN {{server_groups}} AS sgw ON sgw.id = asg.group_id LEFT JOIN {{servers_server_groups}} AS ssg ON ssg.server_id = c.server_id LEFT JOIN {{server_groups}} AS sgs ON sgs.id = asg.group_id AND sgs.id = ssg.group_id WHERE c.steam_account_id = 122882747 AND c.unban_time IS NULL AND (c.length = '0' OR c.create_time + c.length * 60 > UNIX_TIMESTAMP()) GROUP BY c.id Query_VerifyBlock(userid: 5, client: 2)

WildCard65 avatar Mar 02 '14 15:03 WildCard65