Supertracker

[CnTGifts]

Think you could add a report that shows keywords the yuse when they use the search function on site.

I think that would be a grea taddition to the mod

Thanks

[warstormer]

Hi, I've installed all the files, installed the sql but get a completely blank page when I go to Reports > Supertracker. I've now re-installed the database and the sql but still get the blank page... any ideas?

never mind, going for idiot of the year award... realised the supertracker.php for the admin root was missing...

[CnTGifts]

is this mod supported anymore

[Necsy]

Hi, sorry for my english is very bad...

I haved installed supertracker 1.0, have zencart 1.3.7 (3)*

* Italian version

Aved read the doc, installed files php in correct path, patched sql file, patched this sql mod:

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;

And have evry this error:

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]
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.
Database Info: the Supertracker database currently holds 2 rows (oldest record : 12/14/2007 )

Haved read 3 times all posts, is a possible who for my little english no have find the solution, sorry in this case...

Thanks in advance.

[Necsy]

Ehm sorry.. have evry this error if call last 10 visitors and report country visitors... :)

[longstockings]

This mod is excellent.

Just one problem though. I receive this error when trying to delete records. This is installed on a 1.3.8a shop running on Mysql version 3.23.58 and PHP 4.3.11

--------------------------

1064 You have an error in your SQL syntax near 'ORDER by tracking_id ASC LIMIT 1' at line 1
in:
[DELETE FROM supertracker ORDER by tracking_id ASC LIMIT 1]
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.

--------------------------

Any help would be most appreciated.

[a_berezin]

This is your problem:

Mysql version 3.23.58

[longstockings]

Unfortunately as I am just working freelance for a web design company so I can't change the mysql database version but was surprised to see such an early version.

I did however solve the issue by removing the enter rows text field and changing the sql so that it deletes all rows.

Works a treat now but don't have access to the server anymore so cannot post it. I did however find the solution on the Oscommerce forums

[a_berezin]

Hi, sorry for my english is very bad...

My English is also very bad. So bad that some are allowed to laugh over this. But, unlike them, my php is good

Your problem is uncorrect settings of collations in your data base tables. You must set latin1_general_ci collation for ALL your tables in data base.

[a_berezin]

I did however solve the issue by removing the enter rows text field and changing the sql so that it deletes all rows.

This is not the solution. This change functionality. Previously, it was possible to remove the old record, but now you remove all statistics!