Re: [RELEASE] SourceBans++ (v1.6.3) [Updated: 2018-04-06]
 

Also make sure that the host where your game servers are set up is properly Date and Timezone.

I was having the same problem, after I configured the Web Host I configured Server Host too and solved my problem.

Re: [RELEASE] SourceBans++ (v1.6.3) [Updated: 2018-04-06]
 

thx for all the responses
fixed the timezone problem by adding date_default_timezone_set("Europe/Copenhagen"); to the config.php like DarkDeviL suggested

Re: [RELEASE] SourceBans++ (v1.6.3) [Updated: 2018-04-06]
 

Hello!
This week I noticed that my Sourcebans is not working as it should.

I added a ban beginning of this week and it didn't show up on the sourcebans page.
Now I added a mute and it didn't appear either.

The ban and mute was given on different servers. When I added the mute I got this in logs:
Saving punishment for STEAM_0:XXX into queue
Lost connection to DB. Reconnect after delay
Query_AddBlockInsert failed: Subquery returns more than 1 row

All servers recognize admins and you can use commands.
Servers are also preventing banned users from connecting. Something is now wrong with the sql as it tries to write. I can manually add mutes and bans via webpage

Re: [RELEASE] SourceBans++ (v1.6.3) [Updated: 2018-04-06]
 

How to disable logging? Now sourcebans.log is flooding by all DB queries...

Re: [RELEASE] SourceBans++ (v1.6.3) [Updated: 2018-04-06]
 

Any fix for this?

mysql is utf8mb4_general_ci

L 08/11/2019 - 12:55:42: [sbpp_main.smx] Verify Insert Query Failed: Incorrect string value: '\xF0\x9D\x95\xB5\xF0\x9D...' for column 'name' at row 1
L 08/20/2019 - 21:51:55: [sbpp_main.smx] Verify Insert Query Failed: Incorrect string value: '\xC3 \xBCvbe...' for column 'reason' at row 1
L 08/20/2019 - 21:52:58: [sbpp_main.smx] Verify Insert Query Failed: Incorrect string value: '\xC3 \xBCvbe...' for column 'reason' at row 1
L 08/20/2019 - 21:53:38: [sbpp_main.smx] Verify Insert Query Failed: Incorrect string value: '\xC3 \xBCvbe...' for column 'reason' at row 1
L 08/20/2019 - 22:20:03: [sbpp_main.smx] Verify Insert Query Failed: Incorrect string value: '\xC3 \xBCvbe...' for column 'reason' at row 1
L 08/20/2019 - 22:23:58: [sbpp_main.smx] Verify Insert Query Failed: Incorrect string value: '\xC3 \xBCvbe...' for column 'reason' at row 1

Re: [RELEASE] SourceBans++ (v1.6.3) [Updated: 2018-04-06]
 

Hello guys, just installed sourbenas on my server and don't work for me.

This is my error, server can't connect on database

Re: [RELEASE] SourceBans++ (v1.6.3) [Updated: 2018-04-06]
 

Got this shit error fixed finally, system is ubuntu.

Added in /etc/mysql/mysql.conf.d/mysqld.cnf and restart mysql.

[mysqld]
collation-server = utf8mb4_unicode_ci
character-set-server = utf8mb4
init-connect='SET NAMES utf8mb4'

[client]
default-character-set=utf8mb4

[mysql]
default-character-set=utf8mb4

service mysql restart

Change in /var/www/html/sourcebans_dir/config.php

define('DB_CHARSET', 'utf8'); // The Database charset (Default: utf8)

utf8 => utf8mb4

and changed all utf8 entrys to utf8mb4 in the sourcebans database and now it works without this errors, tested twice with old changes and new changes.

Re: [RELEASE] SourceBans++ (v1.6.3) [Updated: 2018-04-06]
 

Please post each request in its own thread (and check if it exists already) in the new SourceBans subforum instead of this big old one.

https://forums.alliedmods.net/forumdisplay.php?f=152


.