Uninstall SQL Patch

[CharInLasVegas]

I installed a mod that required a sql patch, but I need to uninstall because I have an error and I need to see if this caused it or not. But there's no uninstall patch...how would I do this? (there's also no support thread for the mod and No, I did not back up my db )

This is the install patch:

DROP TABLE IF EXISTS customers_basket_later;
CREATE TABLE customers_basket_later (
customers_basket_id int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL default '0',
products_id tinytext NOT NULL,
customers_basket_quantity float NOT NULL default '0',
final_price decimal(15,4) NOT NULL default '0.0000',
customers_basket_date_added varchar(8) default NULL,
PRIMARY KEY (customers_basket_id),
KEY idx_customers_id_zen (customers_id)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table 'customers_basket_attributes'
#

DROP TABLE IF EXISTS customers_basket_later_attributes;
CREATE TABLE customers_basket_later_attributes (
customers_basket_attributes_id int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL default '0',
products_id tinytext NOT NULL,
products_options_id varchar(64) NOT NULL default '0',
products_options_value_id int(11) NOT NULL default '0',
products_options_value_text BLOB NULL,
products_options_sort_order text NOT NULL,
PRIMARY KEY (customers_basket_attributes_id),
KEY idx_cust_id_prod_id_zen (customers_id,products_id(36))
) TYPE=MyISAM;

[Steven300]

DROP TABLE IF EXISTS customers_basket_later;
DROP TABLE IF EXISTS customers_basket_later_attributes;

[CharInLasVegas]

Thank you!

[barracuda]

I also made the same mistake and installed a mod that required a sql patch without making a backup . I want to uninstall it but there is no uninstall patch. Can anyone help please. Here is the sql patch:

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Display Product Short Descriptions', 'PRODUCT_LIST_SHORT_DESC', '3', 'Set to 0 to disable, set to 1-99 to enable.', 8, 11, now(), now(), NULL, NULL);


ALTER TABLE products_description ADD products_short_desc VARCHAR( 255 ) DEFAULT NULL AFTER products_description ;



INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Product Info - Display Product Short Descriptions', 'PRODUCT_INFO_SHORT_DESC', '1', 'Show Product''s short Description<br />0= off<br />1= on', 18, 30, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''0'', ''text''=>''Off''), array(''id''=>''1'', ''text''=>''On'')),');

[Steven300]

DELETE FROM configuration WHERE configuration_key = 'PRODUCT_LIST_SHORT_DESC';

ALTER TABLE products_description DROP COLUMN products_short_desc;

DELETE FROM configuration WHERE configuration_key = 'PRODUCT_INFO_SHORT_DESC';

[barracuda]

Thank you .

[JGraphics]

2 Uninstall SQL Patches needed:
Here is the first patch:


SET @gid=0;
SELECT @gid:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title LIKE '%Tabbed Products Config%'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @gid;
DELETE FROM configuration_group WHERE configuration_group_id = @gid;
SET @gid=0;
SELECT @gid:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title LIKE '%TPP - Config%'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @gid;
DELETE FROM configuration_group WHERE configuration_group_id = @gid;
DELETE FROM configuration_group WHERE configuration_group_title LIKE '%Tabbed Products Config%';
DELETE FROM configuration_group WHERE configuration_group_title LIKE '%TPP - Config%';
DELETE FROM configuration WHERE configuration_description LIKE 'Set this to 1%' LIMIT 12;
DELETE FROM configuration WHERE configuration_title LIKE 'TPP - %' LIMIT 12;
INSERT INTO configuration_group VALUES (NULL, 'TPP - Config', 'Tabbed Products Pro - Config', '1', '1');
SET @gid=last_insert_id();
UPDATE configuration_group SET sort_order = @gid WHERE configuration_group_id = @gid;
INSERT INTO configuration VALUES(NULL, 'TPP - Global Enable Tabs', 'GLOBAL_ENABLE_TABS', '1', 'Set this to 1 if you want to enable the global use of tabs on your products', @gid, 1, '2008-01-14 20:11:07', '2007-01-12 22:07:11', NULL, 'zen_cfg_select_option(array(''0'', ''1''),'),
(NULL, 'TPP - Global Main Image On Tab', 'GLOBAL_MAIN_IMAGE_ON_TAB', '0', 'Set this to 1 if you want all products to have the Main Image on the first (Product Description) tab', @gid, 2, '2008-01-14 20:18:34', '2007-01-12 22:07:11', NULL, 'zen_cfg_select_option(array(''0'', ''1''),'),
(NULL, 'TPP - Global Product Description Tab', 'GLOBAL_PROD_DESC_ON_TAB', '1', 'Set this to 1 if you want all products to have the Main Product Description on its own tab', @gid, 3, '2008-01-14 20:18:34', '2007-01-12 22:07:11', NULL, 'zen_cfg_select_option(array(''0'', ''1''),'),
(NULL, 'TPP - Global Attributes on Tab', 'GLOBAL_ATTRIBUTES_ON_TAB', '0', 'Set this to 1 if you want the Attributes to appear on their own tab. This will only show up if the product has attributes to show. If there are no attributes, the tab will not show up.', @gid, 4, '2008-01-14 20:19:22', '2007-01-12 22:07:11', NULL, 'zen_cfg_select_option(array(''0'', ''1''),'),
(NULL, 'TPP - Global Attributes on Add-to-Cart Tab', 'GLOBAL_ATTRIBUTES_ON_ATC_TAB', '0', 'Set this to 1 if you want the Attributes to appear on the Add-To-Cart tab. They will only show up if the product has attributes to show. YOU MUST ALSO LEAVE THE Global Attributes on Tab OPTION ENABLED. This will override the standalone tab and show the attributes on the Add-To-Cart tab only. If the Add-To-Cart tab is set to false, this will be ignored and the attributes will follow their own tab settings.', @gid, 5, '2008-01-14 20:19:22', '2007-01-12 22:07:11', NULL, 'zen_cfg_select_option(array(''0'', ''1''),'),
(NULL, 'TPP - Global Details On Tabs', 'GLOBAL_DETAILS_ON_TAB', '1', 'Set this to 1 if you want the Product Details to appear on their own tab (weight, model number, etc). This will only show up if the product has details enabled. If there are no product details, the tab will not show up. ', @gid, 6, '2008-01-15 15:34:07', '0001-01-01 00:00:00', NULL, 'zen_cfg_select_option(array(''0'', ''1''),'),
(NULL, 'TPP - Global Add To Cart Tab', 'GLOBAL_ADD_TO_CART_ON_TAB', '0', 'Set this to 1 if you want the add to cart button to be on its own tab. Note this includes Add To Cart button and Qty Discounts table.', @gid, 7, '2008-01-14 19:29:49', '2007-01-12 22:07:11', NULL, 'zen_cfg_select_option(array(''0'', ''1''),'),
(NULL, 'TPP - Global Additional Images Tab', 'GLOBAL_ADDL_IMAGES_ON_TAB', '1', 'Set this to 1 if you want the additional images for a product on its own tab. This will only show up if the product has additional images to show. If there are no additional images, the tab will not show up.', @gid, 8, '2008-01-14 20:19:09', '2007-01-12 22:07:11', NULL, 'zen_cfg_select_option(array(''0'', ''1''),'),
(NULL, 'TPP - Global Customers Also Purchased Tab', 'GLOBAL_CUST_ALSO_PURCH_ON_TAB', '1', 'Set this to 1 if you want the Customers Also Purchased module on its own tab. This will only show up if the product has other products to show. If there are no other products, the tab will not show up.', @gid, 9, '2008-01-14 20:19:15', '2007-01-12 22:07:11', NULL, 'zen_cfg_select_option(array(''0'', ''1''),'),
(NULL, 'TPP - Global Cross Sell Tab', 'GLOBAL_CROSS_SELL_ON_TAB', '0', 'Set this to 1 if you want the Cross Sell module on its own tab. This will only work if Cross Sell contrib is already installed and the product has cross sell items set up. Otherwise it will just not show up.', @gid, 10, '2007-01-12 22:07:11', '2007-01-12 22:07:11', NULL, 'zen_cfg_select_option(array(''0'', ''1''),'),
(NULL, 'TPP - Global Reviews Tab', 'GLOBAL_REVIEWS_ON_TAB', '1', 'Set this to 1 if you want the Product Reviews to show up on its own tab. This will always show up even if there are no reviews. The Review module has its own "No reviews found" so it defaults.', @gid, 11, '2008-01-14 20:19:36', '2007-01-12 22:07:11', NULL, 'zen_cfg_select_option(array(''0'', ''1''),'),
(NULL, 'TPP - Show Tab Headers', 'SHOW_TAB_HEADERS', '1', 'Set this to 1 if you want a header bar to appear under the tabs, above the tab content', @gid, 12, '2007-01-12 22:07:11', '2007-01-12 22:07:11', NULL, 'zen_cfg_select_option(array(''0'', ''1''),'),
(NULL, 'TPP - Pages to enable', 'TPP_PAGES', 'product_info', 'Enter product pages you want to enable TPP, separated by comma. (Example: \'product_info,document_product_info,product_music_info\')', @gid, 13, NOW(), NOW(), NULL, NULL),
(NULL, 'TPP - Stylesheet', 'TPP_STYLESHEET', 'alt_tpp_tabs1.css', 'Enter the stylesheet you want to use for TPP, you can find them under your css/tpp folder', @gid, 14, NOW(), NOW(), NULL, NULL);


Here is the second:


SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'CSS/JS Loader';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

INSERT INTO configuration_group VALUES ('', 'CSS/JS Loader', 'Set CSS/JS Loader Options', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'CSS/JS Loader';

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('Enable Minify', 'MINIFY_STATUS', 'true', 'Minifying will speed up your site\'s loading speed by combining and compressing css/js files.', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Minify Cache Time', 'MINIFY_CACHE_TIME_LENGHT', '31536000', 'Set minify cache time (in second). Default is 1 year (31536000)', @t4, 2, NOW(), NOW(), NULL, NULL),
('Latest Cache Time', 'MINIFY_CACHE_TIME_LATEST', '0', 'Normally you don\'t have to set this, but if you have just made changes to your js/css files and want to make sure they are reloaded right away, you can reset this to 0.', @t4, 3, NOW(), NOW(), NULL, NULL);

[Steven300]

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'TPP - Config'
LIMIT 1;

DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;


SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'CSS/JS Loader'
LIMIT 1;

DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;

[JGraphics]

Thanks Steven, really appreciate it.
Cheers

[esport14]

I installed a mod (Ajax image swapper) that required a sql patch, but I need to uninstall because I had a response of "can not create a configuration key because already exists", could you help me with the UNINSTALL patch?

*/

-- UNINSTALLATION
-- SET @t4=0;
-- SELECT (@t4:=configuration_group_id) as t4
-- FROM configuration_group
-- WHERE configuration_group_title= 'Fual Slimbox';
-- DELETE FROM configuration WHERE configuration_group_id = @t4;
-- DELETE FROM configuration_group WHERE configuration_group_id = @t4;

-- DROP TABLE products_attributes_images;

-- SET @t4=0;
-- SELECT (@t4:=configuration_group_id) as t4
-- FROM configuration_group
-- WHERE configuration_group_title= 'AJAX Image Swapper';
-- DELETE FROM configuration WHERE configuration_group_id = @t4;
-- DELETE FROM configuration_group WHERE configuration_group_id = @t4;

INSERT INTO configuration_group VALUES (NULL, 'Fual Slimbox', 'Configure Slimbox options', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Fual Slimbox';

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

(NULL, 'Enable Fual Slimbox?', 'FUAL_SLIMBOX', 'true', '<br />If true, all product images on the following pages will be displayed within a lightbox:<br /><br />- document_general_info<br />- document_product_info<br />- product_free_shipping_info<br />- product_info<br />- product_music_info<br />- product_reviews<br />- product_reviews_info<br />- product_reviews_write<br /><br />Please note: To completely remove Fual Slimbox please see the documentation provided.<br /><br /><b>Zen Lightbox overrides this when installed</b>. This means that if you have the ZL mod and Slimbox, Slimbox will do nothing. I have done this specifically to stop people messing their installations up. I have provided a modified version of ZL for ZL users, unfortunately switching ZL off doesnt really switch it off (all the javascript is still loaded), the modified version actually switches ZL off when you switch it off.<br /><br />
The big advantage of Slimbox over lightbox is that it takes only 30kb of javasript rather than well over 100kb for lightbox<br /><br />Unlike (Zen) Lightbox the Slimbox is completely generated using CSS, so any tweeks that you want to make to the look can be made from the CSS file.<br /><br />Props to: <a href="http://www.digitalia.be/software/slimbox">Christophe Beyls</a> for writing Slimbox, <a href="http://homepage.mac.com/yukikun/software/slimbox_ex/">Yukio Arita</a> for extending it to work with iframes (this is the extended version so you can put whole webpages in the Slimbox, dont get carried away though!) and Alex Clarke for the original ZL plugin which inspired me to write this.<br /><br /><b>Default: true</b><br />', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option( array(''true'', ''false''), '),

(NULL, 'Paranoia Mode', 'FUAL_SLIMBOX_NERVOUS', '1', '<br />Controls whether to wait until the DOM loads to display the image. This stops the problem of being redirected to the image rather than displaying the image in the lightbox if a user with a slow connection clicks on the image before the slimbox script has been initialised.<br /><br />0 = Relaxed: Dont wait until the DOM loads.<br />1 = Conservative: Waits until the DOM has loaded to make the image visible.<br />2 = Funky: Waits until the DOM has loaded to reveal the image with a funky transition. <strong>Depending on your template this may cause problems in IE6, so if you want to use the funky transition please test it in older browsers before going live.</strong><br /><br /><b>Default: 1 (Conservative)</b><br />', @t4, 10, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2''), '),

(NULL, 'Safe Navigation', 'FUAL_SLIMBOX_DISPLAY_VAR', 'true', '<br />With safe navigation enabled the Next and Prev links are displayed permenantly in the lightbox when there are additional images to display. Safe Navigation is recommended because without it the navigation links fail to show in IE6.<br /><br /><b>Default: true</b><br />', @t4, 15, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '),

(NULL, 'Page of Text', 'FUAL_SLIMBOX_PAGEOF', 'Page #1 of #2', '<br />Sets the "Page #1 of #2" text when there is more than one image.<br /><br />The text is replaced with a regular expression: #1 is the number of the current page, #2 is the total number of pages.<br /><br /><b>Examples:</b><br />Page #1 of #2 - default English<br />Page #1 (of #2) - variation English<br />Pagina #1 di #2 - Itallian<br /><br /><b>Default: Page #1 of #2</b><br />', @t4, 17, NOW(), NOW(), NULL, NULL),

(NULL, 'Transition Duration', 'FUAL_SLIMBOX_DURATION', '800', '<br />Controls the duration of the transition in milliseconds. (note that 1000 milliseconds = 1 second, so the default value of 800 is just under a second)<br /><br /><b>Default: 800</b><br />', @t4, 20, NOW(), NOW(), NULL, NULL),

(NULL, 'Transition Type', 'FUAL_SLIMBOX_TRANSITION_TYPE', 'Sine', '<br />Controls the type of the transition. See <a href="http://docs.mootools.net/Effects/Fx-Transitions.js">Mootools</a> for what the options mean.<br /><br /><b>Default: Sine</b><br />', @t4, 30, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''linear'', ''Quad'', ''Cubic'', ''Quart'', ''Quint'', ''Expo'', ''Circ'', ''Sine'', ''Back'', ''Bounce'', ''Elastic''), '),

(NULL, 'Transition Ease', 'FUAL_SLIMBOX_EASE', 'easeInOut', '<br />Controls the easing of the transition. See <a href="http://docs.mootools.net/Effects/Fx-Transitions.js">Mootools</a> for what the options mean.<br /><br /><b>Default: easeInOut</b><br />', @t4, 40, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''easeIn'', ''easeOut'', ''easeInOut''), '),

(NULL, 'Transition Amplitude', 'FUAL_SLIMBOX_AMPLITUDE', '5', '<br />Controls the amplitude of the transition.<br /><br /><b>Default: 5</b><br />', @t4, 50, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''1'', ''2'', ''3'',''4'',''5'',''6'',''7'',''8'',''9''), '),

(NULL, 'FPS', 'FUAL_SLIMBOX_FPS', '60', '<br />Controls the frames per second of the motion.<br /><br /><em>Should be an integer value between 1 - 200.</em><br /><br /><b>Default: 60</b><br />', @t4, 60, NOW(), NOW(), NULL, NULL),

(NULL, 'Width', 'FUAL_SLIMBOX_WIDTH', '400', '<br />Controls the initial width of the lightbox.<br /><br /><b>Default: 400</b><br />', @t4, 70, NOW(), NOW(), NULL, NULL),

(NULL, 'Height', 'FUAL_SLIMBOX_HEIGHT', '300', '<br />Controls the initial height of the lightbox. Have a play!<br /><br /><b>Default: 300</b><br />', @t4, 80, NOW(), NOW(), NULL, NULL),

(NULL, 'iFrame Width', 'FUAL_SLIMBOX_IWIDTH', '500', '<br />Controls the initial width of the lightbox when it contains an iFrame. Have a play!<br /><br /><b>Default: 500</b><br />', @t4, 90, NOW(), NOW(), NULL, NULL),

(NULL, 'iFrame Height', 'FUAL_SLIMBOX_IHEIGHT', '300', '<br />Controls the initial width of the lightbox when it contains an iFrame. Have a play!<br /><br /><b>Default: 300</b><br />', @t4, 100, NOW(), NOW(), NULL, NULL),

(NULL, 'Animate Caption', 'FUAL_SLIMBOX_CAPTION', 'true', '<br />Animates the caption. Have a play!<br /><br /><b>Default: true</b><br />', @t4, 110, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '),

(NULL, 'Class to Hide', 'FUAL_SLIMBOX_HIDE_ME', 'zenLightboxHideMe', '<br />Any content wrapped in with this class will be hidden when the lightbox is displayed (this extends the behaviour of Zen Lightbox which only hides DIV tags).<br /><br /><b>Default: zenLightboxHideMe</b> (This coincides with the Zen Lightbox default class.)<br />', @t4, 120, NOW(), NOW(), NULL, NULL);

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'AJAX Image Swapper';

CREATE TABLE products_attributes_images (
image_id INT NOT NULL AUTO_INCREMENT,
products_attributes_id INT NOT NULL,
products_id_no_attribute INT,
image_path VARCHAR(255),
image_title VARCHAR(255),
image_sort_order INT,
PRIMARY KEY(`image_id`)
);

INSERT INTO configuration_group
(configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible)
VALUES (NULL, 'AJAX Image Swapper', 'Config options for AJAX Image Swapper', '1', '1');

UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SET @last_id=0;
SELECT (@last_id:=configuration_group_id) as last_id
FROM configuration_group
WHERE configuration_group_title= 'AJAX Image Swapper';

INSERT INTO configuration
(configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added)
VALUES
('', 'Small Image Height', 'IMAGE_VIEWER_SMALL_IMAGE_HEIGHT','75','The height of small images in AJAX Image Swapper, shown as thumbnails. Default 75.', @last_id, 1, now()),
('', 'Small Image Width', 'IMAGE_VIEWER_SMALL_IMAGE_WIDTH','75','The height of small images in AJAX Image Swapper, shown as thumbnails. Default 75.', @last_id, 5, now()),
('', 'Medium Image Height', 'IMAGE_VIEWER_MEDIUM_IMAGE_HEIGHT','300','The height of medium images in AJAX Image Swapper. Default 300.', @last_id, 10, now()),
('', 'Medium Image Width', 'IMAGE_VIEWER_MEDIUM_IMAGE_WIDTH','300','The width of medium images in AJAX Image Swapper. Default 300.', @last_id, 15, now()),
('', 'Large Image Height (Max. image height)', 'IMAGE_VIEWER_LARGE_IMAGE_HEIGHT','9999','The height of large images / maximum image height in AJAX Image Swapper.', @last_id, 16, now()),
('', 'Large Image Width (Max. image width)', 'IMAGE_VIEWER_LARGE_IMAGE_WIDTH','9999','The width of large images / maximum image width in AJAX Image Swapper.', @last_id, 17, now()),
('', 'Number of Images Shown', 'IMAGE_VIEWER_IMAGES_NUM','3','Number of images shown in AJAX Image Swapper', @last_id, 20, now()),
('', 'Scroll Size', 'IMAGE_VIEWER_SCROLL_SIZE','3','How many images to be scrolled when pressing left or right arrow', @last_id, 25, now());