This error just means that the sql has already been run.Hi
Thanks for the quick reply yes they are in the right place I try and run the sql file and got this error message
everytime I run the sql I get this error message
1062 Duplicate entry ‘PRODUCT_LISTING_LAYOUT_STYLE’ for key 2
in:
[INSERT INTO zen_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:
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"),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
I thought it came with that style but it has never worked or been available to me ,that's why I tried installing the add-on
If you want to use the column layout grid module you just need to do step 2 in the install.txt file:
Code:==================================================== 2. SQL File for Column Layout Grid Module (Optional) ==================================================== Run the following SQL commands into your database. The easiest way is to open Admin->Tools->Install SQL Patch and paste them in the box and click Send. 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);


Reply With Quote



