Category page – random event recurrence
-
Hello, when i list event with recurrence event is listed random not next date from “today” in category page, my query code is:
$events = eo_get_events(array( 'event_end_after'=>'now', 'event_start_after'=>'now', 'event-category'=>$wp_query->query_vars['event-category'], 'posts_per_page' => $per_page, 'paged' => $paged, 'group_events_by' => 'series', 'orderby'=>'eventstart', 'order'=>'ASC', //'event_end_before' => $time5, 'showpastevents' => false // 'numberposts' => -1
And for list date i use eo_the_start
My event have this settings:
1. Start date 09.05.2016
2. End date 09.05.2016
Recurrence every day , repeat 1
-
if i remove ‘group_events_by’ => ‘series’,, all sort and date is correct but event repeat for each date
and query debug result is:
WP_Query Object ( [query] => Array ( [event-category] => limbi-straine ) [query_vars] => Array ( [event-category] => limbi-straine [error] => [m] => [p] => 0 [post_parent] => [subpost] => [subpost_id] => [attachment] => [attachment_id] => 0 [name] => [static] => [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] => [meta_value] => [preview] => [s] => [sentence] => [title] => [fields] => [menu_order] => [embed] => [category__in] => Array ( ) [category__not_in] => Array ( ) [category__and] => Array ( ) [post__in] => Array ( ) [post__not_in] => Array ( ) [post_name__in] => Array ( ) [tag__in] => Array ( ) [tag__not_in] => Array ( ) [tag__and] => Array ( ) [tag_slug__in] => Array ( ) [tag_slug__and] => Array ( ) [post_parent__in] => Array ( ) [post_parent__not_in] => Array ( ) [author__in] => Array ( ) [author__not_in] => Array ( ) [post_type] => event [showpastevents] => 1 [group_events_by] => series [event_start_after] => [event_start_before] => [event_end_after] => [event_end_before] => [ignore_sticky_posts] => [suppress_filters] => [cache_results] => 1 [update_post_term_cache] => 1 [update_post_meta_cache] => 1 [posts_per_page] => 24 [nopaging] => [comments_per_page] => 50 [no_found_rows] => [taxonomy] => event-category [term] => limbi-straine [order] => DESC ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [0] => Array ( [taxonomy] => event-category [terms] => Array ( [0] => limbi-straine ) [field] => slug [operator] => IN [include_children] => 1 ) ) [relation] => AND [table_aliases:protected] => Array ( [0] => wp_term_relationships ) [queried_terms] => Array ( [event-category] => Array ( [terms] => Array ( [0] => limbi-straine ) [field] => slug ) ) [primary_table] => wp_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( ) [relation] => [meta_table] => [meta_id_column] => [primary_table] => [primary_id_column] => [table_aliases:protected] => Array ( ) [clauses:protected] => Array ( ) [has_or_relation:protected] => ) [date_query] => [queried_object] => WP_Term Object ( [term_id] => 227 [name] => Limbi str?ine [slug] => limbi-straine [term_group] => 0 [term_taxonomy_id] => 227 [taxonomy] => event-category [description] => [parent] => 231 [count] => 0 [filter] => raw [color] => ) [queried_object_id] => 227 [request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.*, wp_eo_events.event_id, wp_eo_events.event_id AS occurrence_id, wp_eo_events.StartDate, wp_eo_events.StartTime, wp_eo_events.EndDate, wp_eo_events.FinishTime, wp_eo_events.event_occurrence FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN ( SELECT * FROM wp_eo_events ORDER BY wp_eo_events.StartDate ASC, wp_eo_events.StartTime ASC ) AS wp_eo_events ON wp_posts.id = wp_eo_events.post_id LEFT JOIN wp_postmeta wphptbl ON wp_posts.ID = wphptbl.post_id and wphptbl.meta_key like '_wplp_%' AND ((wp_posts.post_type = 'post' AND wphptbl.meta_key not like '_wplp_%' ) OR (wp_posts.post_type = 'page' AND wphptbl.meta_key <> '_wplp_page_flags' AND wphptbl.meta_key not like '_wplp_%' )) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (227,951,982,991,996,1182,1183,1184) ) AND wp_posts.post_type = 'event' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private') AND wphptbl.post_id IS NULL GROUP BY wp_posts.ID ORDER BY wp_eo_events.StartDate ASC, wp_eo_events.StartTime ASC LIMIT 0, 24 [post_count] => 0 [current_post] => -1 [in_the_loop] => [comment_count] => 0 [current_comment] => -1 [found_posts] => 0 [max_num_pages] => 0 [max_num_comment_pages] => 0 [is_single] => [is_preview] => [is_page] => [is_archive] => 1 [is_date] => [is_year] => [is_month] => [is_day] => [is_time] => [is_author] => [is_category] => [is_tag] => [is_tax] => 1 [is_search] => [is_feed] => [is_comment_feed] => [is_trackback] => [is_home] => [is_404] => [is_embed] => [is_paged] => [is_admin] => [is_attachment] => [is_singular] => [is_robots] => [is_posts_page] => [is_post_type_archive] => [query_vars_hash:WP_Query:private] => be250d29b4d8ed9090a74a7ebe2e5024 [query_vars_changed:WP_Query:private] => 1 [thumbnails_cached] => [stopwords:WP_Query:private] => [compat_fields:WP_Query:private] => Array ( [0] => query_vars_hash [1] => query_vars_changed ) [compat_methods:WP_Query:private] => Array ( [0] => init_query_flags [1] => parse_tax_query ) )
if you look is not
'event_end_after'=> 'today', 'event_start_after' => 'today',
The SQL statement doesn’t contain the SQL segment for the above conditionals. I see that there is some additional custom SQL statements (wphptbl) – do you know which plug-in is doing that? Could it be that that plugin is breaking Event Organiser?
wphptbl – is WP hide post and with/without him is same result
last update fix this problem
- The topic ‘Category page – random event recurrence’ is closed to new replies.