[leeter]

Originally Posted by Groruk Can you provide a list of your used plugins (sm plugins list)?

yeah, sure:

PHP Code:

16:10:28 [SM] Listing 52 plugins:
           01 "Fun Votes" (1.8.0.5985) by AlliedModders LLC
           02 "CS:GO Retakes: Customised Weapon Allocator for splewis retakes plugin" (0.2.0) by BatMen
           03 "Map Nominations Extended" (1.10.0) by Powerlord and AlliedModders LLC
           04 <Failed> "SourceBans++: SourceSleuth" (1.6.0) by ecca, SourceBans++ Dev Team
           05 "Basic Info Triggers" (1.8.0.5985) by AlliedModders LLC
           06 "[Any] Chat Logging Redux + RTF Support" (1.1.2) by McFlurry, Keith Warren (Drixevel)
           07 "Player Commands" (1.8.0.5985) by AlliedModders LLC
           08 "Basic Votes" (1.8.0.5985) by AlliedModders LLC
           09 "SMAC ESEA Global Banlist" (0.8.6.0) by SMAC Development Team
           10 "SourceMod Anti-Cheat" (0.8.6.0) by SMAC Development Team
           11 "Nextmap" (1.8.0.5985) by AlliedModders LLC
           12 "SourceBans++" (1.5.4.6) by SourceBans Development Team, Sarabveer(VEER™)
           13 "VAC Status Checker" (2.0.0) by Stevo.TVR
           14 "[CSS/CS:GO] ResetScore" (1.5fix) by AbNeR_CSS
           15 "Map Nominations" (1.8.0.5985) by AlliedModders LLC
           16 "Client Preferences" (1.9.0.6080) by AlliedModders LLC
           17 "Anti-Flood" (1.8.0.5985) by AlliedModders LLC
           18 "Basic Chat" (1.8.0.5985) by AlliedModders LLC
           19 "Web Shortcuts CS:GO version" (2.5) by Franc1sco franug and James "sslice" Gray
           20 "MOTDgd Adverts" (2.5.3) by Blackglade and Ixel
           21 "CallAdmin: Mysql module" (0.1.5) by Impact, Popoklopsi
           22 "Fun Commands" (1.8.0.5985) by AlliedModders LLC
           23 "Admin Menu" (1.8.0.5985) by AlliedModders LLC
           24 <Failed> "SourceBans++: Main Plugin" (1.6.0) by SourceBans Development Team, SourceBans++ Dev Team
           25 "Sound Commands" (1.8.0.5977) by AlliedModders LLC
           26 "SourceBans: Admin Config Loader" ((SB++) 1.5.4.6) by AlliedModders LLC, Sarabveer(VEER™)
           27 "MapChooser Extended" (1.10.2) by Powerlord, Zuko, and AlliedModders LLC
           28 "SourceComms" ((SB++) 1.5.4.6) by Alex, Sarabveer(VEER™)
           29 "CS:GO Retakes: site picker" (0.3.2) by splewis
           30 "Updater" (1.2.2) by GoD-Tony
           31 "Rock The Vote Extended" (1.10.0) by Powerlord and AlliedModders LLC
           32 "Basic Commands" (1.8.0.5985) by AlliedModders LLC
           33 "CS:GO Retakes" (0.3.2) by splewis
           34 "RandomCycle" (1.8.0.5985) by AlliedModders LLC
           35 "Admin Help" (1.8.0.5985) by AlliedModders LLC
           36 "Warmup Round" (3.1.1) by XARiUS, Avo, Gdk
           37 "SMAC Aimbot Detector" (0.8.6.0) by SMAC Development Team
           38 "SourceBans Checker" ((SB++) 1.5.4.6) by psychonic, Ca$h Munny, Sarabveer(VEER™)
           39 "AFK Manager" (4.1.1) by Rothgar
           40 "SourceBans++: Admin Config Loader" (1.6.0) by AlliedModders LLC, SourceBans++ Dev Team
           41 "Advertisements" (2.0.2) by Tsunami
           42 <Failed> "SourceBans++: SourceComms" (1.6.0) by Alex, SourceBans++ Dev Team
           43 "SourceBans++: Bans Checker" (1.6.0) by psychonic, Ca$h Munny, SourceBans++ Dev Team
           44 "Basic Comm Control" (1.8.0.5985) by AlliedModders LLC
           45 "CallAdmin" (0.1.5) by Impact, Popoklopsi
           46 "SM Most Active" (2.2) by Franc1sco Steam: franug
           47 "[ANY] Player Analytics" (1.3.1) by Dr. McKay
           48 "Admin File Reader" (1.8.0.5985) by AlliedModders LLC
           49 "Reserved Slots" (1.8.0.5985) by AlliedModders LLC
           50 "SourceSleuth" ((SB++) 1.5.4.6) by ecca, Sarabveer(VEER™)
           51 "High Ping Kicker - Lite Edition" (1.0.0.1) by Liam
           52 "RankMe" (3.0.3.Kento.25) by lok1, Scooby, pracc, Kento, Kxnrl
         Errors:
         sbpp_sleuth.smx (SourceBans++: SourceSleuth): Native "SourceBans_BanPlayer" was not found
         sbpp_main.smx (SourceBans++: Main Plugin): unexpected error 23 in AskPluginLoad callback
         sbpp_comms.smx (SourceBans++: SourceComms): unexpected error 23 in AskPluginLoad callback 


[shanapu]

you have sourcebans installed twice. 1.5.4 & 1.6.0

PHP Code:

12 "SourceBans++" (1.5.4.6) by SourceBans Development Team, Sarabveer(VEER™)
24 <Failed> "SourceBans++: Main Plugin" (1.6.0) by SourceBans Development Team, SourceBans++ Dev Team 


[cravenge]

Originally Posted by leeter [...]

Originally Posted by shanapu you have sourcebans installed twice. 1.5.4 & 1.6.0

Not only that, it's because of this.

[Groruk]

Originally Posted by cravenge In sbpp_main.sp, instead of SP_ERROR_NATIVE, they use 1 and 2 (which is SP_ERROR_FILE_FORMAT and SP_ERROR_DECOMPRESSOR respectively in functions.inc) when a native returns an error, hence why it was producing those errors. And in sbpp_comms.sp, (Don't mind the new syntax) I think it should be: PHP Code: public Native_SetClientMute(Handle hPlugin, int numParams) {     int target = GetNativeCell(1);     if (target < 1 || target > MaxClients)     {         ThrowNativeError(SP_ERROR_NATIVE, "Invalid client index %d", target);         return false;     }     if (!IsClientInGame(target))     {         ThrowNativeError(SP_ERROR_NATIVE, "Client %d is not in game", target);         return false;     }              bool muteState = bool:GetNativeCell(2);     int muteLength = GetNativeCell(3);              if (muteState && muteLength == 0)     {         ThrowNativeError(SP_ERROR_NATIVE, "Permanent mute is not allowed!");         return false;     }     bool bSaveToDB = bool:GetNativeCell(4);     if (!muteState && bSaveToDB)     {         ThrowNativeError(SP_ERROR_NATIVE, "Removing punishments from DB is not allowed!");         return false;     }     char sReason[256];     GetNativeString(5, sReason, sizeof(sReason));     if (muteState)     {         if (g_MuteType[target] > bNot)         {             return false;         }         PerformMute(target, _, muteLength, _, _, _, sReason);         if (bSaveToDB)             SavePunishment(_, target, TYPE_MUTE, muteLength, sReason);     }     else     {         if (g_MuteType[target] == bNot)         {             return false;         }         PerformUnMute(target);     }     return true; }  instead of: PHP Code: public Native_SetClientMute(Handle:hPlugin, numParams) {     new target = GetNativeCell(1);     if (target < 1 || target > MaxClients)     {         return ThrowNativeError(SP_ERROR_NATIVE, "Invalid client index %d", target);     }     if (!IsClientInGame(target))     {         return ThrowNativeError(SP_ERROR_NATIVE, "Client %d is not in game", target);     }     new bool:muteState = GetNativeCell(2);     new muteLength = GetNativeCell(3);     if (muteState && muteLength == 0)     {         return ThrowNativeError(SP_ERROR_NATIVE, "Permanent mute is not allowed!");     }     new bool:bSaveToDB = GetNativeCell(4);     if (!muteState && bSaveToDB)     {         return ThrowNativeError(SP_ERROR_NATIVE, "Removing punishments from DB is not allowed!");     }     new String:sReason[256];     GetNativeString(5, sReason, sizeof(sReason));     if (muteState)     {         if (g_MuteType[target] > bNot)         {             return false;         }         PerformMute(target, _, muteLength, _, _, _, sReason);         if (bSaveToDB)             SavePunishment(_, target, TYPE_MUTE, muteLength, sReason);     }     else     {         if (g_MuteType[target] == bNot)         {             return false;         }         PerformUnMute(target);     }     return true; }

https://github.com/sbpp/sourcebans-pp/pull/270
https://github.com/sbpp/sourcebans-pp/pull/271
This has been fixed now. Next time just make an Pull Request in the SourceBans++ repo on Github.

[leeter]

I still got 1 Error, i have used the latest version of PRs.

[SM] Listing 48 plugins: 01 "Fun Votes" (1.8.0.5985) by AlliedModders LLC 02 "CS:GO Retakes: Customised Weapon Allocator for splewis retakes plugin" (0.2.0) by BatMen 03 "Map Nominations Extended" (1.10.0) by Powerlord and AlliedModders LLC 04 "Basic Info Triggers" (1.8.0.5985) by AlliedModders LLC 05 "[Any] Chat Logging Redux + RTF Support" (1.1.2) by McFlurry, Keith Warren (Drixevel) 06 "Player Commands" (1.8.0.5985) by AlliedModders LLC 07 "Basic Votes" (1.8.0.5985) by AlliedModders LLC 08 "SMAC ESEA Global Banlist" (0.8.6.0) by SMAC Development Team 09 "SourceMod Anti-Cheat" (0.8.6.0) by SMAC Development Team 10 "Nextmap" (1.8.0.5985) by AlliedModders LLC 11 "VAC Status Checker" (2.0.0) by Stevo.TVR 12 "[CSS/CS:GO] ResetScore" (1.5fix) by AbNeR_CSS 13 "Map Nominations" (1.8.0.5985) by AlliedModders LLC 14 "Client Preferences" (1.9.0.6080) by AlliedModders LLC 15 "Anti-Flood" (1.8.0.5985) by AlliedModders LLC 16 "Basic Chat" (1.8.0.5985) by AlliedModders LLC 17 "Web Shortcuts CS:GO version" (2.5) by Franc1sco franug and James "sslice" Gray 18 "MOTDgd Adverts" (2.5.3) by Blackglade and Ixel 19 "CallAdmin: Mysql module" (0.1.5) by Impact, Popoklopsi 20 "Fun Commands" (1.8.0.5985) by AlliedModders LLC 21 "Admin Menu" (1.8.0.5985) by AlliedModders LLC 22 "Sound Commands" (1.8.0.5977) by AlliedModders LLC 23 "MapChooser Extended" (1.10.2) by Powerlord, Zuko, and AlliedModders LLC 24 "CS:GO Retakes: site picker" (0.3.2) by splewis 25 "Updater" (1.2.2) by GoD-Tony 26 "Rock The Vote Extended" (1.10.0) by Powerlord and AlliedModders LLC 27 "Basic Commands" (1.8.0.5985) by AlliedModders LLC 28 "CS:GO Retakes" (0.3.2) by splewis 29 "RandomCycle" (1.8.0.5985) by AlliedModders LLC 30 "Admin Help" (1.8.0.5985) by AlliedModders LLC 31 "Warmup Round" (3.1.1) by XARiUS, Avo, Gdk 32 "SMAC Aimbot Detector" (0.8.6.0) by SMAC Development Team 33 "AFK Manager" (4.1.1) by Rothgar 34 "Advertisements" (2.0.2) by Tsunami 35 "Basic Comm Control" (1.8.0.5985) by AlliedModders LLC 36 "CallAdmin" (0.1.5) by Impact, Popoklopsi 37 "SM Most Active" (2.2) by Franc1sco Steam: franug 38 "[ANY] Player Analytics" (1.3.1) by Dr. McKay 39 "Admin File Reader" (1.8.0.5985) by AlliedModders LLC 40 "Reserved Slots" (1.8.0.5985) by AlliedModders LLC 41 "High Ping Kicker - Lite Edition" (1.0.0.1) by Liam 42 "RankMe" (3.0.3.Kento.25) by lok1, Scooby, pracc, Kento, Kxnrl 43 "SourceBans++: SourceSleuth" (1.6.0) by ecca, SourceBans++ Dev Team 44 "SourceBans++: Main Plugin" (1.6.0) by SourceBans Development Team, SourceBans++ Dev Team 45 "SourceBans++: Admin Config Loader" (1.6.0) by AlliedModders LLC, SourceBans++ Dev Team 46 <Failed> "SourceBans++: SourceComms" (1.6.0) by Alex, SourceBans++ Dev Team 47 "SourceBans++: Bans Checker" (1.6.0) by psychonic, Ca$h Munny, SourceBans++ Dev Team 48 "Simple Warnings" (1.2) by Potatoz, B3none Errors: sbpp_comms.smx (SourceBans++: SourceComms): unexpected error 23 in AskPluginLoad callback

[Robin955]

someone got the files for sourcebans 1.5.4.7? not interested in upgrading to this as there's no point.

nvm already had them.

[SytekBox]

Originally Posted by Robin955 someone got the files for sourcebans 1.5.4.7? not interested in upgrading to this as there's no point. nvm already had them.

Not sure how you find pointless to update to a newer and better version. That's weird if you ask lol

[DaRk56]

Originally Posted by Robin955 someone got the files for sourcebans 1.5.4.7? not interested in upgrading to this as there's no point. nvm already had them.

https://github.com/sbpp/sourcebans-p...es/tag/1.5.4.7
--------

I installed this for the vip system, and the connection to the database is done more, what have been the changes since 1.6.0 to fix this.
Donation Control

[Dakier]

Fatal error: mysqli error: [1048: Column 'host' cannot be null] in EXECUTE("INSERT INTO sb_log(type,title,message, function, query, aid, host, created) VALUES ('e','PHP Error','[256] mysqli error: [1048: Column \'adminIp\' cannot be null] in EXECUTE(\"INSERT INTO sb_bans(created,type,ip,authid,name,ends,length,reason,aid,adminIp ) VALUES\n (UNIX_TIMESTAMP(),\'0\',\'\',\'STEAM_0:0:91202798\',\'Dakier\',(UNIX_TIMESTAMP() + 60),60,\'joku pippeli\',\'1\',NULL)\")\n
\nFatal error on line 79 in file /home/jonnekah/public_html/sourcebans/includes/adodb/adodb-errorhandler.inc.php','/home/jonnekah/public_html/sourcebans/includes/adodb/adodb-errorhandler.inc.php - 79
/home/jonnekah/public_html/sourcebans/includes/adodb/adodb.inc.php - 1250
/home/jonnekah/public_html/sourcebans/includes/adodb/adodb.inc.php - 1190
/home/jonnekah/public_html/sourcebans/includes/sb-callback.php - 1791
','N/A','1',NULL,1493468819)") in /home/jonnekah/public_html/sourcebans/includes/adodb/adodb-errorhandler.inc.php on line 79
You have whitespace in your response.

How I can fix it?

[404UserNotFound]

Originally Posted by Robin955 someone got the files for sourcebans 1.5.4.7? not interested in upgrading to this as there's no point. nvm already had them.

What? I am so confused by this.

Originally Posted by Dakier How I can fix it?

It's telling you that "host" and "adminIp" cannot be "NULL", yet if you read the EXECUTE line's entries, you blatantly see that you've got adminIp set as "NULL" for some reason. I highlighted (red text) the adminIp bit, and bolded the weirdness related to the host bit.

Fatal error: mysqli error: [1048: Column 'host' cannot be null] in EXECUTE("INSERT INTO sb_log(type,title,message, function, query, aid, host, created) VALUES ('e','PHP Error','[256] mysqli error: [1048: Column \'adminIp\' cannot be null] in EXECUTE(\"INSERT INTO sb_bans(created,type,ip,authid,name,ends,leng th,reason,aid,adminIp ) VALUES\n (UNIX_TIMESTAMP(),\'0\',\'\',\'STEAM_0:0:9120 2798\',\'Dakier\',(UNIX_TIMESTAMP() + 60),60,\'joku pippeli\',\'1\',NULL)\")\n

What's weird though is that the first SQL query's 1st, 2nd and 3rd variables (type, title and message) are set to "e", "PHP Error", and "[256] mysqli error: <entirety of the 2nd query's error message>" which is really odd....so I don't know how to fix it. All I know is how to read the error message and that's about it