Address Details Missing - SQL error

Description

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.

Environment

None

Steps to reproduce

Unable to reproduce. Am I able to query the browser the customer used?

Activity

Show:
Giles Marshall
January 8, 2013, 5:05 AM

Not enough information here to bugfix.

Debbie Doerrlamm
September 29, 2012, 7:25 AM

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

Giles Marshall
September 29, 2012, 6:08 AM

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.

Assignee

Unassigned

Reporter

mike

Severity

Minor