Supertracker

[a_berezin]

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

[BlessIsaacola]

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=&pfr om=&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!

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

[BlessIsaacola]

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!

[a_berezin]

where do I apply the change you proposed?

/includes/classes/supertracker.php

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

[BlessIsaacola]

/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!

[a_berezin]

Check name and case - /includes/GeoIP.dat

[BlessIsaacola]

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!

[alray10]

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

[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?