Not able to index product category and orders not showing in woocommerce

  • aman61087
    Participant
    8 months, 3 weeks ago #35231

    Hi Team,
    I am using Apache wpsolr for the last few years and it was working fine, recently we just tried to upgrade the Solr version from 22 to 23 and it’s just stopped indexing. whenever I am trying to index getting the following error.

    Server configuration
    LiteSpeed V8.1
    PHP Version 8.1.18
    Wordpress 6.2.2

    I tried PHP 7.4 and apache server also but same error

    An error occured:

    Solr HTTP error: Bad Request (400) { “responseHeader”:{ “status”:400, “QTime”:4}, “error”:{ “metadata”:[ “error-class”,”org.apache.solr.common.SolrException”, “root-error-class”,”org.apache.solr.common.SolrException”], “msg”:”ERROR: [doc=product_cat_543] Error adding field ‘displaymodified’=’false’ msg=Invalid Date String:’false'”, “code”:400}}

    error screen shot

    wpsolr
    Keymaster
    8 months, 3 weeks ago #35232

    Sorry for that, but we had a major Solr schema update in the past.
    You’ll need to create and use a new Solr index.

    aman61087
    Participant
    8 months, 2 weeks ago #35239

    Yes, I have created it. even I use the fresh server to do this. you can see in the screenshot everything is indexed only the product category is giving an error. you can see in the attached screenshot.

    image-2023-07-28-T13-49-17-988-Z

    image-2023-07-28-T13-49-17-988-Z

    wpsolr
    Keymaster
    8 months, 2 weeks ago #35240

    (As a quick fix, you could stop indexing taxonomies as standalone documents: they are used only on suggestions, to show with products)

    Concerning your issue, which Apache Solr version is it? (for information, we support only 9.x)

    aman61087
    Participant
    8 months, 2 weeks ago #35243

    I am using ubuntu 22.04
    Open LiteSpeed V8.1
    PHP Version 8.1.18
    Wordpress 6.2.2
    Apache solr version 8.6.0
    Plugin wpsolr Pro 23.3

    aman61087
    Participant
    8 months, 2 weeks ago #35244

    I just tried with the following configuration and all products and categories are indexed but now orders are not showing me in wooCommerce please check the screenshot. You can see what I selected in tab 2.2 Data.
    ubuntu 22.04
    Open LiteSpeed V8.1
    PHP Version 8.1.18
    Wordpress 6.2.2
    Apache Solr version 9.3.0
    Plugin wpsolr Pro 23.3

    Fire-Shot-Capture-078-WPSOLR-PRO-Online-Pound-Store-Word-Press-www-opstest-uk

    wpsolr
    Keymaster
    8 months, 2 weeks ago #35251

    In screen 2.1, use option “Replace admin archives” to use WPSOLR in your admin (orders, products, …)

    aman61087
    Participant
    8 months, 2 weeks ago #35252

    Screenshot-1

    after selecting Replace admin archives get this error on the order page.

    • This reply was modified 8 months, 2 weeks ago by aman61087.
    wpsolr
    Keymaster
    8 months, 2 weeks ago #35254

    “Neither collection nor core set”: it looks like a Solr problem. Do you use the same Solr index for backend configuration?

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

You must be logged in to reply to this topic.