Best of joomla gives you news, joomla templates, tutorials and websites about Joomla , FireBoard and FireMessage official page.
| No account yet?   |
The FireBoard forum component development is still going on. In order to get better, FireBoard will be moved from the Best of Joomla website.
During this transition period, the forum in Best of Joomla will be closed to new posts.
Welcome, Guest
Please Login or Register.    Lost Password?
FireBoard Manual Latest release discussions Download FireBoard
Recount Category Stats Not Working / Timing Out (1 viewing) (1) Guest
TOPIC: Recount Category Stats Not Working / Timing Out
#61915
Recount Category Stats Not Working / Timing Out 1 Month, 3 Weeks ago  
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
imaaxx (User)
Junior Boarder
Posts: 26
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
 
#61920
Re:Recount Category Stats Not Working / Timing Out 1 Month, 3 Weeks ago  
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!!!
imaaxx (User)
Junior Boarder
Posts: 26
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
 
#61922
Re:Recount Category Stats Not Working / Timing Out 1 Month, 3 Weeks ago  
You can mark this solved and maybe "Sticky" this as it seems many people are having the same problems...

Best Regards
imaaxx (User)
Junior Boarder
Posts: 26
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
 
#61932
Re:Recount Category Stats Not Working / Timing Out 1 Month, 2 Weeks ago  
Right, fixed my problem with the category statistics too after upgrading to 1.05 RC2.
zehlein (User)
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
 
#62041
Re:Recount Category Stats Not Working / Timing Out 1 Month, 2 Weeks ago  
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
sunnyjey (User)
Junior Boarder
Posts: 25
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
 
#62790
Re:Recount Category Stats Not Working / Timing Out 4 Weeks ago  
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:
Code:

var $ctype = 'mysql';


but needs to be this:
Code:

var $ctype = 'mysqli';


for MySQL 5+ using the mysqli PHP extension.
jayjovial (User)
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
Last Edit: 2008/12/11 23:58 By jayjovial.
 
 
Go to top