Supertracker

kennymxp:

Hi,

I installed SuperTracker successfully on ZC 1.3.7.1 (fresh installation). I can manage SuperTracker under Configuartion -> SuperTracker. I can also open the report page at Reports -> SuperTracker.

However, the report always say: "Database Info: the Supertracker database currently holds 0 rows (oldest record : )"

It should have at least some info because I've installed it for a few days. My cart has visitors when checking with AWStats. I also disabled the function to exclude myself and bots. Thus, at least, I should see some records of me browsing around. However, nothing was recorded.

Please help me. Thank you very much.

Regards,
Kenny

Hi, Ive the same problem.. No records of anything.. Did you manage to get a fix for this?

Anybody else ran into this before?

Thank you.

Hello Mark,

You've done a wonderfull job with this module, the item I like the most is the last ten visitors as we can see visitors and not only the one who purchased something.

Of course like with many good things we would like more, and if you let me suggest some of them...

I'm sure the data recorded can give us more points of view, for example

• from the last ten visitors, clicking on someone can filter to this person and track this visitor to know how many times he came before purcahsing

-It can also give us the mean number of visits before purchase

• If doing that by IP, perhaps we can get how many time he came before registering

-We can also get the to ten categories visited

That's a few ideas, let me know what you think about that.

Thanks and congratulations

Regards

Hubert

Just installed this, no probs, thanks devs.

Looked at the source and the following looks like it wouldn't work...

    //Next line defines pages on which a new visitor should definitely not be recorded
            $prohibited_pages = 'login,checkout_shipping,checkout_payment,checkout_process,checkout_confirmation,checkout_success';
            $prohibited_pages = '';
            if (!strpos($prohibited_pages, $_GET['main_page'])) {
```It seems that $prohibited_pages is set, then reset to ''

Is this right? If the code isn't meant to be executed does it need to be there?
Or should the second assignment of $prohibited_pages not be there?

Cheers,
S

Hello! I am trying to install this mod. Getting an error when I do this step:

2. Go to Admin->Tools->Install SQL Patches and install install.sql

I am attempting to upload the install.sql file using the Upload button on that page. When I do so, I get the following 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 's', 'XTRACKING_EXCLUDED_IPS', '127.0.0.1', 'Comma Separate List of IPs which sho' at line 1
in:
[INSERT INTO zen_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'),');]
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 thoughts?

Thanks! I am not super technical, so I hope it's something simple that I'm doing wrong!

chacha-vintage:

Hello! I am trying to install this mod. Getting an error when I do this step:

2. Go to Admin->Tools->Install SQL Patches and install install.sql

I am attempting to upload the install.sql file using the Upload button on that page. When I do so, I get the following error: {snipped}
Rather han upload, copy and paste the SQL code. Open install.sql in a text editor, then copy all the text, and then paste into the big text box on "install SQL patches".

Woody

Super! I had tried that as well yesterday and it didn't work. I just did it again and it looks like it worked this time. Thanks for your help! :clap:

Can anyone help?

I have downloaded and installed the supertracker but when going to the reports it states that the database holds 0 records, although I have had visitors since the install.

Thank you

Great mod. I was using the User Tracking by REZA, but SuperTracker gives more info AND does not touch core files as User Tracking does (trying not to install mods that touch core, just makes upgrading easier)...

BUT User Tracking gives the ability to see the whole user session by expanding a particular heading, which then shows were the user went throughout your site. Very nice, and hope this can be something included in SuperTracker in the future. Then it would be ideal!! Hopefully it will be considered.

Is this something that can be ported from User Tracking?

So now that I've got it installed, I think SuperTracker is fantastic! Now, this might seem like a dumb question, but is there a way to get a simple count (counter) from it as well without adding another mod?

I know Zen has a counter, but I don't think it gives a very reliable number. Of course, I could scroll back through my last 10 visits, but would love to have something at a glance.

Thanks!

This mod does not support ' in product name. When a product name contains ' for example something's don't change...it renders the site useless and displays a bunch of error code.

If anyone no how to escape the ' for all products with apostrophe in the name that would be great.

Maybe give more information? I have not been able to reproduce the error.

a_berezin:

Maybe give more information? I have not been able to reproduce the error.

Here is the error 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 Pretend PlayBrix - Set of 54&search_in_description=1&categories_id=2274&inc_su' at line 1
in:
[UPDATE supertracker SET last_click = NOW(), exit_page='/search/results.html?keyword=Let's Pretend PlayBrix - Set of 54&search_in_description=1&categories_id=2274&inc_subcat=1&manufacturers_id=&pfrom=&pto=&dfrom=&dto=&x=33&y=8', exit_page_name='Search Results', num_clicks=num_clicks+1, added_cart='false', categories_viewed='a:7:{i:388;i:1;i:392;i:1;i:238;i:1;i:889;i:1;i:890;i:1;i:891;i:1;i:892;i:1;}', products_viewed='*13466?', customer_id='0', completed_purchase='false', cart_contents='', cart_total = '0', order_id = '0' WHERE tracking_id='3957']

This error happens everything a product includes ' in the name. Change one of your product name to some like Andrew's Mod and then search for Andrew's Mod on the Advanced Search window. It should generate this error.

Thanks!

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.

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.

Thanks Andrew for the fix, where do I apply the change you proposed? In a file or is this and sql update? I am not sure I understand where I should make the change.

The only reason I referenced the product is because the error only happens when I have a product name that includes '

Also, is there another place to download this since it sounded like the one in the download area may not be the most updated version?

Thanks!

BlessIsaacola:

where do I apply the change you proposed?
/includes/classes/supertracker.php

BlessIsaacola:

The only reason I referenced the product is because the error only happens when I have a product name that includes '
The error only happens when you enter ' in url (for ex in search box/page).

a_berezin:

/includes/classes/supertracker.php

The error only happens when you enter ' in url (for ex in search box/page).

Thank you very much! The problem is fixed.

Any idea why visitor country stats is not working? I have the geoip.data uploaded to the includes/ folder. I am assuming that's the right location or is it myadminfolder/includes?

Thanks!

Check name and case - /includes/GeoIP.dat

a_berezin:

Check name and case - /includes/GeoIP.dat

Thanks Andrew! That was the problem. I downloaded and updated geopip and the case wasn't right. Now everything works! Awesome!

Great mod but it seems to record any hits from the UK United Kingdom 6 times.
It reports them coming from United Kingdom and then it reports the same hit as.
Northern Ireland
Scotland
Wales
England
and Isle Of Man

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?