Wrong order of upcoming events

Hey Michael,

Thank you for the inquiry.

We may need to access the site in order to properly check the issue. Please provide the WP and S/FTP details in the private field. In the meantime, please try to edit the enfold/config-templatebuilder/avia-shortcodes/events_upcoming/events_upcoming.php file around line 483.

$query = array(
	'paged'				=> $this->current_page,
	'posts_per_page'	=> $params['items'],
	'start_date'		=> 'now',
	'eventDisplay'		=> 'list'
);

Replace it with:

$query = array(
	'paged'			=> $this->current_page,
	'posts_per_page'	=> $params['items'],
	'start_date'		=> 'now',
	'eventDisplay'		=> 'list'
);

We just replaced start_date with “now”. Let us know if this changes anything.

Best regards,
Ismael

Hi,

Thank you for the info.

We can’t access the server using the FTP account above. We have tried both FTP and SFTP. Please check the info carefully, or provide another account.

We have modified the query it a bit. Please try it again.

$query = array(
	'paged'			=> $this->current_page,
	'posts_per_page'	=> $params['items'],
	'start_date'		=> 'now',
	'eventDisplay'		=> 'list',
        'orderby' => 'meta_value',
        'meta_key' => '_EventStartDate',
        'order' => 'ASC',
        'tribeHideRecurrence' => false
);

Best regards,
Ismael

Hi,

We are still not able to establish an FTP connection, so it is possible that the access may be restricted to specific countries. Please make sure that the server allows access from the following countries (see private field).

Best regards,
Ismael

Hi,

Thank you for the update.

Looks like the events get mixed up when the tax_query is set. To fix the issue temporarily, we reverted the events_upcoming.php file back to default, then added this code in the functions.php file.

add_filter('avia_tribe_events_upcoming', function($query, $params) {
    unset($query['tax_query']);
    return $query;
}, 10, 2);

Best regards,
Ismael

Hi,

We edited the events_upcoming.php file again and adjusted the query. This seems to have corrected the ordering of the events.

$query = array(
	'posts_per_page'	=> $params['items'],
	'start_date'		=> 'now',
	'eventDisplay'		=> 'custom',
	'tribeHideRecurrence' => true
);

Best regards,
Ismael

Hi,

The items are sorted correctly on our end aside from the “Carnaval de Romont” event, which should start on February 2024 but is positioned between March and April 2024. We are not yet sure why this is happening.

Best regards,
Ismael

Hi,

We’ve been adjusting the query for a while, but we can’t get the “Carnaval de Romont” to display where it should. We’ll forward the thread to other mods for further investigation.

Best regards,
Ismael

Hi,

Apologies for the delay. We’ve recreated Carnaval de Romont B, and it appears to be correctly positioned in the right place. Could you please remove the older event and replace it with the one in the private field?

Best regards,
Ismael

Hi YourChoice Informatik GmbH,

It must have been a problem in database – no idea if related to WP or Tribe not updateing a database field that is responsible for ordering.

If such strange things occur it is always a good idea to create a new post/event/entry and delete the old one.

Best regards,
Günter

Hi,
Glad Günter could help, we will go ahead and close this thread as you requested, if you have any further questions please create a new thread and we will gladly try to help you. Thank you for using Enfold.

Best regards,
Mike