Supertracker

simon1066:

Ok, so this problem seems to have resolved itself. Not sure of the reason yet, but will update if I have any news

Cheers

Simon

Simon,

Have you figured this out? I am still having the problem

I am running Zen 1.3.8 in my site.
I have installed successfully supertracker in my old template, however, due to some security errors, I need to go back to classic template.
In this template supertracker works fine, without following:

1. no customer (ID)name
2. log on time too short for each record, so each click will be added to database

Pls help. :oops:

gottoys:

Simon,

Have you figured this out? I am still having the problem

gotoys, got your pm. No I'm afraid I haven't isolated the cause, just glad it's resolved itself. In case it helps my Admin>Config>Sessions settings are:

Cookie Domain True
Force Cookie Use False
Check SSL Session ID False
Check User Agent False
Check IP Address False
Prevent Spider Sessions True
Recreate Session False
IP to Host Conversion Status true

Sorry I can't suggest more. However I also have installed 'user tracking' it's very good and I find that I tend to use this more. Mind you my site doesn't warrant my using all supertracker options (I tend to use it just to check for bailed carts)

Cheers

Simon

ORIKO:

I am running Zen 1.3.8 in my site.
I have installed successfully supertracker in my old template, however, due to some security errors, I need to go back to classic template.
In this template supertracker works fine, without following:

1. no customer (ID)name
2. log on time too short for each record, so each click will be added to database

Pls help. :oops:

I still cannot solve customer ID problem.
Last time when it was functioning was before I upload TIME OFFSET mod. So I disabled this mod for a while and returned to classic template.

Anyone pls help.

I'm trying to uninstall this because my host says its running a lot of queries and slowing things down. When I try to run the Uninstall SQL patch it takes the store down with some not found errors.

Is there a proper way to remove this?

Thanks

Can someone please tell me how to uninstall this supertracker... each time I remove anything I get sql errors. I put the uninstall sql code and that is when all problems begin.

Thanks

I moved my test web server from Apache to IIS7 and now when i try to access my test zen-carts I get this error.

1364 Field 'cart_contents' doesn't have a default value
in:
[INSERT INTO supertracker (ip_address, browser_string, country_code,
Can anyone tell me what would be causing this? Im running the latest PHP & MySQL (PHP 5.2.12 and MySQL 5.1.42) so i don’t know if that’s the cause.

StarBuck:

I moved my test web server from Apache to IIS7 and now when i try to access my test zen-carts I get this error.

Can anyone tell me what would be causing this? Im running the latest PHP & MySQL (PHP 5.2.12 and MySQL 5.1.42) so i don’t know if that’s the cause.
go into your database and look for that field, check the details on it?

linnx:

I'm trying to uninstall this because my host says its running a lot of queries and slowing things down. When I try to run the Uninstall SQL patch it takes the store down with some not found errors.

Is there a proper way to remove this?

Thanks

look through the download, delete all the files from your website, and run the uninstall???
just an idea, dnno if it will work

PatF:

For some reason that I can't for the life of me figure out my supertacker records each person twice. So when I look up the last 10 visitors I see the last five twice each. This is occurring on two seperate sites now. :frusty:

I use a tracker and see this problem too. I believe it stems from a SEO redirect cause but have never been able to narrow it down far enough to fix.
Do you have a redirect in you .http file?

Most likely cause.

GJW
http: // stampcommune . com

Is there any way to make the URLs that show up in reports actually become links that I can click on? For example, the report for the Top Referring Sites list the URLs that they come from. Is there a way to make those actual links?

vooboo13:

Is there any way to make the URLs that show up in reports actually become links that I can click on? For example, the report for the Top Referring Sites list the URLs that they come from. Is there a way to make those actual links?

Even if there is I wouldn't recommend it:
http://www.zen-cart.com/forum/showthread.php?p=814670#post814670

Hi all,

I have a little problrm. I have installed Supertracker onto my zen-cart, uploaded the right files into the right folders, run the install and uninstall a hundred times but when I look at the report it always says-

"Database Info: the Supertracker database currently holds 0 rows (oldest record : )"

Even tough I have had more than 75 hits to the shop - the tracker has not recorded any of them

What is going wrong? what can I do to get the tracker to work??

Please help before I am totally bald!!:censored:

Thanks in advance

Martin

I have been using Supertracker for a long time. I just tried to access my site and getting this error:

Fatal error: supertracker::update() [<a href='supertracker.update'>supertracker.update</a>]: The script tried to execute a method or access a property of an incomplete object. Please ensure that the class definition "shoppingCart" of the object you are trying to operate on was loaded before unserialize() gets called or provide a __autoload() function to load the class definition in /home/xxxx/public_html/includes/classes/supertracker.php on line 99

I changed code in includes/classes/supertracker to one listed as:

$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'] . "'");[HTML]
```\[/HTML]

And did refresh with it still not working. I can not get to store to empty shopping cart.:frusty::frusty: Help!

a_berezin:

1. In sql replace
   NOW()
   by
   date_add(now(), INTERVAL ' . TIME_ZONE_OFFSET . ' HOUR)
2. Replace
   $thirty_mins_ago = date('Y-m-d H:i:s', (time() - (3060)));
   by
   $thirty_mins_ago = date('Y-m-d H:i:s', (time()+TIME_ZONE_OFFSET6060 - (3060)));

Hi, this time offset 60*60 business confuses me a bit, could someone explain how I might go about adding 4 hours to the times reported so that its inline with UK time?

Any help with this would be appreciated :unsure:

I just found out it is possible to edit client accounts from the frotside of shop using Suppertracker. I'm not going to tell here how it's done, but it is important enough to be mentioned.

**Anyone know how to remove this modules when i was install it?

Thanks for advice!**

Does anyone know how to replace the ereg functions on this mod so that it's compatible with PHP 5.3? I really like the mod, been using it for ages but it's broken on new updated servers.

ok, found the solution on a Google group and it works

the file that has the problem is:

includes/classes/db/mysql/query_factory.php

Just replace all these:
**
ereg('^[0-9]', $key)**

with this:
**
preg_match('/^[0-9]/', $key)**

Is there a way to stop intenal links appearing on the 'Top referrers' list?

for example, I have the following in my list:

Rank Referring URL
11 http://www.snowrepublic.co.uk/Clearance
14 http://www.snowrepublic.co.uk/helmets 1
15 http://www.snowrepublic.co.uk/tools/pocket

They are all internal links from my site so are muddying the waters for me a little when I'm trying to see who my top referrers are.

Thanks for the mod bye the way, it's already helped me figure out why a customer binned their cart!