Supertracker

[Strefa-Buddy]

Hello,

I've just installed supertracker and...
For some hours it collected 0 records and after that I've discovered that my site works only if opened from clients from the exclude list.

Any other clients do not open the site at all :-( They are waiting and waiting and waiting...

I've disabled the mod by changing the name of jscript_supertracker.php file to jscript_supertracker.php.bak.

Any ideas?

[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

[CnTGifts]

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']

[DrByte]

As I said in your other thread, that looks like an unsanitized database insert, which could lead to sql injection, which is very bad.

[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