Kryptronic Software Support Forum

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.

#1 01-15-2014 17:16:37

Uncletim
Member
From: Boulder, CO
Registered: 08-03-2003
Posts: 375
Website

Step 13 of the installer - error

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

 

#2 01-16-2014 11:29:32

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Step 13 of the installer - error

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


Nick Hendler

Offline

 

#3 01-17-2014 17:57:45

Uncletim
Member
From: Boulder, CO
Registered: 08-03-2003
Posts: 375
Website

Re: Step 13 of the installer - error

Ouch!

You were right, I did miss a step.

Thank you.

Offline

 

#4 01-21-2014 20:01:20

rtringo
Member
Registered: 06-22-2005
Posts: 95

Re: Step 13 of the installer - error

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

 

#5 01-22-2014 10:11:47

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Step 13 of the installer - error

Run:

ALTER TABLE ecom_shiprealtimep CHANGE id id VARCHAR(200) DEFAULT '' NOT NULL

DELETE FROM ecom_shiprealtimep WHERE shipper='USPS'

Then run the update.


Nick Hendler

Offline

 

#6 01-23-2014 10:30:36

rtringo
Member
Registered: 06-22-2005
Posts: 95

Re: Step 13 of the installer - error

FYI....your two items above solved the problem.  Got the update successfully loaded.

As usual great support and solutions

Offline

 

Board footer