Supertracker

Correction: the mod shows up in backend but doesnt register anything... This is weird. Can someone help, I installed it like 3 times and same issue the webpage is just blank.

Quote:

---

Originally Posted by alivewjesus

I have zen 1.3.9h installed and am having trouble with looking at the last 10 visitors. I get the following error code:

1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
in:
[SELECT s.*, c.countries_name, s.country_code FROM supertracker s LEFT JOIN countries c ON (c.countries_iso_code_2 = s.country_code) ORDER BY last_click DESC LIMIT 0, 10]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I've reinstalled the files an d sql and still get this error. any ideas?

Thanks,

--Rob--

---

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]

Quote:

---

Originally Posted by rorrock

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.

Quote:

---

Originally Posted by gnro

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.

---

So I used phpadmin and viewed the structure of the supertracker table and set the collation to latin1_general_ci for all the fields. I did this manually since I couldn't find a way to do it through sql.

Quote:

---

Originally Posted by rxalex

Correction: the mod shows up in backend but doesnt register anything... This is weird. Can someone help, I installed it like 3 times and same issue the webpage is just blank.

---

1. Put back the js file you deleted.
2. Blank pages mean you have a syntax error or corrupted file (which can sometimes happen during upload).
3. Review the files on your server - do any of them have a 0 byte content? If so, it is corrupted and needs to be reinstalled.
4. This is an old mod...it may use syntax that has since been deprecated and needs to be updated. For example, users who have PHP5.3 will need to make a fix, as shown in this thread
5. Take a look in your store's cache folder - there should be debug logs there telling you what the error is and what file is causing the error. Before you can know how to fix the problem, you have to know where it's originating.
6. If you have multiple debug files to look at and don't know which one is the right one, delete them all, reload the store page to create the error, and then go back and look at the new files that were created as a result.
7. Check out this tutorial, but ignore the section on installing and using the debugging tool, as this is already installed in ZC139.
8. Once you've done all this, if you still need help, post the error message from the debug file to the forum. Someone who understands how to interpret them will likely give you the answer or point you in the right direction to figure it out.

Good luck :smile:

Hi, I have problem
I download GeoIP.dat from http://www.maxmind.com/app/geoip_country Binary Format

in FTP I see thet file like GeoIP.dat.gz end I can't Unzip


Hay to solve thet problem?

Thanks

Quote:

---

Originally Posted by kobra8

Hi, I have problem
I download GeoIP.dat from http://www.maxmind.com/app/geoip_country Binary Format

in FTP I see thet file like GeoIP.dat.gz end I can't Unzip


Hay to solve thet problem?

Thanks

---

Windows won't unzip a .gz file. You need a compression utility (a zipper/unzipper) to do that for you. 7-Zip is free. Give that a try. You'll need to download it and install it in order to unzip the your GeoIP.dat.gz file.

Thanks ScriptJunkie, on help. I upload :-)

But in report -Visiting Countries Stats- I don't get name of Country end flag?!

Hay to solve thet problem??? :blush:

Quote:

---

Originally Posted by kobra8

Thanks ScriptJunkie, on help. I upload :-)

But in report -Visiting Countries Stats- I don't get name of Country end flag?!

Hay to solve thet problem??? :blush:

---

That's not something I can help you with, as I'm not familiar enough with this mod. You're going to need the help of the mod's developer or someone experienced with this mod.

My guess would be that maybe something didn't install correctly - meaning that perhaps files did not get installed to the correct folder, or files were corrupted during upload.

My first step whenever I'm missing data is to go back and make sure I correctly renamed custom folders (if any) and then double check if all the files are in the right place.

If all looks good from there, I re-upload the files. I also use the Firefox browswer with the Firebug addon to look at pages that aren't displaying correctly. This helps provide me with information I can use to help diagnose problems.

The developer's toolkit in the admin is also very helpful, but you have to know what you're looking for - which is where Firebug comes in handy.

My install (after some reading here) was working perfectly... Notice logs since last night now show twice in the "Last 10 visitors"

Any ideas anyone?

Thanks