solved Duplicated Orders row after adding left Join.

[sword2500]

Hi,

Config:
php: 5.6.40
Version :  1.6.1.24
mode multiboutiques enabled.

 

I have a problem after adding the left join

$this->_join .= 'LEFT JOIN `'._DB_PREFIX_.'order_detail` od ON (od.`id_order` = a.`id_order`)';

 in my override file AdminOrderController.php.

All my orders with N products are duplicate N times.

Someone have a idéa to correcting this broken JOIN.

thanks.

 

AdminOrdersController.php

[Eolia]

Add a: GROUP BY a.id.order at the end of the request

[sword2500]

18 minutes ago, Eolia said:

Add a: GROUP BY a.id.order at the end of the request

yes, fixed with

$this->_group = 'GROUP BY a.`id_order`';

 thanks.