|
dmc
|
February 5, 2020 at 10:30 am
I want to delete events and registrations from past years
start with deleting a transaction then trash the registration
the trash step results in a wordpress critical error with learn more about debugging in wordpress message
the registration remains
how do i recover from this error?
is there a better way to remove past events and registrations?
|
|
Josh
|
February 5, 2020 at 11:12 am
The error may be from deleting the transaction, there isn’t actually a User Interface for deleting a transaction.
A yet-to-be released feature we’re working on will have a better way to remove past events where you’ll simply trash and event, then when you permanently delete the event it will automatically delete all related registrations and transactions. If you’d like to test that feature out before its release please let us know and we can show you how to install that version onto a testing/staging site.
|
|
dmc
|
February 5, 2020 at 1:08 pm
excellent i look forward to the release of this new feature
my application is for an annual convention – so i don’t need to retain older entries
i think my current error is created because i had deleted the event (at that time expecting the transactions and registrations to be also deleted)
so now i have registrations without an event – so i can’t delete those registrations and the error is returned
any guidance?
|
|
Josh
|
February 5, 2020 at 3:02 pm
Did the Trashed events page actually let you do the permanent delete of the event? Usually that page will not let you permanently delete an event if there are registrations.
|
|
dmc
|
February 5, 2020 at 6:04 pm
yes somehow the event is no longer listed, not sure how that happened at all
|
|
Josh
|
February 5, 2020 at 6:13 pm
May I ask do you have a backup of the database from before you started deleting things?
|
|
dmc
|
February 5, 2020 at 6:59 pm
somehow i removed that event sometime ago – i’m not sure how long ago, but before the most recent event for sure.
so going back is not really feasible
|
|
Tony
|
February 6, 2020 at 2:29 am
Just to be really clear, if you go to Event Espresso -> Events
Along the top of the event list table, you’ll see some filters – ‘View All Events’, ‘Draft’, ‘Trash’, etc.
Is the event not listed in the Trash list?
If you view a registration for this event in the registration list, what does it show under the ‘Event’ column, like this – https://monosnap.com/file/tLK9tGN0kwl6PdW5wuScdHWZnrPpCi
|
|
dmc
|
February 6, 2020 at 10:59 am
there are no events in my event trash
with view all – there are only 3 events, 2019 – 2018 – 2017
when i view all registrations and filter with march 2015
under event column – No Associated Event
under event date – April 30, 2015 8:00 am
i did have events in 2014 and 2015 – but somehow those events are gone but the registrations and transactions remain
the 2016 event, registrations, transactions have all been removed
i think i removed those one at a time
|
|
Josh
|
February 6, 2020 at 11:01 am
If you do have a database backup, you could selectively restore just the events that were deleted, which will avoid the orphaned data issues you’re having now.
|
|
dmc
|
February 6, 2020 at 3:20 pm
Hi Josh,
is there any other way to clean up orphaned data?
I am not comfortable with selective restoring databases
thanks
|
|
Tony
|
February 7, 2020 at 4:29 am
Not without doing it manually in the database (which would be more work than the above).
By deleting the event any data the relies on that relationship is now broken within the EE UI, meaning EE can not be used to remove them from the database.
Do you need to keep any of the EE data you currently have?
There is an option in EE to drop all of its tables and rebuild them, meaning it will be as if EE was just installed on the site and you’ll need to set up any settings/payment methods/messages etc which aren’t the defaults.
|
|
dmc
|
February 7, 2020 at 9:18 am
i don’t need to keep any transactions or registrations
as it is an annual event – i copy event tickets, registration form, payment
is there a way to retain that portion
|
|
Tony
|
February 10, 2020 at 3:28 am
Not really no, you’d need to selectively copy those details from the database, export them and then import them back. You mentioned you’re not comfortable doing that above and it would likely take longer to manually pull those details than it could to rebuild them.
You could copy the site locally so you have everything as it is now, reset EE4 on the live site and then manually copy the details from the local site to the live site (as in using the UI to copy specific sections as you work through them, not export and import in a single step).
So you can either:
1. Reset EE and remove all of the details to start fresh.
2. Selectively restore the events in question from backup to allow the EE UI to delete the registrations (and related data).
3. Selectively export the event tickets, registration form, payment (I’m not sure what payment relates to exactly but it can likely be exported if needed) reset EE4 and then import those details back.
Option 1 is likely the quickest to do.
2 leaves all of your data intact but requires database manipulation.
3 Brings back some of you data after the reset but requires database manipulation and a fairly in-depth understanding of EE’s database structure as you’ll be dealing with many more relationships than option 2.
|
