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

Cannot install module ps_legalcompliance. The module is invalid and cannot be loaded.

Dear Customer, If you have error when install theme Cannot install module ps_legalcompliance. The module …

Leave a Reply