[paulo_crash]

Originally Posted by `666 Yes. In "date format" I have it "d-m-y H:i T" https://www.bmbans.nn.pe/sourcebans/index.php?p=banlist edit: and in webhost cpanel -> multiphp ini editor for domain I had to add new line: date.timezone = "Europe/London"

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.

[8guawong]

Originally Posted by `666 Yes. In "date format" I have it "d-m-y H:i T" https://www.bmbans.nn.pe/sourcebans/index.php?p=banlist edit: and in webhost cpanel -> multiphp ini editor for domain I had to add new line: date.timezone = "Europe/London"

Originally Posted by paulo_crash 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.

Originally Posted by DarkDeviL I am very sure that I've seen it in settings previously (of the official SourceBans), as I also advise over here. If that doesn't fit in your SB++, you can try the advise given here instead.

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

[jouluvalo]

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

[egorka2]

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

[asdfxD]

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:538: [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

[trotinetaidg]

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

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

[sbpp_main.smx] Database failure: [2013]: Lost connection to MySQL server at 'reading initial communication packet', system error: 110. See Docs: https://sbpp.github.io/docs/

[asdfxD]

Originally Posted by asdfxD 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:538: [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

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: utf

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.

[RumbleFrog]

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


.