Hi,
In Multi-field/Geo filteringCountry
how to remove all countries other than one by one to keep only one ?
Thank you.
Hi,
In Multi-field/Geo filteringCountry
how to remove all countries other than one by one to keep only one ?
Thank you.
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
Last edited by Acte Immo; August 24, 2016 at 03:18 PM.
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.
Thank you, Curtis.
@Flynax Company
Perfect Curtis !
Thank you for all.
Hi Curtis,
I am trying to do the same as Acte Immo, but unsuccessfully.
I run query
But in throws error: #1054 - Unknown column 'T1' in 'field list'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.*'
Using
Does not produce anything either.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.*'
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.
Thank you, Curtis.
@Flynax Company
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.