0 documents in index and 0 remain to be indexed

Can you try to upgrade to WPSOLR 3.4 ?

Then, first delete your index data from WPSOLR admin. If errors occur, you should see them in the UI now.

After, try to re-index.

I upgraded to 3.4 – no change.

There is no index data to delete as it shows zero documents in the index:

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

did you delete the data from WPSOLR ?

What data are you talking about – and how to delete it?

Button “Empty the Solr index”

Yes – I’ve been doing that all along. There is no difference, no errors showing, with version 3.4. I click “empty the Solr index” and the page just reloads and still show the same:
A total of 0 documents are currently in your index
0 document(s) remain to be indexed

You’ll have to debug.

Please tell me what’s in $lastPostDate, class-wp-solr.php, just after line 615:

$lastPostDate = wp_Solr::get_hosting_option( 'solr_last_post_date_indexed', '1000-01-01 00:00:00' );

global $wpdb;

		// Last post date set in previous call. We begin with posts published after.
		$lastPostDate = wp_Solr::get_hosting_option( 'solr_last_post_date_indexed', '1000-01-01 00:00:00' );

		$tbl   = $wpdb->prefix . 'posts';
		$where = '';

		$client      = $this->client;
		$updateQuery = $client->createUpdate();
		// Get body of attachment
		$solarium_extract_query = $client->createExtract();

		$solr_indexing_options = get_option( 'wdm_solr_form_data' );

		$post_types = $solr_indexing_options['p_types'];
		$exclude_id = $solr_indexing_options['exclude_ids'];
		$ex_ids     = array();
		$ex_ids     = explode( ',', $exclude_id );
		$posts      = explode( ',', $post_types );

I need the content of $lastPostDate

Not sure exactly where to get that information…I posted lines 612-632. Is it different lines you need? Is what you need in the actual class-wp-solr.php file?

Try updating to WPSOLR 3.5. It integrates a debug mode to display stuff during indexing.

You’ll see $lastPostDate and the sql query which retrieves posts to be indexed.

Updated to 3.5, clicked the operations tab, checked “Display debug infos…”, ran the index – there was no information displayed. What you see below is exactly what I saw.

If you tell me where/how to get the sql query you need I’ll be glad to get it.

Solr Operations
A total of 0 documents are currently in your index
0	 document(s) remain to be indexed
The indexing is incremental: only documents updated after the last operation are sent to the index.

So, the first operation will index all documents, by batches of 100 documents.

If a timeout occurs, you just have to click on the button again: the process will restart from where it stopped.

If you need to reindex all again, delete the index first.

Number of documents sent in Solr as a single commit.
You can change this number to control indexing's performance.
Display debug infos during indexing

It looks like the (ajax) code behind the index button is not called.

What’s your browser and OS ?

And that would prevent it from seeing anything to be indexed? Because when this was working it showed documents in the index – but clicking “Empty the Solr Index” didn’t have an impact.

Is there a way to fix that?

I’m on a mac….Safari, Firefox, Chrome…I have a Windows server….let me log into that and try.