AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   SourceBans / SourceBans++ (https://forums.alliedmods.net/forumdisplay.php?f=152)
-   -   [SB++] Inserting ban "Incorrect string value" (https://forums.alliedmods.net/showthread.php?t=329369)

TheFlyingApple 12-20-2020 20:19

[SB++] Inserting ban "Incorrect string value"
 
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:

https://i.gyazo.com/546b4f6c0a702ac2...99c30307bb.png

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?

asdfxD 12-23-2020 16:01

Re: [SB++] Inserting ban "Incorrect string value"
 
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


All times are GMT -4. The time now is 11:31.

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