How do I remove these sql patches?

[discoverytdi]

HI asked this question on the all business template forum
this is the answer I got hence I'm posting here.

I included the column layout grid mod with the template but am not the author of that mod. Read the install file for the mod or ask or read the mod support thread. I am sure the question has been asked before.

Thanks,

Anne


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 Listing - Layout Style', 'PRODUCT_LISTING_LAYOUT_STYLE', 'rows',
'Select the layout style:<br />Each product can be listed in its own row (rows option)
or products can be listed in multiple columns per row (columns option)', '8', '40', NULL,
now(), NULL, 'zen_cfg_select_option(array(\'rows\', \'columns\'),');

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 Listing - Columns Per Row', 'PRODUCT_LISTING_COLUMNS_PER_ROW', '3',
'Select the number of columns of products to show in each row in the product listing.
The default setting is 3.', '8', '41', NULL, now(), NULL, NULL);


Peter

[discoverytdi]

http://www.rvsolarsystems.co.uk/store I'm assuming it's these patches that are causing this

[RodG]

http://www.rvsolarsystems.co.uk/store I'm assuming it's these patches that are causing this

Bad assumption.

It is very rare for an SQL patch to be the cause of any problems. Even if/when the module(s) that did the patching are removed.

You are far more likely to CAUSE a problem by removing/undoing SQL patches than you are by leaving them.

The problems arise as a result of people removing/undoing the SQL patches but NOT removing/undoing the changes to the .php files that reference the updated database fields that the patches install.

In other words, to solve your problem you need to undo the *file* changes that were made, and not the SQL changes.

Make sense?

Cheers
Rod