Admin product save give the 500 error but the product is save succefully
Posted: Fri Jul 12, 2019 12:05 am
Hi
I am using the opencart version 3.0.2.0
recently I have one issue when I am save the any product or category or the product option from the admin panel
It just comes up from last 1 or 2 days before its all working well
here is the error when I try to save the product.
PHP Fatal error: Uncaught exception 'Exception' with message 'Error: Duplicate entry '19000-1' for key 'PRIMARY'<br />Error No: 1062<br />INSERT INTO oc_product_description SET product_id = '19000', language_id = '1', name = 'Double High Queen Airbed', description = '<p>Actual product may differ from image shown.</p>', tag = 'Camping, King Koil', meta_title = 'Double High Queen Airbed', meta_description = 'Double High Queen Airbed', meta_keyword = 'Double High Queen Airbed'' in /home/xxx/public_html/opencart/system/library/db/mysqli.php:61
Stack trace:
#0 /home/xxxxx/public_html/opencart/system/library/db.php(45): DB\MySQLi->query('INSERT INTO oc_...')
#1 /home/xxxxx/storage/modification/admin/model/catalog/product.php(147): DB->query('INSERT INTO oc_...')
#2 [internal function]: ModelCatalogProduct->editProduct('19000', Array)
#3 /home/xxxxx/public_html/opencart/vqmod/vqcache/vq2-_home_xxx_storage_modification_system_engine_loader.php(248): call_user_func_array(Array, Array)
#4 [internal functi in /home/xxxxx/public_html/opencart/system/library/db/mysqli.php on line 61
Can anyone help me out I have check there is no any two entry in the product table with the same 19000 id there is only one row.
Thanks
sachin patel
I am using the opencart version 3.0.2.0
recently I have one issue when I am save the any product or category or the product option from the admin panel
It just comes up from last 1 or 2 days before its all working well
here is the error when I try to save the product.
PHP Fatal error: Uncaught exception 'Exception' with message 'Error: Duplicate entry '19000-1' for key 'PRIMARY'<br />Error No: 1062<br />INSERT INTO oc_product_description SET product_id = '19000', language_id = '1', name = 'Double High Queen Airbed', description = '<p>Actual product may differ from image shown.</p>', tag = 'Camping, King Koil', meta_title = 'Double High Queen Airbed', meta_description = 'Double High Queen Airbed', meta_keyword = 'Double High Queen Airbed'' in /home/xxx/public_html/opencart/system/library/db/mysqli.php:61
Stack trace:
#0 /home/xxxxx/public_html/opencart/system/library/db.php(45): DB\MySQLi->query('INSERT INTO oc_...')
#1 /home/xxxxx/storage/modification/admin/model/catalog/product.php(147): DB->query('INSERT INTO oc_...')
#2 [internal function]: ModelCatalogProduct->editProduct('19000', Array)
#3 /home/xxxxx/public_html/opencart/vqmod/vqcache/vq2-_home_xxx_storage_modification_system_engine_loader.php(248): call_user_func_array(Array, Array)
#4 [internal functi in /home/xxxxx/public_html/opencart/system/library/db/mysqli.php on line 61
Can anyone help me out I have check there is no any two entry in the product table with the same 19000 id there is only one row.
Thanks
sachin patel