4 replies to this topic

[HuskyDog]

If a customer creates an account with an address in Germany or Austria then their State/County/Province does not show in their address book.

If they go in to their account and edit their address to show a different country then the State/County/Province will display correctly.

There must be some bug that is causing this to happen, as you will get the same result if you sign up for an account on the oscommerce demo site. As far as I can see this is just for Germany and Austria.

I have gone through PHPMyAdmin and deleted the German and Austrian zones and reinstalled them very carefully, but the same thing happens.

When you get an email informing you about an order from someone with a German/Austrian address the state will not be displayed there either.

This may be a big problem if the full address of the customer is not passed to PayPal.

Anybody have any ideas?

[geoffreywalton]

The address format is determined by the country.

Go and maintain the country and you wll see an address code format.

This address format is held in a table called address_format.

You need to use phpmyadmin to see the contrnts of this file.

On my sites germany is set to format 5

HTH

G

[HuskyDog]

Hi Geoffrey,

Thanks for the help. I have found the table in the database but I'm not sure what needs changing to fix the problem.

Sorry if that sounds stupid.

Best regards,

Ian

[HuskyDog]

Hi Geoffrey,

Gotcha. I changed it in the countries table. The only two countries set to 5 were Austria and Germany.

Many thanks for that.

Best regards,

Ian

[geoffreywalton]

Nice one

G