Posted: July 3, 2020 at 5:58 am
We’ve had two customers contact us because the event registrations they placed (using offline payment methods) have disappeared from our site. They were issued with invoices to be paid, but all record of their tickets, registrations and transactions are gone. We have downloaded a database backup from our host (WPEngine) from the day after one of the registrations was made, and can confirm we see the expected data in the
There has been no unauthorised access to the site nor its hosting.
Are there any circumstances under which data would be purged by Event Espresso itself?
Apologies for the delayed reply.
We have one method which removes registrations on a cron schedule here:
So the start is
Which is shown HERE.
The default query_args (filtered so may well have been changed by other code on the site) checks for transactions with a ‘failed’ status, note this is NOT a failed payment status, but a transaction status of failed which is set when the transaction is first created.
AND no payment objects associated with the transaction at all (invoice wont have any payment objects)
AND are older than 1 week (again 1 week by default, the value is filtered).
Any transactions its finds that match, it removes.
Then we run
Deletes any registrations in which a transactions doesn’t exist for (every registration within EE should be assigned to a transaction unless the above removed it).
So for that cleanup job to remove the registration it all starts from the transaction and it needed to have a status of ‘TFL’ in the database (which it should not if the user made it even to the payment options step), so if you have the database saved, check the esp_registration table, find the registration in question and note the TXN_ID linked to it. What value is it?
Then check esp_transaction and check the STS_ID for the row using that TXN_ID, what is it?