Support

Home Forums Event Espresso Premium Creating an event with Multiple Start Times

Creating an event with Multiple Start Times

Posted: January 6, 2016 at 8:35 am


britorthopaedic

January 6, 2016 at 8:35 am

When creating an event in EE3, start and end times are populated over 2000 times, which makes it impossible to create an event. Can you advise?

Melanie


Josh

  • Support Staff

January 6, 2016 at 1:35 pm

Hi Melanie,

It turns out those pre-populated start and end times are the result of not updating to the current version of Event Espresso 3, then trying to create new events with the older version. Those will need to be cleared out from the database. Are you familiar with using phpmyAdmin? If so I can give you instructions on how to remove those. If not, someone from Event Espresso support staff can remove them if you can completely fill out the secure form on this page:

https://eventespresso.com/send-login-details/


britorthopaedic

January 7, 2016 at 3:51 am

Hi Josh

Yes I can use Phpmyadmin and know sql so please send me the script to fix this.

Thanks

Melanie


Lorenzo Orlando Caum

  • Support Staff

January 7, 2016 at 1:36 pm

Hi Melanie,

Try these steps:

1) Backup your WordPress site including the database (https://eventespresso.com/wiki/how-to-back-up-your-site/)

2) Deactivate Event Espresso through the Plugins screen in your WP dashboard

3) Login to your database using a tool like PHPMyAdmin

4) You’ll be making changes to three database tables:

wp_events_start_end
wp_events_prices
wp_events_category_rel

Go ahead and locate the wp_events_start_end database table and click on it. Then click on the event id column to sort and you’ll see some rows that have 0 (zero) for the event id. Remove only these rows that have 0 for the event id.

5) Locate the wp_events_prices database table and click on it. Then click on the event id column to sort and you’ll see some rows that have 0 (zero) for the event id. Remove only these rows that have 0 for the event id.

6) Locate the wp_events_category_rel database table and click on it. Then click on the event id column to sort and you’ll see some rows that have 0 (zero) for the event id. Remove only these rows that have 0 for the event id.

7) Return to your WordPress dashboard and then reactivate Event Espresso 3 along with its add-ons.

Thanks


Lorenzo

The support post ‘Creating an event with Multiple Start Times’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso