blank result

note55
(@note55)

5 years, 2 months ago

Hi

I set up the plugin and did everything right
And he worked for the first day without any problems

But after three days he stopped working, I don’t know the reason

When searching for the name or the result, nothing appears

Note, I did not update or do anything in the properties

Everything is the same, but after a while it does not work
This code
[pdb_search target_instance=”1″ search_fields=”passportid”][pdb_list suppress=true]

I’ve updated looking for passportid to shown the result

Viewing 4 replies - 1 through 4 (of 4 total)

Thread Starter note55
(@note55)

5 years, 2 months ago
this is log
```
[03/13/21 12:44pm UTC]
PDb_List::_setup_iteration list query: SELECT p.first_name, p.passportid, p.last_accessed, p.date_updated, p.date_recorded, p.id FROM co_participants_database p WHERE p.id = "0" ORDER BY p.date_recorded ASC
[03/13/21 12:44pm UTC]
PDb_List::_setup_iteration list query: SELECT p.first_name, p.passportid, p.last_accessed, p.date_updated, p.date_recorded, p.id FROM co_participants_database p ORDER BY p.date_recorded ASC
[03/13/21 12:44pm UTC]
PDb_List::_setup_iteration list query: SELECT p.first_name, p.passportid, p.last_accessed, p.date_updated, p.date_recorded, p.id FROM co_participants_database p WHERE p.id = "0" ORDER BY p.date_recorded ASC
[03/13/21 12:44pm UTC]
PDb_List::_setup_iteration list query: SELECT p.first_name, p.passportid, p.last_accessed, p.date_updated, p.date_recorded, p.id FROM co_participants_database p ORDER BY p.date_recorded ASC
[03/13/21 12:44pm UTC]
PDb_List::_setup_iteration list query: SELECT p.first_name, p.passportid, p.last_accessed, p.date_updated, p.date_recorded, p.id FROM co_participants_database p WHERE p.id = "0" ORDER BY
```
Plugin Author Roland Barker
(@xnau)

5 years, 2 months ago

That is the database query that is used when the “suppress” attribute is enabled in the list shortcode.

I suggest you clear the log, perform your search, then see what comes in to the log.

Thread Starter note55
(@note55)

5 years, 2 months ago

Hello

same issues

Log file initiated at: 13 March، 2021 9:37 pm UTC
[03/13/21 9:37pm UTC]
PDb_List::_setup_iteration list query: SELECT p.first_name, p.passportid, p.last_accessed, p.date_updated, p.date_recorded, p.id FROM co_participants_database p WHERE (p.passportid LIKE “%A123456%”) ORDER BY p.date_recorded ASC
[03/13/21 9:37pm UTC]
PDb_List::_setup_iteration list query: SELECT p.first_name, p.passportid, p.last_accessed, p.date_updated, p.date_recorded, p.id FROM co_participants_database p WHERE p.id = “0” ORDER BY p.date_recorded ASC

Plugin Author Roland Barker
(@xnau)

5 years, 2 months ago

Are you using the [pdb_search] shortcode? Avoid doing that way of you are, you really only need to add the search=true atrribute to the list shortcode to get your list search.

If you do want to use the [pdb_search] shortcode you need to make sure it is properly configured:

The Search Shortcode

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘blank result’ is closed to new replies.