Latest update wiped data

[Alex Steer]

Hi,

Stephen I applied your latest update 2.13.5 and after all my events and bookings were gone????

Having to resore from a backup.

Any ideas?

[Stephen Harris]

Hi Alex,

The only relevant change was to register the database tables early (see this thread: http://wp-event-organiser.com/forums/topic/eo_get_the_occurrences_of-not-working-with-wpdb-eo_events/).

However this alone would not cause the issue you describe. When you say events/bookings are gone, do you mean they were deleted from the database or just not viewable? I think the latter would make more sense but again, the update itself wouldnt have caused this. But I’m happy to help you investigate this further.

[Alex Steer]

Not 100% sure the update was the cause yet – still looking at it.

All bookings and event data was missing from the wp_admin and frontend – However I believe the data remains in the database.

I have been working with my host all day to resolve and had to revert back to an old backup to get the site going again.

The host has asked if could you provide an sql script so we can add the newer data to the rebuild, they weren’t sure which tables needed to updated and copied.

[Stephen Harris]

It would probably be best to a full database rebuild. But on top of the default WordPress tables there are the following tables:

• eo_events
• eo_venuemeta
• eo_booking_tickets
• eo_booking_ticketmeta

The exact names will depend on the prefix of your wp-config.php file.

[Alex Steer]

Are these tables the only that have reference or link to bookings?

[Stephen Harris]

Bookings are in the posts table. So you’ll want to include post_meta too. Bookings made by a logged-in user, will reference a user ID too.

[Author]

Posts