I have a site with 1500+ users and over 10,000 posts but have NEVER had a problem with recounting stats.
It runs on Joomla 1.0.13 and FB 1.04 = (EXTREMELY modified) BUT I am on a dedicated server. But still I have never seen the slightest delay in stats count or posting. This just seems so strange. I wonder if the different templates MAY have something to do with it OR just overall configuration.

Something that I HAVE read on this forum. If you have mod latest post running, THIS is killing your server to begin with. If either of you ARE running mod latest posts for FB, try uninstalling that and see what (If anything) changes.

Hazzaa wrote:
Have you tried reinstalling like I suggested?

Nothing to do after reinstall!

My idea is the problem is the cycle in class.fireboard.php... I'm an engineer, but i have no clear idea to do for resolve this "bug".

Too many cycles in this "while" ....

yes you are correct, and if you replace the select statement for categories to only retrieve 1 (or even a for each for the catid's you have) it will run.

I will go through the code and run some tests tomorrow. I will post what I find.

I'm not sure about the code, but it looks like it could only run into an infinite loop if you have a thread where no parent==0.
You should run "SELECT COUNT(thread) FROM jos_fb_messages" and "SELECT COUNT(thread) FROM jos_fb_messages WHERE parent=0" on your database, to assure that every thread has its root (parent==0). Both results has to be the same.

Goodbyte wrote:
I'm not sure about the code, but it looks like it could only run into an infinite loop if you have a thread where no parent==0.
You should run "SELECT COUNT(thread) FROM jos_fb_messages" and "SELECT COUNT(thread) FROM jos_fb_messages WHERE parent=0" on your database, to assure that every thread has its root (parent==0). Both results has to be the same.

SELECT COUNT(thread) FROM jos_fb_messages = 10814

SELECT COUNT(thread) FROM jos_fb_messages WHERE parent=0 = 2078

2078 messages are without a parent?

The meaning of this???


But this number is so similar to the number of thread and to the number of responses....

2070 threads, 10718 responses from fireboard backend....

Ok, we have to find a solution...

"Parent" what is it in the forum?

if i select all of row with parent=0, and i assign to parent a number.... what can i see?

If parent==0 this messages starts the thread. Because of this every thread should have exactly (for the loop "at least" is important) one starting post (with parent==0).

Please execute the query "SELECT * FROM `mos_fb_messages` WHERE parent=id" this should return an empty result.

Goodbyte wrote:
If parent==0 this messages starts the thread. Because of this every thread should have exactly (for the loop "at least" is important) one starting post (with parent==0).

Please execute the query "SELECT * FROM `mos_fb_messages` WHERE parent=id" this should return an empty result.

yes!!! empty! no row with parent=id

so...what i have to find in DB to resolve this problem???

parent==id whould be a suspicous setting. You have to find out which threads have a root with parent!=0 or which thread has no messages with parent==0.
But I think a dev should confirm, that we are on the right way.