How to reset the counting of topic and post each categories

[thanhtantran]

Hello,

I just did the cleaning by delete manually all post and topic in my forum. However, I don't know why now the categories showing negative number of topic and post. Please see the attachment.

https://prnt.sc/gon6cc

How to reset it to 0?

[baris]

Are you using mongodb or redis?

[thanhtantran]

MongoDB

I am not familiar with this

[baris]

In mongo cli, for each category you have to run the below query replacing the correct values.

db.objects.update({_key: "category:<replace_category_id>"}, {$set: {"topic_count": "<replace_correct_topic_count>", "post_count": "<replace_correct_post_count>"}});

[thanhtantran]

@baris said in How to reset the counting of topic and post each categories:

In mongo cli, for each category you have to run the below query replacing the correct values.

db.objects.update({_key: "category:<replace_category_id>"}, {$set: {"topic_count": "<replace_correct_topic_count>", "post_count": "<replace_correct_post_count>"}});

This works like a charm