User tracking mod

i Have downloaded the user tracking and installed it with in the relative path the it belongs but when i go to my admin/tool/user tracking and click report to get a report i get this

This tool allows for you to see the click patterns of the users through your site, organized by sessions. This data can be very valuable to those looking for how to improve your site by watching how customers actually use it. You can surf back and forth through the days by using the link below.


SELECT VIEW: Back to Apr 18, 2007

Now displaying the latest CONFIG_USER_TRACKING_SESSION_LIMIT sessions of this 24 hour period. You can also purge all records past the last 72 hours of data.

Delete all info from IP-Address CONFIG_USER_TRACKING_EXCLUDED purge all records

1146 Table 'zencart1.zen_user_tracking' doesn't exist
in:
[select customer_id, full_name, ip_address, time_entry, time_last_click, last_page_url, page_desc, session_id, referer_url, customers_host_address from zen_user_tracking where time_entry > 1176966000 and time_entry < 1177052400 order by time_last_click desc]
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.


Also the user tracking config page doesn't show anything.

Any thought as to whats wrong?

Quote:

---

Originally Posted by sirryche

load the mod from the downloads page and installed it on one site and had no problem. then loaded into my live site and in the user config there is nothing.. both sites are set up the same zen 1.3.7 installed sql files the same way on both data bases, installed files in footers. help....

---

This has happened to me.
Don't understand what could be wrong.
Can anyone help please.

Quote:

---

Originally Posted by Woody619

This has happened to me.
Don't understand what could be wrong.
Can anyone help please.

---

Ok sorted it now used the back up from yesterday and this time installed through phpmyadmin.

Anybody know how to disable the bots from this module, its a pain in the ######## to HAVE to view there sessions all the time.

Even how to force there sessions to shrink would be great.

Quote:

---

Originally Posted by dasonix

I have had a read through this thread and been looking for a way to turn off bots or to by default shrink there session info (page views) does such a hack exist? As we have either google or yahoo on our site constantly it would be nice to stop there data from hogging the screen when looking at this mods output (looking at over 1200 page views in detail is a right pain in the bum). In the ideal world something like the visitors mod for OSC would be nice where I can turn bots sessions views on or off

---

Petter Normann developed a version of User Tracking which contained some features missing in JeffD's version. (Petter's last version Sept 10-06). And JeffD's later version contains some features not in Petter's version. (Jeff's last version Dec 04-06). Both Petter and Jeff are now out of the Zen Cart dev scene.

So it would be very fine if someone with the dev skills could takeover the development of this mod and reconcile features from both versions into one.

Regarding tracking bots or not, here's some info in Petter's last version readme (info which is not included in JeffD's readme):

PHP Code:

---

File Modifications: 2 with Catalog-user-tracking AND Admin-user-tracking

add the following to the end of /includes/templates/YOUR_TEMPLATE/common/tpl_footer.php

Alternative 1: tracking all users and bots.
<?php if (ZEN_CONFIG_USER_TRACKING == 'true' && function_exists('zen_update_user_tracking')) { zen_update_user_tracking(); } ?>

Alternative 2: track only users with set sessions.
<?php if (ZEN_CONFIG_USER_TRACKING == 'true' && $session_started && function_exists('zen_update_user_tracking')) { zen_update_user_tracking(); } ?>

Alternative 3: RECOMMENDED, track all users except bots/spiders, requires Configuration->Sessions->Prevent Spider Sessions->true (I don't know if this works with Zen-Cart versions older than 1.2.6d).
<?php if (ZEN_CONFIG_USER_TRACKING == 'true' && !$spider_flag && function_exists('zen_update_user_tracking')) { zen_update_user_tracking(); } ?>


Add if you want to track admin pages viewed add the following to the end of /admin/includes/footer.php

<?php if (ADMIN_CONFIG_USER_TRACKING == 'true' && function_exists('zen_update_user_tracking')) { zen_update_user_tracking(); } ?>

---

The above code works for me on ZC 1.37 with JeffD's last UT mod version (12-04-06). YMMV.

Hope this helps.

Woody

TYVM you are a star :)

Thanks Woody I also needed to do this.
Works perfect :bigups:

Woody

Thanks Woody, that did the trick on removing bot sessions.

I ported osCommerce Supertracker mod to Zen. I use it together with User tracking mod. Somebody is interested to try it?

Yes please. :smile: