XF 1.5 Recalculation Post

[AlexGC]

Hi, i accidentally run a query that calculates posts including those deleted without backing up before, but what i wanted to do it was a recalculation of the messages without counting those deleted or hidden, how can i recalculate the userpost without count the hidden/deleted posts?


Sorry for my english.

 

[AlexGC]

Can someone help me please?

 

[Paul B]

It's not clear what query you ran, or indeed how you managed to run it accidentally.

Typically we would never recommend running queries directly on the database and if you are determined to do so, a backup should be taken first.

I think there may be a thread which lists the queries to run to rebuild user counts - you can try searching for it.