Duplicates Detection
Scotty scans your database for duplicate metadata entries and helps you clean them up.
What Are Duplicates?
Duplicate metadata occurs when the same meta_key + meta_value combination exists multiple times for the same parent entity (post, comment, user, or term). This can happen due to plugin bugs, failed imports, or database inconsistencies.
Detected Duplicates
| Table | Description |
|---|---|
| PostMeta | Duplicate entries in wp_postmeta |
| CommentMeta | Duplicate entries in wp_commentmeta |
| UserMeta | Duplicate entries in wp_usermeta |
| TermMeta | Duplicate entries in wp_termmeta |
How Deletion Works
When deleting duplicates, Scotty keeps the most recent entry (highest meta_id) and removes the older copies. This ensures you always retain the latest version of the data.
Last updated on
