Supertracker

[fjutt]

Hi,

Looking at this cool mod but when I go to download the geoip files I only see files for geoipv6
do we need to adjust the code for them?
Just wondering as I think the current code only refers to geoip.
Anybody an idea?


Thanks!
Frans

[Design75]

Hi,

Looking at this cool mod but when I go to download the geoip files I only see files for geoipv6
do we need to adjust the code for them?
Just wondering as I think the current code only refers to geoip.
Anybody an idea?


Thanks!
Frans

For the latest file I always go to http://www.maxmind.com/app/geoip_country . There is the link Download the latest GeoLite Country Binary Format

unpack the file and upload it to your shop.

[saucy-but-nice]

Does anyone know if this mod will be updated for the newest version of Zen Cart 1.5?

I managed to get it working now in 1.50, see this thread http://www.zen-cart.com/showthread.p...t=supertracker

[Design75]

I had contact with Andrew, about updating this module for Zen Cart 1.5. This weekend I am going to submit a new version of Super tracker to the plug-in area, version 1.1.

Super Tracker v1.1 Changelog

• In YOUR_ADMIN/supertracker.php changed http://www.showmyip.com to whatismyipaddress.com, thanks to "saucy-but-nice" see forum post
• updated includes/geoip.inc to a new version new countries were added, some removed, and some changed
• added the country flags images to the installation in YOUR_ADMIN/images/flags
• added GeoIP.dat standard to the install in includes/GeoIP.dat
• added files for the auto installer for sql
• added sql statements for zen cart 1.5
• added a version number in the admin panel for easier tracking of the (future) module versions
• updated the readme

I had some more upgrades in mind for this great module, but that will take more time, and also is working on some new version.

[a_berezin]

This weekend I am going to submit a new version of Super tracker to the plug-in area, version 1.1.

Thank you for this upgrade - I did not have enough time.

I had some more upgrades in mind for this great module, but that will take more time, and also is working on some new version.

Can you describe in detail what changes are you planning? I'm also working on the development of statistics and analytics at the store. And I would not compete, and to work together :)

[Design75]

Hi Andrew,

I was going to drop you a line through the PM, about the other "updates" , but one of my daughters distracted me and I completely forgot. The PM will come your way this evening. It's nothing special I had in mind just some updating/upgrading of old files like searchengine.php.
No intention to compete, Zen Cart is a team effort.

[kappy1]

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

[Design75]

you will need to change your character set in your database for super tracker to be the same as the rest.

[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?