User tracking mod

Reza-

1. The advice Andrew provided above helped me previously when I observed User Tracking menu issues. I forgot about that tip. Should go in the UT readme file!

2. Also in the readme did you see:

File Modifications: 2

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

<?php if (ZEN_CONFIG_USER_TRACKING == 'true') { 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') { zen_update_user_tracking(); } ?>

3. And also if you have Admin Profiles installed you may have an issue with the User Tracking menus repeating themselves. Andrew provided a fix for this earlier in the thread which worked me. (I don;t recall but it may have been the fix Andrew provided above).

In some previous UT releases User Tracking And User Tracking Config both were set up to display on the tools menu. Other versions were developed which had User Tracking Config show up under the Configuration menu.

Also DrByte previously has stated User Tracking utilizes unique install techniques, which are advanced in their own way but can be problematic in other ways.

So I suspect the UT menu config/conflict/upgrade issues many of us have observed are a culmination of the above.

Woody

Regards to future development of the User Tracking mod & repair of UT menu config issues:

Pinghead is not supporting the mod any longer and we haven't seen JeffD around for some time. Where is Jeff?

Andrew has proven repeatedly he understands Zen Cart SQL installer technology and the mods he produces are top notch. Maybe if we cheer Andrew on a bit he would be willing to take this mod under his wing and apply his knowledge to repair the constant SQL installation issues we repeatedly observe wiith this mod?

Might be best to create an uninstaller that deals with all the other past versions (which I have copies of, if needed), and then patch the db with fresh SQL, rather than developing an updater for all the various different past versions. At the same time maybe take both Pinghead's and JeffD's latest versions of User Tracking, and merge the best features of both (In this thread I learned JeffD based his version on older User Tracking version, not aware of Pinghead's version. So both versions are slightly different and each have beneficial features the other version does not have).

If I had more understanding of SQL I would help. but I don't. Studying the mySQL manual is not getting me far enough fast enough.

Woody

Someone just PM'd me with a question about availablity of User Tracking versions which I did not quite understand, since all the recent versions are available in ZC Downloads area. Below is the question and my response.

I also downloaded user_tracking without success. Existing install on my 1.3.7 Zen-Cart was published (I think) back in August. Having installed the latest SQL patch and the revised admin/includes/functions/extra_functions and includes/functions/extra_functions files (JeffD/120406), I'd love to get my hands on the preceding User Tracking files.Any chance you might email them to me?
[/URL]

Not sure what your question is regards to "preceding" files? I suggest a complete re-install of new User tracking version.

The latest FULL version which in now available in the ZC Downloads area is:
v. 1.3.6.2 12-04-06 (JeffD)
(as packaged by Reza)

See http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_41&products_id=261

Preceding versions are available at same link above:

v. 1.3.6.1 11-30-06 (JeffD)
v. 1.3.6 11-27-06 (JeffD)

Before that a patch JeffD was made available on 11-22-06 (JeffD)
(NOTE: The JeffD patch was intended for a version Jeff was using (based on previous open-operations version), not Pinghead's recent version... this mix-up created some minor issues for various people including me.

Then there was pinghead's last version: 20060805 (08-31-06) (pinghead)

I am using the latest User Tracking v1.3.6.2 on Zen Cart 1.37. YMMV regarding which versions run on Zen Cart 1.3.7.

JeffD... where are you?

Woody

Woodymon:

Reza-

1. The advice Andrew provided above helped me previously when I observed User Tracking menu issues. I forgot about that tip. Should go in the UT readme file!

2. Also in the readme did you see:

3. And also if you have Admin Profiles installed you may have an issue with the User Tracking menus repeating themselves. Andrew provided a fix for this earlier in the thread which worked me. (I don;t recall but it may have been the fix Andrew provided above).

In some previous UT releases User Tracking And User Tracking Config both were set up to display on the tools menu. Other versions were developed which had User Tracking Config show up under the Configuration menu.

Also DrByte previously has stated User Tracking utilizes unique install techniques, which are advanced in their own way but can be problematic in other ways.

So I suspect the UT menu config/conflict/upgrade issues many of us have observed are a culmination of the above.

Woody After posting in a few other places I found this thread. I am not very knowledgeable about directories and such. I hope someone will take the time to guide me as to what I need to do to get this working on my site. I've uploaded user tracking to my site and the sql patch. User tracking is in my Admin Config. but not in the tools so I can use it. Please tell me what directory or directories user tracking needs to be in to work also I have seen readme about the footer and such but I do not understand where that is. Please help I know I sound stupid but i would really like to get it running. Thnank you

Ok I found the includes/template/your template/common/tpl_footer.php and added the last line. I am pretty sure I don't have the user tracking in the right directory can someone help me out on that one please.

Ok everyone I followed the "easy to follow" instructions including what was in the readme folder and this is the result...........

Fatal error: Cannot redeclare class base in /home/impress/public_html/includes/classes/class.base.php on line **17

Now what?
**

I have spiders/robots on my site that keep showing in User Tracking. I can't delete them as they don't have a session ID. The lists can get very long as they are always on. Anyway to get rid? I think they have started since I changed my meta tag to robots index follow

Jeff's version readme leaves out some useful info which was in pinghead's UserTracking version readme.

Here is an excerpt from pinghead's last version which may help:

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(); } ?>

BTW you may want to checkout Pinghead's version as some features in his vresion are not in JeffD's version (and vice versa)

Thanks Woody ;)

This one was just what I needed. Where do I find the other version, and which is the best if you know?

whispers65233:

Ok everyone I followed the "easy to follow" instructions including what was in the readme folder and this is the result...........

Fatal error: Cannot redeclare class base in /home/impress/public_html/includes/classes/class.base.php on line **17

Now what?
**
I don't think the error is related to user tracking. You may have muffed up something while editing. If this is not the case then you may have another mod which is calling the same class file. Search your install using the Developers Tool Kit (in admin under Tools) to see if you find multiple references to whatever is being called on line 17. (you will need to open class.base.php first).

You may have good reasons for your shop directory path above, but just in case, the path shows your shop includes directory within your webroot. This is not standard. With a normal install one would observe sonething like:

/home/account_name/public_html/shop_name/includes

Installing your shop directly in your webroot makes setting up and maintaining Zen Cart more tricky.

If you need assistance with this the Installing Zen Cart board is probably the best place to post questions on this subject. And be sure to check out the Installation docs in the FAQs and Tutorials area.

Woody

I previously was running zen 1.3.6 with user tracking no problem. Just upgraded to zen 1.3.7 and ran the new user tracking install. I'm getting the following error from myphpadmin. I see in zen admin tools I have the "user tracking config" but when I select that there is nothing showing. Please Help!!!!!!!

Thanks
OI

Error

SQL query:
INSERT INTO configuration_group( configuration_group_id , configuration_group_title , configuration_group_description , sort_order , visible )
VALUES ( 999, 'User Tracking Config', 'User Tracking', 31, 1 ) ;

**MySQL said: **[IMG]https://green2.sashbox.net:2083/3rdparty/phpMyAdmin/themes/original/img/b_help.png[/IMG]
#1062 - Duplicate entry '999' for key 1

The configuration_group_id is protected ... meaning you cannot have more than 1 record with the same configuration_group_id ...

You are trying to add to configuration_group_id 999 so look via phpMyAdmin and see if this value is already used by this add-on or used by something else ...

Hi Linda aka (Ajeh),

Yes I'm looking in phpmyadmin and I do have a table "configuration_group". I also tried the same SQL query to update from Zen - admin/tools and get a little more info but really same error.

1062 Duplicate entry '999' for key 1
in:
[INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (999, 'User Tracking Config', 'User Tracking', 31, 1);]
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.

I'm not real good ad SQL but any suggestions?

Thanks your a lifesaver

OI..:)

Linda,

Below is the user tracking SQL script that was run that is generating these errors.

DROP TABLE IF EXISTS user_tracking;
CREATE TABLE user_tracking (
customer_id int(11) default NULL,
click_id int(11) default NULL,
full_name varchar(64) NOT NULL default '',
session_id varchar(32) NOT NULL default '',
ip_address varchar(15) NOT NULL default '',
time_entry varchar(14) NOT NULL default '',
time_last_click varchar(14) NOT NULL default '',
last_page_url varchar(128) NOT NULL default '',
referer_url varchar(254) NOT NULL default '',
page_desc varchar(64) NOT NULL default '',
customers_host_address varchar(64) NOT NULL default ''
) TYPE=MyISAM;

DELETE FROM configuration where configuration_group_id = '999';
INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (999, 'User Tracking Config', 'User Tracking', 31, 1);
INSERT INTO configuration VALUES ('', 'User Tracking (ADMIN)', 'ADMIN_CONFIG_USER_TRACKING', 'true', 'Check the ADMINs behaviour ? (each click will be recorded)', 999, 2, '2003-03-03 11:19:26', '2003-02-09 21:20:07', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES ('', 'User Tracking (exclude this IP-Address)', 'CONFIG_USER_TRACKING_EXCLUDED', 'your IP', 'Do NOT record this IP Address<br>(like webmaster/owners/Beta-testers)', 999, 10, '2003-03-04 23:08:38', '2003-02-09 21:20:07', NULL, NULL);
INSERT INTO configuration VALUES ('', 'User Tracking (Session Limit)', 'CONFIG_USER_TRACKING_SESSION_LIMIT', '50', 'Displaying the latest # sessions of this 24 hour period.<br>(SET to 999999 for unlimited per 24 hour period)<br>NOTE:<BR>Watch you space !', 999, 15, '2003-03-03 11:19:13', '2003-02-09 21:20:07', NULL, NULL);
INSERT INTO configuration VALUES ('', 'User Tracking (your favorite WHOIS URL)', 'USER_TRACKING_WHOIS_URL', 'http://www.dnsstuff.com/tools/whois.ch?ip=', 'Put here you favorite WHOIS tracking site<br>(the IP will follow automaticly after this url)', 999, 50, '2003-03-03 11:19:13', '2003-03-11 11:40:01', NULL, NULL);
INSERT INTO configuration VALUES ('', 'User Tracking Visitors', 'ZEN_CONFIG_USER_TRACKING', 'true', 'Check the Customers/Guests behaviour ? (each click will be recorded)', 999, 1, '2003-03-03 11:19:26', '2003-02-09 21:20:07', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES ('', 'User Tracking (Show Product Category when tracking product clicks)', 'ZEN_CONFIG_SHOW_USER_TRACKING_CATEGORY', 'true', 'Show Product Category when tracking product clicks', 999, 60, '2006-12-05 11:19:26', '2006-12-05 21:20:07', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

OK, the user tracking mod that is in download area does not work for us who previously had user tracking installed with zen 1.3.6. The SQL patch gives errors, but somehow I was able to get around with a previous SQL patch by another user. This mod really nees to be taken off the download pages.

While I can see user tracking information. I also have 2 selections of "user tracking". One if the admin configuration and one in tools. In both of these cases I get no options at all but a blank screen. I reloaded files but still same issue.

Any advice?

Thanks OI

OutdoorsInteriors:

OK, the user tracking mod that is in download area does not work for us who previously had user tracking installed with zen 1.3.6. The SQL patch gives errors, but somehow I was able to get around with a previous SQL patch by another user. This mod really nees to be taken off the download pages.

Background:

There are two different "base" versions of the mod from different "developers" (pinghead and JeffD) and the upgrade SQL for one version does not necessarily apply to the other version and each version supports slightly different features.

(JeffD was in the process of combining those features and putting together SQL updates for all the various past versions, but JeffD disappeared from the scene. And pinghead is no longer developing his version).

Originally (when the mod was ported to Zen Cart and released by Open-operations, which both pinghead and JeffD based there later versions on) you were suppose to see User Tracking Config in the Config menu and User Tracking in the Tools menu. Then along the way one of the versions changed this to also place User tracking under the Config menu. This was a bad move causing much confusion for upgraders.

So that is why it is important to know which version of the mod you are upgrading from (on your 1.36 shop) and which version you upgraded to (on your 137 shop).

OutdoorsInteriors:

While I can see user tracking information. I also have 2 selections of "user tracking". One if the admin configuration and one in tools. In both of these cases I get no options at all but a blank screen. I reloaded files but still same issue.

Others reported observing the same issue (including yours truly) and solved issue, as I did also. But at this moment I don't recall the steps involved. I did and found the solution(s) in this thread.

I do remember andrew (a_berezin) posted a SQL fix to this thread that helped.

Also if you have Admin Profiles installed there is another special fix you may want to try (see Admin Profiles readme).

Hope some of this helps.

Woody

NamSingh:

Thanks Woody ;)

<?php if (ZEN_CONFIG_USER_TRACKING == 'true' && !$spider_flag && function_exists('zen_update_user_tracking')) { zen_update_user_tracking(); } ?>

This one was just what I needed. Where do I find the other version, and which is the best if you know?

YMMV in what you consider best. I use JeffD's latest version (12-04-06) on Zen Cart 1.37.

pinghead's last version released 08-31-06 is still available in ZC Downloads area (look down the list of previous versions and see author: Pinghead).

I do have user tracking showing but again I have user tracking in both the config and admin areas which show nothing. Also when I go to user tracking and view details I have to log into admin tool again. This mod needs a major rework.

Thanks for the suggestions

OI

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

Is there a step by step somewhere? WOW this is crazy!
If there isnt or no one knows ,
Will someone who does know Exactly how to install this thing please break it down for me?
is there a default db table name in this thing that i can just create a new db with that name? What is that default db name ?
Im gonna go clean up my tracks now to get ready for my new clean install, Whatever that may consist of.
Most of the directions given in the readme I for some reason do not understand.
any help, thank you.
John