Database error when indexing

  • sraggio
    Participant
    # 2 months ago

    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
    Keymaster
    # 2 months ago

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

    sraggio
    Participant
    # 2 months ago

    Yes, tried that, but same error after reactivating.

    sraggio
    Participant
    # 2 months ago

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

    wpsolr
    Keymaster
    # 2 months ago

    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.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.