
Originally Posted by
jsarwar
Thank you. I am working on it. I tried to run following sql for this template on fresh zencart 1.5.3 installation and it shows "Warning An error have occurred" I tried this in zc admin via install sql patch. Template is Sheffield_blue.
Any idea?
## 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 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);
## The following may be run via phpMyAdmin rather than in Zen Cart Admin (if it gives an error)
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 ('Define About Us Status', 'DEFINE_ABOUT_US_STATUS', '1', 'Enable the Defined About Us Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', 25, 59, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');
1 more question Template Sheffield_blue have catalog folders like classes, e.datafiles, language, modules and templates but responsive Sheffield_blue have only two for catalog section which are modules and templates so responsive will work with only these two directories for catalog section or do I have to get rest files from Template is Sheffield_blue?
Bookmarks