cancel
Showing results for 
Search instead for 
Did you mean: 

Upgrade failing because of email address?

Upgrade failing because of email address?

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-

enter image description here

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.

10 REPLIES

Re: Upgrade failing because of email address?

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 linkhttps://github.com/magento/magento2/issues/14964

if issue solved,Click Kudos & Accept as Solution

Re: Upgrade failing because of email address?

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?

Re: Upgrade failing because of email address?

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

if issue solved,Click Kudos & Accept as Solution

Re: Upgrade failing because of email address?

Screenshot from 2018-05-16 12-40-12.png

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

Re: Upgrade failing because of email address?

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 !!

if issue solved,Click Kudos & Accept as Solution

Re: Upgrade failing because of email address?

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. 

Re: Upgrade failing because of email address?

what is the process to upgrade it

iball tech support

Re: Upgrade failing because of email address?

Re: Upgrade failing because of email address?

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