Sheffield Blue Template Support Thread

[jsarwar]

Thank you. on 1.3.9 I had so many modules/modification so I think best would be to do fresh installed on 1.5.3
Can you guide me if I install all modules on this 1.5.3 and they work then I can just move all files to live site and run any applicable sql in admin and all should work?

Thank you

[picaflor-azul]

Thank you. on 1.3.9 I had so many modules/modification so I think best would be to do fresh installed on 1.5.3
Can you guide me if I install all modules on this 1.5.3 and they work then I can just move all files to live site and run any applicable sql in admin and all should work?

Thank you

I would upgrade your database, then do a fresh install of the zen cart files, then install the template package (lots will be broken), then install/upgrade the modules.

Thanks,

Anne

[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?

[picaflor-azul]

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?

The Responsive Sheffield Blue and Sheffield Blue are 2 completely different template packages. If you used to have the Sheffield Blue template installed then you can not just upgrade to the responsive package. You need to install the responsive package like a new template and then use the new template override directory to install any modules.

Thanks,

Anne

[jsarwar]

The Responsive Sheffield Blue and Sheffield Blue are 2 completely different template packages. If you used to have the Sheffield Blue template installed then you can not just upgrade to the responsive package. You need to install the responsive package like a new template and then use the new template override directory to install any modules.

Thanks,

Anne

Thank you but any idea why I am getting sql error?

[picaflor-azul]

Thank you but any idea why I am getting sql error?

Probably because you have installed the template previously before you upgraded.

Thanks,

Anne

[QueenKat]

I installed the template to my store and it's not showing up in the template section in my admin. Please advise. thank you.