TOPIC/POST REBUILD/RECOUNT HOW ?

[STAR]

R Hi Guys I have wierd issue my members topic count does not match with actual topic count inside the section.

Let me explain. When looking at sections on my website it shows 

5339 posts 

Now if I go inside this public mod releases section you will see there is actually 8250 topics inside  ( not incluiding post replys also inside each topic ) as seen here 330 pages 25 topics per page which makes it 8250 again thats just topics not counting how many replys some of the topics have.

0

 

But some reason outside in main section of the site it's not showing this number correctly as seen in image 1 

 

Is there a way to rebuild forum topic/posts manually? 

 

As members think there is lot less topics inside then it's showing

 

Thanks for help.

 

Yes I did try support tool in admin panel also cleared the saved data on my browser as well as deleting catch still same.

[STAR]

Well I don't know how bit it's showing correct count 3 days later

I haven't done anything I still don't know why would IPB remove the rebuild tool from ACP.

Anyway its fixed looks like eventually it catches up it self.

 

[Jeffrey]

You could change it in your database if you manually count the number of topics/posts by yourself;

Find the forums_forums table and it is organized in forum id order. Find the forum id of that board from the URL (https://i.gyazo.com/e4dfe0510f0dc74e49697571604d830f.png) and find the table for it. Change the number of topics and/or posts you'd like to change it to.

Edited April 3, 2018 by Testmyluck

[STAR]

7 hours ago, Testmyluck said:

You could change it in your database if you manually count the number of topics/posts by yourself;

Find the forums_forums table and it is organized in forum id order. Find the forum id of that board from the URL (https://i.gyazo.com/e4dfe0510f0dc74e49697571604d830f.png) and find the table for it. Change the number of topics and/or posts you'd like to change it to.

Thanks for reply but that would not be any good as I made auto forum posting Bot and on daily bases it adds new posts and I can't go to SQL DB everyday and update how many posts it has posted.

 

That's why I was asking if there is some sort of tool or script that can be made so it recounts number of posts on the website.

 

Thank you 

[Jeffrey]

19 minutes ago, STAR said:

Thanks for reply but that would not be any good as I made auto forum posting Bot and on daily bases it adds new posts and I can't go to SQL DB everyday and update how many posts it has posted.

 

That's why I was asking if there is some sort of tool or script that can be made so it recounts number of posts on the website.

 

Thank you 

There is no script or tool currently out right now that recounts posts or topics on a forum. In a post on the official IPS forum, a situation like this one was brought up and IPS management investigated it as a report and not a need for a tool. In the end, they fixed the bug and released no tool. You can read about it in the post: https://invisioncommunity.com/forums/topic/407840-where-are-the-rebuild-recount-tools/

If you are looking to request or buy a custom script or tool to be made for you, make a post in the "Marketplace" board: https://webflake.sx/forum/108-marketplace-buy-sell-trade/

 

Edited April 4, 2018 by Testmyluck

[titcrunch]

??? ips have task for this lol you can launch manualy this task in admin => search task and take the system task all task are here and you have one for for recount and rebuild

is not wicked but sometime i don't understand the support team of this forum who answer completly next to the subject ...

Edited April 4, 2018 by titcrunch

[Jeffrey]

22 minutes ago, titcrunch said:

??? ips have task for this lol you can launch manualy this task in admin => search task and take the system task all task are here and you have one for for recount and rebuild

is not wicked but sometime i don't understand the support team of this forum who answer completly next to the subject ...

I apologize that I try to give an answer to someone and at least try to give them a solution that might help them. The support team answers and gives solutions to problems that we have experienced ourselves. We are all humans, make mistakes, and have not experienced some things that you might have experienced. If our solution isn't the best one or correct, we appreciate the member(s) who might know an effective solution or fix for someone problem. I do appreciate you helping the member with his problem, but please understand that the support team isn't the most accurate. 

[STAR]

43 minutes ago, titcrunch said:

??? ips have task for this lol you can launch manualy this task in admin => search task and take the system task all task are here and you have one for for recount and rebuild

is not wicked but sometime i don't understand the support team of this forum who answer completly next to the subject ...

hey thanks for reply canm you please post screen shot which option I need as I can't seem to find recount or rebuild option

 

Thank you

[titcrunch]

48 minutes ago, STAR said:

hey thanks for reply canm you please post screen shot which option I need as I can't seem to find recount or rebuild option

 

Thank you

launch cleanup, cleanupfile and clearcache for empty the cache and launch the rebuild of all data but i think that don't correct your problem your problem come of old file or template qui don't use the new code and count blog, clubs, ecttt the nw code count only post in forum so for verifiy this activate defaut theme and look if you have the same error of count if yes you have old file who need update if no is your theme who are out of date

Edited April 4, 2018 by Davlin
Edited for abusive behavior.

[GradientWizzard]

To be honest, I don't think there is much you can actually do with this problem. IPS simply removed the whole feature to try and make it automatic... that failed. I think the only way is going to be third party add-on, unless cookie has an idea in mind.

[killshandra]

yes checked 2 times also  on the task and there is no option to recount

[STAR]

1 hour ago, Hidden Ninja said:

To be honest, I don't think there is much you can actually do with this problem. IPS simply removed the whole feature to try and make it automatic... that failed. I think the only way is going to be third party add-on, unless cookie has an idea in mind.

Do you have link where I can buy this I'm happy to pay for it.

1 hour ago, killshandra said:

yes checked 2 times also  on the task and there is no option to recount

Yeap same here.

1 hour ago, titcrunch said:

launch cleanup, cleanupfile and clearcache for empty the cache and launch the rebuild of all data but i think that don't correct your problem your problem come of old file or template qui don't use the new code and count blog, clubs, ecttt the nw code count only post in forum so for verifiy this activate defaut theme and look if you have the same error of count if yes you have old file who need update if no is your theme who are out of date

There is no old posts I have custom Auto Posting script running which posts threads on my website and makes 20 posts every minute. 

 

So all new posts made by my auto posting Bot is not been counted towards forum stats search finds this posts as I have rebuilt the search but website it self does not count them on front end even thou there is 300 something pages inside with 25 topics per page

 

[Cookie Monster]

13 hours ago, Testmyluck said:

You could change it in your database if you manually count the number of topics/posts by yourself;

Find the forums_forums table and it is organized in forum id order. Find the forum id of that board from the URL (https://i.gyazo.com/e4dfe0510f0dc74e49697571604d830f.png) and find the table for it. Change the number of topics and/or posts you'd like to change it to.

To build on this, i think you can use SQL and triggers to say, IF a INSERT is made into XYZ then count the number and insert the value into another field or table.

 

https://www.w3resource.com/mysql/mysql-triggers.php

 

So you can think of it like a PHP version, you tell SQL that IF an insert is run into the forum COUNT the topic and then UPDATE the table you want ?

[Jeffrey]

The question(s) in this support topic have been answered and the topic author has resolved their issue. This topic is now closed. If you have other questions, please open a new topic.