[Wilczek]

Originally Posted by ijam_j by the way, what is the recommended way and supported by sourcebans to ban disconnected players? sm_addbans doesnt seems to work.

Well, it works for me Ban is successfully added to the list and prevents player from connecting.

[lnnocent]

Receiving an error on my website.

"Fatal error: mysqli error: [1054: Unknown column 'setting' in 'where clause'] in EXECUTE("SELECT value FROM `sb_settings` WHERE setting = 'config.debug';") in /home/****/public_html/bans/includes/adodb/adodb-errorhandler.inc.php on line 77"

Can anyone help?

[ijam_j]

Originally Posted by Wilczek Well, it works for me Ban is successfully added to the list and prevents player from connecting.

dont know why but now sm_addban works. probably my faults.

[ijam_j]

Originally Posted by lnnocent Receiving an error on my website. "Fatal error: mysqli error: [1054: Unknown column 'setting' in 'where clause'] in EXECUTE("SELECT value FROM `sb_settings` WHERE setting = 'config.debug';") in /home/****/public_html/bans/includes/adodb/adodb-errorhandler.inc.php on line 77" Can anyone help?

i also have an error related to adodb-errorhandler.inc.php on line 77. it is caused by mariadb. sourceban++ only support mysql and mariadb is not 100% compatible with mysql.

see my previous post for solutions.

[eric0279]

Hello,

why i get:

L 11/21/2015 - 09:57:20: SourceMod error session started L 11/21/2015 - 09:57:20: Info (map "de_dust2") (file "errors_20151121.log") L 11/21/2015 - 09:57:20: [sourcecomms.smx] Lost connection to DB. Reconnect after delay. L 11/21/2015 - 09:57:20: [sourcecomms.smx] Query_VerifyBlock failed: SELECT command denied to user 'sourcebans'@'IPDEDICATED' for table 'sb_comms' L 11/21/2015 - 09:57:20: [SourceSleuth.smx] SourceSleuth: Database query error: SELECT command denied to user 'sourcebans'@'IPDEDICATED' for table 'sb_bans' L 11/21/2015 - 09:57:20: [SM] Native "SQL_FetchRow" reported: Invalid query Handle 0 (error: 4) L 11/21/2015 - 09:57:20: [SM] Displaying call stack trace for plugin "SourceSleuth.smx": L 11/21/2015 - 09:57:20: [SM] [0] Line 189, SourceSleuth.sp::SQL_CheckHim() L 11/21/2015 - 09:58:06: [sourcecomms.smx] Lost connection to DB. Reconnect after delay. L 11/21/2015 - 09:58:06: [sourcecomms.smx] Query_VerifyBlock failed: SELECT command denied to user 'sourcebans'@'IPDEDICATED' for table 'sb_comms' L 11/21/2015 - 09:58:52: [sourcecomms.smx] Lost connection to DB. Reconnect after delay. L 11/21/2015 - 09:58:52: [sourcecomms.smx] Query_VerifyBlock failed: SELECT command denied to user 'sourcebans'@'IPDEDICATED' for table 'sb_comms' L 11/21/2015 - 09:598: [sourcecomms.smx] Lost connection to DB. Reconnect after delay. L 11/21/2015 - 09:598: [sourcecomms.smx] Query_VerifyBlock failed: SELECT command denied to user 'sourcebans'@'IPDEDICATED' for table 'sb_comms' L 11/21/2015 - 10:00:25: [sourcecomms.smx] Lost connection to DB. Reconnect after delay. L 11/21/2015 - 10:00:25: [sourcecomms.smx] Query_VerifyBlock failed: SELECT command denied to user 'sourcebans'@'IPDEDICATED' for table 'sb_comms' L 11/21/2015 - 10:01:11: [sourcecomms.smx] Lost connection to DB. Reconnect after delay. L 11/21/2015 - 10:01:11: [sourcecomms.smx] Query_VerifyBlock failed: SELECT command denied to user 'sourcebans'@'IPDEDICATED' for table 'sb_comms' L 11/21/2015 - 10:01:57: [sourcecomms.smx] Lost connection to DB. Reconnect after delay. L 11/21/2015 - 10:01:57: [sourcecomms.smx] Query_VerifyBlock failed: SELECT command denied to user 'sourcebans'@'IPDEDICATED' for table 'sb_comms' L 11/21/2015 - 10:02:43: [sourcecomms.smx] Lost connection to DB. Reconnect after delay. L 11/21/2015 - 10:02:43: [sourcecomms.smx] Query_VerifyBlock failed: SELECT command denied to user 'sourcebans'@'IPDEDICATED' for table 'sb_comms' L 11/21/2015 - 10:03:22: [SourceSleuth.smx] SourceSleuth: Database query error: SELECT command denied to user 'sourcebans'@'IPDEDICATED' for table 'sb_bans'

MySQL is allowed to externe.

User have GRANT Privileges, user/password is correctly.

Client %, localhost, IPDEDICATED and 127.0.0.1 has been added to GRANT privileges.

Mysql restarted.

debug sourcebans:

[+] SourceBans "Error Connecting()" Debug starting for server 94.23.221.98:25815 [+] Trying to establish UDP connection [+] UDP connection successfull! [+] Trying to write to the socket [+] Successfully requested server info. (That doesn't mean anything on an UDP stream.) Reading... [+] Got an response! Server: EMC | DeathMatch by go-free.info [+] Trying to establish TCP connection [+] TCP connection successfull! [+] Trying to write to TCP socket and authenticate via rcon [+] Successfully sent authentication request. Reading... [+] Got an response! [+] Password correct!

server csgo is not on my dedicated server.

[Sarabveer]

Originally Posted by eric0279 Hello, why i get: MySQL is allowed to externe. User have GRANT Privileges, user/password is correctly. Client %, localhost, IPDEDICATED and 127.0.0.1 has been added to GRANT privileges. Mysql restarted. debug sourcebans: server csgo is not on my dedicated server.

On Linux, localhost is always 127.0.0.1

You have to put 127.0.0.1 in databases.cfg

[eric0279]

no, server csgo and web server has not on same machine.

Fixed, work now

[NeioWolf]

Hi guys, i get this error :

L 11/24/2015 - 12:255: [SM] Displaying call stack trace for plugin "sourcebans.smx": L 11/24/2015 - 12:255: [SM] [0] Line 1071, D:\scripting\sourcebans.sp::VerifyInsert()

And I don't get why because players get banned but not kicked.

Thank you for your help.

[asherkin]

Originally Posted by NeioWolf Hi guys, i get this error : And I don't get why because players get banned but not kicked. Thank you for your help.

The error is on the line before that.

[mufin]

im haven a problem and with no errors.


when i join a server its fine i have admin then on map change no one has admin they must rejoin to get there admin back.

anyway to fix this