|
navycoat
|
June 21, 2014 at 12:52 pm
Hi,
I found this thread which seems to be the same problem that I’m having but I still can’t find a solution.
https://eventespresso.com/topic/deleted-attendees-are-still-showing-in-exported-excel-report/
I have been testing my site for a few months and created several dozen test attendees. They are attached to all the different events (which unfortunately are my real events that I need to use to go live). I was testing confirmation emails, etc. This was before I realized I should have made test events to delete later.
I deleted all of the test attendees through Event Espresso and now there are still some “stuck” in my database as well as in the exported Excel file. I am able to access the SQL database through phpMyAdmin and see the leftover attendees wp_events_attendee table.
The “stuck” attendees all seem to be from when I was testing my site initially. I tested making new attendees today and deleting them through WordPress and they seemed to be deleted fine in the SQL wp_events_attendee table.
1. Can I delete the attendees from the wp_events_attendee table? Will that delete all of the connected data correctly? I am very hesitant to do this because of my lack of experience and fear of creating orphan records.
2. If this happens in the future, should I always delete through phpMyAdmin? I know there will be occasions on a live site when I’ll need to delete attendees (accidental duplicate registration, etc) so I don’t always want to delete the entire event and start over.
3. Is there any known cause that these particular attendees got “stuck” in the database? I want to make sure I don’t mess this up again!
Thank you!
Caroleen
Wordpress 3.9.1
Event Espresso 3.1.36.5.P
New installation
Site is online but password protected and in development
|
|
Lorenzo Orlando Caum
|
June 21, 2014 at 3:39 pm
You can remove them from the dbprefix_events_attendee table. Be sure to backup your WordPress before attempting any changes to the database directly.
PHPMyAdmin can be used. Adminer is also another tool that is available as a WordPress plugin.
—
Lorenzo
|
|
navycoat
|
June 21, 2014 at 3:52 pm
Is dbprefix_events_attendee the same as the wp_events_attendee table? I don’t mess around in the database tables very often so I’m very cautious.
I am also backing up my site before making changes.
Thank you!
|
|
Lorenzo Orlando Caum
|
June 21, 2014 at 4:05 pm
It is similar.
Some web hosts prefix the database table name to something else other than wp for security reasons.
z12345_events_attendee would be similar to wp_events_attendee.
—
Lorenzo
|
|
navycoat
|
July 3, 2014 at 9:17 pm
I took the plunge and deleted the records out of that table. So far so good!
My site is out there live on the interwebs and customers are using it : ) I couldn’t have done it without your excellent tech support.
Thank you!
Caroleen
|
