SourceBans

Bug #162

Bans applied in game not sticking, nor appearing in the web db

Added by Cole Cole 168 days ago. Updated 150 days ago.

Status:

Closed

Start:

07/21/2008

Priority:

Urgent

Due date:

Assigned to:

% Done:

Category:

Target version:

Description

I'm not stupid so if you need anything more please ask

Basically when admins ban a user, it will ban them fine, but from what I can tell on a map change the ban isn't there any more, nor does it ever appear in teh mysql database. I checked the error files, and enabled debugging for SB and this is the result upon banning a user.

@
L 07/21/2008 - 22:25:53: [SM] Native "SetPackPosition" reported: Invalid data pack handle 0 (error 4)
L 07/21/2008 - 22:25:53: [SM] Displaying call stack trace for plugin "sourcebans.smx":
L 07/21/2008 - 22:25:53: [SM] [0] Line 1485, sourcebans.sp::HackingSelected()
L 07/21/2008 - 22:25:53: [sourcebans.smx] [SourceBans] Query failed! Column 'sid' cannot be null
L 07/21/2008 - 22:25:53: [SM] Native "KickClient" reported: Client 1 is not connected
L 07/21/2008 - 22:25:53: [SM] Displaying call stack trace for plugin "sourcebans.smx":
L 07/21/2008 - 22:25:53: [SM] [0] Line 1005, sourcebans.sp::UTIL_InsertTempBan()
L 07/21/2008 - 22:25:53: [SM] [1] Line 1045, sourcebans.sp::VerifyInsert()
@

History

#1
Updated by Erik Minekus 168 days ago

Could you type this in console:

rcon sm plugins debug sourcebans on

and when it happens again, post the function and line number that it reports.

#2
Updated by Cole Cole 168 days ago

Sorry I had already done that, but for some reason when I posted it it screwed up, (would be good if it didn't)

This time that I ran the ban it actually banned the player.

[SM] Native "SetPackPosition" reported: Invalid data pack handle 0 (error 4)
[SM] Displaying call stack trace for plugin "sourcebans.smx"
[SM] [0] Line 1485, sourcebans.sp::HackingSelected()
[SM] Native "IsFakeClient" reported: Client 1 is not connected
[SM] Displaying call stack trace for plugin "sourcebans.smx"
[SM] [0] Line 1052, sourcebans.sp::VerifyInsert()

When the player ban doesn't stick it also spits out soemthing similar to this..

[ERROR] Query Failed: Column 'sid' cannot be null

#3
Updated by Recon _ 168 days ago

I think the SB team fixed the sid null error a long time ago.

Just to be sure, try setting the server id in your SB config file (located at addons/sourcemod/configs/sourcebans/sourcebans.cfg

Replace -1 with your server id.

// This is the ID of this server (Check in the admin panel -> servers to find the ID of this server)
"ServerID" "-1"

#4
Updated by Olly Ginger 167 days ago

I'm not really sure what causes the invalid handle thing. But I don't think setting the server ID will fix it, as this was implemented to fix a different/unrelated problem. But still, you could try it anyway.