[digimon_dk]

My HLStatsX has stopped working .. some who have an answer to what is happening. ? or how I get it to work again

2016-10-21 177:25: 192.168.1.19:27015 - RCON: Got Address 188.181.226.36 for Player They see me rollin 2016-10-21 177:25: 192.168.1.19:27015 - DEBUG: Updated IP for 8328 to 188.181.226.36 2016-10-21 177:25: 192.168.1.19:27015 - E014: "They see me rollin" <P:8328,U:46,W:0:57847250,T:CT> say "Hvis der er nogle der har nogle skins til overs vil jeg gerne have dem" 2016-10-21 177:25: 192.168.1.19:27015 - E020: (IGNORED) OK Rcon from "192.168.1.19": "status" 2016-10-21 177:25: 192.168.1.19:27015 - E020: BAD DATA: rcon from "192.168.1.19:44346": command "" DBD::mysql::db do failed: Incorrect string value: '\xF0\x9D\x93\x9C\xD1\x8F...' for column 'name' at row 1 at .//HLstats.plib line 198. DBD::mysql::st execute failed: Incorrect string value: '\xF0\x9D\x93\x9C\xD1\x8F...' for column 'lastName' at row 1 at .//HLstats.plib line 213. Unable to execute query (player_flushdb_player_2): UPDATE hlstats_Players SET connection_time = connection_time + ?, lastName=?, clan=?, kills=kills + ?, deaths=deaths + ?, suicides=suicides + ?, skill=?, headshots=headshots + ?, shots=shots + ?, hits=hits + ?, teamkills=teamkills + ?, last_event=?, last_skill_change=?, death_streak=IF(?>death_streak,?,death_streak ), kill_streak=IF(?>kill_streak,?,kill_streak), hideranking=IF(hideranking=3,0,hideranking), activity = 100 WHERE playerId=? Incorrect string value: '\xF0\x9D\x93\x9C\xD1\x8F...' for column 'lastName' at row 1 at .//HLstats.plib line 213.

[LeetDonkey]

Most likely a unicode emoji in a playername that mess up the mysql query.

Easiest fix would be to install a plugin that disallows it.

[Grainz]

Another fix is making sure your DB is utf8mb4
Edit "HLStats.plib"

$db_conn->do("SET NAMES 'utf8mb4'");

[LeetDonkey]

#3
Did it work for you?
I tried that a while ago and still crashed - I even changed the mysql tables to utf8mb4.

[Grainz]

Originally Posted by LeetDonkey #3 Did it work for you? I tried that a while ago and still crashed - I even changed the mysql tables to utf8mb4.

Yes, That was the only change I made within the hlstats daemon except for converting SteamIDs