Jump to content

error upgrade from prestashop 1.4.3


Recommended Posts

Hi all,

 

in my test server i upgrade from prestashop 1.4.3 to actual 1.6.0.8. The upgrade produce xml with error 34 internal SQL error. But shop seems to be function and ok. What the problem? xml I attached

Share this post


Link to post
Share on other sites

in xml i found fail

<request result="fail" sqlfile="1.6.0.7">
<sqlQuery>
<![CDATA[ ALTER TABLE `ps_order_detail_tax` DROP PRIMARY KEY ]]>
</sqlQuery>
<sqlMsgError>
<![CDATA[ Can't DROP 'PRIMARY'; check that column/key exists ]]>
</sqlMsgError>
<sqlNumberError>
<![CDATA[ 1091 ]]>
</sqlNumberError>
</request>

Share this post


Link to post
Share on other sites

i assume that is just 1 of the 34 errors you received.

 

This statement is trying to drop the primary key on the ps_order_detail_tax table.  It failed to drop the primary key, and there are 2 reasons for this

 

1) The primary key never existed in the first place, so there is nothing to drop. 

2) The primary key exists, but something prevents it from being dropped

 

I suspect it is #1.  This table should not have a primary key.  So you simply need to use phpmyadmin to view the indexes on this table and confirm that a primary key does not exist.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More