I know I messed this up and just want to check the steps I might do to recover.
I wanted to change Pending statuses to Incomplete on a number of attendees. I can’t do it though the EE dashboard so I went into the database PHPMydatabase and manually updated those status fields on the events_attendee table to be Incomplete.
Now I go to the Event Overview and no tables appear when I select all active/inactive and all categories but I see that there are still events listed on the top of the page:
Filters
Events : All Events (13) | This Month (13) | Today (0) Attendees : All Attendees (251) | This Month (251) | Today (19)
If I click All Events (13) the list of all 13 appears for like a second and then the No Records Found! appears.
I went back in and changed the statuses back to Pending but it hasn’t made a difference.
My most recent database backup I just did but it has the changed status fields in it.
Is there another table I should update? Can I manually delete these attendees in the database and would that resolve this issue?
It looks like 2 other tables reference the attendee_id wp_events_answer
wp_events_attendee_meta`
If I remove the records from those databases for the attendees I want to delete, hopefully I can manually remove the ones I want from the database along with the attendee record itself?
OMG nevermind – I had a live search filter in there – sorry for the hysteria!
Viewing 2 reply threads
The support post ‘Events on Events Overview disappeared after database update’ is closed to new replies.
Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.
Support forum for Event Espresso 3 and Event Espresso 4.