clear unapproved posts

[metulburr]

I have had (3) unapproved posts on my forum for over a year. I cant seem to get rid of them. They dont show in the thread listing or in ACP under unapproved. But it shows that there are 3 posts unapproved. Is there a way to remove these since it seems to be unfindable?

[dragonexpert]

Try rebuilding the Forums cache and then the stats. ACP->Tools & Maintenance -> Cache Manager.

[metulburr]

it still shows after that

[dragonexpert]

I guess the best way then would be to run this query:

DELETE FROM mybb_posts WHERE visible=0

Note that this will delete all posts that are unapproved. You may need to rebuild those caches after running the query.

[metulburr]

I was worried if it would delete a tutorial thread as the 3 unapproved posts are in that forum. However i went through the forum pages one by one and selected all threads and selected approved threads, but the unapproved threads still remain.

Is there a way to make all threads approved? As we dont really use that feature. Unapproved threads are just deleted threads in the first place.

But i am worried that somehow one of the legit threads are labeled unapproved.

[.m.]

SELECT * FROM mybb_posts WHERE visible = 0

that gives unapproved posts & content can be checked

below changes unapproved posts to approved

UPDATE `mybb_posts` SET visible = 1 WHERE visible = 0

You may need to rebuild those caches after running the query

[metulburr]

i still have unapproved threads after/posts after running all of these queries and rebuilding all the cache after each one. 

mysql> DELETE FROM mybb_posts WHERE visible=0 
    -> ;
Query OK, 0 rows affected (0.00 sec)

mysql> UPDATE `mybb_posts` SET visible = 1 WHERE visible = 0;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> SELECT * FROM mybb_posts WHERE visible = 0;
Empty set (0.00 sec)

mysql> UPDATE `mybb_posts` SET visible = 1 WHERE visible = 0;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql>

[metulburr]

i wonder if it messed the database up? because for a single day we had new users require approval, and some were purged spammer'd...did they not get deleted form the database?

However if i check mysql there is nothing there.

mysql> SELECT * FROM mybb_posts WHERE visible = 0;
Empty set (0.00 sec)

mysql> SELECT * FROM mybb_threads WHERE visible = 0;
Empty set (0.03 sec)