I am getting the following error while trying to update the prices for products.
Fatal error: Uncaught Exception: Error: Duplicate entry '111024789' for key 'PRIMARY'
Error No: 1062
INSERT INTO oc3fon_product_special(product_special_id,product_id,customer_group_id,priority,price, date_start, date_end) VALUES(111024789,24789,1,0,22.5,'0000-00-00','0000-00-00') in /home/mob/public_html/fnx/system/library/db/mysqli.php:40 Stack trace: #0 /home/mob/oc3fon/storage/modification/system/library/db.php(58): DB\MySQLi->query('INSERT INTO oc3...') #1 /home/mob/public_html/fnx/catalog/controller/service/db.php(156): DB->query('INSERT INTO oc3...') #2 /home/mob/public_html/fnx/system/helper/nusoap/nusoap.php(4202): query('UPDATE oc3fon_p...', 'sYncf0n@x303200...') #3 /home/mob/public_html/fnx/system/helper/nusoap/nusoap.php(3824): nusoap_server->invoke_method() #4 /home/mob/public_html/fnx/catalog/controller/service/db.php(127): nusoap_server->service('/home/mob/public_html/fnx/system/library/db/mysqli.php on line 40
Can anyone help with the solution?
Thanks.
Error says for itself: duplicate entry in database found.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
By checking the table mentioned in the error and removing the duplicate entry.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
Perhaps your database has lost the auto-increment setting?
Either way with that many entries you might be better off finding a developer to help you so you don't mess things up any further.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
The problem you are having is with the install script. Currently I don't have time to fix the issue for you or I would instead of giving lame answers that you have been given. You could change the key value it refences to anything and it will still give you that error.
Steve
Affordable Business Solutions LLC
http://www.cutabovehost.com/
Who is online
Users browsing this forum: Bing [Bot] and 15 guests