Patrick

Hi @antabeacon,

We haven’t heard from you in a while, so I’m going to go ahead and close out this thread for now. If you’re still having trouble, feel free to respond here at your convenience and we’ll be happy to help.

Have a great day!

Hi @bradley,

Thanks for letting us know, I’m happy to hear that this is working on your end.

Once we have the update available, you can safely disable the snippet.

Cheers!

Hi @wpquizzical,

Thanks for reaching out to us.

Looking at the shared SPF record, it appears to be correct and should not have any impact on performance on your end.

Regarding your query on the second part, include:dc-aa8e722993._spfm.mysite.com points to another service your host may use to send emails. If you send emails via another service, keep it, and if you do not have any extra service sending emails, you can remove it to reduce extra DNS lookups.

I hope this helps

Hi @ads97129 and @bradley,

Our development team has confirmed an issue with the event date and time queries when displaying events on the Event List block. They’re working on a fix, which will be included in the next release.

In the meantime, you can use the custom snippet below to fix this issue.

function sc_lite_fix_missing_events_in_upcoming_events_block( $upcoming_events, $args, $atts ) {

	if (
		! function_exists( 'sugar_calendar' ) ||
		sugar_calendar()->is_pro()
	) {
		return $upcoming_events;
	}

	global $wpdb;

	$calendars_left_join = '';
	$where_calendars     = '';

	// Get the category left join and where queries if necessary.
	if ( ! empty( $args['calendar_ids'] ) ) {
		$term_taxonomy_ids = array_filter( array_map( 'absint', $args['calendar_ids'] ) );

		if ( ! empty( $term_taxonomy_ids ) ) {
			$calendars_left_join = 'LEFT JOIN ' . $wpdb->term_relationships . ' ON ' . $wpdb->prefix . 'sc_events.object_id = ' . $wpdb->term_relationships . '.object_id';
			$where_calendars     = $wpdb->prepare(
				'AND ( ' . $wpdb->term_relationships . '.term_taxonomy_id IN (%1$s) )',
				implode( ',', $term_taxonomy_ids )
			);
		}
	}

	$select_query = 'SELECT ' . $wpdb->prefix . 'sc_events.id FROM ' . $wpdb->prefix . 'sc_events';

	if ( ! empty( $calendars_left_join ) ) {
		$select_query .= ' ' . $calendars_left_join;
	}

	$now   = sugar_calendar_get_request_time( 'mysql' );
	$today = gmdate( 'Y-m-d 00:00:00', strtotime( $now ) );

	$where_query = $wpdb->prepare(
		'WHERE ' . $wpdb->prefix . 'sc_events.status = "publish" AND ' . $wpdb->prefix . 'sc_events.object_subtype = "sc_event" AND ' . $wpdb->prefix . 'sc_events.start >= %s AND ' . $wpdb->prefix . 'sc_events.end >= %s',
		$today,
		$now
	);

	if ( ! empty( $where_calendars ) ) {
		$where_query .= ' ' . $where_calendars;
	}

	if ( ! empty( $args['search'] ) ) {
		$where_query .= $wpdb->prepare(
			' AND ' . $wpdb->prefix . 'sc_events.title LIKE %s',
			'%' . $wpdb->esc_like( $args['search'] ) . '%'
		);
	}

	$order_by = $wpdb->prepare(
		'ORDER BY ' . $wpdb->prefix . 'sc_events.start ASC LIMIT %d OFFSET %d',
		$args['number'],
		$args['offset']
	);

	$final_query = $select_query . ' ' . $where_query . ' ' . $order_by;

	// The query below is prepared/sanitized individually.
	// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
	$event_ids = $wpdb->get_results( $final_query );

	if ( empty( $event_ids ) ) {
		return [];
	}

	$sugar_calendar_events_args = [
		'id__in'  => wp_list_pluck( $event_ids, 'id' ),
		'orderby' => 'start',
		'order'   => 'ASC',
	];

	return sugar_calendar_get_events( $sugar_calendar_events_args );
}

add_filter( 'sugar_calendar_helpers_get_upcoming_events_list_with_recurring', 'sc_lite_fix_missing_events_in_upcoming_events_block', 100, 3 );

Could you please try it out and let us know how it goes?

Kind regards.

Hi @water4better,

Thanks for getting in touch, and we are sorry to hear about your experience. We always strive to resolve our customers’ issues in the shortest time possible. I reviewed the conversations on our end and while I couldn’t confirm your specific query, I can confirm that we responded to all the queries raised.

If you don’t mind me following up on this, if you’re still facing an issue, could you please reach back out to our support so that we can take a look at your issue?

Kind regards.

Hey @malferov,

I received an update from the team and they confirmed that the deprecation error with PHP 8.4.5 has been noted and they will be fixing it in future releases.

Kind regards.

Hey @lsalvatorianos,

Thank you so much for your kind words! We’re thrilled to hear that our plugin works perfectly for you and that you found it easy to install.

Regards.