[sraggio]

3 years, 9 months ago #13729

In tab 3 Send your data: When creating first index, using Woocommerce extension, getting the error below when indexing. I started with 100 documents, then 50, 20 and 5 — it appears to add the selected number of documents to the index, as the number of total documents indexed does increase by the specified number when I manually click to stop indexing.

An error or timeout occured.

Error code: parsererror

Error message: SyntaxError: Unexpected token < in JSON at position 0

<div id=”error”><p class=”wpdberror”>WordPress database error: [Table 'broinc5_wpwoo.wp_wpsolr_index_history' doesn't exist]<br />delete from wp_wpsolr_index_history where model_id IN ('16063', '16064', '16065', '16066', '16067')</p></div>{“models_nb_results”:{“product”:5,”product_variation”:0},”nb_results”:5,”status”:0,”indexing_complete”:false,”debug_text”:null}

[wpsolr]

3 years, 9 months ago #13730

It appears a table was not created. Can you try to deactivate, then reactivate the WPSOLR plugin?

[sraggio]

3 years, 9 months ago #13731

Yes, tried that, but same error after reactivating.

[sraggio]

3 years, 9 months ago #13732

Delete plugin and re-install? Or possible to manually create the table?

[wpsolr]

3 years, 9 months ago #13734

Here is a fix for the missing table:
https://www.dropbox.com/s/vmybvqefznbo2jx/wpsolr-pro-fix-missing-history-table.zip?dl=0

Just remove WPSOLR, and install the fix instead.