Forums / Managing Customers and Orders / Sorry, but we no longer accept billing or shipping addresses in "Country"

Sorry, but we no longer accept billing or shipping addresses in "Country"

Views: 2,727

Results 1 to 4 of 4
13 Dec 2022, 4:20 PM
#1
ormhaugen avatar

ormhaugen

New Zenner

Join Date:
Apr 2009
Posts:
32
Plugin Contributions:
0

Sorry, but we no longer accept billing or shipping addresses in "Country"

I've got a phone call from a customer telling me he got this message when trying to place an order:
'Sorry, but we no longer accept billing or shipping addresses in "Noreg". Please update this address to continue.'
He is a returning customer. Seems to be a problem because he's already in the database.
I've got orders over the last days from first-time customers, no problem.
Earlier I've had returning customers placing orders without any problems.
I haven't done any editing of the site over the last months.
Can anybody point me in the right direction to fix this?
The site is in norwegian, the error text is copied from the english.php.

Geir

ZC 1.5.7d
https://www.osteroy-sogelag.org/butikk157d/
PHP 7.4.32

13 Dec 2022, 4:41 PM
#2
carlwhat avatar

carlwhat

zennedOut

Join Date:
Nov 2005
Location:
los angeles
Posts:
2,973
Plugin Contributions:
8

Re: Sorry, but we no longer accept billing or shipping addresses in "Country"

your problem starts here:

https://github.com/zencart/zencart/blob/742b837868a2b128df96b6635c413c8187972679/includes/init_includes/init_header.php#L69-L72

now why noreg would have its status changed, i can not really say.

if this was previously working, and now is not, it suggests to me possibly a php change or mysql change by your host. but that's purely a guess; and probably not a good one.

in phpMyadmin you could see the results of:

select * from countries where status = 0;

and see if noreg pops up. better yet, look here:

YOUR_ADMIN/index.php?cmd=countries&page=N

and see if there is a green or red box. change accordingly.

if all else fails, you could comment out lines 71 and 72 above, but that would be a last resort.

hope that points you in a good direction!

author of square Webpay, now with Apple Pay and Google Pay.
mXworks
donations: venmo or paypal accepted.
premium consistent excellent support. available for hire.

13 Dec 2022, 8:41 PM
#3
ormhaugen avatar

ormhaugen

New Zenner

Join Date:
Apr 2009
Posts:
32
Plugin Contributions:
0

Re: Sorry, but we no longer accept billing or shipping addresses in "Country"

Found it.
I the database table 'countries' there is a field 'status'. Alle countries have '1', only Norway has '0'.
I have no clue how that happened, but changing it to '1' seems to fix the problem.
Thank you carlwhat!

13 Dec 2022, 8:53 PM
#4
carlwhat avatar

carlwhat

zennedOut

Join Date:
Nov 2005
Location:
los angeles
Posts:
2,973
Plugin Contributions:
8

Re: Sorry, but we no longer accept billing or shipping addresses in "Country"

Ormhaugen:

Found it.
I the database table 'countries' there is a field 'status'. Alle countries have '1', only Norway has '0'.
I have no clue how that happened, but changing it to '1' seems to fix the problem.
Thank you carlwhat!

:thumbsup:

author of square Webpay, now with Apple Pay and Google Pay.
mXworks
donations: venmo or paypal accepted.
premium consistent excellent support. available for hire.