Originally Posted by
supersnow
I am having the exact same problem. The only thing is it is only isolated to our UK customers. Help!!!
Solved it!!!!
I had upgraded the site only a few months ago and the UK was set to use an address_format_id 6 but for some reason the address_format_id 6 was not in the address_format table. Once I inserted the address format into the table that use to be there it worked again.
So the two areas I have to look into was the countries table, check the address_format_id then I checked the address_format table saw that the address_format_id was missing so I did a sql query to insert the extra format.
I used the following sql code to insert the UK address format:
Code:
INSERT INTO `address_format` (`address_format`, `address_summary`) VALUES ('$firstname $lastname$cr$streets$cr$city$cr$state$cr$postcode', 'UK format');
(I found this code on another forum post)
Hope this might help someone else who comes across this issue.
Bookmarks