• Resolved jacksonsky

    (@jacksonsky)


    A client accidentally deleted an event that already had a large number of registrants, etc. Is there any way to restore an event that’s been deleted? Or find a list of those people who have registered?

    Thank you.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Franky

    (@liedekef)

    Sorry but no, when an event is deleted it is immediately removed from the db (and the corresponding registrations too). I ask for confirmation before actually deleting it, but after that it’s gone.
    Maybe I should also implement a type of trash for events too (like for people and bookings), but that won’t help you now.
    You could restore a database backup …

    Thread Starter jacksonsky

    (@jacksonsky)

    Thank you for the quick reply. Yes, a trash folder where you can restore events would be great for a situation like this. In the meantime, we will just restore the database and try to figure out who has registered for the other events between the restore and now.

    Ambyomoron

    (@josiah-s-carberry)

    Franky, instead of restoring a whole backup database, is it also possible to export from the backup those rows in those tables that correspond to the deleted event and registrants and import them into the current production database? If so, is there anything to be careful about, other than the import order to maintain referential integrity?

    Plugin Author Franky

    (@liedekef)

    That would require knowing the event id for the events table (so searching in the backup and taking that one row) and the corresponding bookings (based on the event id) in the bookings table. Also if optional fields were used in the form: for each booking you’d need the booking id and look up the corresponding rows in the eme answers table. That’s about it. Take care to not change the auto-increment when importing of course …

    Plugin Author Franky

    (@liedekef)

    FYI: the next release will have trash/restore functionality for events.

    Plugin Author Franky

    (@liedekef)

    Version 2.1.40 now has trash/restore for events.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Restore Deleted Event?’ is closed to new replies.