User tracking mod

Printable View

Show 100 post(s) from this thread on one page

17 Jun 2014, 09:52 PM
MyCoolHats

Re: User tracking mod

Quote:

Originally Posted by mc12345678

I can say this, no it's not because of using zC 1.5.1.

Placing the entire code of the new install sql into the instaall sql patches window of the admin should install all of the sql at once. It will not work if put in one line at a time.

I tried it again and received an error, please refresh page and try again. Now in my error log it says duplicate error (below). I have tried the uninstall sql and then the new install sql and get the same duplicate error. :(

PHP Code:

[17-Jun-2014 14:49:42] PHP Fatal error: 1062:Duplicate entry 'UserTracking' for key 'page_key' :: /* Tables need to be ensured to include the prefix if it exists. */ 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); in /home1/mycoolha/public_html/catalog/includes/classes/db/mysql/query_factory.php on line 120
17 Jun 2014, 10:04 PM
mc12345678

Re: User tracking mod

Quote:

Originally Posted by MyCoolHats

I tried it again and received an error, please refresh page and try again. Now in my error log it says duplicate error (below). I have tried the uninstall sql and then the new install sql and get the same duplicate error. :(

PHP Code:

[17-Jun-2014 14:49:42] PHP Fatal error: 1062:Duplicate entry 'UserTracking' for key 'page_key' :: /* Tables need to be ensured to include the prefix if it exists. */ 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); in /home1/mycoolha/public_html/catalog/includes/classes/db/mysql/query_factory.php on line 120

Looking at the ver 1.5 uninstall sql, the removal of that page_key should have occurred already. You can also safely omit that line from the new_install text when posting the sql. The lines that can not be omitted, involve @UserTrackgID up to the ending semicolon.
17 Jun 2014, 10:18 PM
MyCoolHats

Re: User tracking mod

Quote:

Originally Posted by mc12345678

Looking at the ver 1.5 uninstall sql, the removal of that page_key should have occurred already. You can also safely omit that line from the new_install text when posting the sql. The lines that can not be omitted, involve @UserTrackgID up to the ending semicolon.

Okay, so I upload this portion of the new install sql

PHP Code:

SELECT @UserTrackgID := configuration_group_id FROM configuration_group where configuration_group_title LIKE '%User Tracking%'; DELETE FROM configuration where configuration_group_id = @UserTrackgID; /* DELETE FROM configuration where configuration_group_id = '999'; Desire is to replace 999 with the next configuration_group_id; however, this may require revision to the base code to support*/ INSERT INTO configuration_group (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES (0, 'User Tracking Config', 'User Tracking', '', 1); SELECT @UserTrackgID := configuration_group_id FROM configuration_group where configuration_group_title LIKE '%User Tracking%'; UPDATE configuration_group SET sort_order = @UserTrackgID WHERE configuration_group_id = @UserTrackgID; INSERT INTO configuration VALUES (0, 'User Tracking Visitors', 'ZEN_CONFIG_USER_TRACKING', 'true', 'Check the Customers/Guests behaviour ? (each click will be recorded)', @UserTrackgID, 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 (0, 'User Tracking (ADMIN)', 'ADMIN_CONFIG_USER_TRACKING', 'true', 'Check the ADMINs behaviour ? (each click will be recorded)', @UserTrackgID, 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 (0, 'User Tracking (exclude this IP-Address)', 'CONFIG_USER_TRACKING_EXCLUDED', 'your IP', 'Do NOT record this IP Address (like webmaster/owners/Beta-testers)', @UserTrackgID, 10, '2003-03-04 23:08:38', '2003-02-09 21:20:07', NULL, NULL); INSERT INTO configuration VALUES (0, 'User Tracking (Session Limit)', 'CONFIG_USER_TRACKING_SESSION_LIMIT', '50', 'Displaying the latest # sessions of this 24 hour period. (SET to 999999 for unlimited per 24 hour period) NOTE: Watch you space !', @UserTrackgID, 15, '2003-03-03 11:19:13', '2003-02-09 21:20:07', NULL, NULL); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (0, 'User Tracking (Admin User Can Delete)', 'CONFIG_USER_TRACKING_ADMIN_CAN_DELETE', 'true', 'Allow Record Deletion to be Active? Setting this to true will override ENTRY and SESSION purges. Default true ', @UserTrackgID, 25, '2013-11-09 11:19:26', '2013-11-09 11:19:26', NULL, 'zen_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (0, 'User Tracking (Admin User Can Delete Historical Data)', 'CONFIG_USER_TRACKING_ADMIN_CAN_DELETE_RECORDS', 'false', 'Allow Record Deletion of records older than now - the purge duration set below. This value is ignored if Admin User Can Delete is set to true. Otherwise set this to true to allow deletion of visits. Default false. ', @UserTrackgID, 26, '2013-11-09 11:19:26', '2013-11-09 11:19:26', NULL, 'zen_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (0, 'User Tracking (Admin User Can Delete SESSIONS)', 'CONFIG_USER_TRACKING_ADMIN_CAN_DELETE_SESSIONS', 'false', 'Allow SESSION Deletion to be Active? This setting is ignored if Admin User Can Delete is set to true. Default false ', @UserTrackgID, 27, '2013-11-09 11:19:26', '2013-11-09 11:19:26', NULL, 'zen_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (0, 'User Tracking (Admin User Can Delete IP)', 'CONFIG_USER_TRACKING_ADMIN_CAN_DELETE_IP', 'false', 'Allow Deletion of records that match the identified IP address? This setting is ignored if Admin User Can Delete is set to true. Default false ', @UserTrackgID, 28, '2013-11-09 11:19:26', '2013-11-09 11:19:26', NULL, 'zen_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (0, 'User Tracking (Purge this Number)', 'CONFIG_USER_TRACKING_PURGE_NUMBER', '3', 'What is the number associated with purging before the current date/time? An example would be to choose 3 here and units associated with days to delete data greater than 3 days before today. ', @UserTrackgID, 30, '2013-11-09 23:08:38', '2013-11-09 23:08:38', NULL, NULL); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (0, 'User Tracking (Purge Units)', 'CONFIG_USER_TRACKING_PURGE_UNITS', '1440', 'Pick the units associate with the periodicity to allow purging data. 60) Hours 1440) Days 10080) Weeks 43200) Months (Based on 30 days) ', @UserTrackgID, 31, '2013-11-09 23:08:38', '2013-11-09 23:08:38', NULL, 'zen_cfg_select_option(array(''60'', ''1440'',''10080'',''43200''),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (0, 'User Tracking (Type of User Interaction to Record)', 'CONFIG_USER_TRACKING_TRACK_TYPE_RECORD', '1', 'Type of user tracking to record? 1 - All visitors. 2 - Visitors views where sessions have been started. 3 - All users except bots/spiders ( requires Configuration->Sessions->Prevent Spider Sessions->true) (Don\'t know if this works with Zen-Cart versions older than 1.2.6d) Related to above: If you set Force Cookie Use->true, then at the first user entry, sessions do not start!!! And in variants 2 and 3, user-tracking will not have started. In this case you lose one click and do not log the refferal. But if this user is a returning user and has an old/previous zen cookie the session started and your tracking system will collect this info. So, the result beforehand is not logged or will not be known. ', @UserTrackgID, 40, '2013-11-09 11:19:26', '2013-11-09 11:19:26', NULL, 'zen_cfg_select_option(array(''1'', ''2'',''3''),'); INSERT INTO configuration VALUES (0, '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 (the IP will follow automaticly after this url)', @UserTrackgID, 50, '2003-03-03 11:19:13', '2003-03-11 11:40:01', NULL, NULL); INSERT INTO configuration VALUES (0, 'User Tracking (Show Product Category when tracking product clicks)', 'ZEN_CONFIG_SHOW_USER_TRACKING_CATEGORY', 'true', 'Show Product Category when tracking product clicks', @UserTrackgID, 60, '2006-12-05 11:19:26', '2006-12-05 21:20:07', NULL, 'zen_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration VALUES (0, 'User Tracking (Version Installed)', 'CONFIG_USER_TRACKING_VERSION', '1.5', 'Shows the version number associated with user tracking and should be updated with each upgrade', @UserTrackgID, 1000, '2013-11-10 04:19:26', '2013-11-18 04:19:26', NULL, NULL);

I still received a webpage error, to refresh page and try again later. In my logs I have this error

PHP Code:

[17-Jun-2014 15:15:23] PHP Fatal error: 1136:Column count doesn't match value count at row 1 :: INSERT INTO configuration VALUES (0, 'User Tracking Visitors', 'ZEN_CONFIG_USER_TRACKING', 'true', 'Check the Customers/Guests behaviour ? (each click will be recorded)', @UserTrackgID, 1, '2003-03-03 11:19:26', '2003-02-09 21:20:07', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
17 Jun 2014, 10:28 PM
mc12345678

Re: User tracking mod

Quote:

Originally Posted by mc12345678

Then I think now that I look at the new_install and update sqls, that the update sql is to be run after the new_install.

Sorry, it appears that the full new install sql didn't get the new features added to it. :/ thank you for identifying this. All the more reason to put together the installer I was working on so that the instructions will be very easy. :) it is easier to do than to document. :) I will do better though.

Had a better opportunity to look/search through the two files. I was wrong about the above statement. The two files do have the same SQL queries in them to create all of the options afforded by Version 1.5; however, there still remains a formatting issue that may be affecting some versions of SQL server... There is also a no-no in the SQL statements that I will include here.

New Users until the next update:

Code:

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); SELECT @UserTrackgID := configuration_group_id FROM configuration_group where configuration_group_title LIKE '%User Tracking%'; 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_CONFIGURATION', CONCAT('gID=', @UserTrackgID), 'configuration', 'Y', 10001) WHERE @UserTrackgID <> 0; 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; SELECT @UserTrackgID := configuration_group_id FROM configuration_group where configuration_group_title LIKE '%User Tracking%'; DELETE FROM configuration where configuration_group_id = @UserTrackgID and @UserTrackgID <> 0; INSERT INTO configuration_group (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES (0, 'User Tracking Config', 'User Tracking', '', 1); SELECT @UserTrackgID := configuration_group_id FROM configuration_group where configuration_group_title LIKE '%User Tracking%'; UPDATE configuration_group SET sort_order = @UserTrackgID WHERE configuration_group_id = @UserTrackgID and @UserTrackgID <> 0; INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (0, 'User Tracking Visitors', 'ZEN_CONFIG_USER_TRACKING', 'true', 'Check the Customers/Guests behaviour ? (each click will be recorded)', @UserTrackgID, 1, '2003-03-03 11:19:26', '2003-02-09 21:20:07', NULL, 'zen_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (0, 'User Tracking (ADMIN)', 'ADMIN_CONFIG_USER_TRACKING', 'true', 'Check the ADMINs behaviour ? (each click will be recorded)', @UserTrackgID, 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 (0, 'User Tracking (exclude this IP-Address)', 'CONFIG_USER_TRACKING_EXCLUDED', 'your IP', 'Do NOT record this IP Address (like webmaster/owners/Beta-testers)', @UserTrackgID, 10, '2003-03-04 23:08:38', '2003-02-09 21:20:07', NULL, NULL); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (0, 'User Tracking (Session Limit)', 'CONFIG_USER_TRACKING_SESSION_LIMIT', '50', 'Displaying the latest # sessions of this 24 hour period. (SET to 999999 for unlimited per 24 hour period) NOTE: Watch you space !', @UserTrackgID, 15, '2003-03-03 11:19:13', '2003-02-09 21:20:07', NULL, NULL); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (0, 'User Tracking (Admin User Can Delete)', 'CONFIG_USER_TRACKING_ADMIN_CAN_DELETE', 'true', 'Allow Record Deletion to be Active? Setting this to true will override ENTRY and SESSION purges. Default true ', @UserTrackgID, 25, '2013-11-09 11:19:26', '2013-11-09 11:19:26', NULL, 'zen_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (0, 'User Tracking (Admin User Can Delete Historical Data)', 'CONFIG_USER_TRACKING_ADMIN_CAN_DELETE_RECORDS', 'false', 'Allow Record Deletion of records older than now - the purge duration set below. This value is ignored if Admin User Can Delete is set to true. Otherwise set this to true to allow deletion of visits. Default false. ', @UserTrackgID, 26, '2013-11-09 11:19:26', '2013-11-09 11:19:26', NULL, 'zen_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (0, 'User Tracking (Admin User Can Delete SESSIONS)', 'CONFIG_USER_TRACKING_ADMIN_CAN_DELETE_SESSIONS', 'false', 'Allow SESSION Deletion to be Active? This setting is ignored if Admin User Can Delete is set to true. Default false ', @UserTrackgID, 27, '2013-11-09 11:19:26', '2013-11-09 11:19:26', NULL, 'zen_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (0, 'User Tracking (Admin User Can Delete IP)', 'CONFIG_USER_TRACKING_ADMIN_CAN_DELETE_IP', 'false', 'Allow Deletion of records that match the identified IP address? This setting is ignored if Admin User Can Delete is set to true. Default false ', @UserTrackgID, 28, '2013-11-09 11:19:26', '2013-11-09 11:19:26', NULL, 'zen_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (0, 'User Tracking (Purge this Number)', 'CONFIG_USER_TRACKING_PURGE_NUMBER', '3', 'What is the number associated with purging before the current date/time? An example would be to choose 3 here and units associated with days to delete data greater than 3 days before today. ', @UserTrackgID, 30, '2013-11-09 23:08:38', '2013-11-09 23:08:38', NULL, NULL); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (0, 'User Tracking (Purge Units)', 'CONFIG_USER_TRACKING_PURGE_UNITS', '1440', 'Pick the units associate with the periodicity to allow purging data. 60) Hours 1440) Days 10080) Weeks 43200) Months (Based on 30 days) ', @UserTrackgID, 31, '2013-11-09 23:08:38', '2013-11-09 23:08:38', NULL, 'zen_cfg_select_option(array(''60'', ''1440'',''10080'',''43200''),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (0, 'User Tracking (Type of User Interaction to Record)', 'CONFIG_USER_TRACKING_TRACK_TYPE_RECORD', '1', 'Type of user tracking to record? 1 - All visitors. 2 - Visitors views where sessions have been started. 3 - All users except bots/spiders ( requires Configuration->Sessions->Prevent Spider Sessions->true) (Don\'t know if this works with Zen-Cart versions older than 1.2.6d) Related to above: If you set Force Cookie Use->true, then at the first user entry, sessions do not start!!! And in variants 2 and 3, user-tracking will not have started. In this case you lose one click and do not log the refferal. But if this user is a returning user and has an old/previous zen cookie the session started and your tracking system will collect this info. So, the result beforehand is not logged or will not be known. ', @UserTrackgID, 40, '2013-11-09 11:19:26', '2013-11-09 11:19:26', NULL, 'zen_cfg_select_option(array(''1'', ''2'',''3''),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (0, '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 (the IP will follow automaticly after this url)', @UserTrackgID, 50, '2003-03-03 11:19:13', '2003-03-11 11:40:01', NULL, NULL); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (0, 'User Tracking (Show Product Category when tracking product clicks)', 'ZEN_CONFIG_SHOW_USER_TRACKING_CATEGORY', 'true', 'Show Product Category when tracking product clicks', @UserTrackgID, 60, '2006-12-05 11:19:26', '2006-12-05 21:20:07', NULL, 'zen_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration VALUES (0, 'User Tracking (Version Installed)', 'CONFIG_USER_TRACKING_VERSION', '1.5', 'Shows the version number associated with user tracking and should be updated with each upgrade', @UserTrackgID, 1000, '2013-11-10 04:19:26', '2013-11-18 04:19:26', NULL, NULL);

The above is updated to reflect mostly what I would say will be in the next version. I plan on changing all of the dates so that they are autopopulated though, rather than hard coded as above, also, the use of 0 for the configuration_id is unnecessary and actually can cause some installations not to work as they expect either a NULL or to not have the value passed to begin with.

This revision of the new install file removes the need to run an update query that is posted 2 pages back to rid the use of the user_tracking_config file. Now the settings appear under the admin's configuration menu option as expected/desired.
17 Jun 2014, 10:54 PM
MyCoolHats

Re: User tracking mod

Quote:

Originally Posted by mc12345678

This revision of the new install file removes the need to run an update query that is posted 2 pages back to rid the use of the user_tracking_config file. Now the settings appear under the admin's configuration menu option as expected/desired.

I did try this new sql first with the first line and received the duplicate error. Then I did it without the first line and received this error:

Code:

[17-Jun-2014 15:49:54] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE @UserTrackgID <> 0' at line 1 :: 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_CONFIGURATION', CONCAT('gID=', @UserTrackgID), 'configuration', 'Y', 10001) WHERE @UserTrackgID <> 0; in /home1/mycoolha/public_html/catalog/includes/classes/db/mysql/query_factory.php on line 120

Was I not suppose to try this sql?? I am so sorry to bother you with all of this. I love your work and I know you are working very hard on this. Please know that I greatly appreciate all you are doing.
17 Jun 2014, 11:02 PM
mc12345678

Re: User tracking mod

Quote:

Originally Posted by MyCoolHats

I did try this new sql first with the first line and received the duplicate error. Then I did it without the first line and received this error:

Code:

[17-Jun-2014 15:49:54] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE @UserTrackgID <> 0' at line 1 :: 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_CONFIGURATION', CONCAT('gID=', @UserTrackgID), 'configuration', 'Y', 10001) WHERE @UserTrackgID <> 0; in /home1/mycoolha/public_html/catalog/includes/classes/db/mysql/query_factory.php on line 120

Was I not suppose to try this sql?? I am so sorry to bother you with all of this. I love your work and I know you are working very hard on this. Please know that I greatly appreciate all you are doing.

Okay, so I posted that solution without doing a little more review. My concern is in a delete situation that if the @UserTrackgID is zero then the wrong information will be deleted. In an insert situation such as that line, if you only omitted the first line (the install) then the value should be non-zero, but the check is there so that the configuration option doesn't get buried. So, to that end, and without my other resources immediately available, can try where @UserTrackgID != 0 or instead of just 0 try '0' for the two cases of <> '0' and != '0'.

See if that helps/works. In use though, really the insertion of the admin pages appears to not be necessary as they are currently installed per the duplicate errors reported. Can fix the user tracking configuration error in a bit after verifying that the remaining SQL works. :)
17 Jun 2014, 11:06 PM
mc12345678

Re: User tracking mod

Try repeating what you did before with starting just after the table creation.
17 Jun 2014, 11:20 PM
MyCoolHats

Re: User tracking mod

Quote:

Originally Posted by mc12345678

So, to that end, and without my other resources immediately available, can try where @UserTrackgID != 0 or instead of just 0 try '0' for the two cases of <> '0' and != '0'.

Huh? where and what do you want me to change? :blink:
17 Jun 2014, 11:40 PM
mc12345678

Re: User tracking mod

Quote:

Originally Posted by MyCoolHats

Huh? where and what do you want me to change? :blink:

In the line that reads:

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_CONFIGURATION', CONCAT('gID=', @UserTrackgID), 'configuration', 'Y', 10001) WHERE @UserTrackgID <> 0;

Try

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_CONFIGURATION', CONCAT('gID=', @UserTrackgID), 'configuration', 'Y', 10001) WHERE @UserTrackgID != 0;

Or:

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_CONFIGURATION', CONCAT('gID=', @UserTrackgID), 'configuration', 'Y', 10001) WHERE @UserTrackgID <> '0';

Or:

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_CONFIGURATION', CONCAT('gID=', @UserTrackgID), 'configuration', 'Y', 10001) WHERE @UserTrackgID != '0';

As a substitution for what is already there. (Meaning, omit the very first line, then include the remaining sql with the substitution of the above.

Although, I think that won't matter in this case, as you are likely to get a duplicate error again. But if you try like you posted before of using the statements that follow the table creation as they have been rewritten then that is more than likely to work. May have to do the substitution of != in place of <> though in one or more of those statements.
17 Jun 2014, 11:45 PM
mc12345678

Re: User tracking mod

Primarily at the moment I waant to see if any of the insert into configuration statements will work on your system. It's not that it is highly unique, but is more than likely a result of having a "updated" version of the sql server software or a requirement to be more specific than what was needed in the past. Thing is that the insert statements need to have that @configusergid variable assigned a value as part of running. Otherwise a different problem will appear.

Does that make sense this go round?

Show 100 post(s) from this thread on one page