ZCA Bootstrap 4 Template [Support Thread]

[ianhg]

Hi
Running Zencart 1.5.8 with Bootstrap
I am getting this Fatal error message any ideas anyone, Thanks..

[21-Nov-2022 09:00:03 UTC] Request URI: /shop/index.php?main_page=specials, IP address: 68.183.70.118
#1 trigger_error() called at [/includes/classes/db/mysql/query_factory.php:667]
#2 queryFactory->show_error() called at [/includes/classes/db/mysql/query_factory.php:634]
#3 queryFactory->set_error() called at [/includes/classes/db/mysql/query_factory.php:275]
#4 queryFactory->Execute() called at [/includes/classes/zca/zca_split_page_results.php:102]
#5 zca_splitPageResults->__construct() called at [/includes/modules/bootstrap/product_listing.php:37]
#6 require(/includes/modules/bootstrap/product_listing.php) called at [/includes/templates/bootstrap/templates/tpl_modules_product_listing.php:12]
#7 require(/includes/templates/bootstrap/templates/tpl_modules_product_listing.php) called at [/includes/templates/bootstrap/templates/tpl_specials_default.php:24]
#8 require(/includes/templates/bootstrap/templates/tpl_specials_default.php) called at [/includes/modules/pages/specials/main_template_vars.php:59]
#9 require(/includes/modules/pages/specials/main_template_vars.php) called at [/includes/templates/bootstrap/common/tpl_main_page.php:202]
#10 require(/includes/templates/bootstrap/common/tpl_main_page.php) called at [/index.php:94]
--> PHP Fatal error: 1109:Unknown table 'p' in field list :: SELECT COUNT(p.products_id) as total ==> (as called by) /includes/classes/zca/zca_split_page_results.php on line 102 <== in /includes/classes/db/mysql/query_factory.php on line 667.

[brittainmark]

It may be that the query in includes/modules/pages/specials/header_php_specials_zca_bootstrap.php has been altered
Lines 29-34 should look like this

$listing_sql =
    "SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_model, 
            p.products_quantity, p.products_weight, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status, p.master_categories_id,
            p.manufacturers_id, m.manufacturers_name
       FROM (" . TABLE_PRODUCTS . " p
                LEFT JOIN " . TABLE_SPECIALS . " s 
                    ON p.products_id = s.products_id
                LEFT JOIN " . TABLE_MANUFACTURERS . " m
                    ON m.manufacturers_id = p.manufacturers_id
                LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd 
                    ON p.products_id = pd.products_id
                   AND pd.language_id = :languageID
            )
      WHERE p.products_status = 1
        AND s.status = 1
      ORDER BY s.specials_date_added DESC";

note the line

FROM (" . TABLE_PRODUCTS . " p

defines an alias for products as p

[swguy]

Indeed, be sure you have the latest version of the Bootstrap template.

[ianhg]

Indeed, be sure you have the latest version of the Bootstrap template.

Thank you for this I realised that I had missed adding the header_php_specials_zca_bootstrap.php to Pages/specials.. feel a bit stupid now.. many thanks

[lat9]

Thank you for this I realised that I had missed adding the header_php_specials_zca_bootstrap.php to Pages/specials.. feel a bit stupid now.. many thanks

Appreciate the update; it's always the little bits that bite you in the ar*e.

[ianhg]

It may be that the query in includes/modules/pages/specials/header_php_specials_zca_bootstrap.php has been altered
Lines 29-34 should look like this

$listing_sql =
    "SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_model, 
            p.products_quantity, p.products_weight, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status, p.master_categories_id,
            p.manufacturers_id, m.manufacturers_name
       FROM (" . TABLE_PRODUCTS . " p
                LEFT JOIN " . TABLE_SPECIALS . " s 
                    ON p.products_id = s.products_id
                LEFT JOIN " . TABLE_MANUFACTURERS . " m
                    ON m.manufacturers_id = p.manufacturers_id
                LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd 
                    ON p.products_id = pd.products_id
                   AND pd.language_id = :languageID
            )
      WHERE p.products_status = 1
        AND s.status = 1
      ORDER BY s.specials_date_added DESC";

note the line

FROM (" . TABLE_PRODUCTS . " p

defines an alias for products as p

Thank you for this I realised that I had missed adding the header_php_specials_zca_bootstrap.php to Pages/specials.. feel a bit stupid now.. many thanks