Quote Originally Posted by a_berezin View Post
I you use module from dl-area replace
Code:
$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

Code:
$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:"attri butes_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.