Printable View
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.
Attachment 20596
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.Quote:
Originally Posted by Shop Suey
~Melanie
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 =)Quote:
Originally Posted by Shop Suey
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...ling-countries
Good to know for the future!Quote:
Originally Posted by swguy
One problem which still occurs at the registration form are duplicate entries.
Please see the attachement.
Attachment 20618
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.