making private posts public again…

  • Tried a plug in I thought would shut down comments for older posts, turns out it shut down the older posts themselves by making them private. Any way to batch undo this? In other words batch “public” all of my posts? Even a mySQL command??

    Thanks,
    Dave…

Viewing 5 replies - 1 through 5 (of 5 total)

  • Hmmm, this should work (assuming WP 1.5):

    UPDATE ‘wp_posts’ SET ‘post_password’ = ” WHERE ‘post_password’ = ‘XYZ’;

    Replacing XYZ with the password you have used for your entries.

    Tried and tested on mine ??

    Thread Starter daveo123

    (@daveo123)

    Thanks, but it’s not a password problem. It’s that 8 months of posts are marked as “private” and I need to change that to public. There was no password, I just need to undo what I did in a batch. I can see the posts no problem. They just aren’t public.

    Then a slight mod to tbw’s query:

    UPDATE wp_posts SET post_status = 'publish' WHERE post_status = 'private';

    Oops, misread, but as Kafkaesqui said, thanks ??

    Thread Starter daveo123

    (@daveo123)

    Worked like a charm! Thanks guys. Appreciate the help.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘making private posts public again…’ is closed to new replies.