manual upgrade 1.4.70 to 1.5.40 sql error

[entrancey]

Hi

 

I'm having sql error as below when performing manual upgrade from 1.4.7.0 to 1.5.4.0 :

 

*ERROR* 2013/04/29 - 15:53:32: SQL query:

INSERT INTO `ps_cart_rule_product_rule` (`id_product_rule`, `id_cart_rule`, `quantity`, `type`) (

SELECT DISTINCT `id_product_rule`, `id_product_rule`, 1, 'categories' FROM `ps_cart_rule_product_rule_value`

)

*ERROR* 2013/04/29 - 15:53:32: SQL error:

Duplicate entry '1' for key 1

*ERROR* 2013/04/29 - 15:55:25: PHP error: /* PHP:update_customer_default_group(); */

 

Followed all steps mentioned in http://doc.prestasho...?pageId=5374295

 

Thanks in advance for your help

Edited April 29, 2013 by entrancey (see edit history)

[bellini13]

the error is saying that the record already exists. you might be able to safely ignore this error.

 

query the "ps_cart_rule_product_rule" database table and see what is in there, and if it matches the record they are trying to insert.

[entrancey]

hi

 

the table is empty -> "MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0004 sec )"

 

how bout the other errror? *ERROR* 2013/04/29 - 15:55:25: PHP error: /* PHP:update_customer_default_group(); */

 

but why FO & BO shos blank page?

 

thanks

Edited May 2, 2013 by entrancey (see edit history)