Support

June 3, 2017 at 9:12 pm

Hi, I had been using an old EE_Event_List_Query on my client’s home page to get the next 3 upcoming events. Each event displayed the Event Name, Link, Date and Thumbnail.

Upgrading EE4 to 4.9.39.p seems to have broken that query. I’ve since moved on to the following, but for some reason cannot get the date to display at all (the page display gets thrown off and no dates are shown):

<?php
// set up show expired = false
$where = array(
	'Datetime.DTT_EVT_end' => array( '>=', current_time( 'mysql' )),
	'status' => 'publish',
);
// run the query
if ( class_exists( 'EE_Registry' ) ) :
// Load Event View Helper
EE_Registry::instance()->load_helper('Event_View');
$events = EE_Registry::instance()->load_model( 'Event' )->get_all( array(
	$where,
	'limit' => 3,
	'order_by' => 'Datetime.DTT_EVT_start',
	'order' => 'ASC',
	'group_by' => 'EVT_ID'
));
// the loop
if ( ! empty( $events )) {
	foreach ( $events as $event ) {
	
	
	
		if ( $event instanceof EE_Event ) {
			echo '<div class="column one_fourth" style="margin-right:0%;">';
			echo '<h4><a href="' . get_permalink( $event->ID() ) . '">' . $event->name() . ' &raquo;</a></h4>';
			echo '</div>';
		 }
	}
} 
endif; ?>   

Do you have any suggestions on how I might get the date and thumbnail in this query? I’ve done some searching but everything I try seems to produce this same crash, with no errors in the console.