Guest Posted December 9, 2011 Share Posted December 9, 2011 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? cagejyiofh 1 Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted December 9, 2011 Share Posted December 9, 2011 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 Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
Guest Posted December 9, 2011 Share Posted December 9, 2011 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted December 9, 2011 Share Posted December 9, 2011 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 Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted December 9, 2011 Share Posted December 9, 2011 Nice one G Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.