AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   SourceBans / SourceBans++ (https://forums.alliedmods.net/forumdisplay.php?f=152)
-   -   Release SourceBans++ (v1.6.3) [Updated: 2018-04-09] (https://forums.alliedmods.net/showthread.php?t=263735)

paulo_crash 07-25-2019 14:42

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

Originally Posted by `666 (Post 2660603)
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 07-26-2019 02:46

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

Originally Posted by `666 (Post 2660603)
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"

Quote:

Originally Posted by paulo_crash (Post 2660608)
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.

Quote:

Originally Posted by DarkDeviL (Post 2660571)
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 07-26-2019 10:36

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

egorka2 08-03-2019 17:49

Re: [RELEASE] SourceBans++ (v1.6.3) [Updated: 2018-04-06]
 
How to disable logging? Now sourcebans.log is flooding by all DB queries...

asdfxD 08-21-2019 13:16

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

trotinetaidg 09-06-2019 14:08

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

Quote:

[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 09-13-2019 00:43

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

Originally Posted by asdfxD (Post 2664117)
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

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.

RumbleFrog 09-20-2019 22:45

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



.


All times are GMT -4. The time now is 22:26.

Powered by vBulletin®
Copyright ©2000 - 2020, vBulletin Solutions, Inc.