Hi,
\ni’m experiencing a 404 redirect when i try to access to a single event page clicking on the event calendar.<\/p>\n
I followed all the instruction to fix 404 and you can find the informations below.<\/p>\n
Indeed the problem is due to an error in the query:
\nSELECT DISTINCT wp_posts.*, MIN(wp_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM wp_posts LEFT JOIN wp_postmeta as tribe_event_end_date ON ( wp_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ ) WHERE 1=1 AND wp_posts.post_name = ‘alessandro-barbero-milano-18-luglio-2016’ AND wp_posts.post_type = ‘tribe_events’ ORDER BY EventStartDate DESC, wp_posts.post_date DESC <\/p>\n
#1054 – Unknown column ‘wp_postmeta.meta_value’ in ‘field list’<\/p>\n
Since you used a cast wp_postmeta as tribe_event_end_date you can’t use the name of the table.<\/p>\n
The error seems to be at the following line of the \\the-events-calendar\\src\\Tribe\\Query.php file:
\n$fields[‘event_start_date’] = “MIN({$postmeta_table}.meta_value) as EventStartDate”;<\/p>\n
Best regards,
\nSara.<\/p>\n
********
\n<Tribe Events Query>
\nobject(WP_Query)#3808 (57) {
\n [“query”]=>
\n array(4) {
\n [“page”]=>
\n string(0) “”
\n [“tribe_events”]=>
\n string(40) “alessandro-barbero-milano-18-luglio-2016”
\n [“post_type”]=>
\n string(12) “tribe_events”
\n [“name”]=>
\n string(40) “alessandro-barbero-milano-18-luglio-2016”
\n }
\n [“query_vars”]=>
\n array(55) {
\n [“page”]=>
\n string(0) “”
\n [“tribe_events”]=>
\n string(40) “alessandro-barbero-milano-18-luglio-2016”
\n [“post_type”]=>
\n string(12) “tribe_events”
\n [“name”]=>
\n string(40) “alessandro-barbero-milano-18-luglio-2016”
\n [“error”]=>
\n string(0) “”
\n [“m”]=>
\n string(0) “”
\n [“p”]=>
\n int(0)
\n [“post_parent”]=>
\n string(0) “”
\n [“subpost”]=>
\n string(0) “”
\n [“subpost_id”]=>
\n string(0) “”
\n [“attachment”]=>
\n string(0) “”
\n [“attachment_id”]=>
\n int(0)
\n [“static”]=>
\n string(0) “”
\n [“pagename”]=>
\n string(0) “”
\n [“page_id”]=>
\n int(0)
\n [“second”]=>
\n string(0) “”
\n [“minute”]=>
\n string(0) “”
\n [“hour”]=>
\n string(0) “”
\n [“day”]=>
\n int(0)
\n [“monthnum”]=>
\n int(0)
\n [“year”]=>
\n int(0)
\n [“w”]=>
\n int(0)
\n [“category_name”]=>
\n string(0) “”
\n [“tag”]=>
\n string(0) “”
\n [“cat”]=>
\n string(0) “”
\n [“tag_id”]=>
\n string(0) “”
\n [“author”]=>
\n string(0) “”
\n [“author_name”]=>
\n string(0) “”
\n [“feed”]=>
\n string(0) “”
\n [“tb”]=>
\n string(0) “”
\n [“paged”]=>
\n int(0)
\n [“meta_key”]=>
\n string(0) “”
\n [“meta_value”]=>
\n string(0) “”
\n [“preview”]=>
\n string(0) “”
\n [“s”]=>
\n string(0) “”
\n [“sentence”]=>
\n string(0) “”
\n [“title”]=>
\n string(0) “”
\n [“fields”]=>
\n string(0) “”
\n [“menu_order”]=>
\n string(0) “”
\n [“embed”]=>
\n string(0) “”
\n [“category__in”]=>
\n array(0) {
\n }
\n [“category__not_in”]=>
\n array(0) {
\n }
\n [“category__and”]=>
\n array(0) {
\n }
\n [“post__in”]=>
\n array(0) {
\n }
\n [“post__not_in”]=>
\n array(0) {
\n }
\n [“post_name__in”]=>
\n array(0) {
\n }
\n [“tag__in”]=>
\n array(0) {
\n }
\n [“tag__not_in”]=>
\n array(0) {
\n }
\n [“tag__and”]=>
\n array(0) {
\n }
\n [“tag_slug__in”]=>
\n array(0) {
\n }
\n [“tag_slug__and”]=>
\n array(0) {
\n }
\n [“post_parent__in”]=>
\n array(0) {
\n }
\n [“post_parent__not_in”]=>
\n array(0) {
\n }
\n [“author__in”]=>
\n array(0) {
\n }
\n [“author__not_in”]=>
\n array(0) {
\n }
\n }
\n [“tax_query”]=>
\n NULL
\n [“meta_query”]=>
\n bool(false)
\n [“date_query”]=>
\n bool(false)
\n [“post_count”]=>
\n int(0)
\n [“current_post”]=>
\n int(-1)
\n [“in_the_loop”]=>
\n bool(false)
\n [“comment_count”]=>
\n int(0)
\n [“current_comment”]=>
\n int(-1)
\n [“found_posts”]=>
\n int(0)
\n [“max_num_pages”]=>
\n int(0)
\n [“max_num_comment_pages”]=>
\n int(0)
\n [“is_single”]=>
\n bool(true)
\n [“is_preview”]=>
\n bool(false)
\n [“is_page”]=>
\n bool(false)
\n [“is_archive”]=>
\n bool(false)
\n [“is_date”]=>
\n bool(false)
\n [“is_year”]=>
\n bool(false)
\n [“is_month”]=>
\n bool(false)
\n [“is_day”]=>
\n bool(false)
\n [“is_time”]=>
\n bool(false)
\n [“is_author”]=>
\n bool(false)
\n [“is_category”]=>
\n bool(false)
\n [“is_tag”]=>
\n bool(false)
\n [“is_tax”]=>
\n bool(false)
\n [“is_search”]=>
\n bool(false)
\n [“is_feed”]=>
\n bool(false)
\n [“is_comment_feed”]=>
\n bool(false)
\n [“is_trackback”]=>
\n bool(false)
\n [“is_home”]=>
\n bool(false)
\n [“is_404”]=>
\n bool(false)
\n [“is_embed”]=>
\n bool(false)
\n [“is_paged”]=>
\n bool(false)
\n [“is_admin”]=>
\n bool(false)
\n [“is_attachment”]=>
\n bool(false)
\n [“is_singular”]=>
\n bool(true)
\n [“is_robots”]=>
\n bool(false)
\n [“is_posts_page”]=>
\n bool(false)
\n [“is_post_type_archive”]=>
\n bool(false)
\n [“query_vars_hash”:”WP_Query”:private]=>
\n string(32) “3154c94e57c97d55c7111beff41b3ee6”
\n [“query_vars_changed”:”WP_Query”:private]=>
\n bool(false)
\n [“thumbnails_cached”]=>
\n bool(false)
\n [“stopwords”:”WP_Query”:private]=>
\n NULL
\n [“compat_fields”:”WP_Query”:private]=>
\n array(2) {
\n [0]=>
\n string(15) “query_vars_hash”
\n [1]=>
\n string(18) “query_vars_changed”
\n }
\n [“compat_methods”:”WP_Query”:private]=>
\n array(2) {
\n [0]=>
\n string(16) “init_query_flags”
\n [1]=>
\n string(15) “parse_tax_query”
\n }
\n [“tribe_is_event”]=>
\n bool(true)
\n [“tribe_is_multi_posttype”]=>
\n bool(false)
\n [“tribe_is_event_category”]=>
\n bool(false)
\n [“tribe_is_event_venue”]=>
\n bool(false)
\n [“tribe_is_event_organizer”]=>
\n bool(false)
\n [“tribe_is_event_query”]=>
\n bool(true)
\n [“tribe_is_past”]=>
\n bool(false)
\n [“tribe_is_week”]=>
\n bool(false)
\n [“tribe_is_photo”]=>
\n bool(false)
\n [“tribe_is_map”]=>
\n bool(false)
\n [“tribe_is_event_pro_query”]=>
\n bool(false)
\n}<\/p>\n
Query Results:
\narray(0) {
\n}<\/p>\n
is_404() =
\nbool(false)
\n<\/Tribe Events Query><\/p>\n","protected":false},"template":"","class_list":["post-1155763","topic","type-topic","status-closed","hentry"],"yoast_head":"\n