Single event page: duplicate query

A possibile dirty solution could be cashing the main event venue id in a global variable: this way, tribe_get_event_meta is called once instead of sixty times.

src/functions/template-tags/venue.php

function tribe_get_venue_id( $postId = null ) {
$postId = Tribe__Events__Main::postIdHelper( $postId );
if ( tribe_is_venue( $postId ) ) {
return $postId;
} else {
/**
* Allow for customizing the Venue ID retrieved for this item.
*
* @since ??
* @since 4.5.12 Added docblock and venue ID to filter.
*
* @param int $venue_id The Venue ID for the specified event.
* @param int $postId The ID of the event whose venue is being looked for.
*/

/*
* bnkr: cash current post venue_id
*/
global $wp_query, $main_post_venue_id;
if (is_singular( Tribe__Events__Main::POSTTYPE ) && $wp_query->query_vars[‘p’] === $postId) {
if (!$main_post_venue_id) {
$main_post_venue_id = apply_filters( ‘tribe_get_venue_id’, tribe_get_event_meta( $postId, ‘_EventVenueID’, true ), $postId );
}
return $main_post_venue_id;
} else {
return apply_filters( ‘tribe_get_venue_id’, tribe_get_event_meta( $postId, ‘_EventVenueID’, true ), $postId );
}
// return apply_filters( ‘tribe_get_venue_id’, tribe_get_event_meta( $postId, ‘_EventVenueID’, true ), $postId );
}
}

Without this snippet:
Memory usage:
94.225.144 byte (89,9 MB)
70,2% of 128 MB WordPress limit
Database queries
0,0265s
Total: 220
With this snippet:
Memory usage:
92.065.728 byte (87,8 MB)
68,6% of 128 MB WordPress limit
Database queries
0,0219s
Total: 161

• This reply was modified 3 years, 10 months ago by massimomegistus.

Hello @abzlevelup, glad to hear that.
I haven’t contacted the wpml team yet but I will for sure.

I’ve just noticed that, whether WPML is active, when updating an Event (using Gutenberg Editor) this warning appears:

“Aggiornamento fallito. Impossibile aggiornare il valore meta di _EventVenueID nel database.”

In english:
“Update failed. Failed to update _EventVenueID meta value in database.”

Is this a known issue?

Thank you.

Php warnings in debug.log

1) After opening a Edit Event Screen (Gutenberg editor)
[08-Jul-2022 06:50:03 UTC] PHP Notice: Undefined index: post_id in /wp-content/plugins/the-events-calendar/src/views/blocks/event-website.php on line 29

2) After changing Event end time and updating the event
[08-Jul-2022 06:50:47 UTC] PHP Warning: array_filter() expects parameter 1 to be array, bool given in /wp-content/plugins/the-events-calendar/src/Tribe/Editor/Meta.php on line 150
[08-Jul-2022 06:50:51 UTC] PHP Notice: Undefined index: post_id in /wp-content/plugins/the-events-calendar/src/views/blocks/event-website.php on line 29

3) The warning “Update failed. Could not update the meta value of _EventVenueID in database.” appears in the Edit Event Screen