Ошибка при выводе статистики по покупателям

[bruklin]

Добрый день.

 

Пытаюсь сформировать отчет по покупателям и сайт выдает ошибку:

 

Notice: Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
Error No: 1104
SELECT t.customer_id, t.customer, t.email, t.customer_group, t.status, COUNT(t.order_id) AS orders, SUM(t.products) AS products, SUM(t.total) AS total FROM (SELECT c.customer_id, CONCAT(c.firstname, ' ', c.lastname) AS customer, c.email, cgd.name AS customer_group, c.status, o.order_id, SUM(op.quantity) as products, SUM(DISTINCT o.total) AS total FROM `oc_order` o LEFT JOIN `oc_order_product` op ON (o.order_id = op.order_id)LEFT JOIN `oc_customer` c ON (o.customer_id = c.customer_id) LEFT JOIN `oc_customer_group_description` cgd ON (c.customer_group_id = cgd.customer_group_id) WHERE o.customer_id > 0 AND cgd.language_id = '2' AND o.order_status_id > '0' GROUP BY o.order_id LIMIT 0,30) AS t GROUP BY t.customer_id ORDER BY total DESC in /home/p/plushno2ru/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/p/plushno2ru/public_html/admin/model/report/customer.php on line 131Warning: Invalid argument supplied for foreach() in /home/p/plushno2ru/public_html/admin/controller/report/customer_order.php on line 78

 

Понимаю, что где-то надо вставить: SET SQL_BIG_SELECTS=1, но не понимаю где.

 

Движок OC2.1

 

Заранее благодарен

[bruklin]

Методом "научного тыка" решено:

 

необходимо в файле system/library/db/mysqli.php между строками

$this->link->set_charset("utf8");
$this->link->query("SET SQL_MODE = ''");

вставить

$this->link->query("SET SQL_BIG_SELECTS=1");