Bulk change comment status to on

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

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

Open Support Ticket
  • Author
    Posts
  • #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?

    #402219

    Guust
    Moderator
    Post count: 29970

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

    #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

    #402393

    Scott Harris
    Lifetime Member
    Post count: 74

    Thanks that worked.

    #402474

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Great! 🙂

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
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount