search

10up / ElasticPress

A fast and flexible search and query engine for WordPress.
https://elasticpress.io
GNU General Public License v2.0
1.24k stars 312 forks source link

BUG: Elasticpress breaks my default listings of blog posts on front end and wp-admin #3888

Closed gosixl closed 4 months ago

gosixl commented 5 months ago

Describe the bug

I have 24 blog posts, when elasticpress is active, it lists 1. In my wp-admin > posts area it'll say I have 24, but only 1 will actually render in the table.

When I reviewed my wp-queries with elasticpress on and off - the difference in the "request" keys is as follows: No ES: "SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC LIMIT 0, 10 "

ES: "SELECT wp_posts.*\n\t\t\t FROM wp_posts \n\t\t\t WHERE 1=1 AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish'))\n\t\t\t \n\t\t\t ORDER BY wp_posts.post_date DESC\n\t\t\t LIMIT

The breaking factor is whether elasticpress is active or not. I am sure it is not my code as changing themes has no effect.

Does anyone know how I can resolve this?

Steps to Reproduce

I'm not sure what lead to this, I mainly use elasticsearch for products not blog posts.. maybe there is a way to make ES not work for posts?

Screenshots, screen recording, code snippet

No response

Environment information

Live site (fluf.io/journal) - running on cloudways server.

WordPress and ElasticPress information

Failed Queries

https://fluf.io/tag/boris-johnson (2024-04-04 01:29:49)

error: No mapping found for [meta._elementor_priority.long] in order to sort on recommended_solution: The field meta._elementor_priority.long was not found. Make sure it is added to the list of indexed fields and run a new sync to fix the issue. es_req: POST http://127.0.0.1:9200/flufio-post-1/_search request_id: ec93a6b0450246dab16e59b4a19be7b6 query_time: 4.5211315155029 wp_args: array ( 'numberposts' => -1, 'category' => 0, 'orderby' => 'meta_value_num', 'order' => 'ASC', 'include' => array ( ), 'exclude' => array ( ), 'meta_key' => '_elementor_priority', 'meta_value' => '', 'post_type' => 'elementor_snippet', 'suppress_filters' => true, 'meta_query' => array ( 0 => array ( 'key' => '_elementor_location', 'value' => 'elementor_body_end', ), ), 'post_status' => 'publish', 'posts_per_page' => -1, 'ignore_sticky_posts' => true, 'no_found_rows' => true, 'error' => '', 'm' => '', 'p' => 0, 'post_parent' => '', 'subpost' => '', 'subpost_id' => '', 'attachment' => '', 'attachment_id' => 0, 'name' => '', 'pagename' => '', 'page_id' => 0, 'second' => '', 'minute' => '', 'hour' => '', 'day' => 0, 'monthnum' => 0, 'year' => 0, 'w' => 0, 'category_name' => '', 'tag' => '', 'cat' => '', 'tag_id' => '', 'author' => '', 'author_name' => '', 'feed' => '', 'tb' => '', 'paged' => 0, 'preview' => '', 's' => '', 'sentence' => '', 'title' => '', 'fields' => '', 'menu_order' => '', 'embed' => '', 'categoryin' => array ( ), 'categorynot_in' => array ( ), 'categoryand' => array ( ), 'postin' => array ( ), 'postnot_in' => array ( ), 'post_namein' => array ( ), 'tagin' => array ( ), 'tagnot_in' => array ( ), 'tagand' => array ( ), 'tag_slug__in' => array ( ), 'tag_slugand' => array ( ), 'post_parentin' => array ( ), 'post_parent__not_in' => array ( ), 'authorin' => array ( ), 'author__not_in' => array ( ), 'search_columns' => array ( ), 'ep_integrate' => true, 'ep_facet' => true, 'aggs' => array ( 'name' => 'terms', 'use-filter' => true, 'aggs' => array ( 'category' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.category.slug', ), ), 'post_tag' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.post_tag.slug', ), ), 'product_cat' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.product_cat.slug', ), ), 'product_tag' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.product_tag.slug', ), ), 'pa_brand' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_brand.slug', ), ), 'pa_colours' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_colours.slug', ), ), 'pa_condition' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_condition.slug', ), ), 'pa_department' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_department.slug', ), ), 'pa_size' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_size.slug', ), ), 'post_type' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'post_type.raw', ), ), ), ), 'cache_results' => true, 'update_post_term_cache' => true, 'update_menu_item_cache' => false, 'lazy_load_term_meta' => true, 'update_post_meta_cache' => true, 'nopaging' => true, 'comments_per_page' => '20', ) status_code: 400 body: {"from":0,"size":10000,"post_filter":{"bool":{"must":[{"bool":{"must":[{"exists":{"field":"meta._elementor_priority"}},{"bool":{"should":{"bool":{"should":[{"terms":{"meta._elementor_location.raw":["elementor_body_end"]}}]}}}}]}},{"terms":{"post_type.raw":["elementor_snippet"]}},{"term":{"post_status":"publish"}}]}},"query":{"match_all":{"boost":1}},"sort":[{"meta._elementor_priority.long":{"order":"asc"}}],"aggs":{"terms":{"filter":{"bool":{"must":[{"bool":{"must":[{"exists":{"field":"meta._elementor_priority"}},{"bool":{"should":{"bool":{"should":[{"terms":{"meta._elementor_location.raw":["elementor_body_end"]}}]}}}}]}},{"terms":{"post_type.raw":["elementor_snippet"]}},{"term":{"post_status":"publish"}}]}},"aggs":{"category":{"terms":{"size":10000,"field":"terms.category.slug"}},"post_tag":{"terms":{"size":10000,"field":"terms.post_tag.slug"}},"product_cat":{"terms":{"size":10000,"field":"terms.product_cat.slug"}},"product_tag":{"terms":{"size":10000,"field":"terms.product_tag.slug"}},"pa_brand":{"terms":{"size":10000,"field":"terms.pa_brand.slug"}},"pa_colours":{"terms":{"size":10000,"field":"terms.pa_colours.slug"}},"pa_condition":{"terms":{"size":10000,"field":"terms.pa_condition.slug"}},"pa_department":{"terms":{"size":10000,"field":"terms.pa_department.slug"}},"pa_size":{"terms":{"size":10000,"field":"terms.pa_size.slug"}},"post_type":{"terms":{"size":10000,"field":"post_type.raw"}}}}}} result: array ( 'error' => array ( 'root_cause' => array ( 0 => array ( 'type' => 'query_shard_exception', 'reason' => 'No mapping found for [meta._elementor_priority.long] in order to sort on', 'index_uuid' => 'KhWqXdYhTN-ypPfRE_lIRg', 'index' => 'flufio-post-1', ), ), 'type' => 'search_phase_execution_exception', 'reason' => 'all shards failed', 'phase' => 'query', 'grouped' => true, 'failed_shards' => array ( 0 => array ( 'shard' => 0, 'index' => 'flufio-post-1', 'node' => 'rmRUCZebTTGdayUJG73AMg', 'reason' => array ( 'type' => 'query_shard_exception', 'reason' => 'No mapping found for [meta._elementor_priority.long] in order to sort on', 'index_uuid' => 'KhWqXdYhTN-ypPfRE_lIRg', 'index' => 'flufio-post-1', ), ), ), ), 'status' => 400, )

https://fluf.io/catalogue/jordan-4-metallic-red-uk9?add-to-cart=52502 (2024-04-04 01:29:47)

error: No mapping found for [meta._elementor_priority.long] in order to sort on recommended_solution: The field meta._elementor_priority.long was not found. Make sure it is added to the list of indexed fields and run a new sync to fix the issue. es_req: POST http://127.0.0.1:9200/flufio-post-1/_search request_id: 720fc738283b4ab19c540322ed5c6d75 query_time: 4.9111843109131 wp_args: array ( 'numberposts' => -1, 'category' => 0, 'orderby' => 'meta_value_num', 'order' => 'ASC', 'include' => array ( ), 'exclude' => array ( ), 'meta_key' => '_elementor_priority', 'meta_value' => '', 'post_type' => 'elementor_snippet', 'suppress_filters' => true, 'meta_query' => array ( 0 => array ( 'key' => '_elementor_location', 'value' => 'elementor_body_end', ), ), 'post_status' => 'publish', 'posts_per_page' => -1, 'ignore_sticky_posts' => true, 'no_found_rows' => true, 'error' => '', 'm' => '', 'p' => 0, 'post_parent' => '', 'subpost' => '', 'subpost_id' => '', 'attachment' => '', 'attachment_id' => 0, 'name' => '', 'pagename' => '', 'page_id' => 0, 'second' => '', 'minute' => '', 'hour' => '', 'day' => 0, 'monthnum' => 0, 'year' => 0, 'w' => 0, 'category_name' => '', 'tag' => '', 'cat' => '', 'tag_id' => '', 'author' => '', 'author_name' => '', 'feed' => '', 'tb' => '', 'paged' => 0, 'preview' => '', 's' => '', 'sentence' => '', 'title' => '', 'fields' => '', 'menu_order' => '', 'embed' => '', 'categoryin' => array ( ), 'categorynot_in' => array ( ), 'categoryand' => array ( ), 'postin' => array ( ), 'postnot_in' => array ( ), 'post_namein' => array ( ), 'tagin' => array ( ), 'tagnot_in' => array ( ), 'tagand' => array ( ), 'tag_slug__in' => array ( ), 'tag_slugand' => array ( ), 'post_parentin' => array ( ), 'post_parent__not_in' => array ( ), 'authorin' => array ( ), 'author__not_in' => array ( ), 'search_columns' => array ( ), 'ep_integrate' => true, 'ep_facet' => true, 'aggs' => array ( 'name' => 'terms', 'use-filter' => true, 'aggs' => array ( 'category' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.category.slug', ), ), 'post_tag' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.post_tag.slug', ), ), 'product_cat' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.product_cat.slug', ), ), 'product_tag' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.product_tag.slug', ), ), 'pa_brand' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_brand.slug', ), ), 'pa_colours' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_colours.slug', ), ), 'pa_condition' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_condition.slug', ), ), 'pa_department' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_department.slug', ), ), 'pa_size' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_size.slug', ), ), 'post_type' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'post_type.raw', ), ), ), ), 'cache_results' => true, 'update_post_term_cache' => true, 'update_menu_item_cache' => false, 'lazy_load_term_meta' => true, 'update_post_meta_cache' => true, 'nopaging' => true, 'comments_per_page' => '20', ) status_code: 400 body: {"from":0,"size":10000,"post_filter":{"bool":{"must":[{"bool":{"must":[{"exists":{"field":"meta._elementor_priority"}},{"bool":{"should":{"bool":{"should":[{"terms":{"meta._elementor_location.raw":["elementor_body_end"]}}]}}}}]}},{"terms":{"post_type.raw":["elementor_snippet"]}},{"term":{"post_status":"publish"}}]}},"query":{"match_all":{"boost":1}},"sort":[{"meta._elementor_priority.long":{"order":"asc"}}],"aggs":{"terms":{"filter":{"bool":{"must":[{"bool":{"must":[{"exists":{"field":"meta._elementor_priority"}},{"bool":{"should":{"bool":{"should":[{"terms":{"meta._elementor_location.raw":["elementor_body_end"]}}]}}}}]}},{"terms":{"post_type.raw":["elementor_snippet"]}},{"term":{"post_status":"publish"}}]}},"aggs":{"category":{"terms":{"size":10000,"field":"terms.category.slug"}},"post_tag":{"terms":{"size":10000,"field":"terms.post_tag.slug"}},"product_cat":{"terms":{"size":10000,"field":"terms.product_cat.slug"}},"product_tag":{"terms":{"size":10000,"field":"terms.product_tag.slug"}},"pa_brand":{"terms":{"size":10000,"field":"terms.pa_brand.slug"}},"pa_colours":{"terms":{"size":10000,"field":"terms.pa_colours.slug"}},"pa_condition":{"terms":{"size":10000,"field":"terms.pa_condition.slug"}},"pa_department":{"terms":{"size":10000,"field":"terms.pa_department.slug"}},"pa_size":{"terms":{"size":10000,"field":"terms.pa_size.slug"}},"post_type":{"terms":{"size":10000,"field":"post_type.raw"}}}}}} result: array ( 'error' => array ( 'root_cause' => array ( 0 => array ( 'type' => 'query_shard_exception', 'reason' => 'No mapping found for [meta._elementor_priority.long] in order to sort on', 'index_uuid' => 'KhWqXdYhTN-ypPfRE_lIRg', 'index' => 'flufio-post-1', ), ), 'type' => 'search_phase_execution_exception', 'reason' => 'all shards failed', 'phase' => 'query', 'grouped' => true, 'failed_shards' => array ( 0 => array ( 'shard' => 0, 'index' => 'flufio-post-1', 'node' => 'rmRUCZebTTGdayUJG73AMg', 'reason' => array ( 'type' => 'query_shard_exception', 'reason' => 'No mapping found for [meta._elementor_priority.long] in order to sort on', 'index_uuid' => 'KhWqXdYhTN-ypPfRE_lIRg', 'index' => 'flufio-post-1', ), ), ), ), 'status' => 400, )

https://fluf.io/tag/rishi-sunak (2024-04-04 01:29:31)

error: No mapping found for [meta._elementor_priority.long] in order to sort on recommended_solution: The field meta._elementor_priority.long was not found. Make sure it is added to the list of indexed fields and run a new sync to fix the issue. es_req: POST http://127.0.0.1:9200/flufio-post-1/_search request_id: 4af3805a5f1a435fab0b3671af5577e1 query_time: 4.1251182556152 wp_args: array ( 'numberposts' => -1, 'category' => 0, 'orderby' => 'meta_value_num', 'order' => 'ASC', 'include' => array ( ), 'exclude' => array ( ), 'meta_key' => '_elementor_priority', 'meta_value' => '', 'post_type' => 'elementor_snippet', 'suppress_filters' => true, 'meta_query' => array ( 0 => array ( 'key' => '_elementor_location', 'value' => 'elementor_body_end', ), ), 'post_status' => 'publish', 'posts_per_page' => -1, 'ignore_sticky_posts' => true, 'no_found_rows' => true, 'error' => '', 'm' => '', 'p' => 0, 'post_parent' => '', 'subpost' => '', 'subpost_id' => '', 'attachment' => '', 'attachment_id' => 0, 'name' => '', 'pagename' => '', 'page_id' => 0, 'second' => '', 'minute' => '', 'hour' => '', 'day' => 0, 'monthnum' => 0, 'year' => 0, 'w' => 0, 'category_name' => '', 'tag' => '', 'cat' => '', 'tag_id' => '', 'author' => '', 'author_name' => '', 'feed' => '', 'tb' => '', 'paged' => 0, 'preview' => '', 's' => '', 'sentence' => '', 'title' => '', 'fields' => '', 'menu_order' => '', 'embed' => '', 'categoryin' => array ( ), 'categorynot_in' => array ( ), 'categoryand' => array ( ), 'postin' => array ( ), 'postnot_in' => array ( ), 'post_namein' => array ( ), 'tagin' => array ( ), 'tagnot_in' => array ( ), 'tagand' => array ( ), 'tag_slug__in' => array ( ), 'tag_slugand' => array ( ), 'post_parentin' => array ( ), 'post_parent__not_in' => array ( ), 'authorin' => array ( ), 'author__not_in' => array ( ), 'search_columns' => array ( ), 'ep_integrate' => true, 'ep_facet' => true, 'aggs' => array ( 'name' => 'terms', 'use-filter' => true, 'aggs' => array ( 'category' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.category.slug', ), ), 'post_tag' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.post_tag.slug', ), ), 'product_cat' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.product_cat.slug', ), ), 'product_tag' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.product_tag.slug', ), ), 'pa_brand' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_brand.slug', ), ), 'pa_colours' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_colours.slug', ), ), 'pa_condition' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_condition.slug', ), ), 'pa_department' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_department.slug', ), ), 'pa_size' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_size.slug', ), ), 'post_type' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'post_type.raw', ), ), ), ), 'cache_results' => true, 'update_post_term_cache' => true, 'update_menu_item_cache' => false, 'lazy_load_term_meta' => true, 'update_post_meta_cache' => true, 'nopaging' => true, 'comments_per_page' => '20', ) status_code: 400 body: {"from":0,"size":10000,"post_filter":{"bool":{"must":[{"bool":{"must":[{"exists":{"field":"meta._elementor_priority"}},{"bool":{"should":{"bool":{"should":[{"terms":{"meta._elementor_location.raw":["elementor_body_end"]}}]}}}}]}},{"terms":{"post_type.raw":["elementor_snippet"]}},{"term":{"post_status":"publish"}}]}},"query":{"match_all":{"boost":1}},"sort":[{"meta._elementor_priority.long":{"order":"asc"}}],"aggs":{"terms":{"filter":{"bool":{"must":[{"bool":{"must":[{"exists":{"field":"meta._elementor_priority"}},{"bool":{"should":{"bool":{"should":[{"terms":{"meta._elementor_location.raw":["elementor_body_end"]}}]}}}}]}},{"terms":{"post_type.raw":["elementor_snippet"]}},{"term":{"post_status":"publish"}}]}},"aggs":{"category":{"terms":{"size":10000,"field":"terms.category.slug"}},"post_tag":{"terms":{"size":10000,"field":"terms.post_tag.slug"}},"product_cat":{"terms":{"size":10000,"field":"terms.product_cat.slug"}},"product_tag":{"terms":{"size":10000,"field":"terms.product_tag.slug"}},"pa_brand":{"terms":{"size":10000,"field":"terms.pa_brand.slug"}},"pa_colours":{"terms":{"size":10000,"field":"terms.pa_colours.slug"}},"pa_condition":{"terms":{"size":10000,"field":"terms.pa_condition.slug"}},"pa_department":{"terms":{"size":10000,"field":"terms.pa_department.slug"}},"pa_size":{"terms":{"size":10000,"field":"terms.pa_size.slug"}},"post_type":{"terms":{"size":10000,"field":"post_type.raw"}}}}}} result: array ( 'error' => array ( 'root_cause' => array ( 0 => array ( 'type' => 'query_shard_exception', 'reason' => 'No mapping found for [meta._elementor_priority.long] in order to sort on', 'index_uuid' => 'KhWqXdYhTN-ypPfRE_lIRg', 'index' => 'flufio-post-1', ), ), 'type' => 'search_phase_execution_exception', 'reason' => 'all shards failed', 'phase' => 'query', 'grouped' => true, 'failed_shards' => array ( 0 => array ( 'shard' => 0, 'index' => 'flufio-post-1', 'node' => 'rmRUCZebTTGdayUJG73AMg', 'reason' => array ( 'type' => 'query_shard_exception', 'reason' => 'No mapping found for [meta._elementor_priority.long] in order to sort on', 'index_uuid' => 'KhWqXdYhTN-ypPfRE_lIRg', 'index' => 'flufio-post-1', ), ), ), ), 'status' => 400, )

https://fluf.io/tag/star-bursts (2024-04-04 01:29:26)

error: No mapping found for [meta._elementor_priority.long] in order to sort on recommended_solution: The field meta._elementor_priority.long was not found. Make sure it is added to the list of indexed fields and run a new sync to fix the issue. es_req: POST http://127.0.0.1:9200/flufio-post-1/_search request_id: 24457fa864724eb7b36050c4f3eaa200 query_time: 4.490852355957 wp_args: array ( 'numberposts' => -1, 'category' => 0, 'orderby' => 'meta_value_num', 'order' => 'ASC', 'include' => array ( ), 'exclude' => array ( ), 'meta_key' => '_elementor_priority', 'meta_value' => '', 'post_type' => 'elementor_snippet', 'suppress_filters' => true, 'meta_query' => array ( 0 => array ( 'key' => '_elementor_location', 'value' => 'elementor_body_end', ), ), 'post_status' => 'publish', 'posts_per_page' => -1, 'ignore_sticky_posts' => true, 'no_found_rows' => true, 'error' => '', 'm' => '', 'p' => 0, 'post_parent' => '', 'subpost' => '', 'subpost_id' => '', 'attachment' => '', 'attachment_id' => 0, 'name' => '', 'pagename' => '', 'page_id' => 0, 'second' => '', 'minute' => '', 'hour' => '', 'day' => 0, 'monthnum' => 0, 'year' => 0, 'w' => 0, 'category_name' => '', 'tag' => '', 'cat' => '', 'tag_id' => '', 'author' => '', 'author_name' => '', 'feed' => '', 'tb' => '', 'paged' => 0, 'preview' => '', 's' => '', 'sentence' => '', 'title' => '', 'fields' => '', 'menu_order' => '', 'embed' => '', 'categoryin' => array ( ), 'categorynot_in' => array ( ), 'categoryand' => array ( ), 'postin' => array ( ), 'postnot_in' => array ( ), 'post_namein' => array ( ), 'tagin' => array ( ), 'tagnot_in' => array ( ), 'tagand' => array ( ), 'tag_slug__in' => array ( ), 'tag_slugand' => array ( ), 'post_parentin' => array ( ), 'post_parent__not_in' => array ( ), 'authorin' => array ( ), 'author__not_in' => array ( ), 'search_columns' => array ( ), 'ep_integrate' => true, 'ep_facet' => true, 'aggs' => array ( 'name' => 'terms', 'use-filter' => true, 'aggs' => array ( 'category' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.category.slug', ), ), 'post_tag' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.post_tag.slug', ), ), 'product_cat' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.product_cat.slug', ), ), 'product_tag' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.product_tag.slug', ), ), 'pa_brand' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_brand.slug', ), ), 'pa_colours' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_colours.slug', ), ), 'pa_condition' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_condition.slug', ), ), 'pa_department' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_department.slug', ), ), 'pa_size' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_size.slug', ), ), 'post_type' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'post_type.raw', ), ), ), ), 'cache_results' => true, 'update_post_term_cache' => true, 'update_menu_item_cache' => false, 'lazy_load_term_meta' => true, 'update_post_meta_cache' => true, 'nopaging' => true, 'comments_per_page' => '20', ) status_code: 400 body: {"from":0,"size":10000,"post_filter":{"bool":{"must":[{"bool":{"must":[{"exists":{"field":"meta._elementor_priority"}},{"bool":{"should":{"bool":{"should":[{"terms":{"meta._elementor_location.raw":["elementor_body_end"]}}]}}}}]}},{"terms":{"post_type.raw":["elementor_snippet"]}},{"term":{"post_status":"publish"}}]}},"query":{"match_all":{"boost":1}},"sort":[{"meta._elementor_priority.long":{"order":"asc"}}],"aggs":{"terms":{"filter":{"bool":{"must":[{"bool":{"must":[{"exists":{"field":"meta._elementor_priority"}},{"bool":{"should":{"bool":{"should":[{"terms":{"meta._elementor_location.raw":["elementor_body_end"]}}]}}}}]}},{"terms":{"post_type.raw":["elementor_snippet"]}},{"term":{"post_status":"publish"}}]}},"aggs":{"category":{"terms":{"size":10000,"field":"terms.category.slug"}},"post_tag":{"terms":{"size":10000,"field":"terms.post_tag.slug"}},"product_cat":{"terms":{"size":10000,"field":"terms.product_cat.slug"}},"product_tag":{"terms":{"size":10000,"field":"terms.product_tag.slug"}},"pa_brand":{"terms":{"size":10000,"field":"terms.pa_brand.slug"}},"pa_colours":{"terms":{"size":10000,"field":"terms.pa_colours.slug"}},"pa_condition":{"terms":{"size":10000,"field":"terms.pa_condition.slug"}},"pa_department":{"terms":{"size":10000,"field":"terms.pa_department.slug"}},"pa_size":{"terms":{"size":10000,"field":"terms.pa_size.slug"}},"post_type":{"terms":{"size":10000,"field":"post_type.raw"}}}}}} result: array ( 'error' => array ( 'root_cause' => array ( 0 => array ( 'type' => 'query_shard_exception', 'reason' => 'No mapping found for [meta._elementor_priority.long] in order to sort on', 'index_uuid' => 'KhWqXdYhTN-ypPfRE_lIRg', 'index' => 'flufio-post-1', ), ), 'type' => 'search_phase_execution_exception', 'reason' => 'all shards failed', 'phase' => 'query', 'grouped' => true, 'failed_shards' => array ( 0 => array ( 'shard' => 0, 'index' => 'flufio-post-1', 'node' => 'rmRUCZebTTGdayUJG73AMg', 'reason' => array ( 'type' => 'query_shard_exception', 'reason' => 'No mapping found for [meta._elementor_priority.long] in order to sort on', 'index_uuid' => 'KhWqXdYhTN-ypPfRE_lIRg', 'index' => 'flufio-post-1', ), ), ), ), 'status' => 400, )

https://fluf.io/catalogue/jojo-maman-bb-girls-blue-basic-t-shirt-size-2-3-years-swim-top-unicorn (2024-04-04 01:29:13)

error: No mapping found for [meta._elementor_priority.long] in order to sort on recommended_solution: The field meta._elementor_priority.long was not found. Make sure it is added to the list of indexed fields and run a new sync to fix the issue. es_req: POST http://127.0.0.1:9200/flufio-post-1/_search request_id: 96ff9b05f33c4d67afd0cbe3750d05d4 query_time: 6.1051845550537 wp_args: array ( 'numberposts' => -1, 'category' => 0, 'orderby' => 'meta_value_num', 'order' => 'ASC', 'include' => array ( ), 'exclude' => array ( ), 'meta_key' => '_elementor_priority', 'meta_value' => '', 'post_type' => 'elementor_snippet', 'suppress_filters' => true, 'meta_query' => array ( 0 => array ( 'key' => '_elementor_location', 'value' => 'elementor_body_end', ), ), 'post_status' => 'publish', 'posts_per_page' => -1, 'ignore_sticky_posts' => true, 'no_found_rows' => true, 'error' => '', 'm' => '', 'p' => 0, 'post_parent' => '', 'subpost' => '', 'subpost_id' => '', 'attachment' => '', 'attachment_id' => 0, 'name' => '', 'pagename' => '', 'page_id' => 0, 'second' => '', 'minute' => '', 'hour' => '', 'day' => 0, 'monthnum' => 0, 'year' => 0, 'w' => 0, 'category_name' => '', 'tag' => '', 'cat' => '', 'tag_id' => '', 'author' => '', 'author_name' => '', 'feed' => '', 'tb' => '', 'paged' => 0, 'preview' => '', 's' => '', 'sentence' => '', 'title' => '', 'fields' => '', 'menu_order' => '', 'embed' => '', 'categoryin' => array ( ), 'categorynot_in' => array ( ), 'categoryand' => array ( ), 'postin' => array ( ), 'postnot_in' => array ( ), 'post_namein' => array ( ), 'tagin' => array ( ), 'tagnot_in' => array ( ), 'tagand' => array ( ), 'tag_slug__in' => array ( ), 'tag_slugand' => array ( ), 'post_parentin' => array ( ), 'post_parent__not_in' => array ( ), 'authorin' => array ( ), 'author__not_in' => array ( ), 'search_columns' => array ( ), 'ep_integrate' => true, 'ep_facet' => true, 'aggs' => array ( 'name' => 'terms', 'use-filter' => true, 'aggs' => array ( 'category' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.category.slug', ), ), 'post_tag' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.post_tag.slug', ), ), 'product_cat' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.product_cat.slug', ), ), 'product_tag' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.product_tag.slug', ), ), 'pa_brand' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_brand.slug', ), ), 'pa_colours' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_colours.slug', ), ), 'pa_condition' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_condition.slug', ), ), 'pa_department' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_department.slug', ), ), 'pa_size' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'terms.pa_size.slug', ), ), 'post_type' => array ( 'terms' => array ( 'size' => 10000, 'field' => 'post_type.raw', ), ), ), ), 'cache_results' => true, 'update_post_term_cache' => true, 'update_menu_item_cache' => false, 'lazy_load_term_meta' => true, 'update_post_meta_cache' => true, 'nopaging' => true, 'comments_per_page' => '20', ) status_code: 400 body: {"from":0,"size":10000,"post_filter":{"bool":{"must":[{"bool":{"must":[{"exists":{"field":"meta._elementor_priority"}},{"bool":{"should":{"bool":{"should":[{"terms":{"meta._elementor_location.raw":["elementor_body_end"]}}]}}}}]}},{"terms":{"post_type.raw":["elementor_snippet"]}},{"term":{"post_status":"publish"}}]}},"query":{"match_all":{"boost":1}},"sort":[{"meta._elementor_priority.long":{"order":"asc"}}],"aggs":{"terms":{"filter":{"bool":{"must":[{"bool":{"must":[{"exists":{"field":"meta._elementor_priority"}},{"bool":{"should":{"bool":{"should":[{"terms":{"meta._elementor_location.raw":["elementor_body_end"]}}]}}}}]}},{"terms":{"post_type.raw":["elementor_snippet"]}},{"term":{"post_status":"publish"}}]}},"aggs":{"category":{"terms":{"size":10000,"field":"terms.category.slug"}},"post_tag":{"terms":{"size":10000,"field":"terms.post_tag.slug"}},"product_cat":{"terms":{"size":10000,"field":"terms.product_cat.slug"}},"product_tag":{"terms":{"size":10000,"field":"terms.product_tag.slug"}},"pa_brand":{"terms":{"size":10000,"field":"terms.pa_brand.slug"}},"pa_colours":{"terms":{"size":10000,"field":"terms.pa_colours.slug"}},"pa_condition":{"terms":{"size":10000,"field":"terms.pa_condition.slug"}},"pa_department":{"terms":{"size":10000,"field":"terms.pa_department.slug"}},"pa_size":{"terms":{"size":10000,"field":"terms.pa_size.slug"}},"post_type":{"terms":{"size":10000,"field":"post_type.raw"}}}}}} result: array ( 'error' => array ( 'root_cause' => array ( 0 => array ( 'type' => 'query_shard_exception', 'reason' => 'No mapping found for [meta._elementor_priority.long] in order to sort on', 'index_uuid' => 'KhWqXdYhTN-ypPfRE_lIRg', 'index' => 'flufio-post-1', ), ), 'type' => 'search_phase_execution_exception', 'reason' => 'all shards failed', 'phase' => 'query', 'grouped' => true, 'failed_shards' => array ( 0 => array ( 'shard' => 0, 'index' => 'flufio-post-1', 'node' => 'rmRUCZebTTGdayUJG73AMg', 'reason' => array ( 'type' => 'query_shard_exception', 'reason' => 'No mapping found for [meta._elementor_priority.long] in order to sort on', 'index_uuid' => 'KhWqXdYhTN-ypPfRE_lIRg', 'index' => 'flufio-post-1', ), ), ), ), 'status' => 400, )

WordPress

WordPress Environment

wp_version: 6.5 home_url: https://fluf.io site_url: https://fluf.io is_multisite: false theme: Astra Child (6.3.0) parent_theme: Astra (4.6.10) plugins: AIOSEO - Image SEO (1.1.10), AIOSEO - IndexNow (1.0.11), AIOSEO - Link Assistant (1.1.3), AIOSEO - Redirects (1.3.7), All in One SEO Pro (4.5.8), Astra Pro (4.6.4), Breeze (2.1.6), Classic Widgets (0.3), Dokan (3.10.2), Dokan Pro (3.10.2), ElasticPress (5.0.2), Elementor (3.20.3), Elementor Pro (3.20.2), Fast Results (0.1.1), Fatal Error Notify (1.5.3), Featured Image from URL (FIFU) Premium (6.4.9), Index WP MySQL For Speed (1.4.16), Loco Translate (2.6.7), Nav Menu Roles (2.1.2), Post SMTP (2.8.13), Scalability Pro (5.44), User Switching (1.7.3), and WooCommerce (8.7.0) revisions: 0

Server Environment

php_version: 8.2.17 memory_limit: 512M timeout: 300

Indexable Content

FLUF — https://fluf.io

post_count: 24 page_count: 24 e-landing-page_count: 7 elementor_library_count: 17 product_count: 883,901 request_count: 1 attachment_count: 3,632,884 wp_font_family_count: 0 wp_font_face_count: 0 product_variation_count: 0 shop_order_count: 142 shop_order_refund_count: 13 shop_coupon_count: 10 shop_order_placehold_count: 5 postman_sent_mail_count: 0 dokan_store_reviews_count: 4 patterns_ai_data_count: 0 elementor_font_count: 0 elementor_icons_count: 0 dokan_announcement_count: 500 post_meta_keys: 0 page_meta_keys: 1 e-landing-page_meta_keys: 0 elementor_library_meta_keys: 0 product_meta_keys: 28 request_meta_keys: 0 attachment_meta_keys: 0 wp_font_family_meta_keys: 0 wp_font_face_meta_keys: 0 product_variation_meta_keys: 0 shop_order_meta_keys: 20 shop_order_refund_meta_keys: 0 shop_coupon_meta_keys: 0 shop_order_placehold_meta_keys: 0 postman_sent_mail_meta_keys: 0 dokan_store_reviews_meta_keys: 0 patterns_ai_data_meta_keys: 0 elementor_font_meta_keys: 0 elementor_icons_meta_keys: 0 dokan_announcement_meta_keys: 0 total-all-post-types: 49 distinct-meta-keys: ep_exclude_from_search, _backorders, _downloadable, _manage_stock, _price, _product_version, _regular_price, _sold_individually, _stock, _stock_status, _tax_class, _tax_status, _virtual, _wc_average_rating, total_sales, _crosssell_ids, _height, _length, _product_attributes, _product_image_gallery, _purchase_note, _sale_price, _sale_price_dates_from, _sale_price_dates_to, _thumbnail_id, _upsell_ids, _visibility, _weight, _width, _billing_address_1, _billing_address_2, _billing_city, _billing_country, _billing_email, _billing_first_name, _billing_last_name, _billing_phone, _billing_postcode, _billing_state, _customer_user, _order_key, _shipping_address_1, _shipping_city, _shipping_country, _shipping_first_name, _shipping_last_name, _shipping_postcode, _shipping_address_2, and _shipping_state

ElasticPress

Settings

host: http://127.0.0.1:9200 index_prefix: language: site-default per_page: 350 network_active: false

Timeouts

request_timeout: 5 index_document_timeout: 15 bulk_request_timeout: 30

Elasticsearch Indices

flufio-post-1

health: yellow status: open index: flufio-post-1 uuid: KhWqXdYhTN-ypPfRE_lIRg pri: 5 rep: 1 docs.count: 885815 docs.deleted: 132197 store.size: 3.1gb pri.store.size: 3.1gb total_fields_limit: 5000 analyzer_language: english stop_language: english snowball_language: English

Last Sync

2024/02/15 4:43:40 am (In Progress)

method: WP-CLI is_full_sync: No end_date_time: 2024/02/15 5:16:27 am total_time: 0 hours, 32 minutes, 48 seconds total: 0 synced: 0 skipped: 0 failed: 0 errors: array ( ) trigger: final_status: aborted

Feature Settings

Custom Search Results

active: true force_inactive: false

Filters

active: true force_inactive: false match_type: all

Post Search

active: true decaying_enabled: 0 force_inactive: false highlight_enabled: 0 highlight_excerpt: 0 highlight_tag: mark synonyms_editor_mode: simple synonyms: 

# Defined sets (equivalent synonyms).
sneakers, tennis shoes, trainers, runners


Defined alternatives (explicit mappings).


shoes => sneaker, sandal, boots, high heels
weighting: array ( )

Protected Content

active: true force_inactive: false

Related Posts

active: true force_inactive: false

WooCommerce

active: true force_inactive: false orders: 0

Code of Conduct

felipeelia commented 5 months ago

@gosixl, did you already run a sync with the "Delete all data and start fresh sync" checkbox enabled? You'll need to run that and wait until it reaches the end. After that, can you please share a new ElasticPress Status Report? Thanks.

gosixl commented 5 months ago

No.. I've had horrible luck with the syncs they tend to hang and time out.. probably my server's fault. Have 800k documents.. I got it to work once and now all new docs keep getting added to the index. Don't want to mess with that.. don't know how long I'll wait + be without an index.

I spoke to ChatGPT and they proposed the following which works:

// Skip Elasticpress selectively
function decide_to_skip_ep_integrate( $skip, $query ) {
    if (is_post_type_archive('post')) {
        return true;
    }

    return $skip; // Otherwise, don't alter the existing behavior
}
add_filter( 'ep_skip_query_integration', 'decide_to_skip_ep_integrate', 10, 2 );
github-actions[bot] commented 5 months ago

It has been 3 days since more information was requested from you in this issue and we have not heard back. This issue is now marked as stale and will be closed in 3 days, but if you have more information to add then please comment and the issue will stay open.

github-actions[bot] commented 4 months ago

This issue has been automatically closed because there has been no response to our request for more information in the past 3 days. With only the information that is currently available, we are unable to take further action on this ticket. Please reach out if you have found or find the answer we need so that we can investigate further. When the information is ready, you can re-open this ticket to share it with us.