1.4.9.0 to 1.5.1.0 Column 'id_order_invoice' cannot be null

[hazyswim]

I'm trying to upgrade from 1.4 to the newest release incrementally, and I'm stuck at the first step.

I'm using 1-click Upgrade v0.7. PHP 5.3.28, MYSQL 5.6.49.

When upgrading I get an error:

Quote

[ERROR] SQL 1.5.0.2 1048 in UPDATE `ps_order_detail` od SET od.`id_order_invoice` = ( SELECT oi.`id_order_invoice` FROM `ps_order_invoice` oi WHERE oi.`id_order` = od.`id_order` 😞 Column 'id_order_invoice' cannot be null
[ERROR] PHP 1.5.0.12 1 - ALTER TABLE `ps_order_payment` CHANGE `id_order_invoice` id_order_invoice int(10) unsigned DEFAULT NULLIncorrect integer value: '' for column 'id_order_invoice' at row 1
Warning detected during upgrade.

I tried with MYSQL version: 5.5.62, 5.6.44, 5.6.49, same error with each.

Help would be appreciated

[musicmaster]

My guess would be that you have some database inconsistencies. It can for example be some missing rows or some values that accidentally are set to null or 0. 

You will need to dive into the details of the database to find the culprit. If you are lucky it is just one or a few very similar issues. The alternative is to outsource.

[hazyswim]

Solved it by truncating tables starting by orders. cant see previous orders now but the site works