I am facing issues with Magento Upgrade from 2.2.2 to 2.2.5. After upgraded, I ran setup:upgrade command several times, but each time It takes too much time in Module_Sales upgrading data. After taking so long, It returns error We can't save the address, Email has a wrong format.

Can anyone help me? Thank Youenter image description here


1 Answer 1


I've faced with the same issue after upgrade magento to 2.2.5 version. Also we're using migrated database and I think this is the main key of current error.

I've solved current issue with queries:

update quote_address a left join customer_entity o on a.customer_id = 
o.entity_id set a.email = coalesce(o.email, '[email protected]') 
where a.email is null

update sales_order_address a left join sales_order o on a.parent_id = 
o.entity_id set a.email = coalesce(o.customer_email, 
'[email protected]') where a.email is null

Briefly, in some quote or sales addresses, email has been missed and we populate it with email of the customer if customer ID not empty, otherwise just added dummy email.

Also it could be useful reference in current question: https://github.com/magento/magento2/issues/14964

  • Yes I did similar thing, It helped Mar 19, 2019 at 10:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.