Support

January 20, 2014 at 8:51 am

Hi Sean,

Can you check the PHP error log for errors at the times the registration page was blank? There may have been a fatal error that was thrown at that time, and the error message will help narrow down the issue.

January 20, 2014 at 12:29 pm

That’s a lot of memory. Does the event overview load up when you go to Event Espresso>Event Overview. How many events load up there?

January 20, 2014 at 12:45 pm

Can you use the filter to load up the deleted events, then permanently delete them?

January 20, 2014 at 2:56 pm

Hi Sean,

I’ve been monitoring this thread all day and replying as soon as possible. If the database update script timed out while updating the last version of Event Espresso then part of the problem may be there isn’t a backup of the database to revert to. We’ll do the best we can with what we have. There are instructions on how to export the database here:

https://eventespresso.com/wiki/how-to-back-up-your-site/

January 20, 2014 at 6:37 pm

Hi Sean,

I posted our email address in the above reply where you can send it to.

Support staff can try to determine if the database was affected by the running the update if you export a copy of the database and email it to support@eventespresso.com

January 21, 2014 at 11:15 am

Thanks for sending. The data was extremely helpful in tracking down the cause. It turns out that on January 16, over 9100 events (Mini Matisse Blue) were added in one go to the database. Adding this many events may not have been the intent, but recurring event manager was set to create a new event for the next 9157+ days. This operation likely timed out, and it’s why you’re seeing the event-registration page go blank when it tries to load. Also the dates on these events are set to years like “0007”

The simplest way I can think of to fix this is to delete the event series and re-add it (with fewer events and correct dates) Normally it’s possible to go in and delete a recurring event series by going into the Event Overview and clicking the “Delete all events in this series”. That might be possible in this case, but from my tests it took a few attempts (each attempt would time out eventually, but it will eventually delete all the events). Alternatively they could be dropped via the mySQLadmin interface by running a query on all the events with the recurrence_ID of 2, then deleting them.

Here are a few tips that will help when you go in and delete this event series:

1) Please backup the database first
2) It will help to put the site in maintenance mode (there are plugins that do this) because the site will become slow and unresponsive while this is done.
3) You can deactivate all the other plugins before going in to delete these events to free up some memory.
4) When you go into the event overview, you will not initially see the events because the dates are set so the events have already happened, so you can set the filter status to show ALL (Active/Inactive) events.
5) As mentioned earlier, the script will likely time out when you try to delete all of these 9157 events, but if the admin hangs up, close the tab and try deleting the series again and it will delete some more events.

January 21, 2014 at 1:18 pm

You go in and delete a recurring event series by going into the Event Overview and click the “Delete all events in this series” link.

January 21, 2014 at 2:35 pm

With that many events, it would be good to go into PHPmyadmin and run a query: