Upgrade failing because of email address?

[TylerWolf]

I was upgrading Magento 2.2.3 to Magento 2.2.4. Everything went ok but the final step is to run bin/magento setup:upgrade and when I run that I get the below error-

We can't save the address: Email has a wrong format.

Which email address has an issue? I have upgraded from 2.2.2 to 2.2.3 with no problem a few months ago.

[Manthan Dave]

Hi @TylerWolf

It looks like it is known issue and previously happen with some other users as well and reported on github as well.

It was related to null entry email in sales_order_address table.

run below query in sales_order_address table

update `sales_order_address` SET email = 'test@test.com' where email is null;

There is also one more query if this will not work - then you can use it for the same.

Here is the github link - https://github.com/magento/magento2/issues/14964

[TylerWolf]

I was able to use the first one and it progressed. Once I did I got this error Missing required argument $options of Magento\Eav\Model\Entity\Attribute\Source\Config at the Magento_Sales step. Any suggestions?

[Manthan Dave]

Hi @TylerWolf

I understand  - can you please share a screenshot for the same ? or error log which exactly you are able to see over there ? - so its help us to troubleshoot the issue

[TylerWolf]

I looked in the logs and didn't see anything. Have a suggestion on which log it would be in?

[Manthan Dave]

Hi @TylerWolf

okay i understand - try below query !!

update sales_order_address a left join customer_entity b on a.customer_id = b.entity_id set a.email = b.email where a.email is null

Hope it helps !!

[TylerWolf]

I ran that and it said 0 rows affected. I ran the php/bin magento:upgrade command again afterwards just to see and I got the same error. 

[iball tech_support]

what is the process to upgrade it

iball tech support

[email_customer number]

if it is due to email tech help from http://www.emailcustomersupportservice.com/forgot-email-password/

[safari browser_support]

I do not know so please tell me, how to update the email process. Safari Browser Support services