WordPress.org

Support

Support » Installation » [Resolved] DB query for all comments on/off?

[Resolved] DB query for all comments on/off?

  • Businessman
    Member

    @businessman

    I’ve imported a MT blog to WP – because of extensive spamming of MT software, I had to close the comments and trackbacks, but I’d like to enable them for the WP install.

    What DB query do I need to use to reset all entries as comments and trackbacks on, instead of all off?

    Many thanks for replies.

Viewing 2 replies - 1 through 2 (of 2 total)
  • UPDATE wp_posts
    SET comment_status = ‘open’
    , ping_status = ‘open’;

    If you are using a different prefix, you have to put it in instead of ‘wp_’.

    Sorry, to switch them all off, set the _status to ‘closed’;

    Businessman
    Member

    @businessman

    Many thanks for that – much appreciated. 🙂

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[Resolved] DB query for all comments on/off?’ is closed to new replies.