|
guiapenin
|
November 1, 2018 at 4:52 am
Good Morning
Once the event is finished, when exporting records to csv, all the data appear, except name, surname, and email.
I check the database, and see that the table wp_events_attendee has disappeared.
How could it have disappeared? This is very serious, we do not have information of the assistants to the event, more than two thousand people.
During the event, these tables existed, since the search of records by name and surname to print the ticket worked, it was after the end of the event that they disappeared.
On the other hand, I see that from the mobile app I can see the names and surnames of the attendees of the event, what tables do you get them from and how can I relate them to the ones of the records without first and last name? Can I get the ATT_ID or the TXN_ID or the REG_code from the tables in the mobile app?
It is not the first database problem we have had since installing EE4 and it already makes us doubt its security in the face of upcoming events, last week we reported the error of not being able to create new events …
Thank you.
|
|
Tony
|
November 1, 2018 at 6:45 am
Hi there,
I check the database, and see that the table wp_events_attendee has disappeared.
wp_events_attendee is not an EE4 table, it’s from EE3 but further in your reply you mention ATT_ID and TXN_ID, those are from EE4 and not EE3, so is that the correct table name?
EE doesn’t remove individual tables like this, there is, one option in EE4 to reset/delete ALL EE4 tables, but NOT individual tables.
How could it have disappeared? This is very serious, we do not have information of the assistants to the event, more than two thousand people.
We don’t have code within EE4 to delete single tables like this, we do have one option that can be used to reset/delete ALL of EE’s tables, but not individual tables like above. Again, that table name is from EE3, which we do not delete with EE4 at all so if that specific table was in the DB and has now been remove, it’s a good indicator that something/someone else is involved making edits to the database.
During the event, these tables existed, since the search of records by name and surname to print the ticket worked, it was after the end of the event that they disappeared.
If you find the Event in Event Espresso -> Events
Hover over the event name and click on the registrations link that appears below it, do you see the registrants names there?
On the other hand, I see that from the mobile app I can see the names and surnames of the attendees of the event, what tables do you get them from and how can I relate them to the ones of the records without first and last name?
I’m not sure I follow this, you can see the names of the attendees but then can’t see the attendee names?
So some registrations show the names, others do not?
Can I get the ATT_ID or the TXN_ID or the REG_code from the tables in the mobile app?
The mobile apps are pulling the data directly from your site, so if they show in the app, the details must be in the database of the site.
It is not the first database problem we have had since installing EE4 and it already makes us doubt its security in the face of upcoming events
May I ask why you believe this is a security issue?
The most likely cause is an issue with the database, and there are many different factors that can cause issues with the database. EE4 doesn’t remove tables, but if your host performs ‘maintenance’ or ‘cleanup’ jobs on the database which removes data, that data is no longer available to EE, we have no control over that.
I’m not saying that is the cause (we currently don’t have enough information to know what the problem is) but the point being, there’s more that can cause the issues you have reported than EE itself.
last week we reported the error of not being able to create new events …
You mentioned in your other thread that this was caused by a database error but we’ve not heard anything more?
|
|
guiapenin
|
November 1, 2018 at 7:52 am
Sorry, the table that is empty is: wp_esp_attendee_meta
In the record that appears below the event, the names do not look like you can see,
but from the mobile application if I see the names, but I do not see the ID
I would like to know which table the mobile app reads, since what we are most interested in are the ones that have really existed
Thank you
|
|
guiapenin
|
November 1, 2018 at 8:44 am
Here you can see better the registrations …
|
|
Tony
|
November 1, 2018 at 8:54 am
Sorry, the table that is empty is: wp_esp_attendee_meta
Ok, so yes, that is an EE4 table and it is the table that all of the EE contact data is stored in.
Have you checked with your host to see if they’ve ran any maintenance on the server side?
Do you (or your host) have a recent database backup for your site? If the table was dropped, EE has likely recreated it again now (EE4 checks for valid tables and will re-create them if they have been removed) the only way to get that data back is through a backup.
In the record that appears below the event, the names do not look like you can see
Yeah, that means EE either can’t access the esp_attendee_meta table, or the data is missing from within that table.
I would like to know which table the mobile app reads, since what we are most interested in are the ones that have really existed
It reads exactly the same tables as the section in EE does, however, the app may be serving a cached copy of the attendee list. Right now I don’t recommend clearing that cache as it may well be your ownly copy of the attendee list (depending on your backup).
If you log in on another device does that list the attendees? If you don’t have another device I can check if you prefer, just send login details (and details of the event) using this form:
https://eventespresso.com/send-login-details/
|
|
guiapenin
|
November 1, 2018 at 11:36 am
I have a backup of 15:10, ten minutes after the end of the event, but the table wp_esp_attendee_meta is empty.
As you can see in the image of the previous message, the last record was made at 13:55 pm, October 30, 2018 … when the event was already finalizing … it is as if at the end of the event, at 15 : 00 h. that table would have been removed.
My hosting provider, OVH, allows me to recover the database of the previous day or the previous week, so in this case it does not work … the previous day the table wp_esp_attendee_meta is empty, and the week before, the event had not taken place and it would lose all the attendees registered in the event
I’ve entered the mobile application with a new tablet and I’m still seeing the attendees, it’s not a cache issue … that’s why I was commenting on which table I read
I am trying to relate the records of the event with the ID TXN_ID in the different tables but they are more than 4000 and it is very slow, so I told you if I could relate that TXN_ID with the table that is shown in the mobile application, where I see names and surnames … now I’m trying to relate the csv with the emails sent, to retrieve name and surnames
Any idea to solve?
Attached access data
|
|
Tony
|
November 2, 2018 at 12:37 pm
My apologies, I checked into this and the mobile apps are using the espresso_attendees posts directly from the {prefix}_posts table (likely wp_posts on your site) to pull the names. It does join wp_esp_attendee_meta for all of the other attendee data (including email) but within the wp_posts table are the espresso_attendees posts, the only data stored there is the attendee’s name and bio.
They are linked to the registrations within wp_esp_registration using the ATT_ID, which is the ID from wp_posts for those espresso_attendee posts.
I am trying to relate the records of the event with the ID TXN_ID in the different tables but they are more than 4000 and it is very slow, so I told you if I could relate that TXN_ID with the table that is shown in the mobile application, where I see names and surnames
Without wp_esp_attendee_meta you’ll only be able to find the name.
You’ll have the Attendee ID in the CSV (which is the ATT_ID).
If you look in the wp_posts table you can look for individual attendees using the ID there, or you can search for all records with post_type of ‘espresso_attendees’ – http://take.ms/9LiUk
|
|
guiapenin
|
November 4, 2018 at 6:03 am
In the end I was able to recover the data except the phone and the name of the street of the company, through the field TXN_ID and the MSG_content manually deleting the other data from the body of the message.
The problem is why that table has disappeared from the database … it is what we can not explain and that is what generates doubts in the face of future events.
|
|
Josh
|
November 5, 2018 at 8:59 am
Your web host may have an explanation, and in any case it’s highly recommended to have a reliable backup system in place. VaultPress is one of the better options, but there are a number of WordPress plugins that make it possible to take daily backups of your data and send them via email or sync to Dropbox, Amazon cloud storage, and so on.
|
