swagevolution.com Posted January 2, 2013 Share Posted January 2, 2013 I am sort of new to prestashop. Tonight I accidentally deleted all the countries from the back office. Can anyone tell me the fastest way to replace them all one shot. HELP!!! I APPRECIATE YOU ALL CLEM Link to comment Share on other sites More sharing options...
vekia Posted January 2, 2013 Share Posted January 2, 2013 you must ad them manually or create sql script to add many values to database. It isn't simple procedure. maybe someone knows other way to do that Link to comment Share on other sites More sharing options...
swagevolution.com Posted January 2, 2013 Author Share Posted January 2, 2013 Omg. Are you serious? Do you think there is an easy way to add them manually. I'm afraid I may miss countries. Where an I find a solid country list. Thank you soo much Link to comment Share on other sites More sharing options...
prestashopninja Posted May 3, 2013 Share Posted May 3, 2013 I wish I'd see this one before to help in time, yet for similar future problems: This happened to me while configuring a new webshop. Here is how it is solved: 1. Make a fresh Prestashop install using the same version as the site where the countries are lost. 2. Open phpMyAdmin and stiwch to the new installation's database. 3. export ps_country, ps_country_lang and ps_country_shop tables into a file with "drop table if exists" and "create table" options. 4. Switch to the damaged installation's database and import the file you have exported in step #3 and you are done. Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts