+ Reply to Thread
Results 1 to 9 of 9

Thread: Multifield/Location Filter - Find out what location is on the 5th level

  1. #1

    Multifield/Location Filter - Find out what location is on the 5th level

    Rudi,

    I was entering a 4th level in the Multifield/Location Filter.

    When I finished, I ended up with a 5th level.

    I spent hours trying to find where I entered a 5th level.

    Is there any way to find the 5th level without having to look at every level one by one?

    Your help is always appreciated.

  2. #2
    Master
    Join Date
    Jun 2017
    Location
    Fukushima
    Posts
    299
    Quote Originally Posted by Joe Can View Post
    Rudi,

    I was entering a 4th level in the Multifield/Location Filter.

    When I finished, I ended up with a 5th level.

    I spent hours trying to find where I entered a 5th level.

    Is there any way to find the 5th level without having to look at every level one by one?

    Your help is always appreciated.
    Hello Joe,

    Nothing when you go to Listings fields?

  3. #3
    The Listing Fields page only allows to change the name of the field.

    I want to find out what I accidentally entered in the 5th level of the plugin.

  4. #4
    Flynax developer Rudi's Avatar
    Join Date
    Dec 2014
    Location
    Planet Earth
    Posts
    3,138
    Hello,

    Try to execute the following sql query to check if the 5th level exists in your multi-field entry: Common > Database

    Code:
    Only registered members can view the code.
    it should show all the entries of the 5th level

  5. #5
    I am getting the follow message:

    - "Table 'db3m4zah7urhe7.fl_multi_formats' doesn't exist"

  6. #6
    Flynax developer Rudi's Avatar
    Join Date
    Dec 2014
    Location
    Planet Earth
    Posts
    3,138
    You need to use your db prefix in `fl_multi_formats` instead of fl_

    check it in includes > config.inc.php > RL_DBPREFIX
    Last edited by Rudi; February 1, 2021 at 09:48 AM.

  7. #7
    The DB prefix is "fly"; so, I entered the following:

    - "SELECT `ID`, `Key`, `Path_en` FROM `fly_multi_formats` WHERE `Path_en` regexp '^([^/]*[/]){4}[^/]*$'"

    The following message appeared:

    - "Unknown column 'Path_en' in 'field list'"

    I checked for the 5th field using the Map search on the homepage. I did not find anything entered into the 5th Level.
    However, I am only 90% as I might have missed a few items.

  8. #8
    Flynax developer Rudi's Avatar
    Join Date
    Dec 2014
    Location
    Planet Earth
    Posts
    3,138
    Forget to mention that instead of 'en' in Path_en you should use your language code used on your site

    anyway, you can create a ticket if you have problems

  9. #9
    Yes I am only using English.

    I will open a ticket.

+ Reply to Thread