Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted February 26, 20178 yr Not sure how / why but Guest posting was turned on for a while. Is there any way to delete Guest posts that on Pages Articles that were not stored in a Forum?
February 28, 20178 yr Author Is there a way to simply delete all comments from a Database. It must in the thousands of posts, can't delete them manually. Have to through out them all.
February 28, 20178 yr 5 hours ago, socceronly said: Is there a way to simply delete all comments from a Database. It must in the thousands of posts, can't delete them manually. Have to through out them all. To delete all the posts made by guests in your forum run this sql query. DELETE FROM `forums_posts` WHERE author_id = 0 AND new_topic = 0; But first make a backup of the forums_table table. And if you are using a prefix for your tables, add it to the table name in the above query when you run it.
Archived
This topic is now archived and is closed to further replies.