I took a look at this and it looks like a security restriction. I suggest you ask your web host about this, they may need to set up an exception so the code can run. Alternatively, you could uncheck “Use AJAX Searches” that might fix it.
Also, to explain how the [pdb_search] shortcode works, you need to tell it where the results will be shown. Usually, that is another page. That page must have the [pdb_list] shortcode, because that is what shows the results of the search.
If you want the results on the same page, you don’t need to use the [pdb_search] shortcode at all, just use the [pdb_list] shortcode and enable search like this: [pdb_list search=true]
@xnau, thank you for your help. Unchecking “Use ajax Searches” helped and the code is running, but I don’t get any results. My list contains Zip, Dealer name, and Phone number. All I want is to put a zip in and get a dealer name and phone number if existing.
I used the [pdb_list search=true] but now it when I click search it asks “Please select a column to search in.” and don’t get any result. What do I do wrong?
The page where I have the [pdb_list] is http://foxweldoor.wpengine.com/dealer-location/, where I get the same empty table.
Are you using a custom template or did you edit the plugin at all?
I didn’t touch the plugin files. I’m using Avada theme, and installed the plugin as is. The host is WpEngine.
I’d suggest asking your web host. WpEngine has a good rep for supporting plugins, they have a special server setup that sometimes requires some extra configuration to get things working.
So I have an open ticket with wpengine, and this is what they’re asking:
”
In WPEngine, all pages in a live site are cached which can interfere with forms. To proceed troubleshooting, we need to know if the plugin requires a list of cache exemptions to be added. So far I only see one created for ^/find-a-dealer, but if the plugin depends on other forms or fields we need to add those too.”
Do you have an answer to that?
thank you!
They’re just asking for a list of pages where you are using Participants database shortcodes.
So that means it only uses that one page, nothing else?
thx!
Maybe, I don’t know, but you should make sure that all pages that you have Participants Database shortcodes on should be on their list of cache exceptions.
I got it to work. The fields had the display value of zero by default, and that’s why they didn’t show. The Ajax error was showing because the site was locked. When I unlocked it was gone.
I have a couple more question:
1. Is it possible to only be able to search by ZIP so the customers won’t have to choose the filed they would search by?
2. Is it possible on my page not to show the list, only the search field, and results?
Thank you!
For the first questions, take a look at this post:
Customizing the List Search: Searching on Only One Field
On the second, use the “suppress” attribute in the list shortcode: details…
It works perfectly!
Thank you for your awesome support!
