Since upgrading to PHP 5.3, this mod no longer works. Bailed carts, Successful Checkouts and other features are not working on PHP 5.3
Does anyone know if the author will be releasing a PHP 5.3 compatible update as I really liked this mod a lot.
Printable View
Since upgrading to PHP 5.3, this mod no longer works. Bailed carts, Successful Checkouts and other features are not working on PHP 5.3
Does anyone know if the author will be releasing a PHP 5.3 compatible update as I really liked this mod a lot.
The "SuperTracker" is the principal input source for Federal Express' Cosmos II Package Tracking System, which won the prestigious Malcolm Baldridge award for technical excellence in 1990. It also gave them a significant advantage in this highly competitive market.http://sunrent.de/smileynormal.ico
The SuperTracker hand-held device carried by FedEx collection and delivery agents uses a Hitachi 6303 8-bit microcontroller. It has a 32K PROM and extended RAM for program and data storage. A bar-code scanner in the tip of the SuperTracker device is used to scan package IDs which are kept, along with other data entered from the keyboard on the device, in a database in the RAM. The scanner is also used to communicate with a processor in its rack, which contains a battery charger and a RF transmitter used for up-loading package information to the computers at the FedEx regional centres.http://sunrent.de/smileynormal.ico
Did you get this to work for you?Quote:
Originally Posted by limelites
I been having the same problem.... for now, soved it by removing the time checks...
includes\classes\supertracker.php
Removing this from the sql tests... all three tests.
Got my bailed and completed carts back... also its tracking the same user in one entry now.Code:AND last_click > '" . $thirty_mins_ago . "'
From my testing it look like a difference in server and MySQL database times, but I couldn't resolve it without removing the time tests.
Thanks for posting this fix, works like a charm for me. I'm so glad to have my bailed carts and single user tracking back that I couldn't carre less about the time checks. Thank you!Quote:
Originally Posted by davewest
After running without the time test for a while.... its is needed.Quote:
Originally Posted by limelites
I went back and started testing to see what or how to do time... and I think its a difference in MySQL database time and server or scripting time.... anyway, inshort, found that using the standard NOW() in the SQL statement to store the time was setting the clock different then the server time. (I changed the time in php.ini not the PC) Put the checks back in as they was and add this line above them.. line in red.
Then down near the bottom make the changes to the SQL statements that are in red..Code:$arrived_time = date('Y-m-d H:i:s', time());
$thirty_mins_ago = date('Y-m-d H:i:s', (time() - (30*60)));
and in the next set below the last one...Code:$db->Execute("UPDATE " . TABLE_SUPERTRACKER . "
SET last_click = '" . $arrived_time . "',
exit_page='" . zen_db_input(zen_db_prepare_input(urldecode($_SERVER['REQUEST_URI']))) . "',
exit_page_name='" . $page_title . "',
num_clicks=num_clicks+1,
added_cart='" . zen_db_input($tracking_data->fields['added_cart']) . "',
categories_viewed='" . zen_db_input($categories_viewed) . "',
products_viewed='" . zen_db_input($tracking_data->fields['products_viewed']) . "',
customer_id='" . (int)$customer_id . "',
completed_purchase='" . zen_db_input($completed_purchase) . "',
cart_contents='" . zen_db_input($cart_contents) . "',
cart_total = '" . zen_db_input($cart_total) . "',
order_id = '" . (int)$order_id . "'
WHERE tracking_id='" . (int)$tracking_data->fields['tracking_id'] . "'");
This is working for me so far.... you can test this on a testing server by setting the php.ini timezone to something other then your PC timezone....Code:$db->Execute("INSERT INTO " . TABLE_SUPERTRACKER . "
(ip_address,
browser_string,
country_code,
customer_id,
referrer,
referrer_query_string,
landing_page,
landing_page_name,
exit_page,
exit_page_name,
time_arrived,
last_click,
products_viewed)
VALUES ('" . zen_db_input($_SERVER['REMOTE_ADDR']) . "',
'" . zen_db_input($user_agent) . "',
'" . $country_code . "',
'" . (int)$_SESSION['customer_id'] . "',
'" . zen_db_input($referrer) . "',
'" . zen_db_input($referrer_query_string) . "',
'" . $this_page . "',
'" . $page_title . "',
'" . $this_page . "',
'" . $page_title . "',
'" . $arrived_time . "',
'" . $arrived_time . "',
'" . zen_db_input($products_viewed) . "')");
What you see in the code above may be different then what you have in your file..... Please edit and not copy&paste.... then backup your database before running the code....
Can someone upload a corrected version? It seems that there is some errors after reading this thread and I am running the latest v1.3.9g. Or can someone point us to a corrected version on the internet?
I would appreciate this also. Am upgrading now and really love Supertracker!Quote:
Originally Posted by nohart
Hi,
First of all thank you for the great extension.
I have a problem with countries codes - they are not stored in the table; the filed 'country code' is always '--'. What may be the reason? I use ZC v. 1.3.9h.
Best regards,
Stan
Sorry, that's my fault. I did not install GeoIP.dat...
Hello,
It seems to me there is something missed from the file admin/supertracker.php. When I choose Top Landing Pages (No Sale, but added to cart) from the pull-down list (language variable: TEXT_TOP_LANDING_PAGES_NO_SALE) there is no result displayed.
I have added this piece of the code:
[FONT="Courier New"]case 'landing_added':
$title = TEXT_TOP_LANDING_PAGES_NO_SALE;
$headings[] = TEXT_SERIAL;
$headings[] = TEXT_LANDING_PAGE;
$headings[] = TEXT_NUMBER_OF_OCCURRENCES;
$row_data[] = 'landing_page';
$row_data[] = 'total';
$tracker_query_raw="SELECT landing_page, COUNT(*) as total FROM " . TABLE_SUPERTRACKER . " WHERE completed_purchase='false' AND added_cart='true' GROUP BY landing_page ORDER BY total DESC";
break;
[/FONT]
after the line 292. Now it is OK.
Am I right?
Best regards,
Stan
Good catch....Quote:
Originally Posted by stanislawl
replace TEXT_LANDING_PAGE with TABLE_TEXT_LANDING_PAGE
Hello again,
I have a problem with my website http://www.olaf.legnica.pl. Yesterday everything was OK and today... The correct look of the website is in shown in pic. 1. This morning it changed to the blank screen shown in pic. 2. The problem may be corrected by deleting the file includes/MY_TEMPLATE/jscript/jscript_supertracker.php. What's going on? Have I made something wrong?
Best regards,
Stan
I have just received information from my hosting company. The error results from problems with GeoIP functionality. I will post details when I have them.
Regards,
Stan
Had to look back some, forgot I deleted that file and set up an autoloader for it...
Basically, all it does is load the class file for supertracker, however, if scripting is turned off, then you never see the visitor, thus the conversion to the autoloader which doesn't rely on scripting to run the class.
GeoIP works with 1.3.9-h... I'm using the latest ofQuote:
I have just received information from my hosting company. The error results from problems with GeoIP functionality. I will post details when I have them.
GeoIP.dat
geoip.inc
I have mine in the includes folder.... no sure what the instructions say... but the class file is looking for them there. Did you look to see what the bug file has to say in your folder cache for the blank page...
Is the version in the downloads section compatible with 1.3.9 or is there a version that needs to be updated? Can someone update the downloads section. I am updating my site and I really want to put this module on the site.
Thanks in advance
Hi all,
I went to http://geolite.maxmind.com/download/geoip/database/ but there are many versions of (purportedly) the same thing.
[ ] GeoIPCountryCSV.zip 02-Nov-2010 12:06 1.9M
[ ] GeoIPv6-20100831.csv.gz 03-Sep-2010 07:35 228K
[ ] GeoIPv6-20100831.dat.gz 03-Sep-2010 07:35 637K
[ ] GeoIPv6-20100929.csv.gz 02-Oct-2010 15:04 234K
[ ] GeoIPv6-20100929.dat.gz 02-Oct-2010 15:04 646K
[ ] GeoIPv6-20101031.csv.gz 02-Nov-2010 13:31 244K
[ ] GeoIPv6-20101031.dat.gz 02-Nov-2010 13:31 648K
[ ] GeoIPv6.csv.gz 02-Nov-2010 13:31 244K
[ ] GeoIPv6.dat.gz 02-Nov-2010 13:31 648K
[ ] GeoLiteCity.dat.gz 02-Nov-2010 16:38 18M
1. Which file should I use?
2. Is it possible to use GeoLiteCity.dat? It is the largest archive and (I assume) would provide the most complete location data.
Very interested in this mod but cant seem to figure out if it is up to date with the latest zencart version and where I should get it from. Any help would be appreciated. Thanks
I'm in the process of upgrading to V1.3.9h and I installed the latest version from the downloads yesterday without any problems.
When you say the installed the latest version from downloads does this mean the version in the downloads works with 1.3.9h?Quote:
Originally Posted by Brent
Is the one in downloads php5.3 ready?
Thanks
It did for me. Everything seemed to work out the box.
I can't help you with regards php 5.3 though as my host is running 5.2.12
Very nice Module! loved it!
Am using 1.3.9h, and recenlty installed the supertracker to try and get some reports etc, but after a minor tweak in the tables of the database, I am still having a problem.
I was lead to believe that once installed, there would appear a box in the admin page, under configuration where you could set a few things up for this work, including adding your own IP address to make sure that it doesn't get recorded in the tracking.
However, when i click on supertracker in the configuration part, it comes up blank.
Any suggestions?
Did you install your SQL patch and the GeoIP.dat file? That could be a problem.
I didn't need to do any tweaking to any files of supertracker and I'm running a fresh install of 1.3.9h, except for some template and side box installs; everything is running perfect.
I've used Supertracker about a year ago, and never installed GeoIP.dat before. I don't know what its for, but I installed it anyways. It seemed to work without it just fine...
I downloaded the supertracker mod today and installed it today. no further tweaks or mods needed for 1.3.9h. as far as I can see.
wanted to post screen shots of the config supertacker page and reports supertracker page. And note that i'm using php 5.2.17.
http://magickalingredients.com/shop/images/screen02.jpg
http://magickalingredients.com/shop/images/screen01.jpg
Thanks Magickal, you pointed me in the right direction on this one. I had installed the sql patches but, it had installed the config items into group 0, rather than into the correct group. I have subsequently altered that and it now works. Thank-you for the pointer.
I installed this mod supertracker_1-0_Fix_20100414 last night and ran the install sql to my 1.3.9h shop, but for some reason the site shows up as a blank page after the install... back end works though.. any idea whats wrong here?
Installed the module and its quite impressive. Dont have any sort of problem with it just a minor thing that for Country option, it shows colorful Line only... something i missed or something?)) But thank anyways, all other options are working perfectly fine.
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--
When I deleted the template/jscript file, everything works perfectly ... with the jscript_supertracker.php file the website page is blank... weird
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.
I am also getting this error when trying to run a couple of reports..Quote:
Originally Posted by alivewjesus
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 rorrock
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 gnro
Quote:
Originally Posted by rxalex
- Put back the js file you deleted.
- Blank pages mean you have a syntax error or corrupted file (which can sometimes happen during upload).
- 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.
- 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
- 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.
- 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.
- Check out this tutorial, but ignore the section on installing and using the debugging tool, as this is already installed in ZC139.
- 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
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
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
Thanks but still getting blank page.. the debugging report is as followsQuote:
Originally Posted by ScriptJunkie
[28-Mar-2011 16:24:46] PHP Fatal error: Cannot redeclare class supertracker in /home/on233/public_html/dir/includes/classes/supertracker.php on line 15
any help would be appreciated
I am getting the exact same problem as rxalex. Any fixes yet?
I'm not that well versed in deciphering php error logs. Try searching the entire form for "cannot redeclare class" and see if any threads come up for this or other mods with that error. It might get you pointed in the right direction.
I had a couple errors, but have it working correctly now. Here is what I did to fix each problem:
Error #1 - After installing, my website came up blank. The error log came up as : Cannot redeclare class supertracker in /home/on233/public_html/dir/includes/classes/supertracker.php on line 15
I deleted the install and reinstalled. This fixed it.
Error#2 - Received the following error on the country and last 10 visitors report: 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]
I went into PhpMyAdmin, opened the supertracker table, clicked select all, then edit. I changed all the offending "latin1_swedish_ci" to "latin1_general_ci". This fixed it.
Thank you for the tidbits of help I read on this thread so that I could fix these errors.
Kim
And I spoke too soon. I'm still getting the blank page after reinstalling the mod.
Still getting PHP Fatal error: Cannot redeclare class supertracker in /home2/XXXXXX/public_html/includes/classes/supertracker.php on line 15
The only thing on line 15 is:
class supertracker {
I know absolutely nothing about PHP, but the jscript file seems a little odd. All the other jscript files in the folder have a suffix of .js, whereas this one is named js_supertracker.php. Is this an error?
I'm running PHP 5.2.16.
Any help is greatly appreciated.
Kim
I believe this error message is telling you that some other file is trying to call (or declare) the supertracker class for that page. Meaning that two different files are calling the same class (supertracker) for the same page. This is causing a conflict that can't be resolved, and so the fatal error (stop loading page) results.
To resolve the problem, I believe you have to identify all the files that are calling (or declaring) the class (i.e the code that's on line 15) and remove one of them.
I don't have the faintest idea how to advise you re: where to start. I suggest searching the forum for " PHP Fatal error: Cannot redeclare class" and see what comes up. You might find some instructions on how to handle this kind of error.
You could also do a google search on it.
Sorry I couldn't be of more help
A google search of "cannot redeclare class" brought up this site. See if the info there helps you out a little bit.
To find all the places this class is declared (usually more than once in a single file, but can also be only once in more than one file), try logging in to your ZC admin, and going to tools>>Developer's Toolkit.
Go down to "Look-Up in all Files". In the all files field, select all files. Check "case sensitive" and then in the box, paste in the code from line 15 class supertracker {
See which files that come up that are declaring (calling) this class, or if it's being called more than once in one file.
Armed with that info, you can go to the forum's general support board and start a new thread and provide all the details of your research and request help in fixing it.
Good luck :)
Hi ScriptJunkie,
I've been working on deducing the number of files it could be. I copied this website from another website I created. So, I downloaded supertracker onto the old website. It worked fine.
Then on this website I changed it back to the classic template and the tracker worked fine (or at least it didn't give me a blank page).
So, it's got to be a template file that doesn't exist in the classic template, and that I've changed since copying the website. I've also added about 4 other mods to this website. But I guess if the classic template works fine with those other mods installed, it wouldn't be any files from those mods.
I did the search from the Developer's Tool Kit for "class supertracker" but came up empty except for the original file. Tomorrow I'll be going through my files with a fine tooth comb. I'll let you know what my findings are, as it may help someone else who has the same problem.
Kim
Hmm...those are some interesting results....makes me wonder if it's the file itself that's being called more than once. That can happen when two identical javascript files are competing against each other.
Since it only happens with the current template, makes me wonder if the mod and the template have battling js files. I have no idea how to advise on that though.
Your next step might have to be putting all your results into a new thread in the general support forum.
Quote:
Originally Posted by WriteAtHome
Can I use supertracker outside of zen-cart, like on a portal page if zen-cart is installed in /cart ? Thanks.
Hi - i am trying to get this going to. I have installed ST, there are entries in zen_configuration_group and zen_configuration and a zen_supertracker table too. I see the four config options in Configuration, Super Tracker.Quote:
Originally Posted by Woodymon
I installed supertracker_1-0_Fix_20100414 into ZC v1.3.9h
The issue is i don't see anything under Reports. Where should i start checking?
Many many thanks in advance!
doh - people if you do this, make sure you install into your admin folder, not the default one if you have changed it!!!!!!
I installed it on 1.3.9h but my front end comes out blank...
Hello,
I have used this mod before and love it.
Is the author going to bring out a new version for 1.39h?
Kind regards,
Anthony
I want off supertracker, how do i do this?
Andy.
Uninstall it.Quote:
Originally Posted by Andy_GS
- In the download pack for this mod, there is an uninstall.sql file.
- Run it.
- Look at the read_me for a list of files you uploaded when you installed the mod.
- Delete them.
Thanks Script,
a previous developer installed it several years ago, and recently it's started locking up database tables killing our shop.
thanks again, ill take a look
Andy.
You can go to the "Free Software Addons" link at the top of this page. Once there, search Supertracker. Download the installation pack and have a look at the Read_Me file.Quote:
Originally Posted by Andy_GS
It will tell you which files were originally installed - those are the files you want to delete. It will also contain a file called uninstall.sql - you will want to run it.
Take a look in your database and/or the Supertracker configuration settings in the admin to find out what version you are running.
It's very important that you download the same version pack you have installed so that you get the correct uninstall.sql file and the correct list of installed files.
Back up your store and database before you make the changes.
Does anyone know what it means when Time On Site (Looking at LAST 10 VISITORS) reads 0hrs 0mins 0 seconds?
Are these real visits? or robots? or some other program?
Hi all,
Just started to install this and everything seems to be good, however the link in the Readme file to download the flags is no good. I browsed the main site for a download for the flags and nothing available.
Anyone know of a solution or where I can find the flags to install?
Thanks much in advance.
I tried to upload the file here in this post, but it is to big :(
These are spiders crawling your site.Quote:
Originally Posted by BrooklynArtist
Apparently that site doesn't offer the image package anymore. If you PM me your email address, I'll email you the zip file. It's a small file, but still exceeds the forum's upload limit - which is ridiculously tiny - especially by today's standards.Quote:
Originally Posted by KeystoneAirsoft
Hello ScriptJunkie,
THank you very much. PM has been sent.
YW - file sent via email :smile:Quote:
Originally Posted by KeystoneAirsoft
Found by Google - Flag Icons - famfamfam.com/lab/icons/flags/
When a customer was adding an item to cart, and entered a message in a text box they got this error
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'll miss seeing you at firepot. Love, Wally & Di";}}}',
cart_total = '32', ' at line 1
in:
[UPDATE supertracker SET last_click = NOW(), exit_page='/', exit_page_name='Home', num_clicks=num_clicks+1, added_cart='true', categories_viewed='a:1:{i:1;i:1;}', products_viewed='*5?', customer_id='0', completed_purchase='false', cart_contents='a:1:{s:34:"5:8a3aabda91bb03ac02bdd7c92b2f9bdf";a:3:{s:3:"qty";d:1 ;s:10:"attributes";a:3:{i:3;i:2;i:7;s:1:"0";i:1;s:1:"0";}s:17:"attributes_values ";a:2:{i:7;s:71:"2";i:1;s:74:"Merry Christmas. We'll miss seeing you at firepot. Love, Wally & Di";}}}', cart_total = '32', order_id = '0' WHERE tracking_id='41896']
As I said in your other thread, that looks like an unsanitized database insert, which could lead to sql injection, which is very bad.
Does anyone know if this mod will be updated for the newest version of Zen Cart 1.5?
Yes, it will be. Updates more than compatible with 1.5.0.Quote:
Originally Posted by draw4fun
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 FormatQuote:
Originally Posted by fjutt
unpack the file and upload it to your shop.
I managed to get it working now in 1.50, see this thread http://www.zen-cart.com/showthread.p...t=supertrackerQuote:
Originally Posted by draw4fun
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.
Thank you for this upgrade - I did not have enough time.Quote:
Originally Posted by Design75
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 :)Quote:
Originally Posted by 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:cool:, Zen Cart is a team effort.
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
you will need to change your character set in your database for super tracker to be the same as the rest.
Execute this SQL-code:Quote:
Originally Posted by kappy1
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 '';
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?
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.Quote:
Originally Posted by Design75
When installing, did you rename the YOUR_TEMPLATE folder to your own template for
?PHP Code: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.phpQuote:
Originally Posted by Design75
:( grr. so it is nothing obvious
yeah, I went thru and double checked that all the filese were in the correct place. I am somewhat capable but I have not idea why its not working.Quote:
Originally Posted by Design75
and I am guessing your cache folder is also empty? still can't reproduce the error:frusty:Quote:
Originally Posted by sicivic89
cache folder on my internet browser? I've tried multiple browsers and get the same.Quote:
Originally Posted by Design75
Ok. I got it working! Under my FTP site, I have a bunch of folders such as includes, public_html, and www. My admin folder is under www. I added the "includes" appropriate files under the listed includes directory, but if I expand out my public_html folder, there is another includes directory there. I added the appropriate files here and it worked. Thank you for your time Design75!!!
Just glad you found the problem :flex:
I had tried it on my local machine (zencart v1.5.1). The main page couldn't be loaded when I added the jscript_supertracker.php to the site. When it was installed, I haven't saw the installation confirmation message, but the Configuration page was here.
Attachment 11393
I am not sure why, but the installation message does not always show. does your site work now? If not, i will need a link to your site, otherwise it is almost impossible to know why it is not workingQuote:
Originally Posted by su35
Thanks Design75
I tested it on localhost and couldn't send you a link.
If I copy the jscript_supertracker.php to the site
Attachment 11395
The homepage couldn't be loaded
Attachment 11396
Below is the Page Source shown the stop point(from the firefox)
Attachment 11397
Code:<link rel="stylesheet" type="text/css" href="min/?f=/includes/templates/CPE02/css/style_dynamic_filter.css,/includes/templates/CPE02/css/stylesheet.css,/includes/templates/CPE02/css/stylesheet.css.back.css,/includes/templates/CPE02/css/stylesheet_random.css&1340329967" />
<script type="text/javascript" src="min/?f=/includes/templates/CPE02/jscript/jscript_mfunction.js,/includes/modules/pages/index/jscript_tabs.js&1340329967"></script>
What happens if you turn off minify?
no help.
Code:<link rel="stylesheet" type="text/css" href='/includes/templates/CPE02/css/stylesheet.css.back.css' />
<link rel="stylesheet" type="text/css" href='/includes/templates/CPE02/css/stylesheet_random.css' />
<script type='text/javascript' src='/includes/templates/CPE02/jscript/jscript_mfunction.js'></script>
<script type='text/javascript' src='/includes/modules/pages/index/jscript_tabs.js'></script>
page loading was stopped here
are there any debug-log files that could give us a hint? (found in the cache or log folder)
The error information. It looks like declare the class twice. Do I need change the code to include_once() or require_once() in some where?
Code:PHP Fatal error: Cannot redeclare class supertracker in H:\zencart15\includes\classes\supertracker.php on line 15
do a search for "class supertracker" in your fileset in the frontend of the shop. You probably have a rogue file somewhere where this class is also mentionted it should only be in \includes\classes\supertracker.php
I searched whole site by Xsearch. The "class supertracker" appeared in supertracker.php only.
I have send you a PM