# Unexpected flags showing up... False flags!
**URL:** https://meta.discourse.org/t/unexpected-flags-showing-up-false-flags/128857
**Category:** Bug
**Created:** [September 18, 2019, 2:16am UTC](https://meta.discourse.org/t/unexpected-flags-showing-up-false-flags/128857 "2019-09-18T02:16:54Z")
**Posts on this page:** 16
**Page:** 2
### Author:  [@alxpck](https://meta.discourse.org/u/alxpck)
#### Post date: [September 18, 2019, 1:38pm UTC](https://meta.discourse.org/t/unexpected-flags-showing-up-false-flags/128857/28 "2019-09-18T13:38:44Z")
Love hearing that. We’re on the edge of our seat.
---
### Author:  [@jomaxro](https://meta.discourse.org/u/jomaxro)
#### Post date: [September 18, 2019, 3:13pm UTC](https://meta.discourse.org/t/unexpected-flags-showing-up-false-flags/128857/29 "2019-09-18T15:13:15Z")
Tests have passed, fix rolled out to all affected sites. Sorry about this!
---
### Author:  [@Seth\_Godin](https://meta.discourse.org/u/Seth_Godin)
#### Post date: [September 18, 2019, 3:20pm UTC](https://meta.discourse.org/t/unexpected-flags-showing-up-false-flags/128857/30 "2019-09-18T15:20:05Z")
thanks @jomaxro
to clarify, the original problem is solved, and hearts are no longer flags? We can turn them back on?
thanks for your help
---
### Author:  [@jomaxro](https://meta.discourse.org/u/jomaxro)
#### Post date: [September 18, 2019, 3:21pm UTC](https://meta.discourse.org/t/unexpected-flags-showing-up-false-flags/128857/31 "2019-09-18T15:21:08Z")
That is correct. A change deployed yesterday updated the way we determine when to hide flagged posts, and in doing so introduced this bug where likes could cause posts to be hidden. That bug has been fixed.
---
### Author:  [@dax](https://meta.discourse.org/u/dax)
#### Post date: [September 18, 2019, 3:21pm UTC](https://meta.discourse.org/t/unexpected-flags-showing-up-false-flags/128857/32 "2019-09-18T15:21:46Z")
Seth, I tested on your site and already enabled the Like button again and disabled the global warning.
---
### Author:  [@Seth\_Godin](https://meta.discourse.org/u/Seth_Godin)
#### Post date: [September 18, 2019, 3:22pm UTC](https://meta.discourse.org/t/unexpected-flags-showing-up-false-flags/128857/33 "2019-09-18T15:22:29Z")
thanks @dax
if it was always that easy to get rid of global warming, I’d be a lot more optimistic about the future.
perhaps you and the team could work on that next.
🌥
---
### Author:  [@alxpck](https://meta.discourse.org/u/alxpck)
#### Post date: [September 18, 2019, 3:28pm UTC](https://meta.discourse.org/t/unexpected-flags-showing-up-false-flags/128857/34 "2019-09-18T15:28:23Z")
What’s the best way for to scan the sites for posts that were hidden by this bug and unhide them?
---
### Author:  [@dax](https://meta.discourse.org/u/dax)
#### Post date: [September 18, 2019, 3:28pm UTC](https://meta.discourse.org/t/unexpected-flags-showing-up-false-flags/128857/35 "2019-09-18T15:28:58Z")
With @codinghorror , who knows… we could even do it 💪 🦸♂️ 🦸♀️
😃
---
### Author:  [@jomaxro](https://meta.discourse.org/u/jomaxro)
#### Post date: [September 18, 2019, 3:35pm UTC](https://meta.discourse.org/t/unexpected-flags-showing-up-false-flags/128857/36 "2019-09-18T15:35:01Z")
This [data explorer](https://meta.discourse.org/t/32566?silent=true) query should reveal all hidden (but not deleted) posts:
```plaintext
SELECT id, user_id, topic_id, post_number
FROM posts p
WHERE p.hidden = true AND p.deleted_at IS NULL
```
From there you can unhide the posts found.
---
### Author:  [@alxpck](https://meta.discourse.org/u/alxpck)
#### Post date: [September 18, 2019, 3:45pm UTC](https://meta.discourse.org/t/unexpected-flags-showing-up-false-flags/128857/37 "2019-09-18T15:45:50Z")
> [@jomaxro](#):
>
> SELECT id, user\_id, topic\_id, post\_number FROM posts p WHERE p.hidden = true AND p.deleted\_at IS NULL
Thanks. I just set that up and we’ve got 400 posts to clean up. Is there a way for you to do it programmatically?
Perhaps you can unhide all in one fell swoop?
---
### Author:  [@jomaxro](https://meta.discourse.org/u/jomaxro)
#### Post date: [September 18, 2019, 3:46pm UTC](https://meta.discourse.org/t/unexpected-flags-showing-up-false-flags/128857/38 "2019-09-18T15:46:23Z")
Certainly. You want us to unhide all hidden posts on the 3 sites listed above?
---
### Author:  [@alxpck](https://meta.discourse.org/u/alxpck)
#### Post date: [September 18, 2019, 3:49pm UTC](https://meta.discourse.org/t/unexpected-flags-showing-up-false-flags/128857/39 "2019-09-18T15:49:55Z")
Yes please.
… and now extra chars to hit min post
---
### Author:  [@alxpck](https://meta.discourse.org/u/alxpck)
#### Post date: [September 18, 2019, 4:14pm UTC](https://meta.discourse.org/t/unexpected-flags-showing-up-false-flags/128857/40 "2019-09-18T16:14:50Z")
Let us know when the posts are un-hidden, and we’ll be able to wrap this up.
---
### Author:  [@jomaxro](https://meta.discourse.org/u/jomaxro)
#### Post date: [September 18, 2019, 5:04pm UTC](https://meta.discourse.org/t/unexpected-flags-showing-up-false-flags/128857/41 "2019-09-18T17:04:23Z")
You’re all set. All posts unhidden.
---
### Author:  [@alxpck](https://meta.discourse.org/u/alxpck)
#### Post date: [September 18, 2019, 5:18pm UTC](https://meta.discourse.org/t/unexpected-flags-showing-up-false-flags/128857/42 "2019-09-18T17:18:25Z")
Thank you so much for untangling this bug and helping us clean up after.
---
### Author:  [@jomaxro](https://meta.discourse.org/u/jomaxro)
#### Post date: [September 21, 2019, 10:00pm UTC](https://meta.discourse.org/t/unexpected-flags-showing-up-false-flags/128857/48 "2019-09-21T22:00:10Z")
This topic was automatically closed after 3 days. New replies are no longer allowed.
[Previous page](https://meta.discourse.org/t/unexpected-flags-showing-up-false-flags/128857.md?page=1)