Address Details Missing - SQL error
Some orders are missing the address details in all 3 categories (shipping, billing and customer) however when I go to edit order they are in the database. Also the country is left as default (Afghanistan!) and therefore shipping is Airmail by mistake.
When I query the database all info is there apart from the address_format_id for the three address which when amended to '6' seems to fix the problem and then I have to also manually then add the country and county/state.
Steps to reproduce
Unable to reproduce. Am I able to query the browser the customer used?
Not enough information here to bugfix.
FYI this happens ocassionally on 2.0.25 also.. always the customer is outside the US.
Images 1 & 2 are exactly what I have seen in the past. I never checked the DB because it just happens so rarely
Looking at your images ... YORKSHIRE is not a valid County - South, North and West are ... so how did the customer enter this? Without a country things are going to go wonky.