|
Bonnie
|
May 23, 2017 at 2:56 pm
I’m trying to delete two years of camp registrations. I followed the instructions here:
https://gist.github.com/lorenzocaum/8b338e0474f83d522b96
And successfully deleted the payments.
Then I went to the site and searched for 2015 registrants. Found them and clicked on “Trash Registrations”. I thought I’d moved them all, but then noticed the trash link only showed 48 registrations, when I’d moved well over 150.
I clicked on the trash link and permanently deleted everything in there.
Then I went back to the registrations page and selected those registrations I wanted to delete. Selected over 40, but only 4 showed up in the trash bin. I deleted those.
Now nothing I move to trash actually goes into the trash, which always remains set to “0”.
I deactivated the plugin and reactivated it but no joy. Any assistance would be appreciated.
|
|
Josh
|
May 23, 2017 at 3:04 pm
Hi Bonnie,
When you view the list of registrations do any of the older registrations (the ones you’re trying to delete) have a padlock by the checkbox?
|
|
Bonnie
|
May 23, 2017 at 4:35 pm
Nope. I successfully removed the padlocks by following the directions on deleting payment records with PHPmyAdmin, so these registrations are padlock-free.
|
|
Josh
|
May 24, 2017 at 11:18 am
Are there any error messages that display when you try to trash the registrations?
|
|
Bonnie
|
May 24, 2017 at 11:28 am
No error messages, nothing. I click on the “Trash Registrations” link, the page reloads, and the registrations are still there.
|
|
Bonnie
|
May 24, 2017 at 11:44 am
Some more information:
I just went through the registrations that are undeletable. They are all marked as “overpaid”… when I drill down into each individual registration, I’m given the option to “apply a refund.”
However, I don’t want to try applying a refund because 1) I am concerned the registrant will be issued a refund and 2) there are 120 transactions that I would need to apply a refund to, and no bulk way to do it.
I just experimented with setting those “overpaid” transactions to “pending Payment” which changed their status from “overpaid” to “complete”. Then I tried deleting those registrations, but the trash can still shows “0” and the registrations are still there.
|
|
Josh
|
May 24, 2017 at 11:47 am
Can you complete the form on this page so we can investigate further?
Please include a few of the Registration ID’s of the registrations that you’re trying to move to the Trash bin.
|
|
Bonnie
|
May 24, 2017 at 12:14 pm
Okay, all sent.
|
|
Bonnie
|
May 24, 2017 at 12:56 pm
Oops, just added the link to some of the registrants I need deleted.
Oh, wait.. you just need IDs.
So here’s some more info: I just tried downloading a filtered June 2015 report to quickly get some IDs and got a 406 error… and yet the report downloaded anyway… and the report only contains our 2017 registrants.
You can still see the 2015 and 2016 registrants within the Dashboard, though.
|
|
Josh
|
May 24, 2017 at 12:59 pm
Hi Bonnie,
I’m seeing this error displayed when I try to trash any of those older registrations:
An error has occurred:
The registration for {name} could not be trashed because it has payments attached to the related transaction. If you wish to trash this registration you must first delete the payments on the related transaction.
I sent a note to Lorenzo and asked him to update the instructions he put together because it seems they are missing some steps.
|
|
Bonnie
|
May 24, 2017 at 1:22 pm
Perhaps he needs to know that I did successfully delete payments in the database using his query parameters, and now when I search using those parameters, no payments come up.
Just throwing everything at the wall, hoping that something will stick!
|
|
Josh
|
May 24, 2017 at 1:25 pm
I don’t doubt that you followed those instructions. The problem is the instructions you followed were not complete.
|
|
Josh
|
May 24, 2017 at 5:54 pm
Hi Bonnie,
Can you change the FTP account that you sent so that it gives us access to where the WordPress /plugins/folder is located on your server? The reason I ask is because the FTP account that was sent gives us access to an empty folder.
|
|
Josh
|
May 25, 2017 at 9:56 am
Hi Bonnie,
You will be able to move those older registrations to the trash now. The reason the registrations weren’t going into the trash is because they still had relationships recorded in the _esp_registration_payment table. The instructions in that gist failed to mention the need to delete those relationships.
|
|
Bonnie
|
May 25, 2017 at 11:16 am
Thank you, Josh. Would you let me know when they are updated because I’ll need to use them to remove this year’s registrants at the end of our summer camp season.
Thank you for all your help!
|
|
Josh
|
May 25, 2017 at 11:57 am
Hi Bonnie,
Instead of going in and manually deleting those payments, you can actually go to Event Espresso > Maintenance > Reset and delete everything at the end of your summer camp season.
|
|
Bonnie
|
May 25, 2017 at 12:03 pm
Ah, but Josh!
If I do that then I lose all my hard work on the camp sessions. They’re the same from year to year.
|
|
Josh
|
May 25, 2017 at 1:00 pm
OK I’ll put in a request for a bulk delete registrations/payments feature. The documentation from Lorenzo was missing a few steps. Besides that, going into the database and manually going through and deleting data can be fraught with errors so the way forward will be to have a bulk delete feature for registrations.
|
