Post by Fonax » Mon Jan 25, 2021 11:16 pm

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.

Newbie

Posts

Joined
Thu Jan 21, 2021 4:25 pm

Post by thekrotek » Mon Jan 25, 2021 11:16 pm

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


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by Fonax » Mon Jan 25, 2021 11:21 pm

thekrotek wrote:
Mon Jan 25, 2021 11:16 pm
Error says for itself: duplicate entry in database found.
Yeah, I can see that... but I don't know how and where to fix it.

Newbie

Posts

Joined
Thu Jan 21, 2021 4:25 pm

Post by thekrotek » Mon Jan 25, 2021 11:30 pm

Fonax wrote:
Mon Jan 25, 2021 11:21 pm
Yeah, I can see that... but I don't know how and where to fix it.
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


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by paulfeakins » Tue Jan 26, 2021 6:56 pm

Fonax wrote:
Mon Jan 25, 2021 11:16 pm
Error: Duplicate entry '111024789' for key 'PRIMARY'
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


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by cutabovehost » Thu Dec 09, 2021 9:58 am

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/


Newbie

Posts

Joined
Wed Apr 13, 2011 9:55 am
Who is online

Users browsing this forum: No registered users and 265 guests