Quote:
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:53 8: [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.