[Solved]: How to remove orphan comments?

[Bloom]

Okay, so I went to Admin Tools, checked the right box, and clicked on Submit... however, this is all that comes up:

Searching for orphans, please wait...



1 orphan comments found


back to main

I don't see a button to tell me how to delete it, and the orphaned comment still won't go away. Is there a different way to fix this?

[Nibbler]

Edit util.php, find

Code Select Expand


                if (isset($_POST['del'])){
                        cpg_db_query("DELETE FROM {$CONFIG['TABLE_COMMENTS']} WHERE msg_id= $msg_id");
                        echo "{$lang_util_php['comment']} $msg_body {$lang_util_php['nonexist']} $pid - <a href=\"util.php?action=del_orphans&amp;single=$msg_id\">{$lang_util_php['delete']}</a><br />";
        }


change to

Code Select Expand


                if (isset($_POST['del'])){
                        cpg_db_query("DELETE FROM {$CONFIG['TABLE_COMMENTS']} WHERE msg_id= $msg_id");
        }
                        echo "{$lang_util_php['comment']} $msg_body {$lang_util_php['nonexist']} $pid - <a href=\"util.php?action=del_orphans&amp;single=$msg_id\">{$lang_util_php['delete']}</a><br />";


[Bloom]

Thanks, but where can I find util.php? I can't seem to find it 

[Bloom]

never mind, I found it! Thanks so much for that code, it worked like a charm