I have 2 questions.

Question 1:

What is the semantic of the following fields in the database

bb_topics.topic_status

bb_posts.post_status

Is it safe delete all posts and topics withs status > 0 ?

Question 2:

Are there any rows in bb_topicmeta for topics with topic_status > 0 ?

[@sambauers Participant 16 years, 3 months ago]

For topic_status:

0 = normal

1 = deleted

For post_status:

0 = normal

1 = deleted

2 = spam

It’s safe to delete these as long as you are careful if you ever backup and restore your database not to have the deleted IDs be allowed to be repopulated.

There very well could be rows in topicmeta for topics with topic_status > 0

[@wiseacre Member 16 years, 3 months ago]

Thanks!