Forum Replies Created
- finalwebsitesParticipant2 years, 8 months ago in reply to: No products shown for product tag archives #27533
Hi,
I think we found the problem:
https://www.dropbox.com/s/nd8zw6360iy63j9/ZB_Selection_171.jpg?dl=0
Why do you have two options for the product tag?finalwebsitesParticipant2 years, 8 months ago in reply to: No products shown for product tag archives #27524Hi,
it might work in your simple demo application, but the product tags are missing inside the index while wpsolr says it’s indexed:https://www.dropbox.com/s/s11c9zdy32bpom6/Screenshot%20from%202021-08-18%2014-22-25.png?dl=0
https://www.dropbox.com/s/0s36h1mqc8qyomj/ZB_Selection_170.jpg?dl=0finalwebsitesParticipant2 years, 8 months ago in reply to: No products shown for product tag archives #27504Hi,
I did a complete re-index and still not results for any tag.Can you query manually your index with Kibana, to ensure that “product_tag_str” field contains “Piano Duet” for some of your products?
I checked the index via Kibana and it look like the field “producttags” is not included. The “Send your data” tab show the information “All Producttags are indexed.”
finalwebsitesParticipant2 years, 8 months ago in reply to: No products shown for product tag archives #27472Hi,
sorry that was not the right query log.
The query log for this URL https://123pianomuziek.nl/product-tag/piano-duet/ is:[13-Aug-2021 12:03:00 UTC] WPSOLR Log query => Url: "/product-tag/piano-duet/" Index: "123pianomuziek_index" Nb results shown: 0 Total nb results: 0 Speed: 403 ms Query: { "from": 0, "size": 20, "sort": [ { "menu_order_i": { "order": "desc" } }, { "date": { "order": "desc" } } ], "_source": [ "id", "PID", "type", "meta_type_s", "title", "numcomments", "comments", "displaydate", "displaymodified", "*categories_str", "author", "*post_thumbnail_href_str", "*post_href_str", "snippet_s" ], "query": { "bool": { "must": { "query_string": { "query": "text:(*)", "default_operator": "AND" } }, "filter": { "bool": { "must": [ { "terms": { "type": [ "product" ] } }, { "bool": { "must_not": [ { "terms": { "post_status_s": [ "draft", "pending", "trash", "future", "private", "auto-draft" ] } } ] } }, { "bool": { "must": { "term": { "product_tag_str": "Piano Duet" } } } }, { "bool": { "should": [ { "bool": { "must_not": [ { "exists": { "field": "product_visibility_str" } } ] } }, { "bool": { "must_not": [ { "terms": { "product_visibility_str": [ "exclude-from-catalog" ] } } ] } } ] } }, { "bool": { "should": [ { "bool": { "must_not": [ { "bool": { "must": { "exists": { "field": "is_excluded_s" } } } } ] } }, { "terms": { "is_excluded_s": [ "n" ] } } ] } }, { "bool": { "must_not": [ { "terms": { "_id": [ "wpsolr_doc_id_attachment" ] } } ] } } ] } } } }, "aggs": { "pa_arrangeur_str": { "filter": { "match_all": {} }, "aggs": { "pa_arrangeur_str": { "terms": { "field": "pa_arrangeur_str", "size": 20 } } } }, "pa_bezetting_str": { "filter": { "match_all": {} }, "aggs": { "pa_bezetting_str": { "terms": { "field": "pa_bezetting_str", "size": 20 } } } }, "pa_componist_str": { "filter": { "match_all": {} }, "aggs": { "pa_componist_str": { "terms": { "field": "pa_componist_str", "size": 20 } } } }, "pa_genre_str": { "filter": { "match_all": {} }, "aggs": { "pa_genre_str": { "terms": { "field": "pa_genre_str", "size": 20 } } } }, "pa_moeilijkheidsgraad_str": { "filter": { "match_all": {} }, "aggs": { "pa_moeilijkheidsgraad_str": { "terms": { "field": "pa_moeilijkheidsgraad_str", "size": 20 } } } }, "pa_periode_str": { "filter": { "match_all": {} }, "aggs": { "pa_periode_str": { "terms": { "field": "pa_periode_str", "size": 20 } } } }, "pa_series_str": { "filter": { "match_all": {} }, "aggs": { "pa_series_str": { "terms": { "field": "pa_series_str", "size": 20 } } } }, "pa_uitgever_str": { "filter": { "match_all": {} }, "aggs": { "pa_uitgever_str": { "terms": { "field": "pa_uitgever_str", "size": 20 } } } }, "pa_vorm_str": { "filter": { "match_all": {} }, "aggs": { "pa_vorm_str": { "terms": { "field": "pa_vorm_str", "size": 20 } } } } } } Results: { "took": 3, "timed_out": false, "_shards": { "total": 5, "successful": 5, "skipped": 0, "failed": 0 }, "hits": { "total": 0, "max_score": null, "hits": [] }, "aggregations": { "pa_uitgever_str": { "doc_count": 0, "pa_uitgever_str": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "pa_arrangeur_str": { "doc_count": 0, "pa_arrangeur_str": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "pa_periode_str": { "doc_count": 0, "pa_periode_str": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "pa_genre_str": { "doc_count": 0, "pa_genre_str": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "pa_bezetting_str": { "doc_count": 0, "pa_bezetting_str": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "pa_series_str": { "doc_count": 0, "pa_series_str": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "pa_componist_str": { "doc_count": 0, "pa_componist_str": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "pa_vorm_str": { "doc_count": 0, "pa_vorm_str": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "pa_moeilijkheidsgraad_str": { "doc_count": 0, "pa_moeilijkheidsgraad_str": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } } } }finalwebsitesParticipant2 years, 8 months ago in reply to: No products shown for product tag archives #27461Here is the query:
[10-Aug-2021 05:33:08 UTC] WPSOLR Log query =>
Url: “/componist/anouk/”
Index: “123pianomuziek_index”
Nb results shown: 2
Total nb results: 2
Speed: 839 ms
Query: {
“from”: 0,
“size”: 20,
…
“query”: {
…
{
“bool”: {
“must”: {
“term”: {
“pa_componist_str”: “Anouk”
}
}}….
finalwebsitesParticipant2 years, 8 months ago in reply to: No products shown for product tag archives #27459Nope, no error’s in the console and the debug log is empty.
Check by yourself https://123pianomuziek.nl/product/pop-hits-for-piano-duet-popular-songs-series/finalwebsitesParticipant3 years, 7 months ago in reply to: Suddenly Memory error after product search #22101I solved the problem already, not sure what was the reason 🙁
finalwebsitesParticipant3 years, 7 months ago in reply to: Error when indexing products #21880Okay I found the real reason which is from a bad import of the description. Characters likes here:
„Juwel der Gegenwart“finalwebsitesParticipant3 years, 7 months ago in reply to: Error when indexing products #21879Thanks for this, makes sense.
I did this and than I see this lind of errors:
“message”:”failed to parse field [displaydate_dt_i] of type [integer] in document with id ‘96090’”
Which post meta field is this?finalwebsitesParticipant3 years, 7 months ago in reply to: Error when indexing products #21872Thanks for the information. I think I’ve checked some products before, they looked very basic. For what kind of issues do I need to look with the products?
finalwebsitesParticipant3 years, 7 months ago in reply to: Error when indexing products #21869ooh, I’ve installed the patch and it doesn’t change the result.
finalwebsitesParticipant3 years, 7 months ago in reply to: Error when indexing products #21868Hi,
(I’m working for 123bladmuziek)
The issue is not related to PHP versions and it happens only for one of 3 websites.
What does that error mean?An error or timeout occured.
Error code: parsererror
Error message: SyntaxError: Unexpected token P in JSON at position 0Looks more like some invalid data. Any advice how to debug this? The debug data doesn’t give any useful information.
I tried also a new index, the index process just stops every time for the last ~13000 products. The first 27000 are okay.finalwebsitesParticipant3 years, 10 months ago in reply to: Define your search tab data 2.2 doesn't load #20264how to do that?
Hence the need to select them all and group them by key from wp_postmeta.
I see that it worked for a second site with similar numbers, it took some time right.
finalwebsitesParticipant3 years, 10 months ago in reply to: Define your search tab data 2.2 doesn't load #20262Define a lot 🙂
right now there are 5.3 million post meta records and 135K products.
Is there a limit?finalwebsitesParticipant4 years, 2 months ago in reply to: How to query the WPSOLR results in my theme? #16789You say that there is no way to select simply 5 products based on a search query from WPSOLR.
Just be some PHP code? Or using WP functions?
Please explain why the get_posts() function works this way in the YITH ajax search plugin.
I tried it and the function can search on custom field values which are only indexed by WPSOLR
