Jump to content

[Solved]Restore Countries to default


SpyrosT
 Share

Recommended Posts

There is no option in the Back Office to do this. You'll have to do things the hard way by manually going to your database and emptying the appopriate tables and then open install/sql/db_settings_lite.sql and copy the INSERT INTO `PREFIX_country`section and any other appropriate sections and run the SQL queries on your database using phpMyAdmin to restore the default values. It looks like the relevant tables are `PREFIX_carrier_zone`, `PREFIX_country`, `PREFIX_country_lang`, `PREFIX_state`, `PREFIX_zone`. Remember to make a backup of the tables before emptying them in case something goes wrong!

Share this post


Link to post
Share on other sites

Hey rocky,

Many thanks for your reply and instuctions.
The mess is about the "zones" only, all other infos are ok.

Will this work if I only empty the zones table and reinstall it?

By the way it should e really helpful if there were some restoration functions in BO
because as you said some things need the "hard way".

Share this post


Link to post
Share on other sites

In that case, it should only be the zone and carrier_zone tables you need to restore. They are linked by id_zone, so I think you should restore both, otherwise problems may occur with mislinked zones.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More