[Plugin: Relevanssi – A Better Search] Indexing 0 documents

In case this helps anyone with a similar problem…

My host had a setting on the server that limited the number of join rows. I had to add “SET SQL_BIG_SELECTS=1” before the indexing query. This was causing Relevanssi to report that indexing was complete with 0 documents in the index.

These changes fixed the problem:

(Relevanssi.php Line 2077)

$wpdb->query("TRUNCATE TABLE $relevanssi_table");
// BEGIN modified by renaissancehack
//  modified query to get child records that inherit their post_status
        $q = "SELECT *,parent.post_status as post_status
		FROM $wpdb->posts parent, $wpdb->posts post WHERE

to

$wpdb->query("TRUNCATE TABLE $relevanssi_table");
    $wpdb->query("SET SQL_BIG_SELECTS=1");
// BEGIN modified by renaissancehack
//  modified query to get child records that inherit their post_status
        $q = "SELECT *,parent.post_status as post_status
		FROM $wpdb->posts parent, $wpdb->posts post WHERE

and

(Line 2101)

if ($limit > 0) {
			$size = $limit;
			$limit = " LIMIT $limit";
		}
// BEGIN modified by renaissancehack
//  modified query to get child records that inherit their post_status
        $q = "SELECT *,parent.post_status as post_status
		FROM $wpdb->posts parent, $wpdb->posts post WHERE

to

if ($limit > 0) {
			$size = $limit;
			$limit = " LIMIT $limit";
		}
    $wpdb->query("SET SQL_BIG_SELECTS=1");
// BEGIN modified by renaissancehack
//  modified query to get child records that inherit their post_status
        $q = "SELECT *,parent.post_status as post_status
		FROM $wpdb->posts parent, $wpdb->posts post WHERE

http://wordpress.org/extend/plugins/relevanssi/