[Hischier]

1 year, 11 months ago in reply to: We have 2.8 Million Products in WordPress, but WPSolr recognizes only 370,000 #46408

Error is:

An error occured:

failed to parse field [categories] of type [text] in document with id ‘40458877297’. Preview of field’s value: ‘{is_visible=1, name=pa_netzbreite-mm, is_variation=0, position=0, is_taxonomy=1, value=, checkout_visible=}’

[Hischier]

1 year, 11 months ago in reply to: We have 2.8 Million Products in WordPress, but WPSolr recognizes only 370,000 #46407

Import works from scratch until to 7413 documents, after that I get the error.

[Hischier]

1 year, 11 months ago in reply to: We have 2.8 Million Products in WordPress, but WPSolr recognizes only 370,000 #46406

I am getting only errors on indexing, I have the batch set to 1, but still errors:

n error or timeout occured.

Error code: parsererror

Error message: SyntaxError: JSON Parse error: Unexpected identifier “Posts”

Posts excluded from the index:<br><b></b><br><br>******** DEBUG ACTIVATED – Beginning of new loop (batch size) *******<br><br>******** DEBUG ACTIVATED – Query documents from last post date *******<br><br>Query:<br><b>SELECT ID, post_modified, post_parent, post_type FROM kbp8_posts AS A WHERE ((post_modified = '2024-04-02 12:14:12' AND ID > 40461293305) OR (post_modified > '2024-04-02 12:14:12')) AND ( post_status IN ('publish') AND ( post_type = 'product' ) ) ORDER BY post_modified ASC, ID ASC LIMIT 1</b><br><br>Last post date:<br><b>2024-04-02 12:14:12</b><br><br>Last post ID:<br><b>40461293305</b><br><br>Post to be

[Hischier]

1 year, 11 months ago in reply to: We have 2.8 Million Products in WordPress, but WPSolr recognizes only 370,000 #46405

I have send you by e-mail.

[Hischier]

1 year, 11 months ago in reply to: We have 2.8 Million Products in WordPress, but WPSolr recognizes only 370,000 #46402

It’s ok, we can do that on the live site, thats no problem and better for us. I have daily backups too.

[Hischier]

1 year, 11 months ago in reply to: We have 2.8 Million Products in WordPress, but WPSolr recognizes only 370,000 #46401

I have fixed the problem with not all products are in wpsolr index.

I have on sql set all post_modified dates with the date from post_date.

[Hischier]

1 year, 11 months ago in reply to: We have 2.8 Million Products in WordPress, but WPSolr recognizes only 370,000 #46399

I have deselected the category so that our clients can search and order.

[Hischier]

1 year, 11 months ago in reply to: We have 2.8 Million Products in WordPress, but WPSolr recognizes only 370,000 #46398

Without the wpsolr facet widget we get same issue, no dynamic category site.
I have cleaned all caches (browser and WordPress)

[Hischier]

1 year, 11 months ago in reply to: We have 2.8 Million Products in WordPress, but WPSolr recognizes only 370,000 #46397

Is that a problem when products have post_modified 0000-00-00 00:00:00 ? I think so what I have see are all products with post_modified 0000-00-00 00:00:00 not on the index list of wpsolr.

359909 Products are in the index list of wpsolr and all these products have a correct modified date.

[Hischier]

1 year, 11 months ago in reply to: We have 2.8 Million Products in WordPress, but WPSolr recognizes only 370,000 #46392

I have now reactivate (selected category in wpsolr search)

[Hischier]

1 year, 11 months ago in reply to: We have 2.8 Million Products in WordPress, but WPSolr recognizes only 370,000 #46391

And I can not more products indexing now as 7315, I get an parseerror.

See both pictures

[Hischier]

1 year, 11 months ago in reply to: We have 2.8 Million Products in WordPress, but WPSolr recognizes only 370,000 #46389

I have checked in phpmyadmin in the post database -> Product and it shows me 2.8 Million Products, in WordPress product page too.

I have made a picture of WPSOLR debug and phpmyadmin.

Regards Roman

[Hischier]

1 year, 11 months ago in reply to: We have 2.8 Million Products in WordPress, but WPSolr recognizes only 370,000 #46385

As you have see in the zoom meeting, our clients can select their car like BMW x3 etc. After that normaly it comes our dynamic generated Categorys site wich our clients can click on the categories they need like Brake Disk for their car. But after i select category on WPSOLR (define you’re search), our dynamic category site will not showing, it goes directly to a product list.

Regards

Roman