+ Reply to Thread
Results 1 to 9 of 9

Thread: remove countries

  1. #1
    Senior Member
    Join Date
    Jun 2016
    Posts
    106

    remove countries

    Hi,

    In Multi-field/Geo filteringCountry

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

    Thank you.

  2. #2
    Quote Originally Posted by Acte Immo View Post
    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.
    @Flynax Company

  3. #3
    Senior Member
    Join Date
    Jun 2016
    Posts
    106
    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.

  4. #4

    Cool

    Quote Originally Posted by Acte Immo View Post
    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.
    Thank you, Curtis.
    @Flynax Company

  5. #5
    Senior Member
    Join Date
    Jun 2016
    Posts
    106
    Perfect Curtis !

    Thank you for all.

  6. #6
    Hi Curtis,

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

    I run query
    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
    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

  7. #7
    Hello Stefan,

    Use the following query for selection:

    Code:
    Only registered members can view the code.
    Thank you, Curtis.
    @Flynax Company

  8. #8
    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.

  9. #9
    Quote Originally Posted by Stefan Popadiin View Post
    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.
    Thank you, Curtis.
    @Flynax Company

+ Reply to Thread