Supertracker

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

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

is this mod supported anymore

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

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.

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

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.

This is your problem:

longstockings:

Mysql version 3.23.58

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

Necsy:

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 :smile:

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.

longstockings:

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!

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

Lol! Will we say that a nice pair in English discussions :P

I never questioned your php the contrary, your expected contribution not to disasters :D

Now everything is working and it is truly a beautiful mod, I thank you very much, good job. :clap:

Hi gang..

Slightly unusual and different problem. I have this mod installed on 2 carts. Works fine on one and the other, works fine but some things are not logged.

Ex: In the last 10 visitors list, it doesn't show people adding stuff to the cart, their names, etc. It shows activity, but not the actual things like the sales and such once a user is logged in.

In my first install, it works fine and shows all that stuff. Any ideas why that might not be showing that info like normal? Thanks!
:frusty::cool:

a_berezin:

I you use module from dl-area replace

$db->Execute("UPDATE " . TABLE_SUPERTRACKER . " SET last_click = NOW(), exit_page='" . zen_db_prepare_input(urldecode($_SERVER['REQUEST_URI'])) . "', exit_page_name='" . $page_title . "', num_clicks=num_clicks+1, added_cart='" . $tracking_data->fields['added_cart'] . "', categories_viewed='" . $categories_viewed . "', products_viewed='" . $tracking_data->fields['products_viewed'] . "', customer_id='" . $customer_id . "', completed_purchase='" . $completed_purchase . "', cart_contents='" . $cart_contents . "', cart_total = '" . $cart_total . "', order_id = '" . $order_id . "' WHERE tracking_id='" . $tracking_data->fields['tracking_id'] . "'");

> 
> by
> 
> ```
$db->Execute("UPDATE " . TABLE_SUPERTRACKER . " SET last_click = NOW(), 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='" . $tracking_data->fields['added_cart'] . "', categories_viewed='" . $categories_viewed . "', products_viewed='" . $tracking_data->fields['products_viewed'] . "', customer_id='" . $customer_id . "', completed_purchase='" . $completed_purchase . "', cart_contents='" . $cart_contents . "', cart_total = '" . $cart_total . "', order_id = '" . $order_id . "' WHERE tracking_id='" . $tracking_data->fields['tracking_id'] . "'");

P.S. Why you talk about ' in products name? Error when ' in uri.

Hi
Have a similar issue but the above code did not fix it. Not sure what else is wrong. Any help is appreciated. Error shows up when an " 's " is done with names.

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 peak needed.";}}}', cart_total = '749', order_id = '0' WHERE tracking_id='1431' at line 1
in:
[UPDATE supertracker SET last_click = NOW(), exit_page='/index.php?main_page=shopping_cart&number_of_uploads=2', exit_page_name='Your Shopping Bag', num_clicks=num_clicks+1, added_cart='true', categories_viewed='b:0;', products_viewed='*152?*218?*199?', customer_id='106', completed_purchase='false', cart_contents='a:1:{s:36:"218:5e68c4e2abb050dcafedc16da51fb45c";a:3:{s:3:"qty";d:1;s:10:"attributes";a:24:{i:67;s:3:"329";i:80;s:3:"383";i:23;s:2:"20";i:50;s:2:"43";i:28;s:2:"21";i:59;s:3:"297";i:24;s:2:"46";i:26;s:2:"49";i:22;s:2:"16";i:37;s:2:"27";i:29;s:3:"109";i:30;s:3:"137";i:42;s:3:"138";i:43;s:3:"139";i:31;s:1:"0";i:32;s:1:"0";i:33;s:1:"0";i:34;s:1:"0";i:35;s:1:"0";i:36;s:1:"0";i:58;s:1:"0";i:62;s:3:"313";s:9:"75_chk358";s:3:"358";s:9:"81_chk387";s:3:"387";}s:17:"attributes_values";a:7:{i:31;s:4:"21.5";i:32;s:5:"13.25";i:33;s:2:"12";i:34;s:4:"11.5";i:35;s:5:"13.25";i:36;s:1:"5";i:58;s:65:"For Bricia Pini/Model Release Needed. 1 inch widow's peak needed.";}}}', cart_total = '749', order_id = '0' WHERE tracking_id='14312']

Thanks in advance.

Replace

$db->Execute("UPDATE " . TABLE_SUPERTRACKER . " SET last_click = NOW(), 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='" . $tracking_data->fields['added_cart'] . "', categories_viewed='" . $categories_viewed . "', products_viewed='" . $tracking_data->fields['products_viewed'] . "', customer_id='" . $customer_id . "', completed_purchase='" . $completed_purchase . "', cart_contents='" . $cart_contents . "', cart_total = '" . $cart_total . "', order_id = '" . $order_id . "' WHERE tracking_id='" . $tracking_data->fields['tracking_id'] . "'");

by

      $db->Execute("UPDATE " . TABLE_SUPERTRACKER . "
                    SET last_click = NOW(),
                        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'] . "'");

Newbie to Zen-Cart here, and I just want to thank you for developing this mod. Works great, and I hope to add some contributions as well.

Thanks again! :clap:

Bez.... any ideas why my issue exists? Any help would be appreciated.
:smile:

Hi Andrew

I have had Supertracker loaded for a few days without GeoIP.dat and it worked fine (except the country report).

Yesterday I unzipped GeoIP and loaded it to my shop/includes directory but now get the following error reports:

Warning: supertracker::include(includes/geoip.inc) [function.supertracker-include]: failed to open stream: No such file or directory in /home/charcool/public_html/shop/includes/classes/supertracker.php on line 190

Warning: supertracker::include() [function.include]: Failed opening 'includes/geoip.inc' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/charcool/public_html/shop/includes/classes/supertracker.php on line 190

Fatal error: Call to undefined function geoip_open() in /home/charcool/public_html/shop/includes/classes/supertracker.php on line 191

My site is at www.charcool.com

Have I messed up the unzipping or have I loaded it to the wrong place?

Thanks for your help

The file geoip.inc should be in /shop/admin/includes/

Just had a look at your site and this file does not exist.

Will installing Supertracker slow the website? Is it using logfile analysis?

longstockings, thanks.

I have moved GeoIP to the includes/admin/folder and seems to be working ok now. It is really a pretty good mod.

cheers and happy new year