How to fix the «Unique constraint violation found» / «Duplicate entry for key 'AMASTY_PGRID_QTY_SOLD_PRODUCT_ID'» bug in the Amasty's «Extended Product Grid with Editor» module?

amasty
amasty-product-grid

(Dmitry Fedyuk) #1

Locate the Amasty\Pgrid\Model\Indexer\QtySold::doReindex() method.

Replace the $queryRemained = $this->connection->insertFromSelect($remainedProductsSelect, $table); line with the following code block:

$queryRemained = $this->connection->insertFromSelect(
	$remainedProductsSelect
	,$table
	,[]
	,\Magento\Framework\DB\Adapter\AdapterInterface::REPLACE
);

How to fix the Amasty's Extended Product Grid with Editor «PDO::quote() expects parameter 1 to be string, object given» / «Internal Server Error» bug in Magento 2.2?
(Dmitry Fedyuk) #2

See also: