Abbington Mega Template [Support Thread]

[picaflor-azul]

Good question, I thought I did with no issues. I then tried following the install tutorial again and when I got to the upload sql patch part I get an error "WARNING: An Error occurred, please refresh the page and try again." I then pulled the log file and here is the log entry:

"[17-May-2013 09:22:10] PHP Fatal error: 1062uplicate entry 'PRODUCT_LISTING_LAYOUT_STYLE' for key 'unq_config_key_zen' ::
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', 'columns', '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"),');
in /home4/desotosy/public_html/includes/classes/db/mysql/query_factory.php on line 120


Any idea where I went wrong. Thanks for the help I've been banging my head against the wall.

If you already have the product layout grid module installed and have run the sql patch for that module or any of our other templates installed, you will omit that part of the sql patch:

## The following is used only to remove the column layout grid module:
#delete from configuration where configuration_key in('PRODUCT_LISTING_LAYOUT_STYLE','PRODUCT_LISTING_COLUMNS_PER_ROW');

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', 'columns', 
               '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);

Thanks,

Anne