Hello,

I have spent much time looking for the answer in your forums and although I did see some posts none seemed to help.

Settings:

Joomla 1.0.15
Fireboard 1.0.5 just upgraded from 1.0.4
PHP 5, MSQL 5

This site shows zero posts after the recount categories page is done, even though there are lots of posts (approx. 400 or so posts) … The Recount categories option seems to time out when recounting. I have checked server permissions and ownership and all is well. This problem did exist with the 1.0.4 verison so i tried to update to the 1.0.5 to see if it would help, but the problem still is the same it shows Zero posts.

Any ideas you have or information you need I would be happy to provide…

Thanks for such a great product…

Best Regards

checked my jos_fb_categories table in mySQL and found a duplicate entry in there with id=30 and parent=30... I deleted this duplicate and then ran the Recount Stats again in FB - et voila! So this is what caused the recount to hang in an endless loop. Got all my stats back now

This fixed my problem as I had 2 entries that were like this:

id=6 and parent=6

id=18 and parent=18

So i set the parent for both to "0" then did the recount catagories and BAM! it worked...

Thanks again for a great product!!!

You can mark this solved and maybe "Sticky" this as it seems many people are having the same problems...

Best Regards

Right, fixed my problem with the category statistics too after upgrading to 1.05 RC2.

Hi,

I have similar problem since last one year. My all counts statistics are zero

I have read your post and checked my jos_fb_categories but I cannot see the duplicate id and parent. But I can see some ids are missing. For eg i dont have id no7 and. 23

I have been using fireboard since its beginning. I have one problem which posted twice in the forum 1 year back and 6 months back but still waiting for the solution. I

No statistics are working at my site
1. Views count- 0
2. Post by any user- 0
3. karma - 0

check here

Views count are zero

OR here


where post count of user are zero

Problem could be:
1. I have upgraded and created new categories without deleting sample category ids in the forum in the beginning. If i delete Sample data now-I lose forum posts and categories

2. I have checked jos_categories Mysql some ids are missing for eg I dont have 7 category id

I have tried to upgrade to FB 1.5 RC2 and recounted categories but no use

I will appreciate your help in this matter

My site details:
FB 1.4 stable
Joomla 1.015
Mysql 5

Thank you

Just thought I'd share:

Recount Category Stats using Apache 2.2, MySQL 5.0.6, PHP 5.2.6, Joomla 1.5.7, and FB 1.0.5, was throwing a "call to undefined function" error which turned out to be line 29 in components\com_fireboard\sources\fb_db_iterator.class.php.

It was this:

but needs to be this:

for MySQL 5+ using the mysqli PHP extension.