The Support Forums will be in read-only mode for a scheduled maintenance window on 01 September 2016 14:00 UTC - 20:00 UTC. More information.

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

  1. howlermiller
    Posted 4 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
    Posted 4 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.

  3. howlermiller
    Posted 4 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