Responsive Sheffield Blue v1.0

MeltDown:

Anne, here is a more detailed error log that refers to the template:

[04-Jul-2015 12:21:33] #1 trigger_error(1109:Unknown table 'p' in field list :: select count(p.products_id) as total , 256) called at [/home/xxxx/public_html/tubularwiremeshribbon.com/includes/classes/db/mysql/query_factory.php:120]
#2 queryFactory->show_error() called at [/home/ xxxx /public_html/tubularwiremeshribbon.com/includes/classes/db/mysql/query_factory.php:105]
#3 queryFactory->set_error(1109, Unknown table 'p' in field list) called at [/home/ xxxx /public_html/tubularwiremeshribbon.com/includes/classes/db/mysql/query_factory.php:227]
#4 queryFactory->Execute(select count(p.products_id) as total ) called at [/home/ xxxx /public_html/tubularwiremeshribbon.com/includes/classes/split_page_results.php:78]
#5 splitPageResults->splitPageResults(, 30, p.products_id, page) called at [/home/ xxxx /public_html/tubularwiremeshribbon.com/includes/modules/responsive_sheffield_blue/product_listing.php:34]
#6 include(/home/ xxxx 0/public_html/tubularwiremeshribbon.com/includes/modules/responsive_sheffield_blue/product_listing.php) called at [/home/ xxxx /public_html/tubularwiremeshribbon.com/includes/templates/responsive_sheffield_blue/templates/tpl_modules_product_listing.php:13]
#7 require(/home/ xxxx /public_html/tubularwiremeshribbon.com/includes/templates/responsive_sheffield_blue/templates/tpl_modules_product_listing.php) called at [/home/ xxxx /public_html/tubularwiremeshribbon.com/includes/templates/responsive_sheffield_blue/templates/tpl_products_new_default.php:19]
#8 require(/home/ xxxx /public_html/tubularwiremeshribbon.com/includes/templates/responsive_sheffield_blue/templates/tpl_products_new_default.php) called at [/home/ xxxx /public_html/tubularwiremeshribbon.com/includes/templates/responsive_sheffield_blue/common/tpl_main_page.php:229]
#9 require(/home/ xxxx /public_html/tubularwiremeshribbon.com/includes/templates/responsive_sheffield_blue/common/tpl_main_page.php) called at [/home/ xxxx /public_html/tubularwiremeshribbon.com/index.php:97]

[04-Jul-2015 12:21:33] PHP Fatal error: 1109:Unknown table 'p' in field list :: select count(p.products_id) as total in /home/ xxxx /public_html/tubularwiremeshribbon.com/includes/classes/db/mysql/query_factory.php on line 120

> I'm off to try and decipher it and appreciate and comments :)

Did you upload the includes/classes/split_page_results file from the template package to your zen cart when you installed the template?

Thanks,

Anne

picaflor-azul:

Did you upload the includes/classes/split_page_results file from the template package to your zen cart when you installed the template?

Thanks,

Anne

Yes, split_page_results.php is there. To be certain it was not corrupted I replaced it with another copy but to no avail.

Anne, I did have a duplicate entry error of the SQL Patches. Could they be related? Is there a way to remove all trace of the patches and then reimport?

Here are those error messages from the log:

[02-Jul-2015 04:48:33] PHP Fatal error:  1062:Duplicate entry 'COLUMN_WIDTH' for key 'unq_config_key_zen' :: INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, '<font color="#0044ff">ACTIVATE Responsive Template by selecting Column Widths</font>', 'COLUMN_WIDTH', '2', 'Width of the Left and Right Columns<br />0 = Use Default Template Settings<br />1 = 75px<br />2 = 150px<br />3 = 225px',@configuration_group_id, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\'),'); in /home/xxxx/public_html/tubularwiremeshribbon.com/includes/classes/db/mysql/query_factory.php on line 120

[02-Jul-2015 04:49:05] PHP Fatal error:  1062:Duplicate entry 'RSB_SLIDES_STATUS' for key 'unq_config_key_zen' :: INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Slides JS Slideshow', 'RSB_SLIDES_STATUS', 'true', 'Activate Slides JS Slideshow', @configuration_group_id, 1, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Play Interval', 'RSB_SLIDES_PLAY', '5000', 'Play interval', @configuration_group_id, 2, NOW(), NULL, NULL), (NULL, 'Banner Display Groups - Rsbslide1', 'SHOW_BANNERS_GROUP_SETRSB1', 'rsbslide1', 'Rsbslide 1', @configuration_group_id, 30, NOW(), NULL, NULL), (NULL, 'Banner Display Groups - Rsbslide2', 'SHOW_BANNERS_GROUP_SETRSB2', 'rsbslide2', 'Rsbslide 2', @configuration_group_id, 31, NOW(), NULL, NULL), (NULL, 'Banner Display Groups - Rsbslide3', 'SHOW_BANNERS_GROUP_SETRSB3', 'rsbslide3', 'Rsbslide 3', @configuration_group_id, 32, NOW(), NULL, NULL), (NULL, 'Banner Display Groups - Rsbslide4', 'SHOW_BANNERS_GROUP_SETRSB4', 'rsbslide4', 'Rsbslide 4', @configuration_group_id, 33, NOW(), NULL, NULL), (NULL, 'Banner Display Groups - Rsbslide5', 'SHOW_BANNERS_GROUP_SETRSB5', 'rsbslide5', 'Rsbslide 5', @configuration_group_id, 34, NOW(), NULL, NULL); in /home/xxxx/public_html/tubularwiremeshribbon.com/includes/classes/db/mysql/query_factory.php on line 120

MeltDown:

Here are those error messages from the log:

[02-Jul-2015 04:48:33] PHP Fatal error: 1062:Duplicate entry 'COLUMN_WIDTH' for key 'unq_config_key_zen' :: INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, '<font color="#0044ff">ACTIVATE Responsive Template by selecting Column Widths</font>', 'COLUMN_WIDTH', '2', 'Width of the Left and Right Columns<br />0 = Use Default Template Settings<br />1 = 75px<br />2 = 150px<br />3 = 225px',@configuration_group_id, NULL, NOW(), NULL, 'zen_cfg_select_option(array('0', '1', '2', '3'),'); in /home/xxxx/public_html/tubularwiremeshribbon.com/includes/classes/db/mysql/query_factory.php on line 120

> 
> ```
[02-Jul-2015 04:49:05] PHP Fatal error:  1062:Duplicate entry 'RSB_SLIDES_STATUS' for key 'unq_config_key_zen' :: INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Slides JS Slideshow', 'RSB_SLIDES_STATUS', 'true', 'Activate Slides JS Slideshow', @configuration_group_id, 1, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Play Interval', 'RSB_SLIDES_PLAY', '5000', 'Play interval', @configuration_group_id, 2, NOW(), NULL, NULL), (NULL, 'Banner Display Groups - Rsbslide1', 'SHOW_BANNERS_GROUP_SETRSB1', 'rsbslide1', 'Rsbslide 1', @configuration_group_id, 30, NOW(), NULL, NULL), (NULL, 'Banner Display Groups - Rsbslide2', 'SHOW_BANNERS_GROUP_SETRSB2', 'rsbslide2', 'Rsbslide 2', @configuration_group_id, 31, NOW(), NULL, NULL), (NULL, 'Banner Display Groups - Rsbslide3', 'SHOW_BANNERS_GROUP_SETRSB3', 'rsbslide3', 'Rsbslide 3', @configuration_group_id, 32, NOW(), NULL, NULL), (NULL, 'Banner Display Groups - Rsbslide4', 'SHOW_BANNERS_GROUP_SETRSB4', 'rsbslide4', 'Rsbslide 4', @configuration_group_id, 33, NOW(), NULL, NULL), (NULL, 'Banner Display Groups - Rsbslide5', 'SHOW_BANNERS_GROUP_SETRSB5', 'rsbslide5', 'Rsbslide 5', @configuration_group_id, 34, NOW(), NULL, NULL); in /home/xxxx/public_html/tubularwiremeshribbon.com/includes/classes/db/mysql/query_factory.php on line 120

And the error message I get now. It also refers to query_factory.php:

[05-Jul-2015 03:50:16] #1  trigger_error(1109:Unknown table 'p' in field list :: select count(p.products_id) as total , 256) called at [/home/xxxx/public_html/tubularwiremeshribbon.com/includes/classes/db/mysql/query_factory.php:120]
#2  queryFactory->show_error() called at [/home/xxxx/public_html/tubularwiremeshribbon.com/includes/classes/db/mysql/query_factory.php:105]
#3  queryFactory->set_error(1109, Unknown table 'p' in field list) called at [/home/xxxx/public_html/tubularwiremeshribbon.com/includes/classes/db/mysql/query_factory.php:227]
#4  queryFactory->Execute(select count(p.products_id) as total ) called at [/home/xxxx/public_html/tubularwiremeshribbon.com/includes/classes/split_page_results.php:78]
#5  splitPageResults->splitPageResults(, 30, p.products_id, page) called at [/home/xxxx/public_html/tubularwiremeshribbon.com/includes/modules/product_listing.php:15]
#6  include(/home/bea10000/public_html/tubularwiremeshribbon.com/includes/modules/product_listing.php) called at [/home/xxxx/public_html/tubularwiremeshribbon.com/includes/templates/responsive_sheffield_blue/templates/tpl_modules_product_listing.php:13]
#7  require(/home/xxxx/public_html/tubularwiremeshribbon.com/includes/templates/responsive_sheffield_blue/templates/tpl_modules_product_listing.php) called at [/home/xxxx/public_html/tubularwiremeshribbon.com/includes/templates/responsive_sheffield_blue/templates/tpl_products_new_default.php:19]
#8  require(/home/xxxx/public_html/tubularwiremeshribbon.com/includes/templates/responsive_sheffield_blue/templates/tpl_products_new_default.php) called at [/home/xxxx/public_html/tubularwiremeshribbon.com/includes/templates/responsive_sheffield_blue/common/tpl_main_page.php:229]
#9  require(/home/xxxx/public_html/tubularwiremeshribbon.com/includes/templates/responsive_sheffield_blue/common/tpl_main_page.php) called at [/home/xxxx/public_html/tubularwiremeshribbon.com/index.php:97]

[05-Jul-2015 03:50:16] PHP Fatal error:  1109:Unknown table 'p' in field list :: select count(p.products_id) as total  in /home/xxxx/public_html/tubularwiremeshribbon.com/includes/classes/db/mysql/query_factory.php on line 120

MeltDown:

Yes, split_page_results.php is there. To be certain it was not corrupted I replaced it with another copy but to no avail.

Anne, I did have a duplicate entry error of the SQL Patches. Could they be related? Is there a way to remove all trace of the patches and then reimport?

Did you upload the copy from the template package?

Also, be sure that you have copied the override files from any plugins you have installed to the new template override folder.

Thanks,

Anne

MeltDown:

And the error message I get now. It also refers to query_factory.php:

[05-Jul-2015 03:50:16] #1 trigger_error(1109:Unknown table 'p' in field list :: select count(p.products_id) as total , 256) called at [/home/xxxx/public_html/tubularwiremeshribbon.com/includes/classes/db/mysql/query_factory.php:120]
#2 queryFactory->show_error() called at [/home/xxxx/public_html/tubularwiremeshribbon.com/includes/classes/db/mysql/query_factory.php:105]
#3 queryFactory->set_error(1109, Unknown table 'p' in field list) called at [/home/xxxx/public_html/tubularwiremeshribbon.com/includes/classes/db/mysql/query_factory.php:227]
#4 queryFactory->Execute(select count(p.products_id) as total ) called at [/home/xxxx/public_html/tubularwiremeshribbon.com/includes/classes/split_page_results.php:78]
#5 splitPageResults->splitPageResults(, 30, p.products_id, page) called at [/home/xxxx/public_html/tubularwiremeshribbon.com/includes/modules/product_listing.php:15]
#6 include(/home/bea10000/public_html/tubularwiremeshribbon.com/includes/modules/product_listing.php) called at [/home/xxxx/public_html/tubularwiremeshribbon.com/includes/templates/responsive_sheffield_blue/templates/tpl_modules_product_listing.php:13]
#7 require(/home/xxxx/public_html/tubularwiremeshribbon.com/includes/templates/responsive_sheffield_blue/templates/tpl_modules_product_listing.php) called at [/home/xxxx/public_html/tubularwiremeshribbon.com/includes/templates/responsive_sheffield_blue/templates/tpl_products_new_default.php:19]
#8 require(/home/xxxx/public_html/tubularwiremeshribbon.com/includes/templates/responsive_sheffield_blue/templates/tpl_products_new_default.php) called at [/home/xxxx/public_html/tubularwiremeshribbon.com/includes/templates/responsive_sheffield_blue/common/tpl_main_page.php:229]
#9 require(/home/xxxx/public_html/tubularwiremeshribbon.com/includes/templates/responsive_sheffield_blue/common/tpl_main_page.php) called at [/home/xxxx/public_html/tubularwiremeshribbon.com/index.php:97]

[05-Jul-2015 03:50:16] PHP Fatal error: 1109:Unknown table 'p' in field list :: select count(p.products_id) as total in /home/xxxx/public_html/tubularwiremeshribbon.com/includes/classes/db/mysql/query_factory.php on line 120

Move the includes/templates/responsive_sheffield_blue/templates/tpl_modules_product_listing.php and includes/templates/responsive_sheffield_blue/templates/tpl_products_new_default.php to .bak files  and see what happens.




Thanks,

Anne

picaflor-azul:

See the readme.html file included in the template package for instructions.

Thanks,

Anne

This is in response to removing "Brands" from the top nav bar. I've been through both readme files in the latest package multiple times and cannot find a mention of this. Am I having the worst two days of my life?

GreggG:

This is in response to removing "Brands" from the top nav bar. I've been through both readme files in the latest package multiple times and cannot find a mention of this. Am I having the worst two days of my life?

Just add this to the bottom of your stylesheet.css file:

.brands-li{display:none;}

Thanks,

Anne

picaflor-azul:

Just add this to the bottom of your stylesheet.css file:

.brands-li{display:none;}

> 
> Thanks,
> 
> Anne

Thanks for the fast response...I was just coming back to say that I realized I was in the "old" forum, not the new, and had found that solution from another user (White Bear, I think?)

picaflor-azul:

Move the includes/templates/responsive_sheffield_blue/templates/tpl_modules_product_listing.php and includes/templates/responsive_sheffield_blue/templates/tpl_products_new_default.php to .bak files and see what happens.
Thanks,

Anne
Thanks, Anne, some forward progress has been made. I changed the file names to tpl_modules_product_listing.bak & tpl_modules_product_listing.bak. As a result my New Products is functioning properly.

Would you recommend doing the same for tpl_modules_featured_products.php, tpl_products_all_default.php, tpl_modules_specials_default.php and tpl_modules_sale_products.php? If so, any others?

Also, I read somewhere that.bak files found on a server can fail PCI Compliance; Can I just remove them?

Thanks again - It's good to see positive changes!

Just a quick question. Will this version 1.1 work with Zen cart version 1.5.4? I saw in the download section that it shows 1.5.1 and the 2.0 version does 1.5.4, but I really like the design of the 1.1 better than the 2.0 so I just wanted to check. Thanks a bunch.

OK, so rather then change all to .bak files, I've removed the following from includes/templates/responsive_sheffield_blue/templates/:

tpl_featured_products_default.php

tpl_modules_featured_products.php

tpl_modules_sale_products.php

tpl_modules_specials_default.php

tpl_products_all_default.php

tpl_specials_default.php

tpl_modules_product_listing.php

tpl_modules_product_listing
And everything is functioning properly. Is there any reason I'm not aware of to change them to .bak files instead?

Thanks

eric47905:

Just a quick question. Will this version 1.1 work with Zen cart version 1.5.4? I saw in the download section that it shows 1.5.1 and the 2.0 version does 1.5.4, but I really like the design of the 1.1 better than the 2.0 so I just wanted to check. Thanks a bunch.

Yes, it will work, but you really should be using version 2.0 as it is more recently updated and advanced.

Thanks,

Anne

Thanks for the great template… we're using this at our Herb Shop and when a customer wants to send a message using their mobile phone, it won't send from the phone because the form does not have a "subject" line.

Can you tell me how to add a subject line to this template?

We want to add it to the menu dropdown and the contact page, so customers can send messages with their mobile phones. It seems mobile carriers won't send if there is no subject line…

jacksbooks:

Thanks for the great template… we're using this at our Herb Shop and when a customer wants to send a message using their mobile phone, it won't send from the phone because the form does not have a "subject" line.

Can you tell me how to add a subject line to this template?

We want to add it to the menu dropdown and the contact page, so customers can send messages with their mobile phones. It seems mobile carriers won't send if there is no subject line…

You can use this mod to add the subject : Contact Us - Add Subject

jacksbooks:

Thanks for the great template… we're using this at our Herb Shop and when a customer wants to send a message using their mobile phone, it won't send from the phone because the form does not have a "subject" line.

Can you tell me how to add a subject line to this template?

We want to add it to the menu dropdown and the contact page, so customers can send messages with their mobile phones. It seems mobile carriers won't send if there is no subject line…

You should be using the updated version of the template package 2.0. It already has the subject added to the contact us page ;)

Thanks,

Anne

i installed the Ajax add to cart module and i think it is setup for the classic template and not yours. i need help styling this for your template.
https://www.floorz-n-more.com
Your Cart | 1 Items @ $31.17 sits on the top left. when i put it to the right it sits at the top right. want to move it where the old 1 is.
here is the css file.
Thankyou jimmie

jimmie:

i installed the Ajax add to cart module and i think it is setup for the classic template and not yours. i need help styling this for your template.
https://www.floorz-n-more.com
Your Cart | 1 Items @ $31.17 sits on the top left. when i put it to the right it sits at the top right. want to move it where the old 1 is.
here is the css file.
Thankyou jimmie

Are you using v 2.0 of the template package?

If you need to make css changes I would recommend using chrome and the web developer tools. They will tell you the line of the file that needs to be edited.

Thanks,

Anne

Hi Anne,
Do you know how to make this template expandable in small devices like cell phone etc. It does not zoom in / out in smaller devices. Thank you!

Anne,

I am sure that I have probably missed this somewhere. I have been scrolling through the thread and cannot seem to find an answer to this. When clicking on an image it is opening the window but showing a very small image. How can this be made to show the full size image? Our site is located at http://bettysbargainbin.net

Thank you!

Todd