I have recently installed the SQL patch to set up the ecommerce function on zencart for google analytics. I also installed a sql patch to set up super tracker fpr zen cart. It has messed up my cart and is not accessible. Can anyone tell me what can be done to uninstall it?
This is the SQL patch- for Google Analytics
SET @configuration_group_id=0;
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Google Analytics Configuration' LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Google Analytics Configuration', 'Set Google Analytics Options', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Analytics Account', 'GOOGLE_ANALYTICS_UACCT', 'UA-XXXXXX-X', 'Enter your Google Analytics account number', @configuration_group_id, 1, NOW(), NULL, NULL),
(NULL, 'Target Address', 'GOOGLE_ANALYTICS_TARGET', 'customers', 'What adress (City/State/Country to correlate the transaction with) use in Analytics transaction?', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'customers\', \'delivery\', \'billing\'),'),
(NULL, 'Affiliation', 'GOOGLE_ANALYTICS_AFFILIATION', '', 'Optional partner or store affilation', @configuration_group_id, 3, NOW(), NULL, NULL),
(NULL, 'Use sku/code', 'GOOGLE_ANALYTICS_SKUCODE', 'products_id', 'Using as Product SKU code', @configuration_group_id, 4, NOW(), NULL, 'zen_cfg_select_option(array(\'products_id\', \'products_model\'),'),
(NULL, 'Use pagename', 'GOOGLE_ANALYTICS_USE_PAGENAME', 'false', 'Use pagename in tracking? Be careful when using this!', @configuration_group_id, 5, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Attributes Brackets', 'GOOGLE_ANALYTICS_PRODUCTS_ATTRIBUTES_BRACKETS', '[]', 'Attributes Brackets', @configuration_group_id, 6, NOW(), NULL, NULL),
(NULL, 'Attributes Delimiter', 'GOOGLE_ANALYTICS_PRODUCTS_ATTRIBUTES_DELIMITER', '; ', 'Attributes Delimiter', @configuration_group_id, 7, NOW(), NULL, NULL),
(NULL, 'Tracking Outbound', 'GOOGLE_ANALYTICS_TRACKING_OUTBOUND', 'false', '', @configuration_group_id, 21, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Tracking Outbound Links Prefix', 'GOOGLE_ANALYTICS_TRACKING_OUTBOUND_LINKS_PREFIX', '/outgoing/', '', @configuration_group_id, 22, NOW(), NULL, NULL),
(NULL, 'Use AdWords Conversion', 'GOOGLE_CONVERSION_ACTIVE', 'true', 'Use AdWords Conversion', @configuration_group_id, 91, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'AdWords Conversion ID', 'GOOGLE_CONVERSION_ID', '', 'Enter your Google Conversion ID', @configuration_group_id, 92, NOW(), NULL, NULL),
(NULL, 'AdWords Conversion Language', 'GOOGLE_CONVERSION_LANGUAGE', 'en_US', 'Enter your Google Conversion Language', @configuration_group_id, 93, NOW(), NULL, NULL);



