# Batch unhide posts

**URL:** <https://meta.discourse.org/t/batch-unhide-posts/27716>\
**Category:** Support\
**Created:** [April 17, 2015, 10:02pm UTC](https://meta.discourse.org/t/batch-unhide-posts/27716 "2015-04-17T22:02:46Z")\
**Posts on this page:** 1\
**Showing post:** 17

<div class="post-metadata">

**Author:** ![Silvanus](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/silvanus/32/62831_2.png) [@Silvanus](https://meta.discourse.org/u/Silvanus)\
**Post date:** [September 6, 2016, 8:09am UTC](https://meta.discourse.org/t/batch-unhide-posts/27716/17 "2016-09-06T08:09:19Z")

</div>

I had a similar problem. Used the following and it worked. First, entered `./launcher enter app` then `rails c` and then:

```
ActiveRecord::Base.exec_sql("UPDATE posts
SET hidden = false, hidden_reason_id = NULL, hidden_at = NULL
WHERE user_id = ?", User.find_by_username("USER_NAME_HERE").id)

```

---

_[View the full topic](https://meta.discourse.org/t/batch-unhide-posts/27716)._