comment_parent information not updated

  • JP

    (@policieuxjp)


    9 years, 11 months ago

    Hi there,

    thanks for that plugin, I’ve just tested it and it is very easy to use.

    I’m just noticing that it keeps the original comment_parent information instead of updating it with the duplicated parent comment’s id.

    And this way we lose the thread information for the post.

    Is there a way to update the comment_parent so that we could show the comments and replies properly ?

    Thanks !
    JP

    https://www.ads-software.com/plugins/copy-or-move-comments/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter JP

    (@policieuxjp)

    Hey,

    I had to fix that quickly so I went up with a SQL request that seems to do the work.

    In my example :
    – 185 is the ID of the post where the comments come from
    – 895 is the ID of the post where the comments have been copied to

    Note that it has only been tested (over 400 comments and 40 parent comments) if you have COPIED the comments. But it might work if you have moved them (you should test though ..).

    UPDATE wp_comments A LEFT JOIN wp_comments B ON B.comment_ID=A.comment_parent
    LEFT JOIN wp_comments C ON B.comment_author_email=C.comment_author_email AND B.comment_date=C.comment_date AND B.comment_content=C.comment_content
    SET A.comment_parent = C.comment_ID
    WHERE
    B.comment_post_ID=185
    AND C.comment_post_ID=895
    AND A.comment_post_ID=895
    AND A.comment_parent > 0

    Still would be great to update the comment_parent directly in the plugin ??

    Plugin Author AppJetty

    (@biztechc)

    Hello Jean-Philippe,

    Thank you for drawing our attention for the issue you are facing.
    we will check the issue and update the plugin.

    Thank you,
    Biztech Consultancy.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘comment_parent information not updated’ is closed to new replies.