invoice issue after upgrade

[lovemyseo]

I am upgrading my shop from PS 1.4.9 to 1.5.6.2 everything seems ok except 2 invoicing and checkout
 

Only invoices with purchase order number shows the payment method other method paid shows no payment e.g Bank Wire, Credit Card Payment
 

Ceckout process not going to the final page after choosing the payment method and click submit it display a blank page
Any idead how to solve it?

Edited July 21, 2014 by lovemyseo (see edit history)

[tuk66]

Look at ps_order_payment table. payment_method field should be filled for all records. I'm not completely sure if upgrade ensure that your old data will look like new. I have seen differences, particularly between the lines (1.4 vs 1.5).

[lovemyseo]

Look at ps_order_payment table. payment_method field should be filled for all records. I'm not completely sure if upgrade ensure that your old data will look like new. I have seen differences, particularly between the lines (1.4 vs 1.5).

Fields are filled but there is an issue that combination are also there but now showing on BO , also do I need to make any changes in ps 1.5.6.2 setup or DB before clicking upgrade

[lovemyseo]

Look at ps_order_payment table. payment_method field should be filled for all records. I'm not completely sure if upgrade ensure that your old data will look like new. I have seen differences, particularly between the lines (1.4 vs 1.5).

This is the error message I got

 

SQL 1.5.0.10 1242 in INSERT INTO `ps_product_attribute_shop` (`id_product_attribute`, `id_shop`, `wholesale_price`, `price`, `ecotax`, `weight`, `unit_price_impact`, `default_on`, `minimal_quantity`, `available_date`) (SELECT `id_product_attribute`, (SELECT `value` FROM `ps_configuration` WHERE `name` = 'PS_SHOP_DEFAULT'), `wholesale_price`, `price`, `ecotax`, `weight`, `unit_price_impact`, `default_on`, `minimal_quantity`, `available_date` FROM `ps_product_attribute`): Subquery returns more than 1 row

Edited July 22, 2014 by lovemyseo (see edit history)