{"action":"closed","issue":{"url":"https://api.github.com/repos/Charcoal-SE/metasmoke/issues/507","repository_url":"https://api.github.com/repos/Charcoal-SE/metasmoke","labels_url":"https://api.github.com/repos/Charcoal-SE/metasmoke/issues/507/labels{/name}","comments_url":"https://api.github.com/repos/Charcoal-SE/metasmoke/issues/507/comments","events_url":"https://api.github.com/repos/Charcoal-SE/metasmoke/issues/507/events","html_url":"https://github.com/Charcoal-SE/metasmoke/issues/507","id":359429911,"node_id":"MDU6SXNzdWUzNTk0Mjk5MTE=","number":507,"title":"TP posts showing up in FP queries","user":{"login":"CalvT","id":15909971,"node_id":"MDQ6VXNlcjE1OTA5OTcx","avatar_url":"https://avatars3.githubusercontent.com/u/15909971?v=4","gravatar_id":"","url":"https://api.github.com/users/CalvT","html_url":"https://github.com/CalvT","followers_url":"https://api.github.com/users/CalvT/followers","following_url":"https://api.github.com/users/CalvT/following{/other_user}","gists_url":"https://api.github.com/users/CalvT/gists{/gist_id}","starred_url":"https://api.github.com/users/CalvT/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/CalvT/subscriptions","organizations_url":"https://api.github.com/users/CalvT/orgs","repos_url":"https://api.github.com/users/CalvT/repos","events_url":"https://api.github.com/users/CalvT/events{/privacy}","received_events_url":"https://api.github.com/users/CalvT/received_events","type":"User","site_admin":false},"labels":[{"id":247979076,"node_id":"MDU6TGFiZWwyNDc5NzkwNzY=","url":"https://api.github.com/repos/Charcoal-SE/metasmoke/labels/type:%20bug","name":"type: bug","color":"006b75","default":false}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-09-12T11:05:41Z","updated_at":"2018-09-13T20:40:40Z","closed_at":"2018-09-13T20:40:40Z","author_association":"MEMBER","body":"It would seem that the `is_fp` column in `p_posts` is not updated when the fp feedback is cleared. It could be the same for naa and tp, but I haven't had time to dig into it properly.\r\n\r\nI came across this while looking at the Autoflag FP Dashboard, and I noticed that there is one FP with 7 reasons, and a weight of 692. [This is the post](https://metasmoke.erwaysoftware.com/post/52612). It has no FP feedback visible, but on clicking clear it shows that two users had their feedback cleared or automatically deleted.\r\n\r\nGlorfindel has written a query to show the [Top 20 FPs](https://metasmoke.erwaysoftware.com/data/sql/queries/120-top-20-fp-posts-by-weight).\r\n\r\nWhen I came to write this issue, the three posts I had found ([1](https://metasmoke.erwaysoftware.com/post/52612), [2](https://metasmoke.erwaysoftware.com/post/55693), [3](https://metasmoke.erwaysoftware.com/post/134223)) had stopped showing up in queries. However three others are now in their place.\r\n\r\nSo it could be something else (other than the `is_fp` column not updating)."}}
{"actor":{"display_login":"ArtOfCode-"}}