Supertracker

[su35]

Thanks Design75
I had uninstalled and re-installed it. The error information was changed as below @#!?

[12-Nov-2012 06:33:39 UTC] PHP Fatal error:  1364:Field 'cart_contents' doesn't have a default value :: INSERT INTO supertracker (ip_address, browser_string, country_code, referrer, referrer_query_string, landing_page, landing_page_name, exit_page, exit_page_name, time_arrived, last_click, products_viewed) VALUES ('127.0.0.1', 'Mozilla/5.0 (Windows NT 6.2; WOW64; rv:16.0) Gecko/20100101 Firefox/16.0', '', 'http://www.zencart15.com/index.php', 'main_page=login', '/index.php?main_page=index', 'Home', '/index.php?main_page=index', 'Home', NOW(), NOW(), '') in H:\zencart15\includes\classes\db\mysql\query_factory.php on line 120

[su35]

base on the configuration of "Excluding IP's", the error message is different.
If the value set to empty, the error log is

PHP Fatal error:  1364:Field 'cart_contents' doesn't have a default value :: INSERT INTO......

If the value set to 127.0.0.1, the error log is

PHP Fatal error:  Cannot redeclare class supertracker

[su35]

If the jscript_supertracker.php was deleted, the pages were loading well. But there was no tracking data been recorded.

[evou]

Hello,

When I view the last ten visitors, the referred by link is always incomplete and cut off.
I use google adwords, so google makes for a long referred by link and when it is cut off (perhaps by a character limit?) I never get to see what keywords were used to get them on my page.

Does anyone know how to make the entire referred by link to show?
Is there a character limit setting?

Thank you

[Limitless]

The error information. It looks like declare the class twice. Do I need change the code to include_once() or require_once() in some where?

PHP Fatal error:  Cannot redeclare class supertracker in H:\zencart15\includes\classes\supertracker.php on line 15

For anyone that gets this error, a workaround that ~seems~ to do the trick is to edit the file:

/includes/templates/YOUR_TEMPLATE/jscript/jscript_supertracker.php

and change

REQUIRE(DIR_WS_CLASSES . 'supertracker.php');

to

include_once(DIR_WS_CLASSES . 'supertracker.php');


This is just a bandage, but is working like a champ for me now.

Nice Mod by the way.

[Pablo]

For anyone that gets this error, a workaround that ~seems~ to do the trick is to edit the file:

/includes/templates/YOUR_TEMPLATE/jscript/jscript_supertracker.php

and change

REQUIRE(DIR_WS_CLASSES . 'supertracker.php');

to

include_once(DIR_WS_CLASSES . 'supertracker.php');


This is just a bandage, but is working like a champ for me now.

Nice Mod by the way.

I applied this workaround and although supertracker is now working, my web pages seem to take a long time to load
and supertracker no longer displays the country flag for the visitor in the reports section.
If I don't apply the workaround, supertracker works fine but when you go to my web sit all you get is an "INTERNAL SERVER ERROR"
I believe this is caused from other java scrip files colliding with each other. Any suggestion on a fix?

[openvista]

I'm moving this discussion over from another support thread (http://www.zen-cart.com/showthread.p...ng-array-given).... I'm using ZC 1.5.1 and PHP 5.3.

I believe I've found a problem with Supertracker. Specifically it seems to be when a user checks out and Supertracker attempts to write the cart contents to the cart_contents field in the supertracker table. The file that controls this, I believe, is /includes/classes/supertracker.php about line 150ish. You can see that if the cart contents return as a string then it serializes them. But what happens when they don't return as a string? What if they are undefined or an array or some other non-string condition. Since the database write operation depends on zen_db_input() function, which is really just a container for the native add_slashes() function, it causes a PHP warning. Under PHP 5.3 addslashes() now strictly checks to see if the data passed to it is a string. If it isn't it throws a warning which ends up as a myDEBUG log file in the /logs folder under Zen Cart 1.5.1. They start adding up quickly if you have a store with enough daily transactions.

If I pass this data straight into the db, bypassing addslashes, it writes "Array" at least in my initial couple tests.

Suggestions on the best way to filter the $carts_content variable so it always ends up a string? I'll try a couple things but just wanted others to weigh in....

Thanks!

[a_berezin]

Wow! You really use this old script? Can you tell me why you use this script? What do you miss in Google Analytics and Piwik?

Quick bug fix.
includes/class/supertracker.php
Search

$cart_contents = unserialize($tracking_data->fields['cart_contents']); 

replace by

$cart_contents = $tracking_data->fields['cart_contents']; 

[picandnix]

Wow! You really use this old script? Can you tell me why you use this script? What do you miss in Google Analytics and Piwik?

Quick bug fix.
includes/class/supertracker.php
Search

$cart_contents = unserialize($tracking_data->fields['cart_contents']); 

replace by

$cart_contents = $tracking_data->fields['cart_contents']; 

It works (naturally)

[openvista]

Wow! You really use this old script? Can you tell me why you use this script? What do you miss in Google Analytics and Piwik?

Quick bug fix.
includes/class/supertracker.php
Search

$cart_contents = unserialize($tracking_data->fields['cart_contents']); 

replace by

$cart_contents = $tracking_data->fields['cart_contents']; 

Indeed, that's the solution I came to as well but was too busy to post a reply yesterday. After examining admin activity logs, it appears this add-on isn't getting used so I'm going to remove it. Plus there are other issues (reports that won't generate properly) that I think have to do with either PHP 5.3 or Zen Cart 1.5.1 or a combination of both.

As you say, Google Analytics, which the site uses, is a more comprehensive solution.

Thanks for your reply and maybe all of this helps someone who isn't comfortable with another solution.