Supertracker

[gnro]

I am also getting this error when trying to run a couple of reports..

1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
in:
[SELECT COUNT(*) AS count, s.country_code, c.countries_name FROM supertracker s LEFT JOIN countries c ON (c.countries_iso_code_2 = s.country_code) GROUP BY country_code]

Hello I think you need to alter the supertracker table with collation "latin1_general_ci". You can use phpmyadmin or the Insert SQL Paches page from ZC admin, but I don't know the exact command for this. Maybe someone else can help here.