Fatal error: Uncaught Exception: Error: Duplicate entry '11708' for key 'PRIMARY'<br />Error No: 1062<br />
INSERT INTO `oc_journal3_product_sales` (
SELECT
p.product_id,
SUM(op.quantity) as sales
FROM `oc_product` p
LEFT JOIN `oc_order_product` op ON (p.product_id = op.product_id)
LEFT JOIN `oc_order` o ON (o.order_id = op.order_id)
WHERE o.order_status_id > 0
AND p.product_id IN (
SELECT
distinct product_id
FROM
`oc_order_product`
WHERE
order_id = '311413'
)
GROUP BY p.product_id
)
in /home/b4b6j3z6/public_html/system/library/db/mysqli.php:49
Stack trace:
#0 /home/b4b6j3z6/storage2022jd/modification/system/library/db.php(55): DB\MySQLi->query('\n\t\t\tINSERT INTO...')
#1 /home/b4b6j3z6/public_html/system/library/journal3/opencart/bestseller.php(127): DB->query('\n\t\t\tINSERT INTO...')
#2 /home/b4b6j3z6/public_html/catalog/controller/journal3/event/cache.php(12): Journal3\Opencart\Bestseller->update('311413')
#3 /home/b4b6j3z6/pu in /home/b4b6j3z6/public_html/system/library/db/mysqli.php on line 49