Bulk change comment status to on

This topic contains 4 replies, has 3 voices, and was last updated by  Stiofan O’Connor 6 years, 6 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Tagged: ,

  • Author
    Posts
  • October 23, 2017 at 7:43 pm #402185

    Scott Harris
    Lifetime Member
    Post count: 74

    We are enabling the GD reviews module and discovered that to make it work, we need to enable comments on the existing places. There are hundreds that we need to change, so we’d like to do this via bulk edits. However, since bulk actions has been disabled, we’re not sure how to make this happen.

    Is there a sql command that would work to turn on comments for all existing places records? If not, is there a way to enable ratings for all existing records without visiting each one?

    October 23, 2017 at 11:58 pm #402219

    Guust
    Moderator
    Post count: 29970

    I’ll get a developer to have a look at your question. Thanks

    October 24, 2017 at 11:40 am #402296

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Something like

    UPDATE wp_posts SET comment_status = 'open' WHERE comment_status = 'closed' AND post_type='gd_place'

    Stiofan

    October 24, 2017 at 9:38 pm #402393

    Scott Harris
    Lifetime Member
    Post count: 74

    Thanks that worked.

    October 25, 2017 at 10:09 am #402474

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Great! 🙂

  • Author
    Posts
Viewing 5 posts - 1 through 5 (of 5 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket