Skip to content

Instantly share code, notes, and snippets.

@deshabhishek007
Created February 8, 2019 07:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save deshabhishek007/71857959e5a066365f9bbe64300f8743 to your computer and use it in GitHub Desktop.
Save deshabhishek007/71857959e5a066365f9bbe64300f8743 to your computer and use it in GitHub Desktop.
Remove Orphan values from post-meta Table in WordPress
<ol><?php
$link = mysqli_connect("localhost","Username","Password","DBNameHere");
$sql = "SELECT `meta_id`,`post_id`,`meta_key`,Length(`meta_value`) as meta_data, `post_title`, `post_type` FROM `wp_postmeta` LEFT JOIN `wp_posts` on `wp_postmeta`.`post_id` = `wp_posts`.`ID` ORDER BY `wp_posts`.`post_title` ASC ";
$result = mysqli_query($link, $sql);
while($data = mysqli_fetch_assoc($result)){
if($data['post_title'] == NULL && $data['post_type'] == NULL){
$meta_id = $data['meta_id'];
$sql = "DELETE FROM `wp_postmeta` WHERE `meta_id` = ".$meta_id;
$res2 = mysqli_query($link, $sql);
echo "<li>".$data['post_id']."- Type: ".$data['post_type']."</li>";
}
}
?>
</ol>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment