error upgrade from prestashop 1.4.3

[mardon]

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

[mardon]

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>

[bellini13]

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.