Supertracker

[a_berezin]

If I select Visitors Countries Stats I get this error. I applied the sq patch but still the same thing and only for this one report.

WARNING: An Error occurred, please refresh the page and try again.
Fatal error: 1267:Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' :: 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 in /home/kellys14/public_html/catalog/includes/classes/db/mysql/query_factory.php on line 101

Execute this SQL-code:

ALTER TABLE  `supertracker` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE  `supertracker` CHANGE  `country_code`  `country_code` CHAR(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';

[sicivic89]

So I downloaded Supertracker and followed the instructions to a Tee. I even went back and double checked that all the correct files were in the right place. Supertracker shows up under reports. I can pick the various options like Last Ten Visitors and such. But it is showing Database Info: the Supertracker database currently holds 0 rows (oldest record : ). Meaning its not gathering any data. Any ideas what I did wrong or need to fix?

[Design75]

did you have any visitors since you installed supertracker? Normally the installation reinstalls the supertracker table, so at the beginning it is empty.

[sicivic89]

did you have any visitors since you installed supertracker? Normally the installation reinstalls the supertracker table, so at the beginning it is empty.

Yes, I have had new people register on the site and orders placed. After I installed it, I hopped on my website from a second computer and it didn't show any data.

[Design75]

When installing, did you rename the YOUR_TEMPLATE folder to your own template for

includes/templates/YOUR_TEMPLATE/jscript/jscript_supertracker.php 

?

[sicivic89]

When installing, did you rename the YOUR_TEMPLATE folder to your own template for

includes/templates/YOUR_TEMPLATE/jscript/jscript_supertracker.php 

?

Yes I did. Logged into my ftp just now, it shows: /includes/templates/bask_black/jscript/jscript_supertracker.php

[Design75]

grr. so it is nothing obvious