Raised This Month: $12 Target: $400
 3% 

[SB++] Inserting ban "Incorrect string value"


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
TheFlyingApple
Member
Join Date: Aug 2016
Old 12-20-2020 , 19:19   [SB++] Inserting ban "Incorrect string value"
Reply With Quote #1

Hi,

Every time a new ban is added via the ingame admin menu, and the banned players ingame name contains unicode-characters (Ex. "𝖘𝖚𝖙𝖉𝖎") i get the following error in my "sourcebans.log":

Code:
L 12/21/2020 - 00:04:15: [sbpp_main.smx] Verify Insert Query Failed: Incorrect string value: '\xF0\x9D\x96\x98\xF0\x9D...' for column 'name' at row 1
My DB setup looks like this:



Everything worked before i changed DB host... I have tried different SQL commands - also changing the "Charset" of the "name" column... But nothing have worked.

Versions:
MySQL: mysql-5.7.31
Sourcemod: 1.10.6501
Metamod: 1.11.1143
Sourcebans++: 1.6.3

Any ideas?
TheFlyingApple is offline
asdfxD
Veteran Member
Join Date: Apr 2011
Old 12-23-2020 , 15:01   Re: [SB++] Inserting ban "Incorrect string value"
Reply With Quote #2

i had the same issue few months ago. open the sbpp_main.sp and change:

PHP Code:
SQL_SetCharset(DB"utf8"); 
to
PHP Code:
SQL_SetCharset(DB"utf8mb4"); 
and recompile the plugin.

do the same with the sbpp_comms.sp

Last edited by asdfxD; 12-23-2020 at 15:02.
asdfxD is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 10:52.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode