Support

Home Forums Event Espresso Premium Can't delete transactions

Can't delete transactions

Posted: January 12, 2018 at 9:46 am


elabo

January 12, 2018 at 9:46 am

I’m still have 2 registrations locked i wan’t to delete.
I’ve got 10 transactions. I check all transactions, there is no payments i can’t delete.
And there is a bug on count :
Transactions list


Josh

  • Support Staff

January 12, 2018 at 9:54 am

Hi Eddy,

The reason the count is wrong is because associated data has been deleted. I’m afraid Event Espresso 4 does not have the ability to do cascading deletes (yet). So when you delete a registration, the associated transaction isn’t deleted. And as you’ve seen, there’s no UI to delete a transaction.

If you’re looking to delete everything, as in all events, all registrations, all transactions, to start with a completely clean slate, you can head over to Event Espresso > Maintenance > Reset and click the button to reset Event Espresso’s tables.

Your other option would be to use a database tool to manually remove transactions and registrations from the database. These are stored within the esp_registrations and esp_transactions table, with related data stored in the esp_registration_payment and esp_payment tables.


mjpaynter

January 22, 2018 at 8:55 pm

I’m having the same issues – unable to delete several transactions and a few registrations. I do not want to delete all of my event data, but I do want a clean slate with registrations and transactions. Can you confirm it is safe to delete all data from the following tables without impacting the events themselves or throwing any public-facing errors?

esp_registration
esp_transaction
esp_registration_payment

Please note: The esp_payment table doesn’t exist in my database.

Thanks


Josh

  • Support Staff

January 23, 2018 at 8:32 am

Hi there, I can confirm it is not safe to delete all data from those tables. This is because you’ll end up with orphaned data from other tables (like the wp_posts table where it has Contact related data that’s associated with registrations).

The support post ‘Can't delete transactions’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3

Documentation for Event Espresso 4

Status: closed

Updated by  Josh 1 year, 8 months ago ago

Topic Tags

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!