AlliedModders - Problem with HLStatsX

Page 1 of 2

Show 40 post(s) from this thread on one page

AlliedModders (https://forums.alliedmods.net/index.php)

- HLstatsX:CE (https://forums.alliedmods.net/forumdisplay.php?f=156)

- - Problem with HLStatsX (https://forums.alliedmods.net/showthread.php?t=249379)

Mike4Told

10-05-2014 00:32

Problem with HLStatsX

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.

Code:

                                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

10-08-2014 02:51

Re: Problem with HLStatsX

Same Problem. Google tells me nothing very helpful =(

Mike4Told

10-13-2014 22:32

Re: Problem with HLStatsX

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

nikooo777

10-14-2014 19:31

Re: Problem with HLStatsX

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

10-14-2014 20:11

Re: Problem with HLStatsX

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

10-15-2014 01:25

Re: Problem with HLStatsX

Quote:

Originally Posted by Mavrick4283 (Post 2211166)

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

10-21-2014 04:53

Re: Problem with HLStatsX

Where can I download? Normal DL - Link?

Mavrick4283

10-21-2014 13:19

Re: Problem with HLStatsX

Yes

Mike4Told

10-28-2014 03:38

Re: Problem with HLStatsX

I assume you didn't change the version number?

Mavrick4283

10-28-2014 21:52

Re: Problem with HLStatsX

Quote:

Originally Posted by Mike4Told (Post 2216832)

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.

All times are GMT -4. The time now is 16:15.

Page 1 of 2

Show 40 post(s) from this thread on one page