next »

[flinkaflenkaflrsk]

Symptoms
I had a problem with the player activity and at first I did not understand why. I went to look and found out that even though the table was created by the correct sql accompanied with the plugin there was a problem with the Collation of the fields within the table!

You wont see anything on your stats page but if you do an

Code:

echo $query;

inside the inc_activitygraph.php and then execute that query directly on your b3 database you will see:
#1267 - Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='

Solution
Change the fields collation to latin1_general_ci

[xlr8or]

Is there anybody else with this problem? I don't recall it being an issue on other setups?

[flinkaflenkaflrsk]

I guess it depends on your default collation?

[Mikobiko]

Hate to necro bump, however I just noticed my xlrstats wasnt displaying ctime, and the fix he listed did correct the issue for me.