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

[Ormhaugen]

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

[carlwhat]

your problem starts here:

https://github.com/zencart/zencart/b...er.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!

[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!

[carlwhat]

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!