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

Quote:

---

Originally Posted by 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

Code:

---

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:

Code:

---

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...

Code:

---

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.

Quote:

---

Originally Posted by aeisecurity

i get the following error...

Code:

---

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

---

---

What mySQL version?