Supertracker

Hi Guys,

Ive had this mod installed for a while now, but for some reason it doesnt track Top Sales Generating Referrers.

Has anyone else noticed this ? Im also using Super Orders so not sure if this would make a difference ?

Thanks
Shane

Hi guys,

I'm running this mod on ZC 1.3.8 and it's been running fine for the first couple weeks and then yesterday my "last ten visitors" reports started feeding me some wacky info. Like each visitors clicking 50-60 times per visit. On a 1-5 minute visit.

Obviously, that's not right.

Also the product viewed images don't show up neither. It shows a "no picture available" picture. All but one of my products have images, so I don't think that's the problem. Not likely that they're all looking at the same product!

Anybody have an idea what the problem could be?

Thanks,
Brian

a_berezin:

This is your problem:
Quote:
Originally Posted by longstockings
Mysql version 3.23.58

Hello Andrew & other Luminaries

Totally new to Zen & not a foggiest idea about sql ... please help. On running Install.sql get this message

"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 's', 'XTRACKING_EXCLUDED_IPS', '127.0.0.1', 'Comma Separate List of IPs which sho' at line 1" ... it continues ...

Is this mod compatible with the MySQL 4.1.22-standard I'm running?
Is there a change to Install.sql I must make to get it working?

Thanks in advance ... Jaap

is SuperTracker Module purpose to track daily Visits like (bots, etc.)?

I am not getting my daily visit like I should. It only shows 2 for the past week.

I usually get about 10 to 20 a day, its not recording them.

Why is it doing this?

Wade

I've installed this mod and it says ***Database Info: ** **the Supertracker database currently holds 0 rows.

*I have geoip.inc and geoip.dat installed in admin/includes. Any suggestions?

Thanks!

SuperTrack Mod. isn't Tracking the Vistors for the last 5 days it shows 0 in the database and I get about 50 a day then why isn't tracking the visitors?

SuperTracker is still not recording visitors like it should what is wrong?

Wade

Hello Everyone - i installed this mod to my Zen Cart installation v1.3.7 and for some reason i cant install part of the SQL file

i split it up into parts and the following sections went through ok

SET @configuration_group_id=0;
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Super Tracker' LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Super Tracker', 'Super Tracker Configuration', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES 
(NULL, 'Excluding IP\'s', 'XTRACKING_EXCLUDED_IPS', '127.0.0.1', 'Comma Separate List of IPs which should not be recorded, for instance, your own PCs IP address, or that of your server if you are using Cron Jobs, etc', @configuration_group_id, 1, NOW(), NULL, NULL),
(NULL, 'Excluding UserAgent\'s', 'XTRACKING_EXCLUDED_UA', 'ServiceUptime.robot', 'Comma Separate List of UserAgent\'s substring which should not be recorded', @configuration_group_id, 2, NOW(), NULL, NULL),
(NULL, 'Excluding bot\'s', 'XTRACKING_EXCLUDE_BOTS', 'true', 'IP\'s Excluding from logging', @configuration_group_id, 3, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');

but i could not insert the last part:

DROP TABLE IF EXISTS `supertracker`;
CREATE TABLE `supertracker` (
  `tracking_id` bigint(32) NOT NULL auto_increment,
  `ip_address` varchar(15) NOT NULL default '',
  `browser_string` varchar(255) NOT NULL default '',
  `country_code` char(2) NOT NULL default '',
  `country_name` varchar(100) NOT NULL default '',
  `customer_id` int(11) NOT NULL default '0',
  `order_id` int(11) NOT NULL default '0',
  `referrer` varchar(255) NOT NULL default '',
  `referrer_query_string` varchar(255) NOT NULL default '',
  `landing_page` varchar(255) NOT NULL default '',
  `landing_page_name` varchar(255) NOT NULL,
  `exit_page` varchar(255) default NULL,
  `exit_page_name` varchar(255) NOT NULL,
  `time_arrived` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_click` datetime NOT NULL default '0000-00-00 00:00:00',
  `num_clicks` int(11) NOT NULL default '1',
  `added_cart` varchar(5) NOT NULL default 'false',
  `completed_purchase` varchar(5) NOT NULL default 'false',
  `categories_viewed` varchar(255) NOT NULL default '',
  `products_viewed` varchar(255) NOT NULL default '',
  `cart_contents` mediumtext NOT NULL,
  `cart_total` int(11) NOT NULL default '0',
  PRIMARY KEY  (`tracking_id`),
  KEY `ip_address` (`ip_address`),
  KEY `last_click` (`last_click`),
  KEY `customer_id` (`customer_id`),
  KEY `browser_string` (`browser_string`),
  KEY `cart_total` (`cart_total`)
) ENGINE=MyISAM;

i get the following error...

1064 You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 1
in:
[CREATE TABLE supertracker ( tracking_id bigint(32) NOT NULL auto_increment, ip_address varchar(15) NOT NULL default '', browser_string varchar(255) NOT NULL default '', country_code char(2) NOT NULL default '', country_name varchar(100) NOT NULL default '', customer_id int(11) NOT NULL default '0', order_id int(11) NOT NULL default '0', referrer varchar(255) NOT NULL default '', referrer_query_string varchar(255) NOT NULL default '', landing_page varchar(255) NOT NULL default '', landing_page_name varchar(255) NOT NULL, exit_page varchar(255) default NULL, exit_page_name varchar(255) NOT NULL, time_arrived datetime NOT NULL default '0000-00-00 00:00:00', last_click datetime NOT NULL default '0000-00-00 00:00:00', num_clicks int(11) NOT NULL default '1', added_cart varchar(5) NOT NULL default 'false', completed_purchase varchar(5) NOT NULL default 'false', categories_viewed varchar(255) NOT NULL default '', products_viewed varchar(255) NOT NULL default '', cart_contents mediumtext NOT NULL, cart_total int(11) NOT NULL default '0', PRIMARY KEY (tracking_id), KEY ip_address (ip_address), KEY last_click (last_click), KEY customer_id (customer_id), KEY browser_string (browser_string), KEY cart_total (cart_total) ) ENGINE=MyISAM;]
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 am running supertracker on zc 1.3.8a. The product images and flags are not showing (for example.. in the last ten visitors section). I have been unable to find the source of this problem. Any assistance would be appreciated.

aeisecurity:

i get the following error...

1064 You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 1

What mySQL version?

Hello a_berezin ,

Thank you for your reply.

the version of mysql running on my server is 5.0.22

AeiSecurity.

Hi, I got the problem with original files from http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=683

I can't read and open file - includes/classes/supertracker.php
its probably broken, I try multiply downloads, please if you can send me the right file and upload file to the contribution on downloads.

my mail: mano ( at ] sonshi . pl

thx!

when I install the SQL, i got these msg...

Success 10 statements processed.
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

pls advise. thanks in advance.

I have a problem with my site ronloganhealth.com. I loaded the sql database by opening it up in notepad and copied and pasted it over to the sql path loaded in my zen cart admin and had no errors. I copied over the files to all of the directories with no issue, but when I try to load my site nothing comes up. a blank screen and nothing else but the words Done at the lower left hand corner of my browser.

Doah!

Make sure you copy over all of the files. I missed one the geoip.inc in the includes directory.

If it dosent work double check that you loaded all of the files.

I am trying to exclude my ip address from the Supertracker results. One problem thought, it seems that everytime I open my browser, I have a new IP address. As you can imagine this will badly skew the statistics results. Is there any solution to this problem?

Hello Everyone,

I have recently upgraded to ZenCart 1.38 and now am having problems with some of the functions of SuperTracker. It worked great on my 1.37 version. Does anyone know if it works well with 1.38? The areas I am having trouble with is the successful checkouts and bailed carts on the last 10 visitors page. I've tried reloading the files and nothing has changed....any thoughts out there?:(

Tot 2 Teen:

Hello Everyone,

I have recently upgraded to ZenCart 1.38 and now am having problems with some of the functions of SuperTracker. It worked great on my 1.37 version. Does anyone know if it works well with 1.38? The areas I am having trouble with is the successful checkouts and bailed carts on the last 10 visitors page. I've tried reloading the files and nothing has changed....any thoughts out there?:(

What do you mean by "The areas I am having trouble with is the successful checkouts and bailed carts on the last 10 visitors page"
We are using this mod with zc138a without problem. How did you concluded that cart abandonement is due to this mod?

Thanks!

I just re-install supertracker, the installation seems fine, I can see it under admin/configaration, and admin/Reports.
But the problem is : it alwasy says: the Supertracker database currently holds 0 rows. I can use "Who's online" to see there are more than 10 visitor already, how come supertracker couln't catch any record?

Thanks

I have the same problem. I am running zen 1.3.7 and SuperTracker. I have a text box option for products where the customer can type a gift card message. If you place a apostrophe in the text box and hit add to cart the following message is displayed - and the browser must be closed and reopened so clearly losing sales here when this happens!

(to make this easier to read note that the text I entered to generate this message was... test'test (note apostrophe)

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 'test";}}}', cart_total = '246.99', order_id = '0' WHERE tracking_id='411'' at line 1
in:
[UPDATE zen_supertracker SET last_click = NOW(), exit_page='/index.php?main_page=shopping_cart&number_of_uploads=0', exit_page_name='The Shopping Cart', num_clicks=num_clicks+1, added_cart='true', categories_viewed='a:3:{i:99;i:1;i:1;i:1;i:100;i:1;}', products_viewed='*149?', customer_id='1742', completed_purchase='false', cart_contents='a:1:{s:36:"149:aaa5db04b044c7dceb59b62a2f9b462c";a:3:{s:3:"qty";d:1;s:10:"attributes";a:3:{i:1;s:1:"1";i:2;s:1:"5";i:3;s:1:"0";}s:17:"attributes_values";a:1:{i:3;s:9:"test'test";}}}', cart_total = '246.99', order_id = '0' WHERE tracking_id='411']

chrisroge:

If you place a apostrophe in the text box and hit add to cart the following message is displayed - and the browser must be closedDid you apply the patch shown in a_berezin's previous message?
That patch is critical, because it adds the zen_db_input function to the update process.
Which in turn calls PHP's 'addslashes' function to add the needed ** in front of the single quote, double quote, and backslash.
Your parse errors should go away.

Juxi