Re: Responsive Sheffield Blue
Quote:
Originally Posted by
MeltDown
Anne, here is a more detailed error log that refers to the template:
Code:
[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
Re: Responsive Sheffield Blue
Quote:
Originally Posted by
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?
Re: Responsive Sheffield Blue
Here are those error messages from the log:
Code:
[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
Code:
[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
Re: Responsive Sheffield Blue
Quote:
Originally Posted by
MeltDown
Here are those error messages from the log:
Code:
[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
Code:
[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:
Code:
[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
Re: Responsive Sheffield Blue
Quote:
Originally Posted by
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
Re: Responsive Sheffield Blue
Quote:
Originally Posted by
MeltDown
And the error message I get now. It also refers to query_factory.php:
Code:
[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
Re: Responsive Sheffield Blue
Quote:
Originally Posted by
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?
Re: Responsive Sheffield Blue
Quote:
Originally Posted by
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:
Code:
.brands-li{display:none;}
Thanks,
Anne
Re: Responsive Sheffield Blue
Quote:
Originally Posted by
picaflor-azul
Just add this to the bottom of your stylesheet.css file:
Code:
.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?)
Re: Responsive Sheffield Blue
Quote:
Originally Posted by
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!