Jump to content

1.4.9.0 to 1.5.1.0 Column 'id_order_invoice' cannot be null


Recommended Posts

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

Link to comment
Share on other sites

  • 2 weeks later...

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.

Link to comment
Share on other sites

  • 1 month later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...