I have this same issue but my Template is: Winchester Black and my original version of Zen Cart was v1.5.5a and everything worked properly. I recently upgraded to ZC version 1.5.5e (no database upgrade needed) and now I get these errors:
Code:
[18-Mar-2017 17:35:44 America/Chicago] Request URI: /index.php?main_page=featured_products, IP address: 192.143.29.184
#1 trigger_error() called at [/myRoot/public_html/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/myRoot/public_html/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/myRoot/public_html/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/myRoot/public_html/includes/classes/split_page_results.php:78]
#5 splitPageResults->__construct() called at [/myRoot/public_html/includes/modules/winchester_black/product_listing.php:35]
#6 include(/myRoot/public_html/includes/modules/winchester_black/product_listing.php) called at [/myRoot/public_html/includes/templates/winchester_black/templates/tpl_modules_product_listing.php:14]
#7 require(/myRoot/public_html/includes/templates/winchester_black/templates/tpl_modules_product_listing.php) called at [/myRoot/public_html/includes/templates/winchester_black/templates/tpl_featured_products_default.php:19]
#8 require(/myRoot/public_html/includes/templates/winchester_black/templates/tpl_featured_products_default.php) called at [/myRoot/public_html/includes/templates/winchester_black/common/tpl_main_page.php:252]
#9 require(/myRoot/public_html/includes/templates/winchester_black/common/tpl_main_page.php) called at [/myRoot/public_html/index.php:97]
[18-Mar-2017 17:35:44 America/Chicago] PHP Fatal error: 1109:Unknown table 'p' in field list :: select count(p.products_id) as total ==> (as called by) /myRoot/public_html/includes/classes/split_page_results.php on line 78 <== in /myRoot/public_html/includes/classes/db/mysql/query_factory.php on line 167
In following this thread, I downloaded the GitHub fix for layout_controller.php and replaced plus I attempted to run the included SQL patch but the SQL query claimed it couldn't be processed because it was already set to what I was trying to set it to (at least this is my version of the error message). As for the changes mentioned in the first post (https://www.zen-cart.com/showthread....rk-with-v1-5-5) I already have those changes. I am wondering if my Zen cart version is so new there hasn't had a chance to make the proper fixes to this template. Now I would like to fix this issue if anyone knows where I can start.
Bookmarks