uninstall SQL patch that's messed up my site

[limelites]

I have just installed a MOD that's completely messed up my site layout.

How on earth do I uninstall these 2 SQL patches? Please, I need very basic instructions as I have no clue where to start:

1.

# QT Pro V4.0 Date: 11/27/2004

# Insert configuration group for Product Information page
INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (888001, 'Dynamic Drop Downs', 'Dynamic Drop Downs configuration options', 8, 1);

# Insert configuration keys for Product Information Page
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('Product Info Single Attribute Display Plugin', 'PRODINFO_ATTRIBUTE_PLUGIN_SINGLE', 'multiple_dropdowns', 'The plugin used for displaying attributes on the product information page.', 888001, 1, now(), NULL, 'zen_cfg_select_option(array(\'single_radioset\', \'single_dropdown\',\'multiple_dropdowns\',\'sequenced_dropdowns\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('Product Info Multiple Attribute Display Plugin', 'PRODINFO_ATTRIBUTE_PLUGIN_MULTI', 'sequenced_dropdowns', 'The plugin used for displaying attributes on the product information page.', 888001, 1, now(), NULL, 'zen_cfg_select_option(array(\'single_radioset\', \'single_dropdown\',\'multiple_dropdowns\',\'sequenced_dropdowns\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('Show Out of Stock Attributes', 'PRODINFO_ATTRIBUTE_SHOW_OUT_OF_STOCK', 'True', 'Controls the display of out of stock attributes.', 888001, 10, now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('Mark Out of Stock Attributes', 'PRODINFO_ATTRIBUTE_MARK_OUT_OF_STOCK', 'Right', 'Controls how out of stock attributes are marked as out of stock.', 888001, 20, now(), NULL, 'zen_cfg_select_option(array(\'None\', \'Right\', \'Left\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('Display Out of Stock Message Line', 'PRODINFO_ATTRIBUTE_OUT_OF_STOCK_MSGLINE', 'True', 'Controls the display of a message line indicating an out of stock attributes is selected.', 888001, 30, now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('Prevent Adding Out of Stock to Cart', 'PRODINFO_ATTRIBUTE_NO_ADD_OUT_OF_STOCK', 'True', 'Prevents adding an out of stock attribute combination to the cart.', 888001, 40, now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'),');


2.

# Add new column to products_options to indicate if stock should be tracked
# for an option

ALTER TABLE products_options
ADD products_options_track_stock tinyint(4) default '1' not null
AFTER products_options_name;


Please, someone help.

[limelites]

It doesn't have any options to disable it from the admin, it has 4 settings, none of which are off. Totally screwed up the layout, pushed the tabs to the bottom, added an extra large image and deleted the additional images... What a mess

[limelites]

is there some way to write an uninstall patch for this?

[limelites]

I think I'm going to need a clean install here.... can anyone help?

I'm thinking about completely deleting the ADMIN folder and re-uploading the install ADMIN folder then having to go through and install all the working SQL patches and redo all the settings...

Surely there's something less drastic I can do here?

[bunyip]

run this from your Admin > Install SQL Patches

DELETE FROM configuration_group WHERE configuration_group_title = 'Dynamic Drop Downs';
DELETE FROM configuration WHERE 'configuration_group_id' = 888001;
ALTER TABLE products_options DROP products_options_track_stock;

[limelites]

Did that,

Now I'm getting this mesasge on product pages:

1054 Unknown column 'popt.products_options_track_stock' in 'field list'
in:
[select distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock from products_options popt, products_attributes patrib where patrib.products_id='2' and patrib.options_id = popt.products_options_id and popt.language_id =1 and popt.products_options_track_stock = '1' order by popt.products_options_sort_order]

[bunyip]

You'll now need to go and remove any file modifications that were made

[limelites]

by file modification, you mean lines added to database._tables.php and product_info.php..... I already changed those back to their original state.

Should I delete all the files that this mod uploaded too?

[bunyip]

I believe the mod you installed had a modified template file:
tpl_modules_attributes.php
that you should have installed at includes/templates/YOUR_TEMPLATE/templates/

If you installed it in that folder, just delete it.
If you overwrote the original cart file at includes/templates/template_default/templates/tpl_modules_attributes.php you will have to upload a fresh, unmodified copy.

[limelites]

Thanks for helping me with this by the way, I hope you can help me get it back the way it was..

It installed a bunch of php files in the /includes/classes folder, but when I rename them it completely deletes the product page view altogether.