Quote Originally Posted by Exonize View Post
Hello, i have some problems running the SQL Command.
Im running the SQL that i got with the template, when i run it i get this error: #1146 - Table 'xblnorge_sys.configuration' doesn't exist

And when i run this:
Code:
## The following can be run via phpMyAdmin, or by Admin->Tools->Install SQLPatch:

## The following is used only to remove this mod:
#delete from configuration where configuration_key in('PRODUCT_LISTING_LAYOUT_STYLE','PRODUCT_LISTING_COLUMNS_PER_ROW');

INSERT INTO xblnorge_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 xblnorge_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);
I get this error: #1062 - Duplicate entry 'PRODUCT_LISTING_LAYOUT_STYLE' for key 'unq_config_key_zen'

I am using the newest version of Zen Cart. Please help me.
Sorry for my bad english, im from Norway.
This just means that you already have the column layout grid sql installed. You just have to turn it on in admin--product listing.

Thanks,

Anne