{"action":"reopened","issue":{"url":"https://api.github.com/repos/magento/magento2/issues/14964","repository_url":"https://api.github.com/repos/magento/magento2","labels_url":"https://api.github.com/repos/magento/magento2/issues/14964/labels{/name}","comments_url":"https://api.github.com/repos/magento/magento2/issues/14964/comments","events_url":"https://api.github.com/repos/magento/magento2/issues/14964/events","html_url":"https://github.com/magento/magento2/issues/14964","id":319889303,"number":14964,"title":"Magento_Sales module fails to upgrade (email has a wrong format)","user":{"login":"gtlt","id":17992895,"avatar_url":"https://avatars3.githubusercontent.com/u/17992895?v=4","gravatar_id":"","url":"https://api.github.com/users/gtlt","html_url":"https://github.com/gtlt","followers_url":"https://api.github.com/users/gtlt/followers","following_url":"https://api.github.com/users/gtlt/following{/other_user}","gists_url":"https://api.github.com/users/gtlt/gists{/gist_id}","starred_url":"https://api.github.com/users/gtlt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gtlt/subscriptions","organizations_url":"https://api.github.com/users/gtlt/orgs","repos_url":"https://api.github.com/users/gtlt/repos","events_url":"https://api.github.com/users/gtlt/events{/privacy}","received_events_url":"https://api.github.com/users/gtlt/received_events","type":"User","site_admin":false},"labels":[{"id":688811200,"url":"https://api.github.com/repos/magento/magento2/labels/G1%20Passed","name":"G1 Passed","color":"0e8a16","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-05-03T11:54:42Z","updated_at":"2018-05-09T09:41:33Z","closed_at":null,"author_association":"NONE","body":"<!--- Provide a general summary of the issue in the Title above -->\r\n<!--- Before adding new issues, please, check this article https://github.com/magento/magento2/wiki/Issue-reporting-guidelines-->\r\n\r\n### Preconditions\r\n<!--- Provide a more detailed information of environment you use -->\r\n<!--- Magento version, tag, HEAD, etc., PHP & MySQL version, etc.. -->\r\n1. Magento 2.2.3\r\n2. PHP 7.1.16\r\n3. MariaDB 10.2.9\r\n\r\n### Steps to reproduce\r\n<!--- Provide a set of unambiguous steps to reproduce this bug include code, if relevant  -->\r\n1. composer update 2.2.3 to 2.2.4\r\n2. upgrade Magento_Sales data: current version - 2.0.7, required version - 2.0.9 \r\n\r\n### Expected result\r\n<!--- Tell us what should happen -->\r\n1. update ok\r\n\r\n### Actual result\r\n<!--- Tell us what happens instead -->\r\n1. upgrade logs :\r\n Module 'Magento_Sales':\r\nUpgrading data.. We can't save the address:\r\nEmail has a wrong format\r\n\r\n<!--- (This may be platform independent comment) -->\r\nIn which table should I fix emails ? I have email Null values with the following request\r\n```\r\nSELECT * FROM `sales_order_address` where email is NULL\r\nSELECT * FROM `sales_order_address` where email is null\r\nSELECT * FROM `quote_address` where email is null ORDER BY `created_at` DESC\r\n```"}}
{"actor":{"display_login":"gtlt"}}