Responsive Sheffield Blue v1.0

[picaflor-azul]

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

[MeltDown]

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?

[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

[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

[picaflor-azul]

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

[picaflor-azul]

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

[GreggG]

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?

[picaflor-azul]

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

[GreggG]

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

[MeltDown]

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!