remove countries

Hi,

In Multi-field/Geo filteringCountry

how to remove all countries other than one by one to keep only one ?

Thank you.

Quote:

---

Originally Posted by Acte Immo

Hi,

In Multi-field/Geo filteringCountry

how to remove all countries other than one by one to keep only one ?

Thank you.

---

You can remove it from database via phpMyAdmin only. In current version it's not possible via admin panel.
P.S. You need make a full backup before any changes in database.

Thank you Curtis

can you build me a SQL query to keep only the France?

If this does not take too long for you.

Thank you

Quote:

---

Originally Posted by Acte Immo

Thank you Curtis

can you build me a SQL query to keep only the France?

If this does not take too long for you.

Thank you

---

Hello Acte,

You can use the following template for it (don't forget make a backup of database before any changes)

1. {db_prefix} - replace to your prefix
2. {country_key} - replace to key of your country (for example: france)

Code:

---

Only registered members can view the code.

---

Perfect Curtis !

Thank you for all.

Hi Curtis,

I am trying to do the same as Acte Immo, but unsuccessfully.

I run query

Quote:

---

SELECT`T1`, `T2` FROM `fl_data_formats` AS `T1` LEFT JOIN `fl_lang_keys` AS `T2` ON`T2`.`Key` = CONCAT('data_formats+name+', `T1`.`Key`) WHERE `T1`.`Key` LIKE'countries_%' AND `T1`.`Key` NOT REGEXP '^countries_bulgaria.*'

---

But in throws error: #1054 - Unknown column 'T1' in 'field list'

Using

Quote:

---

DELETE`T1`, `T2` FROM `fl_data_formats` AS `T1` LEFT JOIN `fl_lang_keys` AS `T2` ON`T2`.`Key` = CONCAT('data_formats+name+', `T1`.`Key`) WHERE `T1`.`Key` LIKE'countries_%' AND `T1`.`Key` NOT REGEXP '^countries_bulgaria.*'

---

Does not produce anything either.

BR.,

First I would like to know if country Active/Inactive flag has a purpose and what

Hello Stefan,

Use the following query for selection:

Code:

---

Only registered members can view the code.

---

Thanks Curtis,

Meanwhile I have inactivated all unnecessary countries and the flag seems to work ok. One should erase cookies after inactivation, otherwise strange behaviour appears in country list.

Quote:

---

Originally Posted by Stefan Popadiin

Thanks Curtis,

Meanwhile I have inactivated all unnecessary countries and the flag seems to work ok. One should erase cookies after inactivation, otherwise strange behaviour appears in country list.

---

Hello Stefan,

Yes, you're right, the old location data saved in cookies and system will try redirect you to old location.