Forum statistics is wrong for some forums.

[vmNav2]

On ACP I found "reset statistics" buttons but it didn't help. Could you advice how to rebuild the statistics?

Thank you

[stevemaury]

Please fill out the Support Request Template and post it back here to enable us to assist you better.

[vmNav2]

Support Request Template
What version of phpBB are you using? phpBB 3.2.1
Who do you host your board with? Amazon
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Fresh Install
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
Do you have any extensions installed? No
What styles do you currently have installed? prosilver
What language(s) is your board currently using? eng
Which database type/version are you using? PostgreSQL
What is your level of experience? New to PHP and phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? No answer given
Please describe your problem. Statistics for forums is wrong - number of topics and posts are wrong on the board index.
Generated by SRT Generator

[david63]

And a link to your board would be helpful

[vmNav2]

This is our production forum:

version is:

the current version works fine.

then I started to move the forum into different server and I have to update the phpbb version to latest. And this is the link:
http://ec2-34-241-99-215.eu-west-1.comp ... onaws.com/

new version:

so not only phpbb changed but DB engine also. So I moved data into the new Postgres DB and all looks good except the forum statistics. Please advise.

[vmNav2]

From which table/column in DB the data is? Probably I imported data from previous without it and can fix. If I know where

[vmNav2]

Solved!

the link helped me:
viewtopic.php?f=466&t=2298971

main part:

That is exactly what I needed, simply replacing $topic_replies with $topic_posts_approved did the job.