User tracking mod

[gilby]

I think that issue is currently still present. I hadn't yet made any changes to that part, and I think I have seen the effects of what you describe. I plan on making more changes, I'll definitely consider that as one of the factors to try to correct.

Thank you for that.
I remember the error came in about zen 138a and newer.
May have had something to do with session handling in the admin.
Prior to those versions of zen there was an admin\includes\classes\sessions.php that was removed in zen v138 and newer.
This file may have had an influence on it.

[mc12345678]

Thank you for that.
I remember the error came in about zen 138a and newer.
May have had something to do with session handling in the admin.
Prior to those versions of zen there was an admin\includes\classes\sessions.php that was removed in zen v138 and newer.
This file may have had an influence on it.

Welcome!

The thing I saw was when I was looking at the user tracking log, someone/something added a large number of items, when I refreshed the logs every entry showed the same thing in the cart rather than just the entry that had something in their cart, but I think it was identical to what was shown on the who's online screen.

So, I'm not sure if that is the same that you observed years ago, but it did appear as the who's online shows (a single "window" with all cart information shown including which session had the item(s).)

[petro]

I tried running the SQL patch via the "install sql patch" in my admin tools, and got this "WARNING: An Error occurred, please refresh the page and try again."

I then tried to manually install it by copypasta into PHPmyAdmin and got 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: Documentation
#1062 - Duplicate entry 'UserTracking' for key 'page_key'

not sure where to go from here in the install of this mod....

[petro]

OK i went back into myphpadmin and ran one line at a time, executed and everything seems to be working ok now

[mc12345678]

OK i went back into myphpadmin and ran one line at a time, executed and everything seems to be working ok now

Good! Whew. :)

Btw, the error message was indicating that you already had the menu option in the table, so you were being notified that there was nothing further to be done for that line.

[petro]

Ok here is my latest issue... it doesnt appear to be tracking anyone other than me in multiple instances... Ive even had someone today register as a new customer and place an order yet it doesnt show on the user tracking admin page... I have times when I have 20 users on and multiple members browsing yet this tracking only shows when Im on...

[mc12345678]

Ok here is my latest issue... it doesnt appear to be tracking anyone other than me in multiple instances... Ive even had someone today register as a new customer and place an order yet it doesnt show on the user tracking admin page... I have times when I have 20 users on and multiple members browsing yet this tracking only shows when Im on...

Can think of four reasons might be happening: 1) setting to track other users is not enabled in the User tracking configuration area, 2) footer file not updated to track users 3) footer file was updated, but is now overridden, and 4) all files not uploaded successfully.

A potential other cause I could see would be that somehow all other IP addresses are excluded from tracking except your own (seems unlikely at best, but could be). Any error logs generated during that time and do they reveal anything?

[petro]

Can think of four reasons might be happening: 1) setting to track other users is not enabled in the User tracking configuration area, 2) footer file not updated to track users 3) footer file was updated, but is now overridden, and 4) all files not uploaded successfully.

A potential other cause I could see would be that somehow all other IP addresses are excluded from tracking except your own (seems unlikely at best, but could be). Any error logs generated during that time and do they reveal anything?

1:) is ok
2:)



3:) snapshot above was from the live tpl_footer file
4:) I never got the database SQL file to function properly.... The very first time I tried the copypasta into the admin>tools>install sql patches of the "new_install_user_tracking" sql file and got an error. then I tried it in myphpadmin and got a "duplicate" error, then based on some info In here I changed "TYPE=MyISAM" to "ENGINE=MyISAM" still get "duplicate" error. then I tried to run it one line at a time and got a "duplicate" error when I did these two lines by themselves:

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

After these two lines the remaining lines went off without a hitch...

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 ''
) ENGINE=MyISAM;

DELETE FROM configuration where configuration_group_id = '1084';
INSERT INTO configuration_group (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES (1084, '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)', 1084, 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)', 1084, 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 !', 1084, 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)', 1084, 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)', 1084, 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', 1084, 60, '2006-12-05 11:19:26', '2006-12-05 21:20:07', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

[petro]

can anyone explain this portion a little more thorough for me?

2:) Install sql patch file, preferably by phpMyAdmin then add sql patch to zen (as recommended in the forum).
4. Login into the admin area, upload via Admin/Tools --> Install SQL Patches the file in Sql --> new_install_user_tracking.sql

[mc12345678]

can anyone explain this portion a little more thorough for me?

As I recall seeing in this forum, there was a SQL patch file for Zen Cart itself related to one of the older versions of Zen Cart and it needed to be installed prior to this plug-in. That said, seeing that you are running 1.5.1, well I don't know of any SQL patches, but... there may be/the instruction still applies in general: make sure ZenCart is up-to-date prior to use for the version that you use.

Item 4 is about uploading the SQL file to support this plug-in as a new user. (Yes, until this is done, there may be errors that appear in the error log(s), because the data storage location may not exist to accept the data collected in the uploaded files. Another change I think to be made in the instructions (SQL before datafiles), although also thinking that installation could be improved through the use of an autoinstaller as well.

Clear it up any?