Hello, I hope you are doing well.<\/p>\n
I had an issue with the previous event link on my website, the issue was that the previous link was “looping” between two events from the same day. I found out how to fix it but I wanted to let you know so you can investigate.<\/p>\n
– The WordPress timezone is set to Los Angeles
\n– Function: get_event_link() in Tribe\/Main.php
\n– $post->EventStartDate is set to “2015-12-02 23:00:00”
\n– in the DB, _EventStartDate is set to “2015-12-02 15:00:00”
\n– in the DB, _EventStartDateUTC is set to “2015-12-02 23:00:00”<\/p>\n
The issue is that the query needs to compare $post->EventStartDate with _EventStartDateUTC and not _EventStartDate. I fixed the issue by changing to following code:<\/p>\n
Let me know if it helps.<\/p>\n Thank you,
\n$args = array(
\n\t'post__not_in' => array( $post->ID ),
\n\t'order' => $order,
\n\t'orderby' => \"TIMESTAMP( $wpdb->postmeta.meta_value ) ID\",
\n\t'posts_per_page' => 1,
\n\t'meta_query' => array(
\n\t\tarray(
\n\t\t\t'key' => '_EventStartDateUTC',
\n\t\t\t'value' => $post->EventStartDate,
\n\t\t\t'type' => 'DATETIME',
\n\t\t\t'compare' => $direction,
\n\t\t),
\n\t\tarray(
\n\t\t\t'key' => '_EventHideFromUpcoming',
\n\t\t\t'compare' => 'NOT EXISTS',
\n\t\t),
\n\t\t'relation' => 'AND',
\n\t),
\n);
\n<\/code><\/p>\n
\nMatt<\/p>\n","protected":false},"template":"","class_list":["post-1028773","topic","type-topic","status-closed","hentry"],"yoast_head":"\n