Home / Prestashop Module Tutorials / Ap Page Builder / Fix bug show many query with ap page builder

Fix bug show many query with ap page builder

Hi

When you got error have many query in home page

When you using leo Bicmart theme with product list in font end

Please download latest version or update code follow my guide:

  1. file modules/appagebuilder/appagebuilder.php

find function

public function getProductsFont($params)
edit code
$sql .= ' ORDER BY '.(!empty($order_by_prefix) ? '`'.pSQL($order_by_prefix).'`.' : '').'`'.bqSQL($order_by).'` '.pSQL($order_way)
        .(!$get_total ? ' LIMIT '.(((int)$p - 1) * (int)$n).','.(int)$n : '');
to
$sql .= ' ORDER BY '.(!empty($order_by_prefix) ? '`'.pSQL($order_by_prefix).'`.' : '').'`'.bqSQL($order_by).'` '.pSQL($order_way)
        .(!$get_total ? ' LIMIT '.(((int)$p - 1) * (int)(isset($params['nb_products'])?($n-1):$n)).','.(int)$n : '');
about line : 1640

2. update file //modules/appagebuilder/classes/shortcodes/ApProductList.php

with this file ApProductList.php

 

About Leo Theme

Check Also

Update Prestashop Themes 1.7.7.0 Leotheme

Update 170+ Prestashop Themes 1.7.7.0 | Prestashop Modules 1.7.7.0 – Leotheme

    Dear valued customers, As we know, Prestashop has just released the latest version …

Leave a Reply