No results!

Hi!

Very strange. Was there any change in the database name? Have you switched to a multisite installation by any chance?

I’ve tried to trigger ajax requests on your site with different parameters, but I still get no results, so I’m guessing it’s not related to the configuration. The request returns without any visible error, which is good.

I suppose there is an error generated in the query so the database returns no results. Could you please open up the wp-content/plugins/ajax-search-lite/includes/search_content.class.php file and go to line 255, where you should see this:

$pageposts = $wpdb->get_results($querystr, OBJECT);

Ok, now add these lines below that line:

var_dump($wpdb->last_error);
var_dump($querystr);
var_dump($pageposts);

It will actually change nothing on the output, but I will be able to see the executed query and an error (if any) on my browsers dev tools.

Let me know, and I will check it again.

Okays. The good news is that there is no error in the SQL query, it just simply doesn’t match any results, which means there is a configuration issue.

Based on the query,it looks like that one category or terms with the id “1” is excluded. Maybe the association post types fall under that category/term so they don’t match the pattern. Everything else looks okay.

I tried to send the request without category exclusions and I got back results, so it must be it: http://i.imgur.com/L2DNkgc.png

So if you “unexclude” the category on the search settings panel on the backend, the search should work again.

Indeed, there is nothing excluded. Then this must be a yet unknown bug.

I will investigate this further, but until then here is a quick solution for you:
Open up the plugins/ajax-search-pro/includes/search-content.class.php file and go to lines 181-187 where you should see this:

} else {
   $ex_cat = w_isset_def($searchData['selected-excludecategories'], array());
    if (count($ex_cat) > 0) {
        $words = '--'.implode('--|--', $ex_cat).'--';
        $term_query = "HAVING (ttid NOT REGEXP '$words')";
    }
}

Okay, now add this line below those lines (after line 187):
$term_query = "";

This will reset the excluded parts and should solve the issue temporary.