|
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 :
|
|
Josh
|
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
|
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).
|
