|
raffy
|
January 16, 2017 at 8:12 am
I have an event with around 1500 this morning. Today registration surged.
After I added an entry on the front end. I searched for the registration code on the backend. Before I searched, the espresso registrations page contained typical and contained registrants. After I searched, it was empty. I looked at the events, they were empty of details.
Have you ever encountered anything like this before? Did you recover? How?
I have daily backups but I practically lost all registrant data today.
That event is for this weekend. We were wrapping up today. I am in deep trouble.
|
|
raffy
|
January 16, 2017 at 8:46 am
Can this help? http://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery.html
|
|
raffy
|
January 16, 2017 at 9:16 am
Unfortunately, I don’t have binary logging on.
|
|
Josh
|
January 16, 2017 at 11:48 am
Hi Raffy,
I can recommend contacting your host to see if they can find out how and why the data got lost, if they have a way to prevent that from happening again, and if they have any more recent backups that can be reverted to.
|
|
raffy
|
January 16, 2017 at 12:40 pm
I have backups but they won’t cover 17 hours worth of registration. The host doesn’t have back up more recent than that.
I’m talking to the host already. Is there any help that you can provide?
Any insights on the fact that the data lost is only on the active events and its 2500 entry registrant database.
This is actually the second time it happened. The last time the data loss happened was very near a back up schedule and no one actually registered. Consequently, we were able to recover everything.
|
|
Josh
|
January 16, 2017 at 1:05 pm
Did you actually check the database tables to see whether the registrations are missing there? One thing to know about Event Espresso registration data is the data for a registration and its associated data (like payments, contact info, registration answers) are spread out across multiple tables. So you can first check those tables to see whether is still there. The tables include esp_registration, esp_transaction, esp_answer, esp_payment. If the data was deleted from only one of those tables, then the registration information will still be in the related tables.
|
|
raffy
|
January 16, 2017 at 3:12 pm
Via phpmyadmin, I checked the tables you mentioned. I am sad to say that data for is not there. To update, it is all event and registrant data including
I don’t know if this info will help but myphpadmin session kept on timing out while I was looking.
I am currently asking help from my host how to search if I was hacked. I would appreciate if you have any suggestions on how to look for clues of that.
|
|
Josh
|
January 16, 2017 at 4:12 pm
There are some good suggestions here:
https://codex.wordpress.org/FAQ_My_site_was_hacked
|
|
raffy
|
January 17, 2017 at 8:29 am
I restored my site and inputted 5 registration entries.
A few other people added 10 more entries.
I tried to generate an All Registrations CSV Report and it happened again.
One minute it was populated with data (at least one page that I can see) then next thing you know all registration data is erased.
|
|
Josh
|
January 17, 2017 at 8:49 am
Have you checked the files on your server to see if there’s a script that’s dropping tables?
|
