search

levelsranks / pawn-levels_ranks-core

Statistics plugin for servers on the Source Engine
GNU General Public License v3.0
71 stars 38 forks source link

SQL_Callback Error (2450) #24

Closed ghost closed 4 years ago

ghost commented 4 years ago

L 12/24/2019 - 16:02:27: [levelsranks.smx] SQL_Callback Error (2450): Incorrect string value: '\xF0\x9F\x93\x97^1...' for column oyntch_ntX0JkS.lvl_base.name at row 1

mgeerse commented 4 years ago

I have the same problem. It is caused by players having special characters in their name. A name such as πŒπŽπ‘π†π€πƒπŽor 𝓼𝔁𝓡𝓽𝔂will cause this.

The playername is gathered with the GetPlayerName() function from SourceMod in databases.sp on line 252 (in the SaveDataPlayer function).

The name does get converted to \xF0\x9F\x93\x97^1... but it can't get updated/inserted into the database. Directly inserting this into the database works, but so far I have not found a fix.

I have tried to change the column collation from utf8_general_cito utf8mb4_general_ci without any luck

Wend4r commented 4 years ago

This problem is related to the incompatibility of your database with dbi.mysql sourcemod driver. The plugin has nothing to do with this. Write here with this problem - https://github.com/alliedmodders/sourcemod/issues .