User tracking mod

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:

Quote:

---

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

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

Quote:

---

Originally Posted by petro

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.

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

http://i530.photobucket.com/albums/d...ksal0t/3-2.jpg


http://i530.photobucket.com/albums/d...ksal0t/4-2.jpg

Quote:

---

Originally Posted by 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...

http://i530.photobucket.com/albums/d...ksal0t/3-2.jpg


http://i530.photobucket.com/albums/d...ksal0t/4-2.jpg

---

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?

Quote:

---

Originally Posted by mc12345678

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:)
http://i530.photobucket.com/albums/d...ksal0t/5-1.jpg


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:

Quote:

---

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

---

Code:

---

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

Code:

---

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

---

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

Quote:

---

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

---

Quote:

---

Originally Posted by petro

1:) is ok
2:)
http://i530.photobucket.com/albums/d...ksal0t/5-1.jpg


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:

Code:

---

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

Code:

---

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

---

---

So, couple of things some related to your original problem, some not. I've looked through the SQL files and I do see that there is a potential to receive the error you had when either applying the SQL update file or the SQL new install file. The error message received though does not bear on the lack of data collection that you are experiencing; however, when I get back to updating this plug-in some more I will incorporate sufficient checks/direction. There really should be no reason to have run the SQL more than the first time it was installed or if upgrading from a version that is older than User Tracking Ver 1.4.0. If any of the times the problem was experienced with the SQL file, then something else was going on or an issue with the database.

To be sure I understood, the tpl_footer file you presented above. Let's assume that you have an active template called ZenCart, so the end of the file shown above is from /includes/templates/ZenCart/common/tpl_footer.php?

With that in mind, I suggest verifying that the two added files /includes/auto_loaders/config.user_tracking.php and includes/classes/observers/class.user_tracking.php be reuploaded. These two files "listen" for the footer code to activate tracking of the users visiting the site. Currently tracking is occurring; however, it is only on the admin side.

Quote:

---

Originally Posted by petro

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?

Quote:

---

Originally Posted by mc12345678

So, couple of things some related to your original problem, some not. I've looked through the SQL files and I do see that there is a potential to receive the error you had when either applying the SQL update file or the SQL new install file. The error message received though does not bear on the lack of data collection that you are experiencing; however, when I get back to updating this plug-in some more I will incorporate sufficient checks/direction. There really should be no reason to have run the SQL more than the first time it was installed or if upgrading from a version that is older than User Tracking Ver 1.4.0. If any of the times the problem was experienced with the SQL file, then something else was going on or an issue with the database.

To be sure I understood, the tpl_footer file you presented above. Let's assume that you have an active template called ZenCart, so the end of the file shown above is from /includes/templates/ZenCart/common/tpl_footer.php?

With that in mind, I suggest verifying that the two added files /includes/auto_loaders/config.user_tracking.php and includes/classes/observers/class.user_tracking.php be reuploaded. These two files "listen" for the footer code to activate tracking of the users visiting the site. Currently tracking is occurring; however, it is only on the admin side.

---

mc, I want to thank you again for helping out here. Im pretty much a noob so I'm trying all this with pretty limited coding skills and knowledge. Yes the image of the code I added to the footer is that of the php file located in my customized template im using. I also verified /includes/auto_loaders/config.user_tracking.php and includes/classes/observers/class.user_tracking.php are both in there and reuploaded them on top of the ones already up there.