When I try to edit or save a product, I get an error similar to below.
I've tried adding AI to the oc_product_advertise_google table. It seems to work for 3 products and then the error re-appears.
I've tried deleting the table & re-building. Same error appears after 2 or 3 product saves.
Googling the error comes up with the 2 ways to fix. I've tried them both and no success. Is there anything else I can try?
Code: Select all
Fatal error: Uncaught Exception: Error: Duplicate entry '85473' for key 'PRIMARY'<br />Error No: 1062<br />INSERT INTO oc_product_option_value SET product_option_value_id = '85473', product_option_id = '12279', product_id = '1552', option_id = '283', option_value_id = '6432', quantity = '0', subtract = '0', price = '0', price_prefix = '+', points = '0', points_prefix = '+', weight = '0', weight_prefix = '+' in
system/library/db/mysqli.php:40 Stack trace: #0 storage/modification/system/library/db.php(58): DB\MySQLi->query('INSERT INTO oc_...')
#1 storage/modification/admin/model/catalog/product.php(286): DB->query('INSERT INTO oc_...')
#2 storage/modification/system/engine/loader.php(256): ModelCatalogProduct->editProduct('1552', Array)
#3 system/engine/proxy.php(47): Loader->{closure}(Array, Array)
#4 storage/modification/admin in system/library/db/mysqli.php on line 40