I working with an existing WP site that has a curious thing that is happening that I haven’t been able to determine where the issue is?
The large issue is that search always returns no results. I have searched the posts the dashboard and that is able to return results but the non-admin always returns none. When I looked at the SQL query this was the query:
SELECT SQL_CALC_FOUND_ROWS tvr_posts.ID FROM tvr_posts WHERE 1=1 AND (0 = 1) ORDER BY tvr_posts.menu_order ASC LIMIT 0, 3
It never shows the search string and the 1=1 AND (0 = 1) seems like it would never show anything. Looking for alternate strategies to possible understand what is going on here.
Read more here:: Search has query that will return no results