WordPress.org

Support

Support » How-To and Troubleshooting » WordPress password protected my posts. I don't want that.

WordPress password protected my posts. I don't want that.

  • So I messed up my blog (QBobble). I had an SQL backup, fortunately, so I reinstalled WordPress, and imported my SQL database.

    Unfortunately, it password protected all of my posts. I know that I can manually unpassword protect them by going to Posts < Edit and edit the visibility to “public”, but I don’t want to do that to all of my posts, I want to do it to all of them at once. How can I do that? Someone said that you can do it in Bulk Actions > Edit, BUT changing the status to “public” in bulk actions doesn’t work. Any ideas?

    It also got rid of the excerpts for each post. They now just read NULL. Is there a way that I can get it to add those back automatically?

    Thanks all!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Hi howlermiller,
    Can you check you database in wp_posts check post_password field to see if you have any values in that collumn, if you do just query your database and update the collumn with no value.
    Regards

    AhHA! Thank you! post_password was set to NULL, and apparently that messed it up.
    The excerpts are still NULL though. Is there any way I can get those back?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘WordPress password protected my posts. I don't want that.’ is closed to new replies.