[Mike4Told]

After a while of running the daemon, this happens and freezes the stats. I have to restart the daemon manually. I have restarted my stats completely with a new database and it still happens. Ideas?

Thanks in advance.

                                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\x9F\x91\x88to...' for column 'lastName' at row 1 a
t .//HLstats.plib line 213.

[micazoid]

Same Problem. Google tells me nothing very helpful =(

[Mike4Told]

I hate to bump this. But is there an update for this problem?

[nikooo777]

Somehow an user with a weird name got saved in the database and it's causing this issue!
Manually find the user with lastname set in the database (should be something like "\xF0\x9F\x91\x88....")
and modify it to anything you like, but normal text.

[Mavrick4283]

It looks like the packets are not being parsed correctly and it is inserting the bad data into the DB.

This might be related to a bug in how I packed the HLX:CE linux tar files, I am going to re-upload in a few mins to correct that.

Once that is done, try to re-download the files and replace the daemon files and see if this happens again.

[micazoid]

Originally Posted by Mavrick4283 It looks like the packets are not being parsed correctly and it is inserting the bad data into the DB. This might be related to a bug in how I packed the HLX:CE linux tar files, I am going to re-upload in a few mins to correct that. Once that is done, try to re-download the files and replace the daemon files and see if this happens again.

That would be awesome. It happens not everytime and not with specific users. I first thought about a sort of Encodingproblem. For example if a Player uses strange characters in his name. But a Unicodechangerplugin didnt solve the problem =(

[micazoid]

Where can I download? Normal DL - Link?

[Mavrick4283]

Yes

[Mike4Told]

I assume you didn't change the version number?

[Mavrick4283]

Originally Posted by Mike4Told I assume you didn't change the version number?

There is no need to do so; I only corrected the way I compressed the files.