Duplicated products prestashop 1.7 backoffice

[Dawn]

Hi, i have a problem with after upgrading to 1.7, i see same product many times at the backend.

In PS 1.6 it was solve replacing some lines to AdminProductsController.php, but that lines not exists in PS 1.7.

That was the trick:

 $this->_use_found_rows = false;
        $this->_group = '';

with this:

        $this->_use_found_rows = true; 
        $this->_group = 'GROUP BY '.$alias.'.id_product';

 

Somebody with same problem?

 

Thanks. 

[dmru]

HI, try to change file \src\Adapter\Product\AdminProductDataProvider.php, line 317

$sqlGroupBy = [];

change to:

$sqlGroupBy = ['id_product'];