|
mjpaynter
|
January 5, 2017 at 8:45 am
I’m trying to delete a registration but it says I must delete the transaction first. However, it appears as though the transaction has already been deleted. Not sure where to go from here. Any help would be greatly appreciated.
|
|
Josh
|
January 5, 2017 at 10:36 am
May I ask, what happens if you view the Registration page, then click the View Transaction button?
|
|
mjpaynter
|
January 5, 2017 at 11:00 am
I try to delete the payment, and I get the error below. I think there are two registrations for two separate events linked to one transaction, but I’m getting this loop where I can’t delete one until I delete the other and visa versa.
The following errors have occurred:
This Payment is currently linked to one or more Registration records. If this Payment is incorrect, then please remove it from all Registrations before attempting to delete it.
EEM_Base – delete_is_blocked_by_related_models – 1892
The payment could not be deleted.
EE_Transaction_Payments – delete_payment_and_update_transaction – 172
Further – is there a way to delete all registrations and transactions? We were in a development setting and we’ll be looking to start fresh soon.
|
|
Tony
|
January 6, 2017 at 11:51 am
Can I take a look at transaction in the admin? If so you can send temporary login details using this form: https://eventespresso.com/send-login-details/
Further – is there a way to delete all registrations and transactions? We were in a development setting and we’ll be looking to start fresh soon.
Not without removing all of the current EE data.
We have a rest feature in EE that removes everything from the tables but that includes events and all settings.
|
|
Josh
|
January 6, 2017 at 1:18 pm
So that’s what you’re seeing when you try to delete a payment, but what happens after you click on the “View Transaction” button from the Registration entry? Does it load the Transaction page and display Transaction information?
Everything Event Espresso-related can be deleted by going to the Event Espresso > Maintenance page, then on the Reset tab there are some options to delete Event Espresso data.
|
|
mjpaynter
|
January 10, 2017 at 9:36 am
From the registration entry, after clicking the “View Transaction” button, I am taken to the transaction page, but for another event registration. Looks like the original registration was moved to this other event because at the bottom under “Attendees Registered In this Transaction” it’s actually the second item “Circle for Awakened Hearts” that I’m unable to delete the registration for.
Registration I’m Trying to delete: http://akashasden.com/wp-content/uploads/2017/01/Screen-Shot-2017-01-10-at-11.32.59-AM.png
Where I land when I click View Transaction button from above screenshot: http://akashasden.com/wp-content/uploads/2017/01/Screen-Shot-2017-01-10-at-11.28.04-AM.png
|
|
Josh
|
January 11, 2017 at 9:06 am
You’ll need to click on the little trash can icon next to the payment in the Transaction view first. After that, you’ll be able to delete those registrations.
|
|
mjpaynter
|
January 12, 2017 at 9:17 am
Sorry if I wasn’t clear…this is the process I tried from the start before contacting support. The issue is this is the error I get when I click the trash can icon.
http://akashasden.com/wp-content/uploads/2017/01/Screen-Shot-2017-01-12-at-11.15.06-AM.png
Hence the weird loop of my not being able to delete the transaction or the registration.
|
|
Josh
|
January 12, 2017 at 2:14 pm
OK so there’s a few extra steps to make sure the payment gets removed from the first registration. Here are the full steps:
1) Look up the original registration and set its status to Pending Payment.
2) Go to view the transaction, which is this screen, and click on the little pencil icon that’s to the left of the trash can icon
3) This will open the payment edit screen, and you’ll look for
Registrations to Apply Payment to:
and you select:
Just the following Registrations
4) You uncheck the boxes in the Apply column, then you click on Save Payment Details.
Now you’ll be able to delete the payment (by clicking on the trash icon that’s on the View Transaction page). You’ll also be able to trash both registrations.
|
|
mjpaynter
|
January 19, 2017 at 1:18 pm
This is the error I get and both transactions are still padlocked. Please advise.
The following errors have occurred:
Payment 24 has not been successfully saved to the database.
Transactions_Admin_Page – _create_payment_from_request_data – 1465
The payment was processed successfully but the amount paid for the transaction was not updated.
Transactions_Admin_Page – _process_transaction_payments – 1492
|
|
Josh
|
January 19, 2017 at 2:25 pm
There should only be one transaction, with two registrations. What’s the registration statuses for those registrations set to at the moment?
|
|
mjpaynter
|
January 19, 2017 at 2:56 pm
Both are pending payment.
|
|
Josh
|
January 20, 2017 at 7:07 am
If you can complete the secure form on this page, we can go in and delete those.
|
|
Josh
|
January 23, 2017 at 5:32 pm
OK the payment on the transaction has been deleted, and the registrations have been moved to the trash.
|
|
mjpaynter
|
January 23, 2017 at 8:27 pm
Thank you very much for this. However, there are several registrations/transactions that are “stuck” like this. Basically, I’m trying to start from scratch by clearing out all registrations. I also need to know how to prevent this from happening in the future. What exactly was the cause so that I can ensure it doesn’t continue to happen? Thanks so much for the support!
|
|
Josh
|
January 24, 2017 at 8:49 am
So how that happens is when you use the Attendee Mover to move a registration from one event to another, you need to remove the payment from the first registration. Once you remove the payment from the first registration (by editing the payment as outlined above), you can delete the payment.
|
|
mjpaynter
|
January 31, 2017 at 2:29 pm
Okay – I’m pretty frustrated here. Your instructions aren’t working for me.
1) Go to Registration page
2) Change Reg Status to “Payment Pending”.
3) CliCK View Transaction
4) Click the Pencil next to the transaction
5) Uncheck the box(es) that are checked (there are never any boxes to uncheck)
6) Click the trash can to delete the transaction
7) Go back to the Registration and delete
What am I missing because every, single time I get an error message when trying to delete the transaction.
Can I just go into a database table and delete all transactions and registrations? What tables would I need to empty?
|
|
Josh
|
February 1, 2017 at 8:48 am
With steps 1 & 2, are you changing both registrations that are attached to that transaction?
If you go into the database table and delete there, it’s really tricky to do that right because of all the relationships between tables.
|
|
Josh
|
February 1, 2017 at 8:49 am
With steps 1 & 2, are you changing both registrations that are attached to that transaction?
If you go into the database table and delete there, it’s really tricky to do that right because of all the relationships between tables.
|
|
mjpaynter
|
February 1, 2017 at 9:06 am
Okay – so I was able to clear out most of them. On some of the cancelled registrations, “Payment Pending” wasn’t an option. The work around was to change status from CANCELLED to NOT APPROVED and then PAYMENT PAYMENT became an option again.
I have one last transaction that’s giving me problems. I’m getting the following error on the transaction page after setting all three registrations to “PAYMENT PENDING”. This error is not allowing me to select the pencil icon and is preventing the list of registrations from displaying.
Fatal error: Call to a member function name() on boolean in /home/akashasd/public_html/wp-content/plugins/event-espresso-core-reg/core/db_classes/EE_Ticket.class.php on line 1096
|
|
Tony
|
February 1, 2017 at 9:47 am
We added a fix to prevent that error in 4.9.26 so it looks like you’re on an older version?
If you update to the latest version (currently 4.9.29) that error should no longer be thrown.
|
|
mjpaynter
|
February 4, 2017 at 2:34 pm
That cleared everything up. Thanks so much for all your help and patience!
|
