Support

March 23, 2017 at 3:28 am

I finally found the solution to a very long lasting issue in EE3.
The db gradually adds up orphan prices and tickets which become default prices and tickets prices when you create a new event.

It has been reported before:
https://eventespresso.com/topic/unwanted-multiple-event-pricing-and-event-times-when-creating-new-event/
https://eventespresso.com/topic/add-event-displays-57-start-times-how-to-get-rid-of-them/#post-157228
https://eventespresso.com/topic/new-events-are-created-with-multiple-event-times-listed-ee3/

The issue comes from the event-identifier field. This field has a limited length in the db. When you create an event with a long title, EE creates a default event identifier by concatenating the title and event id. When it is too long the script stops but the pricing and times are already added to the db and become orphan.

My temporary solution was to have an overnight query removing the orphan prices and times but you can get rid of this problem with the changes below.

My solutions:
In the plugin/event-espresso/includes/event-management/insert_event.php

Change near line 80:
—THIS—
if (!isset($_REQUEST[‘event_identifier’]) || $_REQUEST[‘event_identifier’] == ”){
$event_identifier = sanitize_title_with_dashes($event_name . ‘-‘ . $event_code);
}else{
$event_identifier = sanitize_title_with_dashes($_REQUEST[‘event_identifier’]) . $event_code;
}

—TO THIS—
if (!isset($_REQUEST[‘event_identifier’]) || $_REQUEST[‘event_identifier’] == ”){
$event_identifier = sanitize_title_with_dashes(substr ( $event_name , 0 , 20 ) . ‘-‘ . $event_code);
}else{
$event_identifier = sanitize_title_with_dashes($_REQUEST[‘event_identifier’]) . $event_code;
}

I hope it helps someone.