I see that I can check them and mass delete, but I didn't want to do that in case I decide to ship internationally at some point in the future.
I started going through them and disabling each one at a time, but that is going to take forever.
Has anyone found a simple solution other than deleting?
Also, I tried to check all the ones I wanted to delete and when it went through I got an error that said
'Warning: This zone cannot be deleted as it is currently assigned to 1 address book entries!'
I can't find an address book so I can take this off. Does anyone know any fixes, solutions?
Code: Select all
UPDATE oc_country SET `status` = 0;
You should double-check the table name in your database, since you may have a different prefix than oc_
The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.
Opencart.com Administrator / Quality Assurance Analyst / Programmer
Double-check the database table prefix (which is "oc_" by default, but might be something different in your installation) and double-check that you're clicking the correct button in your database editor (e.g. phpMyAdmin) to actually run the query. If you still have issues after that, I'd maybe ask your host to attempt it, and make sure that phpMyAdmin is working correctly.
Users browsing this forum: No registered users and 4 guests