|
David Waterman
|
August 1, 2013 at 10:04 am
After we create a recurring event series and come back later how can we add / remove events. We have a new installation, on WP 3.5.2 Dev License.
|
|
Josh
|
August 1, 2013 at 10:52 am
Hi David,
After a recurring event series is created you can delete individual events with the delete event action in the event overview.
If you used the create dates automatically option you can add more events by changing the first event date or last event date.
If you used the select dates manually option it gives you additional fields each time you add a date.
In either case, since you are making changes to the recurrence formula, you will need to select “All events in the series” or “All upcoming events” for the changes to take effect.
|
|
David Waterman
|
August 1, 2013 at 2:22 pm
True, after further research the problem is that the following fields in the wp_events_recurrence table must have a value (cannot be null) but the form is not populating values for these fields:
recurrence_start_date
recurrence_event_end_date
recurrence_end_date
As a result, the table is completely blank. None of the data is making it there because the insert statement is failing.
We have attached a link to screenshots of the table structure – showing that these fields can not be null – and the empty record set showing a blank table. So we don’t see these options, we see the events but obviously they are not loaded into the database correctly so that is causing our issue. Any idea why we are getting these db issues? http://easytorsvp.com/ee-error-screenshots/
|
|
Josh
|
August 1, 2013 at 3:37 pm
I haven’t seen this happen before. What version of MySQL is it running?
|
|
David Waterman
|
August 1, 2013 at 4:43 pm
We are running MySQL version 5.1.
|
|
Josh
|
August 2, 2013 at 8:49 am
Okay, I wanted to get that out of the way just in case there was a really old version of mySQL. While it does help to know that you’re trying to manually create the dates. I’ve tried to reproduce this a few different ways and it’s not happening.
The manual date create feature will insert a value of 0 for the dates that would normally be used to calculate the dates automatically.
Here are a few steps you can try that might help troubleshoot this:
1) Turn on WP_DEBUG in the wp-config.php file
2) Go in to create a new event, select “This is a recurring event”
3) Leave it on automatic and enter 0 for First Event Date, First Event End Date, and Last Event Date
4) Switch to Manual date mode
5) Enter some dates manually
6) Click Submit New Event
|
