Magento 2 update from 2.1.9 to 2.2.1 errors

When running command php bin/magento setup:upgrade

I was getting the following erorr

Error converting field product_options in table sales_order_item where item_id=1,2,3,4

UPDATE `sales_order_payment` SET `additional_information` = NULL WHERE `additional_information` = ''

After running that the next error I got was

in phpmyadmin click on the sales_order_payment table then run this sql statment.

UPDATE `sales_order_payment` SET `additional_information` = NULL WHERE 'additional_information' = ''

‘additional_information’ in table ‘sales_payment_transaction’ where ‘transaction_id’=2, 4, 6, 7

UPDATE `sales_payment_transaction` SET `additional_information` = NULL WHERE `additional_information` = '';

Leave a Reply

Your email address will not be published. Required fields are marked *