User tracking mod

Im on 1.3.9h. Indeed I can't see andmin_pages in the DB.

Using the version you pointed me to I now get this on the SQL instal:

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);]

Not my day!

Rizla:

Im on 1.3.9h. Indeed I can't see andmin_pages in the DB.

Using the version you pointed me to I now get this on the SQL instal:

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);]

Not my day!

This telling you that the configuration tables already exists so the things to check for

1. Admin -> configuration look for User Tracking Config in the drop down menu. Click it and verify all information is fully inserted

2. Tools -> User Tracking in the drop down menu. Click it and verify all information is fully inserted

3. Tools -> User Tracking in the drop down menu. Click it and verify all information is fully inserted (Same As #1 Entry which both do same function..

Or you could run the SQL file inside the original file and start over. That will drop all tables and insert new ones

I will update the SQL and remove the configuration table soon from the Admin --> Configuration --> Menu soon but will be for V1.5.0

You could also run the original SQL file in the 1.3.7 version and drop existing tables and start over

Hi
"Or you could run the SQL file inside the original file and start over. That will drop all tables and insert new ones"

Not sure what you mean... when I re-run the SQL I get the error above. Looking at my DB I see there is no "admin_pages"
The only table I see relating to this module is "user_tracking"

If I go to the Config > User Tracking... The page is blank (has the top banner Title Value Action, but nothing else on the page.
Under Tools, it is not listed at all.

I have tried running the SQL both from Zen and PHP MyAdmin and still get this:

ERROR
SQL query:

INSERT INTO admin_pages( page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order )
VALUES (

'UserTracking', 'BOX_TOOLS_USER_TRACKING', 'FILENAME_USER_TRACKING', '', 'tools', 'Y', 10000
);

MySQL said:

#1146 - Table 'metalpix_db1.admin_pages' doesn't exist

First thing is your trying to install UT 1.5.0 Version.. You want to download the Version for 1.3.7 not 1.5.0.

The version you need can be found right under the 1.5.0 version here <--click this link -- then run the SQL file included with those files. Leave and forget about 1.5.0 for now it will not work for you.

Download the Version I linked above upload all files run the SQL file.. Make necessary file changes as the readme in the 1.3.7 Version states. See what happens then.

Ok... Done that and its still not working ALTHOUGH slight progress lol.

I have triple checked every file and dir. everything is where it should be. Before, User Tracker Config AND User Tracker in Tools were both blank.

Now I have a User Tracker Config menu option under both "Config" and "Tools" - Both are still blank. (has the title but no options)

Under "Tools" I have the User Tracker which is populated as follows:

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 Aug 12, 2011

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

There have been 0 page views in this 24 hour period.
There have been 0 page views in this 24 hour period. Total number of users:

I run the SQL in PHPAdmin and get the following:

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:

#1062 - Duplicate entry '999' for key 1

Is this a Database issue?

PS: I did change the dir Admin to my own Admin_Name... Is this correct?

Rizla,

Okay lets take one step at a time so we both know we are on the same page. I have numbered the steps below so you can follow along easily.

1. If you are using a custom named admin directory and then yes you did this correctly. Simply upload the contents of admin in the module folder to your actual admin_directory you have on your FTP.

2. Run the following SQL command from inside your ZenCart Admin tools --> Install SQL Patches"

DROP TABLE IF EXISTS user_tracking;
DELETE FROM configuration_group where configuration_group_id = '999';
```3. Login into your phpMYadmin or host account database management panel search for "User Tracking" (**without the quotes**) insure yourself that the actual configuration ID table was removed. If the results come back something like below (**May Not Be Exact**) but should be similar then you know it was removed.

MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0005 sec )

(**Note:** **Upload using direct upload from the admin --> tools --> Install SQL Patches upload feature instead of pasting the code in to the empty text box**)

Post back here the results...

On another note be sure you back up all SQL (Download a Full Copy) before inserting or removing tables.. It is just good practice to do so..

Knuckle...
We are now signing the same hymn!

Thanks very much for all your help on this... really.

Rizla

I just installed User Tracking (1.3.7 version) on a fresh install of 1.3.9h and am having problems with the Shopping Cart being displayed.

If I go to Who's Online, I can see all active sessions each with their own individual carts showing. But when I go into User Tracking, every session has the identical cart showing - the cart associated with the most recent session.

Has anyone else seen this?

Apache 2.0 on Linux
PHP 5.2.17
MySQL 5.0.91

dchquilling:

I just installed User Tracking (1.3.7 version) on a fresh install of 1.3.9h and am having problems with the Shopping Cart being displayed.

If I go to Who's Online, I can see all active sessions each with their own individual carts showing. But when I go into User Tracking, every session has the identical cart showing - the cart associated with the most recent session.

Has anyone else seen this?

Apache 2.0 on Linux
PHP 5.2.17
MySQL 5.0.91

Yes that "feature" appeared with zen-cart v1.3.9
I had a quick look and couldn't see a quick fix
I can live without it for the time being as the other
info that this mod provides is more important to me.

lumpylumpy:

Hi, i am using 1.39h, with User Traking off course :clap:

When i open User Tracking, by default it opens me the first user that whas recorded without a session_id.
In my case web crawlers as google, yahoo....
This may be only particular to me as i have in config-> Sessions :
Prevent Spider Sessions
Prevent known spiders from starting a session = True
And they have a lot off hits in one day > 5000
it is a headake to scroll to the real users sessions throh so many hits

the solution is that in admin/user_tracking.php around the end there is the line that shows the clicks off a certain user, for me this line returns true by default in the case off spiders as they dont have session IDs.
line 363 in my file

if ($_GET['viewsession'] == $ut['value']['session_id']){
while (($pu = each($ut['value']['last_page_url']))&&($du = each($ut['value']['page_desc'])))
{

> and replaced it with (adedd code in red and bold)
> ```
if ($_GET['viewsession'] == $ut['value']['session_id'] [B] && $ut['value']['session_id'] != ''[/B]){
  while (($pu = each($ut['value']['last_page_url']))&&($du = each($ut['value']['page_desc'])))
  {

in this way even if the is a record without session_id, it does not open by default, only when you click on [view session]

Best regards Zoli.

Hi
I have just done the mod toi the said lines of code and it works to a degree (for me)

Ok, now the spider record is not open by default... Great! BUT, if I click on open session... nothing opens. All users with a session open ok.

Any ideas?

Hello, I have a fresh install on 1.39h using the User Tracking v.1.3.6.2 for ZEN1.3.7 mod for user tracking. I hope this is the right thread for questions...

user tracking comes up in my configuration menu, but not under the tools menu. Anybody have this problem, or am I looking in the wrong place? I have looked at over 100 posts, hope I am not repeating a solved problem.

My FTP program told me it uploaded the pages, but it did not, so that is the reason why it did not work. Had to go into webshell to figure that out, sorry that I could not find a delete or edit function on the forum for my previous post. Mike

In user Tracking Config I've entered the IP address of Google in the "Exclude this IP" heading.

Am I restricted to one IP address, I'm getting visited all the time by crawl.yahoo.net and would also like to exclude this IP address.

It's a toss-up which of these visits the most, but I'd like to not track them both.

Is both possible, or am I restricted to one.

Great add-on by the way. Really useful if users have any problems. You can see where they've been and what they've done.:clap:

technologynow:

In user Tracking Config I've entered the IP address of Google in the "Exclude this IP" heading.

Am I restricted to one IP address, I'm getting visited all the time by crawl.yahoo.net and would also like to exclude this IP address.

It's a toss-up which of these visits the most, but I'd like to not track them both.

Is both possible, or am I restricted to one.

Great add-on by the way. Really useful if users have any problems. You can see where they've been and what they've done.:clap:

Try entering the ips with comma's such as

104.105.151.123, 123.123.123.122

Try entering the ips with comma's such as

104.105.151.123, 123.123.123.122

Just tried that. No errors show, but not sure if that actually works.

At the top of the User Tracking page where I have > Delete all info from IP-Address 66.249.71.141, 67.195.37.98 purge all records Clicking it doesn't remove the Yahoo records.

When only the Google bot was listed > Delete all info from IP-Address 66.249.71.141 purge all records clicking on the ;purge all records link removed the record of Google visits.

technologynow:

In user Tracking Config I've entered the IP address of Google in the "Exclude this IP" heading.

Am I restricted to one IP address, I'm getting visited all the time by crawl.yahoo.net and would also like to exclude this IP address.

It's a toss-up which of these visits the most, but I'd like to not track them both.

Is both possible, or am I restricted to one.

Great add-on by the way. Really useful if users have any problems. You can see where they've been and what they've done.:clap:

try separating them with commas:
EG:
192.133.32.116,87.154.129.67

Tried that. See post 457.

Hi, I installed this and I would like to remove it. It does not have the remove sql file. I am trying to figure it out how to do that but I am very limited on programming.

Here's the sql file:

INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('UserTracking', 'BOX_TOOLS_USER_TRACKING', 'FILENAME_USER_TRACKING', '', 'tools', 'Y', 10000);

INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('UserTrackingConfig', 'BOX_TOOLS_USER_TRACKING_CONFIG', 'FILENAME_USER_TRACKING_CONFIG', '', 'tools', 'Y', 10001);

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''),');

I am trying to figure it out. This is what I have so far BUT desparately need help.

SET @user_tracking=0;
SELECT (@user_tracking:=configuration_group_id) as user_tracking
FROM configuration_group
WHERE configuration_group_title= 'UserTrackingr';
DELETE FROM configuration WHERE configuration_group_id = @user_tracking;
DELETE FROM configuration_group WHERE configuration_group_id = @user_tracking;

Need some guru programming help to delete this addon from my database.

Thanks.