WordPress.org

Ready to get started?Download WordPress

Forums

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

  1. howlermiller
    Member
    Posted 2 years ago #

    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!

  2. jnhghy
    Member
    Posted 2 years ago #

    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

  3. howlermiller
    Member
    Posted 2 years ago #

    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?

Topic Closed

This topic has been closed to new replies.

About this Topic