Support

September 13, 2013 at 3:56 pm

Some of your events may be statused ‘Deleted’, but may still be in the DB. To clean those out first, you can run:
DELETE FROM wp_events_detail WHERE event_status=’D’
You would want to run that first, then clean the attendee table with
DELETE a FROM wp_events_attendee a
WHERE NOT EXISTS(SELECT NULL
FROM wp_events_detail d
WHERE d.id = a.event_id)
then clean out the attendee_meta table:
DELETE am FROM wp_events_attendee_meta am
WHERE NOT EXISTS(SELECT NULL
FROM wp_events_attendee a
WHERE a.id = am.attendee_id)
then the answers table:
DELETE an FROM wp_events_answer an
WHERE NOT EXISTS(SELECT NULL
FROM wp_events_attendee a
WHERE a.id = an.attendee_id)