Search Problem

Hi, somebody can help me?
I reinstall wordpress, i reinstall only this plugin using normal theme and i have again this search problem on frontend. The backend function perfect.
So it is very strange, i have a dropdown search menu that give the right results only with the same field that i include in my shortcode.
For example if i have:
[pdb_list fields=”name, lastaname, private_id, email” search=”true” sort=”true” display_count=”true”]
I search Alex in name dropdow, the result is correct, if i search Alex in lastname dropdown the result is 0 (correct), if i search alex in email field the result is 0 (correct) but if i search alex in city dropdown list field the result put all my data: 1000 results found!
If i add city in my shortcode fuction well and show me 0 result.

Please help me

Thank you

I think it’s a bug in the plugin, but you could do this:

If you set the “display column” to 0 for “city” in the “manage database fields” admin page, it should disappear from the search field dropdown.

Thank you for your answer.
I am sure that it is not a plugin bug because i use in another my website the version 1.3.7 anf function perfect. So, i know that i could set “0” on display column of city field but my problem is that i have various search page and i cannot decide to populate dropdwon search menu in different way for different page. If i put 0 on city field, disappear everywhere!
So i have to show all my fields on dropdown search frontend menu.
How can i solve it?

Best

It could be a bug introduced after 1.3.7 due to code changes.

What is the field type of “city”? Text line?

There are basically 2 ways to fix this:
1) Only display search fields in the dropdown that are specifically passed/requested as shortcode attributes
2) Fix the search for non-display fields

The second one obviously would be better, but both will require code changes. Wish I could help ??

Hi, the field is text line. I am seroiuos thinking about a bug like you said.
If i add city field in my shortcode function well like i explain before but i do not want to insert all the field in my shortcode (space problem).
So, i have to try to solve the problem with your 2 suggestion or i need to come back to older version but i do not want to make this solution.
It is very strange that nobody speak about this.

Thanks for your answer

I think you are the first to notice because I think most of us don’t use multiple different [pdb-list] shortcodes.

On my website for instance, I just use [pdb-list], with no attributes at all. I configure which columns to display by using the admin panel.

So many of us will not see this problem/bug until we start using multiple list shortcodes with different field displays.

Ok, i understand.
I hope to find a solution…
Thank for your support

Thanks a lot to Xanu for his support

Now Function Perfect

BEST

Care to post the solution?

Hi, i do not know wich file he modify but this bug fix will include soon in the next releae

You need to change two lines in PDb_List.class.php

Line 309 changes from:

in_array($this->filter['search_field'], $this->display_columns)

to:

Participants_Db::is_column($this->filter['search_field'])

Line 313 changes from:

$search_field = Participants_Db::get_field_atts($this->display_columns[array_search($this->filter['search_field'], $this->display_columns)]);

to:

$search_field = Participants_Db::get_field_atts($this->filter['search_field']);