todaytonight Posted September 23, 2013 Share Posted September 23, 2013 Tried to enable countries, but delete some of them by accident. How can I get them back? At BO, localization -> countries, select all and tried to enable them. However, the default action is deleting, so I deleted at last 50 countries by accident. How can I get them those countries back? Please help. Thank you! My shop version: 1.5.5 Link to comment Share on other sites More sharing options...
mfedorets Posted September 23, 2013 Share Posted September 23, 2013 Hi, if you havn't made shop customization via backend after installation you can try to change ps_country, ps_country_lang, ps_country_shop tables to their counterparts from initial installation. Link to comment Share on other sites More sharing options...
musicmaster Posted September 23, 2013 Share Posted September 23, 2013 You can make a fresh (dummy) PS install. Then export in phpmyadmin from there the country and country-lang tables. In your real shop you should then delete these two tables and import them from the exported sql file. As mfedorets said, you should also check your ps_country_shop and maybe also other country-related files. 1 Link to comment Share on other sites More sharing options...
todaytonight Posted September 24, 2013 Author Share Posted September 24, 2013 Hi, if you havn't made shop customization via backend after installation you can try to change ps_country, ps_country_lang, ps_country_shop tables to their counterparts from initial installation. thanks for reply. Could you please give me more secific instruaction? Not sure what do you meam "if you havn't made shop customization via backend after installation". The shop has been installed for more than 1 year... Link to comment Share on other sites More sharing options...
vekia Posted September 25, 2013 Share Posted September 25, 2013 i exported default installation countries (6 languages) here is the file: http://pastebin.com/D32v8yDY run this query in your database manager used: table prefix: ps Link to comment Share on other sites More sharing options...
crazyerror Posted January 11, 2014 Share Posted January 11, 2014 (edited) I have the same query. By mistake I have deleted first 50 countries. I looked out for SQL manager but it only allows "SELECT" query. Also, I tried to look out for xml on server, but still I am not getting from where I can add default PS_Country, PS_Country_lang and PS_Country_Shop tables. "TodayTonight" have you got any solution yet? Edited January 11, 2014 by crazyerror (see edit history) Link to comment Share on other sites More sharing options...
Navman Posted January 12, 2014 Share Posted January 12, 2014 You can make a fresh (dummy) PS install. Then export in phpmyadmin from there the country and country-lang tables. In your real shop you should then delete these two tables and import them from the exported sql file. As mfedorets said, you should also check your ps_country_shop and maybe also other country-related files. Yup, that worked, thanks ! ;-) Maybe a good idea for the developers to change that default selection to something else than DELETE !? Best regards, Francois Link to comment Share on other sites More sharing options...
vekia Posted January 12, 2014 Share Posted January 12, 2014 or just use the sql code that i attached here; http://pastebin.com/D32v8yDY much faster without installation etc Link to comment Share on other sites More sharing options...
crazyerror Posted January 13, 2014 Share Posted January 13, 2014 Thank you Navman and Vekia. Vekia, Can you let me know where I can run your query? SQL manager do not allow to run "Insert". Navman I will try to use your method too. Link to comment Share on other sites More sharing options...
vekia Posted January 13, 2014 Share Posted January 13, 2014 if you've got an access to phpmyadmin database manager you can run it there. usuallythis manager is available in all hosting packets, so please verify your hosting account control panel. there is a tab named "SQL", just paste this code there and hit "run" Link to comment Share on other sites More sharing options...
crazyerror Posted January 13, 2014 Share Posted January 13, 2014 Thanks a lot Vekia. I have done that - too fast and easy Link to comment Share on other sites More sharing options...
vekia Posted January 13, 2014 Share Posted January 13, 2014 so, now countries appear well? Link to comment Share on other sites More sharing options...
Recommended Posts