View Single Post
asdfxD
Veteran Member
Join Date: Apr 2011
Old 09-13-2019 , 01:43   Re: [RELEASE] SourceBans++ (v1.6.3) [Updated: 2018-04-06]
#1377

Quote:
Originally Posted by asdfxD View Post
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.

Last edited by asdfxD; 09-13-2019 at 01:46.
asdfxD is offline