Hi everybody,
thanks for your help. I’ve managed to clean it completely via phpmyadmin:
– remove all tables with wp_em prefix (if any)
– remove all datasets in wp_options with dbem_* prefix
– remove all shown datasets in wp_posts with post_type event:
SELECT * FROM wp_posts WHERE post_type like 'event';
– remove all shown datasets in wp_posts with post_type event-recurring:
SELECT * FROM wp_posts WHERE post_type like 'event-recurring';
(and optional)
– show all “generic” faulty links between wp_posts and wp_postmeta in order to find out postmeta-entries which dont have a connection to posts any more (because they were deleted in former times):
SELECT * FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL;
– and delete them:
DELETE pm FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL;
