User Favorites Page Not Finding Any Results

Two things to check here: first, the “favorite” icon should show that the record has been favorited after the page is refreshed…this will show that the user favorite has been saved.

If this is not the case, then I would suspect some issue with the javascript. You can check on this by opening the Browser Developer Tools console and clicking the favorite icon.

For the next thing to check, you’ll need to turn on plugin debugging in the plugin settings under the advanced tab. While logged in as the user you want to test, view the favorites page. Now check the debugging log, it will show you the database query that was used to show the list.

Roland,

Everything is looking great except for the User Favorites page. This is what debug gives my when I load the page:

PDb_List::_setup_iteration list query: SELECT p.id, p.variety, p.goto, p.average_rating, p.favorite FROM wp_jysd9h1471_participants_database p WHERE p.id IN (“0”) ORDER BY p.variety ASC

Of course, I don’t pretend to understand what any of this actually means. But it doesn’t look right. It looks a lot like what I get from running the search page:

PDb_List::_setup_iteration list query: SELECT p.id, p.variety, p.goto, p.average_rating, p.favorite FROM wp_jysd9h1471_participants_database p ORDER BY p.variety ASC

So the difference seems to be with the addition of: WHERE p.id IN (“0”)

I’ve checked repeatedly to ensure I’m using the proper shortcode: [pdb_user_favorites template=responsive]

Lance

OK, that looks right, what that shows is that there are no favorites defined for the current logged-in user.

The first thing to check is that the favorites are getting saved. This should be visible while logged in: the favorites icon will indicate which records have been favorited. If you’re seeing that records are favorited, but nothing shows up in the favorites list, then that would indicate a problem. This is of course all while logged in to the same account.

Roland,
The favorites are being saved. They show up fine in the search list and the record page. They are just not displaying in the User Favorites page.
Lance

So, when the logged-in user that has favorites selected goes to the page with the user favorites shortcode, what do they see? I should have asked this first.

FIG USER FAVORITES
TOTAL RECORDS FOUND: 0, SHOWING 50 PER PAGE

Is it just this one user that’s seeing the problem? Other users favorites are showing up as expected?

I’m attempting to duplicate the problem, don’t see it yet.

• This reply was modified 6 years, 1 month ago by xnau webdesign.

Roland, As far as I can tell, it’s happening to all users. But here’s a new chain of logic for you to follow:

I create a new test user.
User goes to User Favorites page
Page displays the message: Please log in to see your favorites.
User logs in
Page now displays: You have no favorites selected yet.
User goes to search page, selects a record, and favorites that record
The record is saving the favorite and incrementing the total favorites on the search column
User goes back to User Favorites page
The page displays: Total Records Found: 0, showing 50 per page
So what changed before the new user selected a favorite? Clearly we go from “You have no favorites selected yet.” to “Total Records Found: 0, showing 50 per page”. So the system recognizes that favorites have been selected, but can’t find them?

OK, this has got me to thinking: If, when I originally installed Directory Tools, I gave it a URL slug of “figs” and I changed it to “fig-varieties”, could the change have been made across the board except where the User Favorites is looking? The search list and records favorites are working fine, just not the user favorites page.

Well, it shouldn’t matter as long as the permalink to the record eidt page is working. Just to be sure I suggest you go to the WordPress Permalinks settings page and click save to refresh the permalinks.

If you’re still having the issue, please email me with a private link to a test account I can use to see it for myself. I want to get to the bottom of this.

[email protected]