I need to clean unlinked data in an existing a WP installation where some posts/pages/link etc where manually deleted through queries made directly on DB.
I know DB structure and I can find unlinked records in comments, postdata etc, but I have some problems with terms and taxonomies.
wp_term_relationships has an externale key ‘object_id’ that links both to wp_posts and wp_links, but without spec which… the same id can be in posts or links, so I can’t perform the right join/subquery to find non-existant posts/links.
Do you have any suggestion about this?
- The topic ‘Cleaning WP Database’ is closed to new replies.