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?