Add previously purged shipping locations adds empty lines

About a decade ago I decided to ship national only.
I purged all countries but one manually via the admin.
Today I need to add some additional countries and get the problem, that there are also some empty lines added to choose.
How can I fix this?
Please see the attachement.

Shop Suey:

About a decade ago I decided to ship national only.
I purged all countries but one manually via the admin.
Today I need to add some additional countries and get the problem, that there are also some empty lines added to choose.
How can I fix this?
Please see the attachement.

In order to create these you will need to grab the SQL from the correct install version of Zen Cart or port them from another same version install.

~Melanie

I could install a blank shop with the same zc version.
How can I port them?

Shop Suey:

I could install a blank Shop with the same zc version.
How can I port them?

You'll need to use a database tool like PHPmyAdmin to export the table, then drop it in to the other DB. BACKUP first =)

Thank you for the hint.
There is a way with more control. I don't like to copy&paste tables between different shop and database versions.

1. add via admin
2. pickup the countries id from the table countries_name
3. edit the countries id at the table countries

This seems to work so far.

I purged all countries but one manually via the admin.

This is a better way:

https://docs.zen-cart.com/user/admin_pages/locations/countries/#disablingenabling-countries

swguy:

I purged all countries but one manually via the admin.

This is a better way:

https://docs.zen-cart.com/user/admin_pages/locations/countries/#disablingenabling-countries

Good to know for the future!

One problem which still occurs at the registration form are duplicate entries.
Please see the attachement.

When Is switch the backend language I see them doubled at the added language.
Can I just purge them via backend?

What helps is to switch to the re-added language (English in my case), purge all these double entries e.g. "Niederlande" and "Netherlands", and re-add the language here again.
That looks very messed up :(
I can work-around it as described except the main language. I can't purge it because there are customers conected it.

There are some questions I have:

1. how can I fix the problem with the first language (German)
2. how can I fix this mess in general?

I think I got it.
I just purged the country names via the backend.
What was connected to customers I purged at the database.
Then re-creation via backend worked as expected.
And ist doesn't even show the initial problem with these blank lines.