sql error upgrading 1.4.3 to 1.5.4

[PaulJW]

Version 1.4.3 won't let me install the '1-click upgrade module'. I get the error 'Unable to create the directory "/usr/local/pem/vhosts/142803/webspace/httpdocs/silverjewelleryireland.tld/SJIadmin123/autoupgrade"

 

So I followed the manual update instructions on Prestashop. However, even this way I have problems.

 

When I run the 'http://127.0.0.1/prestashop-prep/install/upgrade/upgrade.php' it fails with error '34'.

 

The error xml text identifies the problem to be a missing table entry:

 

<request result="fail" sqlfile="1.5.4.0">

<sqlQuery>

<![CDATA[ /* PHP:p1540_add_missing_columns(); */ ]]>

</sqlQuery>

<phpMsgError>

<![CDATA[

Table 'prestashop_update.ps_layered_product_attribute' doesn't exist

]]>

</phpMsgError>

 

Considering that version 1.4.3 does not create the 'layered_product_attribute' how can I get around the problem of version 1.5.4 needing it for the installation?

[entrancey]

hi

 

I did encountered the same problem and manage to get it work..what i did?

 

upload the file attached to your current 1.4.3 database and try to upgrade again.

 

*it works for me when doing the manual upgrade.

 

thanks

ps_layered_product_attribute.zip

[itsonlymelee]

hi

 

I did encountered the same problem and manage to get it work..what i did?

 

upload the file attached to your current 1.4.3 database and try to upgrade again.

 

*it works for me when doing the manual upgrade.

 

thanks

 

Superstar! Thank you, solved my problem in a flash (once I'd changed the database prefix that is)

[win2]

hi so where can I find the "my.ini"? on FTP or other place? Many thanks!