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

Leotheme Black Friday 2022

Prestashop Theme and Module Black Friday and Cyber Monday Sales Leotheme 2022 30% Off

Prestashop Leotheme Black Friday 2022 Promotion! Dear valued customers, Black Friday and Cyber Monday Sales …

Leave a Reply