westminster_new PHP Fatal error: 1109:Unknown table 'p' in field list

[jwlamb]

Good day,

I am getting a php error in my logs, not sure how to fix. Any thoughts? ZC ver 1.5.7 TIA

[31-Jul-2020 21:13:34 America/Phoenix] Request URI: /index.php?main_page=products_all&disp_order=6&page=5, IP address: 66.249.79.157
#1  trigger_error() called at [/public_html/includes/classes/db/mysql/query_factory.php:170]
#2  queryFactory->show_error() called at [/public_html/includes/classes/db/mysql/query_factory.php:142]
#3  queryFactory->set_error() called at [/public_html/includes/classes/db/mysql/query_factory.php:269]
#4  queryFactory->Execute() called at [/public_html/includes/classes/split_page_results.php:77]
#5  splitPageResults->__construct() called at [/public_html/includes/modules/westminster_new/product_listing.php:35]
#6  include(/public_html/includes/modules/westminster_new/product_listing.php) called at [/public_html/includes/templates/westminster_new/templates/tpl_modules_product_listing.php:11]
#7  require(/public_html/includes/templates/westminster_new/templates/tpl_modules_product_listing.php) called at [/public_html/includes/templates/westminster_new/templates/tpl_products_all_default.php:12]
#8  require(/public_html/includes/templates/westminster_new/templates/tpl_products_all_default.php) called at [/public_html/includes/templates/westminster_new/common/tpl_main_page.php:216]
#9  require(/public_html/includes/templates/westminster_new/common/tpl_main_page.php) called at [/public_html/index.php:94]
--> PHP Fatal error: 1109:Unknown table 'p' in field list :: select count(p.products_id) as total  ==> (as called by) /public_html/includes/classes/split_page_results.php on line 77 <== in /public_html/includes/classes/db/mysql/query_factory.php on line 170.

[swguy]

Templates like westminster_new overwrite core files like includes/modules/pages/products_all/header_php.php leading to issues like this. You can merge in the template copy of that file and this problem should go away.