Ok figured out the problem. In case anyone is dealing with similar issues:
if ( isset( $query->query_vars['post_type'] ) && ( 'post' === $query->query_vars['post_type'] || is_single() ) ) {
$query->set( 'orderby', 'meta_value' );
$query->set( 'meta_key', 'event_start' );
$query->set( 'order', 'ASC' );
$query->set( 'paged', get_query_var( 'paged' ) );
$query->set( 'posts_per_page', get_option( 'posts_per_page' ) );
$query->set( 'meta_query', array(
'relation' => 'AND',
array(
'key' => 'event_start',
'compare' => '>=',
'value' => date( 'Y-m-d H:i:s', strtotime( '-8 hours' ) ),
'type' => 'DATETIME',
),
) );
}
return $query;
Only paged and pages_per_page had to be added. Now it is working proplery.
