0 document(s) remain to be indexed

If you created a new Solr core, for an already indexed WP, you’ll get “0 document(s) remain to be indexed”

Click on “Empty the Solr index” to reset the WP indexed docs cursor.

New core for a new WordPress installation. eg. no exsisting index

What happens when clicking on “Empty the Solr index” ?

After clicking ’empty solr index’ and then clicking ‘index’ it just says ‘indexing’ followed by ‘stopping’. Nothing happens. No errors in the pluggin nor in the Solr installation

What about “xxx document(s) remain to be indexed” ?

Nothing….

Only:

A total of 0 documents are currently in your index
0 document(s) remain to be indexed

It gives me “0 documents indexed so far” right before changing to “Stopping… Please wait”

You need to debug line 687 of file class-wp-solr.php

$ids_array = $wpdb->get_results( $wpdb->prepare( $query, $lastPostDate ), ARRAY_A );

What’s in $query and $lastPostDate ?

This is what i get using the print_r function:

Query
SELECT count(ID) as TOTAL FROM wp_posts WHERE post_modified > %s AND ( ( post_status=’publish’ AND ( post_type=’post’ OR post_type=’page’ OR post_type=’tablepress_table’ ) ) OR ( ( post_status=’publish’ OR post_status=’inherit’ ) AND post_type=’attachment’ ) )

Last post date
2015-05-18 08:30:49

If you see count(ID), that means you debugged the page refresh, rather than the reindexing action.

Now, if you delete first, then re-index, you should see Last post date as ‘1000-01-01 00:00:00’

Try to execute the statement on your mysql. What do you see ?

Deleted and reindexed the the index with the print_r stil in the script. Now i am able to see an error:

An error or timeout occured.

Error code: parsererror

Error message: SyntaxError: JSON.parse: unexpected character at line 1 column 2 of the JSON data

Wil try to execute the query directly into MySql as you sugested

Either it’s JSON error to or from Solr.

From
What Solr version do you use (5.1 is not working)

To
Can you try without attachments ?

WPSOLR – Version: 2.6
Solr – Version: 4.10.2

Tried without attachments: Nothing changed.

Will try some more things

Hello,
Did you ever find a solution to this problem? I’m having a similar issue – no matter what I do I can’t delete an existing index.

When I manually delete the index, through Solr, create a new index, reinstall the plugin, reboot, etc…, WPSolr shows 0 documents in index, 0 documents to be indexed – even though I have 80K documents.

Also can’t display facets – do you have that problem too? ??

Rob

Nope sorry.. Ended up starting from scratch