Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2008
    Location
    Cape Town! South Africa
    Posts
    9
    Plugin Contributions
    0

    Default Reverse SQL Patch

    Hi

    I installed the add-on Column Layout for Product Listing but I haven't managed to get it to do what I want exactly despite following the instructions. Is there a way to reverse the SQL patch?

    It was:

    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);

    If not, I have a back-up of my store files somewhere, but where would the SQL patches be stored in the folders?

    Any help would be greatly appreciated.

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Reverse SQL Patch

    SQL are not stored in files - they are added to the Database.

    Actually, you have the ability to display as normal row or as column with this installed....I do not know the exact reason that this has not been rolled into the core code as I see no downside from it.
    Zen-Venom Get Bitten

 

 

Similar Threads

  1. v139h Upload SQL Patch via phpMyAdmin in MySQL INSTEAD OF Amin-Tools-Install AQL patch ????
    By shags38 in forum Customization from the Admin
    Replies: 11
    Last Post: 20 Aug 2012, 04:19 AM
  2. v139h DB/SQL Error when using SQL Patch for Add Pages More Info Sidebox addon
    By maperr55 in forum All Other Contributions/Addons
    Replies: 6
    Last Post: 5 Mar 2012, 09:32 PM
  3. SQL Patch
    By tstanley in forum General Questions
    Replies: 1
    Last Post: 7 Nov 2010, 07:02 AM
  4. Sql Patch
    By Astarkley in forum Upgrading from 1.3.x to 1.3.9
    Replies: 4
    Last Post: 2 May 2009, 05:34 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR