You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
How do I handle this error.
Step 13 of 13: Database Reload
An error was encountered while performing the database load task requested. Error Information: The MySQL extension encountered a problem submitting an SQL statement. MySQL reported the error as: Duplicate entry 'USPS-INT-First-Class Mail International Large Enve' for key 'PRIMARY'
I tried to delete the entry but there is no way to do it from the console. I only have an update button. Otherwise I would try and delete the 'USPS-INT-First-Class Mail International Large Enve'.
Can anyone tell me how to get around this and finish the install (this is an upgrade to 8.0.7).
Thanks.
Offline
Read the instructions. I think you missed the pre-update database changes where the USPS entries are deleted and the id column is expanded in that table. Instructions here:
https://central.kryptronic.com/public/n … 2013A.html
Offline
Ouch!
You were right, I did miss a step.
Thank you.
Offline
I received the same error message
I was updating from 8.5 and did:
DELETE FROM ecom_shiprealtimep WHERE shipper='USPS' as instructed for 8.5
Got to Step 13 Duplicate entry 'USPS-INT-Priority Mail Express International Flat ' for key 'PRIMARY'
-----------------------------------------------------------
I reviewed the pre-steps for 8.0 - 8.4 and did not see any comments for deleting or changing the statement in error above. The items that I saw for 8.0 - 8.4 were
ALTER TABLE ecom_shiprealtimep CHANGE id id VARCHAR(200) DEFAULT '' NOT NULL
If you are not using the 'ePDQ - Payment Form' and 'Internet Secure - Payment Form' gateways, you should execute this statement:
DELETE FROM ecom_gateway WHERE id='internetsecure' OR id='epdqform'
------------------------------------------------------------
I assume I need to run the DELTE FROM for the Duplicate entry, but not sure how it is written out exactly.
Hope this makes sense.
Offline
FYI....your two items above solved the problem. Got the update successfully loaded.
As usual great support and solutions
Offline