felipeelia
commented
1 month ago @iazema can you please share the code where you are using the ep_prepare_meta_allowed_keys filter to add that meta field to the allowed list? Thanks!
Open iazema opened 1 month ago
felipeelia
commented
1 month ago @iazema can you please share the code where you are using the ep_prepare_meta_allowed_keys filter to add that meta field to the allowed list? Thanks!
iazema
commented
1 month ago Sure, it's in class that contains:
add_filter( 'ep_prepare_meta_allowed_keys', [ $this, 'add_ep_allowed_meta' ] );
public function add_ep_allowed_meta( $metas ): array {
$metas[] = 'spf_event_start_date';
$metas[] = 'spf_content_is_featured';
return $metas;
}
github-actions[bot]
commented
1 month 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.
iazema
commented
1 month ago Hi @felipeelia
My issue has been automatically marked as stale but I did send you the code you asked me :-) Is there anything else you need?
github-actions[bot]
commented
1 month 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
1 month 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.
iazema
commented
1 month ago Hi @felipeelia
This issue has been automatically closed but I had no answer since I sent the code you asked. Can you please look into it?
burhandodhy
commented
4 weeks ago Hi @iazema,
Thank you for reporting this issue. I can confirm that it is indeed a bug in the plugin, as I was able to replicate it on my end. I have added this bug to our roadmap and we aim to fix it in the upcoming version.
Regards, Burhan
iazema
commented
4 weeks ago Thanks a lot Burhan
Describe the bug
Hello,
On a multisite WP, we use a query in order to retrieve post of type "event" and sort them by "spf_event_start_date" field. If the site has posts of type event in its database, it' ok. If there are no "event" posts in the database, we get the following error:
Error: No mapping found for [meta.spf_event_start_date.value.sortable] in order to sort on Recommended Solution: The field meta.spf_event_start_date.value.sortable was not found. Make sure it is added to the list of indexed fields and run a new sync to fix the issue.
The meta has been added using the filter ep_prepare_meta_allowed_keys. I have also tried to manually add it to the mapping but it didn't change anything.
Here is the query:
Steps to Reproduce
If necessary I will see if it's possible to enable debug-bar-elasticpress on the production env for you to see the errors
Screenshots, screen recording, code snippet
No response
Environment information
No response
WordPress and ElasticPress information
Failed Queries
https://www.secourspopulaire.fr/58 (2024-07-11 11:45:47)
error: No mapping found for [meta.spf_event_start_date.value.sortable] in order to sort on recommended_solution: The field
meta.spf_event_start_date.value.sortablewas 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://ipvr8.secours-populaire:9200/spfpro-post-401/_search request_id: spfpro248dedc474c84347b1e3186cc7a4546f query_time: 1.8458366394043 wp_args: array ( 'ignore_sticky_posts' => 1, 'post_type' => 'event', 'offset' => 0, 'postnot_in' => array ( 0 => 15971, ), 'posts_per_page' => -1, 'ep_integrate' => 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' => 1, 'meta_key' => 'spf_event_start_date', 'meta_value' => '', 'preview' => '', 's' => '', 'sentence' => '', 'title' => '', 'fields' => 'ids', 'menu_order' => '', 'embed' => '', 'categoryin' => array ( ), 'categorynot_in' => array ( ), 'categoryand' => array ( ), 'postin' => array ( ), 'post_namein' => array ( ), 'tagin' => array ( ), 'tag__not_in' => array ( ), 'tagand' => array ( ), 'tag_slugin' => array ( ), 'tag_slug__and' => array ( ), 'post_parentin' => array ( ), 'post_parent__not_in' => array ( ), 'authorin' => array ( ), 'authornot_in' => array ( ), 'search_columns' => array ( ), 'spf_events_integrate' => 'future', 'spf_featured_integrate' => false, 'orderby' => 'meta_value', 'order' => 'ASC', 'meta_query' => array ( 'spf_future_events' => array ( 'relation' => 'OR', 0 => array ( 'key' => 'spf_event_start_date', 'value' => '2024-07-11', 'compare' => '>=', 'type' => 'DATE', ), 1 => array ( 'relation' => 'AND', 0 => array ( 'key' => 'spf_event_start_date', 'value' => '2024-07-11', 'compare' => '<=', 'type' => 'DATE', ), 1 => array ( 'key' => 'spf_event_end_date', 'value' => '2024-07-11', 'compare' => '>=', 'type' => 'DATE', ), ), ), 'spf_featured' => array ( 'relation' => 'OR', 0 => array ( 'key' => 'spf_content_is_featured', 'value' => 1, 'compare' => '!=', ), 1 => array ( 'key' => 'spf_content_is_featured', 'value' => '', 'compare' => 'NOT EXISTS', ), ), ), 'cache_results' => false, 'facetwp' => false, 'update_post_meta_cache' => false, 'update_post_term_cache' => false, 'no_found_rows' => true, 'nopaging' => true, 'suppress_filters' => false, 'update_menu_item_cache' => false, 'lazy_load_term_meta' => false, 'comments_per_page' => '50', ) status_code: 400 body: {"from":0,"size":10000,"post_filter":{"bool":{"must":[{"bool":{"must_not":{"terms":{"post_id":[15971]}}}},{"bool":{"must":[{"exists":{"field":"meta.spf_event_start_date"}},{"bool":{"must":{"bool":{"must":[{"bool":{"should":{"bool":{"should":[{"bool":{"must":[{"range":{"meta.spf_event_start_date.date":{"gte":"2024-07-11"}}}]}},{"bool":{"must":{"bool":{"must":[{"bool":{"must":[{"range":{"meta.spf_event_start_date.date":{"lte":"2024-07-11"}}}]}},{"bool":{"must":[{"range":{"meta.spf_event_end_date.date":{"gte":"2024-07-11"}}}]}}]}}}}]}}}},{"bool":{"should":{"bool":{"should":[{"bool":{"must_not":[{"terms":{"meta.spf_content_is_featured.raw":[1]}}]}},{"bool":{"must_not":[{"exists":{"field":"meta.spf_content_is_featured"}}]}}]}}}}]}}}}]}},{"terms":{"post_type.raw":["event"]}},{"terms":{"post_status":["publish","acf-disabled"]}}]}},"query":{"match_all":{"boost":1}},"_source":{"includes":["post_id"]},"sort":[{"meta.spf_event_start_date.value.sortable":{"order":"asc"}}]} result: array ( 'error' => array ( 'root_cause' => array ( 0 => array ( 'type' => 'query_shard_exception', 'reason' => 'No mapping found for [meta.spf_event_start_date.value.sortable] in order to sort on', 'index_uuid' => '0DJolzJmRIaLEKjXXcsmLA', 'index' => 'spfpro-post-401', ), ), 'type' => 'search_phase_execution_exception', 'reason' => 'all shards failed', 'phase' => 'can_match', 'grouped' => true, 'failed_shards' => array ( 0 => array ( 'shard' => 0, 'index' => 'spfpro-post-401', 'node' => 'XQarS25iTM6qGz2uyyKpcg', 'reason' => array ( 'type' => 'query_shard_exception', 'reason' => 'No mapping found for [meta.spf_event_start_date.value.sortable] in order to sort on', 'index_uuid' => '0DJolzJmRIaLEKjXXcsmLA', 'index' => 'spfpro-post-401', ), ), ), ), 'status' => 400, )https://www.secourspopulaire.fr/75 (2024-07-11 11:45:44)
error: No mapping found for [meta.spf_event_start_date.value.sortable] in order to sort on recommended_solution: The field
meta.spf_event_start_date.value.sortablewas 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://ipvr8.secours-populaire:9200/spfpro-post-437/_search request_id: spfpro4cd68eadb8ed45caa954577341c0388c query_time: 1.2919902801514 wp_args: array ( 'ignore_sticky_posts' => 1, 'post_type' => 'event', 'offset' => 0, 'postnot_in' => array ( 0 => 15971, ), 'posts_per_page' => 3, 'ep_integrate' => 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, 'meta_key' => 'spf_event_start_date', 'meta_value' => '', 'preview' => '', 's' => '', 'sentence' => '', 'title' => '', 'fields' => '', 'menu_order' => '', 'embed' => '', 'categoryin' => array ( ), 'categorynot_in' => array ( ), 'categoryand' => array ( ), 'postin' => array ( ), 'post_namein' => array ( ), 'tagin' => array ( ), 'tag__not_in' => array ( ), 'tagand' => array ( ), 'tag_slugin' => array ( ), 'tag_slug__and' => array ( ), 'post_parentin' => array ( ), 'post_parent__not_in' => array ( ), 'authorin' => array ( ), 'authornot_in' => array ( ), 'search_columns' => array ( ), 'spf_events_integrate' => 'future', 'spf_featured_integrate' => false, 'orderby' => 'meta_value', 'order' => 'ASC', 'meta_query' => array ( 'spf_future_events' => array ( 'relation' => 'OR', 0 => array ( 'key' => 'spf_event_start_date', 'value' => '2024-07-11', 'compare' => '>=', 'type' => 'DATE', ), 1 => array ( 'relation' => 'AND', 0 => array ( 'key' => 'spf_event_start_date', 'value' => '2024-07-11', 'compare' => '<=', 'type' => 'DATE', ), 1 => array ( 'key' => 'spf_event_end_date', 'value' => '2024-07-11', 'compare' => '>=', 'type' => 'DATE', ), ), ), 'spf_featured' => array ( 'relation' => 'OR', 0 => array ( 'key' => 'spf_content_is_featured', 'value' => 1, 'compare' => '!=', ), 1 => array ( 'key' => 'spf_content_is_featured', 'value' => '', 'compare' => 'NOT EXISTS', ), ), ), 'cache_results' => false, 'facetwp' => true, 'suppress_filters' => false, 'update_post_term_cache' => true, 'update_menu_item_cache' => false, 'lazy_load_term_meta' => true, 'update_post_meta_cache' => true, 'nopaging' => false, 'comments_per_page' => '50', 'no_found_rows' => false, ) status_code: 400 body: {"from":0,"size":3,"post_filter":{"bool":{"must":[{"bool":{"must_not":{"terms":{"post_id":[15971]}}}},{"bool":{"must":[{"exists":{"field":"meta.spf_event_start_date"}},{"bool":{"must":{"bool":{"must":[{"bool":{"should":{"bool":{"should":[{"bool":{"must":[{"range":{"meta.spf_event_start_date.date":{"gte":"2024-07-11"}}}]}},{"bool":{"must":{"bool":{"must":[{"bool":{"must":[{"range":{"meta.spf_event_start_date.date":{"lte":"2024-07-11"}}}]}},{"bool":{"must":[{"range":{"meta.spf_event_end_date.date":{"gte":"2024-07-11"}}}]}}]}}}}]}}}},{"bool":{"should":{"bool":{"should":[{"bool":{"must_not":[{"terms":{"meta.spf_content_is_featured.raw":[1]}}]}},{"bool":{"must_not":[{"exists":{"field":"meta.spf_content_is_featured"}}]}}]}}}}]}}}}]}},{"terms":{"post_type.raw":["event"]}},{"terms":{"post_status":["publish","acf-disabled"]}}]}},"query":{"match_all":{"boost":1}},"sort":[{"meta.spf_event_start_date.value.sortable":{"order":"asc"}}]} result: array ( 'error' => array ( 'root_cause' => array ( 0 => array ( 'type' => 'query_shard_exception', 'reason' => 'No mapping found for [meta.spf_event_start_date.value.sortable] in order to sort on', 'index_uuid' => 'l9NXeI_xT2mo3-KQIDsDtg', 'index' => 'spfpro-post-437', ), ), 'type' => 'search_phase_execution_exception', 'reason' => 'all shards failed', 'phase' => 'can_match', 'grouped' => true, 'failed_shards' => array ( 0 => array ( 'shard' => 0, 'index' => 'spfpro-post-437', 'node' => 'XQarS25iTM6qGz2uyyKpcg', 'reason' => array ( 'type' => 'query_shard_exception', 'reason' => 'No mapping found for [meta.spf_event_start_date.value.sortable] in order to sort on', 'index_uuid' => 'l9NXeI_xT2mo3-KQIDsDtg', 'index' => 'spfpro-post-437', ), ), ), ), 'status' => 400, )https://www.secourspopulaire.fr/75 (2024-07-11 11:45:44)
error: No mapping found for [meta.spf_event_start_date.value.sortable] in order to sort on recommended_solution: The field
meta.spf_event_start_date.value.sortablewas 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://ipvr8.secours-populaire:9200/spfpro-post-437/_search request_id: spfproaaa6877a78324c22bc7e54ac2a67e3ef query_time: 1.36399269104 wp_args: array ( 'ignore_sticky_posts' => 1, 'post_type' => 'event', 'offset' => 0, 'postnot_in' => array ( 0 => 15971, ), 'posts_per_page' => 3, 'ep_integrate' => 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' => 1, 'meta_key' => 'spf_event_start_date', 'meta_value' => '', 'preview' => '', 's' => '', 'sentence' => '', 'title' => '', 'fields' => '', 'menu_order' => '', 'embed' => '', 'categoryin' => array ( ), 'categorynot_in' => array ( ), 'categoryand' => array ( ), 'postin' => array ( ), 'post_namein' => array ( ), 'tagin' => array ( ), 'tag__not_in' => array ( ), 'tagand' => array ( ), 'tag_slugin' => array ( ), 'tag_slug__and' => array ( ), 'post_parentin' => array ( ), 'post_parent__not_in' => array ( ), 'authorin' => array ( ), 'authornot_in' => array ( ), 'search_columns' => array ( ), 'spf_events_integrate' => 'future', 'spf_featured_integrate' => false, 'orderby' => 'meta_value', 'order' => 'ASC', 'meta_query' => array ( 'spf_future_events' => array ( 'relation' => 'OR', 0 => array ( 'key' => 'spf_event_start_date', 'value' => '2024-07-11', 'compare' => '>=', 'type' => 'DATE', ), 1 => array ( 'relation' => 'AND', 0 => array ( 'key' => 'spf_event_start_date', 'value' => '2024-07-11', 'compare' => '<=', 'type' => 'DATE', ), 1 => array ( 'key' => 'spf_event_end_date', 'value' => '2024-07-11', 'compare' => '>=', 'type' => 'DATE', ), ), ), 'spf_featured' => array ( 'relation' => 'OR', 0 => array ( 'key' => 'spf_content_is_featured', 'value' => 1, 'compare' => '!=', ), 1 => array ( 'key' => 'spf_content_is_featured', 'value' => '', 'compare' => 'NOT EXISTS', ), ), ), 'cache_results' => false, 'facetwp' => true, 'suppress_filters' => false, 'update_post_term_cache' => true, 'update_menu_item_cache' => false, 'lazy_load_term_meta' => true, 'update_post_meta_cache' => true, 'nopaging' => false, 'comments_per_page' => '50', 'no_found_rows' => false, ) status_code: 400 body: {"from":0,"size":3,"post_filter":{"bool":{"must":[{"bool":{"must_not":{"terms":{"post_id":[15971]}}}},{"bool":{"must":[{"exists":{"field":"meta.spf_event_start_date"}},{"bool":{"must":{"bool":{"must":[{"bool":{"should":{"bool":{"should":[{"bool":{"must":[{"range":{"meta.spf_event_start_date.date":{"gte":"2024-07-11"}}}]}},{"bool":{"must":{"bool":{"must":[{"bool":{"must":[{"range":{"meta.spf_event_start_date.date":{"lte":"2024-07-11"}}}]}},{"bool":{"must":[{"range":{"meta.spf_event_end_date.date":{"gte":"2024-07-11"}}}]}}]}}}}]}}}},{"bool":{"should":{"bool":{"should":[{"bool":{"must_not":[{"terms":{"meta.spf_content_is_featured.raw":[1]}}]}},{"bool":{"must_not":[{"exists":{"field":"meta.spf_content_is_featured"}}]}}]}}}}]}}}}]}},{"terms":{"post_type.raw":["event"]}},{"terms":{"post_status":["publish","acf-disabled"]}}]}},"query":{"match_all":{"boost":1}},"sort":[{"meta.spf_event_start_date.value.sortable":{"order":"asc"}}]} result: array ( 'error' => array ( 'root_cause' => array ( 0 => array ( 'type' => 'query_shard_exception', 'reason' => 'No mapping found for [meta.spf_event_start_date.value.sortable] in order to sort on', 'index_uuid' => 'l9NXeI_xT2mo3-KQIDsDtg', 'index' => 'spfpro-post-437', ), ), 'type' => 'search_phase_execution_exception', 'reason' => 'all shards failed', 'phase' => 'can_match', 'grouped' => true, 'failed_shards' => array ( 0 => array ( 'shard' => 0, 'index' => 'spfpro-post-437', 'node' => 'XQarS25iTM6qGz2uyyKpcg', 'reason' => array ( 'type' => 'query_shard_exception', 'reason' => 'No mapping found for [meta.spf_event_start_date.value.sortable] in order to sort on', 'index_uuid' => 'l9NXeI_xT2mo3-KQIDsDtg', 'index' => 'spfpro-post-437', ), ), ), ), 'status' => 400, )https://www.secourspopulaire.fr/75 (2024-07-11 11:45:44)
error: No mapping found for [meta.spf_event_start_date.value.sortable] in order to sort on recommended_solution: The field
meta.spf_event_start_date.value.sortablewas 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://ipvr8.secours-populaire:9200/spfpro-post-437/_search request_id: spfpro89d59e4ede974a57806e99d50d050600 query_time: 1.4488697052002 wp_args: array ( 'ignore_sticky_posts' => 1, 'post_type' => 'event', 'offset' => 0, 'postnot_in' => array ( 0 => 15971, ), 'posts_per_page' => -1, 'ep_integrate' => 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' => 1, 'meta_key' => 'spf_event_start_date', 'meta_value' => '', 'preview' => '', 's' => '', 'sentence' => '', 'title' => '', 'fields' => 'ids', 'menu_order' => '', 'embed' => '', 'categoryin' => array ( ), 'categorynot_in' => array ( ), 'categoryand' => array ( ), 'postin' => array ( ), 'post_namein' => array ( ), 'tagin' => array ( ), 'tag__not_in' => array ( ), 'tagand' => array ( ), 'tag_slugin' => array ( ), 'tag_slug__and' => array ( ), 'post_parentin' => array ( ), 'post_parent__not_in' => array ( ), 'authorin' => array ( ), 'authornot_in' => array ( ), 'search_columns' => array ( ), 'spf_events_integrate' => 'future', 'spf_featured_integrate' => false, 'orderby' => 'meta_value', 'order' => 'ASC', 'meta_query' => array ( 'spf_future_events' => array ( 'relation' => 'OR', 0 => array ( 'key' => 'spf_event_start_date', 'value' => '2024-07-11', 'compare' => '>=', 'type' => 'DATE', ), 1 => array ( 'relation' => 'AND', 0 => array ( 'key' => 'spf_event_start_date', 'value' => '2024-07-11', 'compare' => '<=', 'type' => 'DATE', ), 1 => array ( 'key' => 'spf_event_end_date', 'value' => '2024-07-11', 'compare' => '>=', 'type' => 'DATE', ), ), ), 'spf_featured' => array ( 'relation' => 'OR', 0 => array ( 'key' => 'spf_content_is_featured', 'value' => 1, 'compare' => '!=', ), 1 => array ( 'key' => 'spf_content_is_featured', 'value' => '', 'compare' => 'NOT EXISTS', ), ), ), 'cache_results' => false, 'facetwp' => false, 'update_post_meta_cache' => false, 'update_post_term_cache' => false, 'no_found_rows' => true, 'nopaging' => true, 'suppress_filters' => false, 'update_menu_item_cache' => false, 'lazy_load_term_meta' => false, 'comments_per_page' => '50', ) status_code: 400 body: {"from":0,"size":10000,"post_filter":{"bool":{"must":[{"bool":{"must_not":{"terms":{"post_id":[15971]}}}},{"bool":{"must":[{"exists":{"field":"meta.spf_event_start_date"}},{"bool":{"must":{"bool":{"must":[{"bool":{"should":{"bool":{"should":[{"bool":{"must":[{"range":{"meta.spf_event_start_date.date":{"gte":"2024-07-11"}}}]}},{"bool":{"must":{"bool":{"must":[{"bool":{"must":[{"range":{"meta.spf_event_start_date.date":{"lte":"2024-07-11"}}}]}},{"bool":{"must":[{"range":{"meta.spf_event_end_date.date":{"gte":"2024-07-11"}}}]}}]}}}}]}}}},{"bool":{"should":{"bool":{"should":[{"bool":{"must_not":[{"terms":{"meta.spf_content_is_featured.raw":[1]}}]}},{"bool":{"must_not":[{"exists":{"field":"meta.spf_content_is_featured"}}]}}]}}}}]}}}}]}},{"terms":{"post_type.raw":["event"]}},{"terms":{"post_status":["publish","acf-disabled"]}}]}},"query":{"match_all":{"boost":1}},"_source":{"includes":["post_id"]},"sort":[{"meta.spf_event_start_date.value.sortable":{"order":"asc"}}]} result: array ( 'error' => array ( 'root_cause' => array ( 0 => array ( 'type' => 'query_shard_exception', 'reason' => 'No mapping found for [meta.spf_event_start_date.value.sortable] in order to sort on', 'index_uuid' => 'l9NXeI_xT2mo3-KQIDsDtg', 'index' => 'spfpro-post-437', ), ), 'type' => 'search_phase_execution_exception', 'reason' => 'all shards failed', 'phase' => 'can_match', 'grouped' => true, 'failed_shards' => array ( 0 => array ( 'shard' => 0, 'index' => 'spfpro-post-437', 'node' => 'XQarS25iTM6qGz2uyyKpcg', 'reason' => array ( 'type' => 'query_shard_exception', 'reason' => 'No mapping found for [meta.spf_event_start_date.value.sortable] in order to sort on', 'index_uuid' => 'l9NXeI_xT2mo3-KQIDsDtg', 'index' => 'spfpro-post-437', ), ), ), ), 'status' => 400, )https://www.secourspopulaire.fr/44-nantes (2024-07-11 11:45:43)
error: No mapping found for [meta.spf_event_start_date.value.sortable] in order to sort on recommended_solution: The field
meta.spf_event_start_date.value.sortablewas 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://ipvr8.secours-populaire:9200/spfpro-post-1647/_search request_id: spfprob7f7867bab7a4ff2862b5af06f6afdc5 query_time: 1.417875289917 wp_args: array ( 'ignore_sticky_posts' => 1, 'post_type' => 'event', 'offset' => 0, 'postnot_in' => array ( 0 => 15971, ), 'posts_per_page' => 3, 'ep_integrate' => 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, 'meta_key' => 'spf_event_start_date', 'meta_value' => '', 'preview' => '', 's' => '', 'sentence' => '', 'title' => '', 'fields' => '', 'menu_order' => '', 'embed' => '', 'categoryin' => array ( ), 'categorynot_in' => array ( ), 'categoryand' => array ( ), 'postin' => array ( ), 'post_namein' => array ( ), 'tagin' => array ( ), 'tag__not_in' => array ( ), 'tagand' => array ( ), 'tag_slugin' => array ( ), 'tag_slug__and' => array ( ), 'post_parentin' => array ( ), 'post_parent__not_in' => array ( ), 'authorin' => array ( ), 'authornot_in' => array ( ), 'search_columns' => array ( ), 'spf_events_integrate' => 'future', 'spf_featured_integrate' => false, 'orderby' => 'meta_value', 'order' => 'ASC', 'meta_query' => array ( 'spf_future_events' => array ( 'relation' => 'OR', 0 => array ( 'key' => 'spf_event_start_date', 'value' => '2024-07-11', 'compare' => '>=', 'type' => 'DATE', ), 1 => array ( 'relation' => 'AND', 0 => array ( 'key' => 'spf_event_start_date', 'value' => '2024-07-11', 'compare' => '<=', 'type' => 'DATE', ), 1 => array ( 'key' => 'spf_event_end_date', 'value' => '2024-07-11', 'compare' => '>=', 'type' => 'DATE', ), ), ), 'spf_featured' => array ( 'relation' => 'OR', 0 => array ( 'key' => 'spf_content_is_featured', 'value' => 1, 'compare' => '!=', ), 1 => array ( 'key' => 'spf_content_is_featured', 'value' => '', 'compare' => 'NOT EXISTS', ), ), ), 'cache_results' => false, 'suppress_filters' => false, 'update_post_term_cache' => true, 'update_menu_item_cache' => false, 'lazy_load_term_meta' => true, 'update_post_meta_cache' => true, 'nopaging' => false, 'comments_per_page' => '50', 'no_found_rows' => false, ) status_code: 400 body: {"from":0,"size":3,"post_filter":{"bool":{"must":[{"bool":{"must_not":{"terms":{"post_id":[15971]}}}},{"bool":{"must":[{"exists":{"field":"meta.spf_event_start_date"}},{"bool":{"must":{"bool":{"must":[{"bool":{"should":{"bool":{"should":[{"bool":{"must":[{"range":{"meta.spf_event_start_date.date":{"gte":"2024-07-11"}}}]}},{"bool":{"must":{"bool":{"must":[{"bool":{"must":[{"range":{"meta.spf_event_start_date.date":{"lte":"2024-07-11"}}}]}},{"bool":{"must":[{"range":{"meta.spf_event_end_date.date":{"gte":"2024-07-11"}}}]}}]}}}}]}}}},{"bool":{"should":{"bool":{"should":[{"bool":{"must_not":[{"terms":{"meta.spf_content_is_featured.raw":[1]}}]}},{"bool":{"must_not":[{"exists":{"field":"meta.spf_content_is_featured"}}]}}]}}}}]}}}}]}},{"terms":{"post_type.raw":["event"]}},{"terms":{"post_status":["publish","acf-disabled"]}}]}},"query":{"match_all":{"boost":1}},"sort":[{"meta.spf_event_start_date.value.sortable":{"order":"asc"}}]} result: array ( 'error' => array ( 'root_cause' => array ( 0 => array ( 'type' => 'query_shard_exception', 'reason' => 'No mapping found for [meta.spf_event_start_date.value.sortable] in order to sort on', 'index_uuid' => 'Gok3GPfsRY6KLmVy2RwgNQ', 'index' => 'spfpro-post-1647', ), ), 'type' => 'search_phase_execution_exception', 'reason' => 'all shards failed', 'phase' => 'can_match', 'grouped' => true, 'failed_shards' => array ( 0 => array ( 'shard' => 0, 'index' => 'spfpro-post-1647', 'node' => 'XQarS25iTM6qGz2uyyKpcg', 'reason' => array ( 'type' => 'query_shard_exception', 'reason' => 'No mapping found for [meta.spf_event_start_date.value.sortable] in order to sort on', 'index_uuid' => 'Gok3GPfsRY6KLmVy2RwgNQ', 'index' => 'spfpro-post-1647', ), ), ), ), 'status' => 400, )WordPress
WordPress Environment
wp_version: 6.5.3 home_url: https://www.secourspopulaire.fr site_url: https://www.secourspopulaire.fr/wp is_multisite: true theme: Secours Populaire UAS (1.0.0) plugins: ACF Medium Editor Field (3.0.0), Advanced Custom Fields: SVG Icon (2.1.3), Advanced Custom Fields PRO (6.2.10), Advanced Responsive Images (4.1.2), Anchor Block (2.0.2), BBQ Pro (3.7), BEA - Content Sync Fusion (3.12.3), BeAPI - ElasticPress Geo (0.2.0), Be API Dynamic block (1.0.8), Be API Icon block (2.1.4), Be API Manual Block (1.0.8), Cache-Control (2.2.5), Connect Matomo (1.0.30), Disable All WordPress Updates (1.7.0), Disable Block Editor FullScreen mode (2.7.2), Disable Comments (2.4.6), Disable Embeds (1.5.0), Disable Emojis (GDPR friendly) (1.7.6), Disable Gutenberg (3.1.1), DynaMo (1.2), ElasticPress (5.0.2), Enable Media Replace (4.1.5), FacetWP (4.2.12), Gravity Forms (2.8.5.1), GTM4WP (1.16.2), Multisite Enhancements (1.6.1), Multisite Shared Blocks (1.1.1), New Relic Reporting for WordPress (1.3.2), OpenID Connect Generic (3.9.1), OpenID Connect Generic PKCE Addon (1.0.0), Redirection (5.3.6), Redis Object Cache (2.2.3), Related Posts for WordPress Premium (2.1.2), Safe SVG (2.2.4), Secours populaire français - Actions (1.0.0), Secours populaire français - Actions rapides (1.0.0), Secours populaire français - Anonymisation des utilisateurs (1.0.0), Secours populaire français - Atrium (1.0.0), Secours populaire français - Blocs (1.0.0), Secours populaire français - Campagnes (1.0.0), Secours populaire français - Contenus à la une (1.0.0), Secours populaire français - Dolist (1.0.0), Secours populaire français - Données structurées (1.0.0), Secours populaire français - Dynamic Block Extention (1.0.0), Secours populaire français - Elasticpress (1.0.0), Secours populaire français - Events (1.0.0), Secours populaire français - FAQS (1.0.0), Secours populaire français - Gravity Forms (1.0.0), Secours populaire français - Inbenta Chatbot (1.2.5), Secours populaire français - iRaiser (1.0.0), Secours Populaire Français - Keepeek (1.0.0), Secours populaire français - Medias (1.0.0), Secours populaire français - Mobilisation d'urgence (1.0.0), Secours populaire français - Mots clés (1.0.0), Secours populaire français - News (1.0.0), Secours populaire français - Ordre personnalisé du menu (1.0.0), Secours populaire français - Pages (1.0.0), Secours populaire français - Pays (1.0.0), Secours populaire français - Presse (1.0.0), Secours populaire français - Recherche (1.0.0), Secours populaire français - Sitemap (1.0.0), Secours populaire français - SSO (1.0.0), Secours populaire français - Tableau de bord (1.0.0), Secours populaire français - Tarte au citron (1.0.5), Secours populaire français - Thematics action (1.0.0), Secours populaire français - Témoignages (1.0.0), Secours populaire français - Utilisateurs (1.0.0), Secours populaire français - Variables dynamiques (1.0.0), Secours populaire français - Vidéos embarquées (1.0.0), Secours populaire français - Wiki (1.0.0), Stream (4.0.0), User Switching (1.7.3), Virtual Robots.txt (1.10), Wicked Folders Pro (2.23.15), WP-CLI Site Duplicator (2.0.1), WP-PageNavi (2.94.1), WP-Polls (2.77.0), WP Cerber Security, Anti-spam & Malware Scan (9.5.7), WP Rocket (3.15.6), WP Sitemap Page (1.9.2), Yoast Duplicate Post (4.5), et Yoast SEO (22.7) revisions: all
Server Environment
php_version: 8.2.20 memory_limit: 64M timeout: 300
Indexable Content
Secours populaire français — https://www.secourspopulaire.fr/wp
post_count: 652 page_count: 173 spf-action_count: 0 event_count: 667 faq_count: 48 press_count: 497 testimonial_count: 488 post_meta_keys: 2 page_meta_keys: 1 spf-action_meta_keys: 0 event_meta_keys: 3 faq_meta_keys: 0 press_meta_keys: 1 testimonial_meta_keys: 0 total-all-post-types: 3 distinct-meta-keys: ep_exclude_from_search, spf_content_is_featured, et spf_event_start_date
Fédération de l'AIN — https://www.secourspopulaire.fr/01
post_count: 0 page_count: 5 spf-action_count: 0 event_count: 0 faq_count: 0 press_count: 0 testimonial_count: 17 post_meta_keys: 0 page_meta_keys: 0 spf-action_meta_keys: 0 event_meta_keys: 0 faq_meta_keys: 0 press_meta_keys: 0 testimonial_meta_keys: 0 total-all-post-types: 0 distinct-meta-keys:
[Truncated because there are more than 1600 sites]
Code of Conduct