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
latest member in stats not updating (1 viewing) (1) Guest
TOPIC: latest member in stats not updating
#60694
latest member in stats not updating 2 Months, 2 Weeks ago  
i have a similar problem. i have 3780 registerd users showing on my total users module, but in fireboard right down the bottom in the stats area it says 4071 members. And another issue is that fireboard says the last member is x not the last member signed up to the site is not x, there ahve been newer people sign up. i have recently migrated my site from J1.0.15 and FB1.04. All seems to be working fine apart from these issues.

I use J1.5.7, FB1.05RC2, CB1.2RC3, PHP 5.2.3

i have also tried synchronising users in fireboard and community builder but doesnt correct this issue.

i think the issue with the users is that FB stats is showing teh total members wheres the total members module is only showing those members that are confirmed (activated). anyway to change setting in FB?

any ideas about these two issues?
Please note, although no boardcode and smiley buttons are shown, they are still useable
peetree21 (User)
Senior Boarder
Posts: 116
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Australia
Logged Logged
 
Such is Life
 
 
#62134
Re:latest member in stats not updating 1 Month, 2 Weeks ago  
Identical problem here.
albvital (User)
Fresh Boarder
Posts: 16
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
 
#62369
Re:latest member in stats not updating 1 Month, 1 Week ago  
Is everyone on vacation or does no one have the answer?

albvital wrote:
Identical problem here.
albvital (User)
Fresh Boarder
Posts: 16
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
 
#62370
Re:latest member in stats not updating 1 Month, 1 Week ago  
Luckily I'm just now looking at the right file.

look at: components/com_fireboard/template/default/plugin/stats/stats.class.php, line 19:

New code:
Code:

$database->setQuery("SELECT COUNT(*) FROM #__users WHERE activation =''");


That should fix your problem.
mahagr (User)
Junior Boarder
Posts: 94
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
 
#62376
Re:latest member in stats not updating 1 Month, 1 Week ago  
mahagr

Youyr solution gave me the differance between my joomla registered users and fireboard users
So It did not work for me

I am having trouble with all fire board versions , current version is 1.05 rc2

Issues

1)Latest User is not updating
2)Total users registered in joomla has to be manually sync(using fireboard admin options) to show the user count correct.Still the last registered user is an earlier user than the last registered user

SOme where on net I found a solution ,just to make user profile assigned to admin , and then revert back to normal, which kind of work initially, How can I manually do such thing , when there is 1000s of users(You cannot do a group update, unless you get your hands dirty with SQL)

Please suggest,.... .I am almost about to find another forum , solution, but I quite like fireboard


NastyKid
NastyKid (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
 
#62377
Re:latest member in stats not updating 1 Month, 1 Week ago  
Hmm.. You just need to know which users are counted in your other stats module. Which stats module are you using?

The problem is that you can count users in many different ways; you can count them all, you may leave out those who haven't logged in yet, or you may just count registered users and not admins (with many variations to this one). Every module/component can do this in it's own way.

The only solution is to look at the source code of your stats module and do the same in Fireboard.

Default templates get user count and latest user from Joomla, so no sync is needed. The problem may be that FB does not do it in a right way in some environments (Joomla version, other modules).

1) Latest user works in J1.5.5+. Do you have phpmyadmin or Easy SQL for Joomla? Just check the contents of jos_users.activation field. If it's something else than '' (empty string) for registered users, there may be an easy way to correct this issue.

2) This should update on every new user: there is no reason why not. This is because it just counts how many items are in jos_users table (before my change above). And every user must be in that table, otherwise it does not exist for Joomla. The only exception could be that your template messes things up. Just make sure that there is no directory called plugin/stats in your template. If it does exist, remove or rename it.

EDIT:

on 1) check also that jos_users.block = 0, not something else. You may want to make this query:
Code:

SELECT id, name, usertype, block, activation, registerDate, lastvisitDate FROM jos_users WHERE block!=0 OR activation!=''

and look if there are too many users.
mahagr (User)
Junior Boarder
Posts: 94
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
Last Edit: 2008/11/29 02:38 By mahagr.
 
 
#62458
Re:latest member in stats not updating 1 Month, 1 Week ago  
mahagr wrote:
Luckily I'm just now looking at the right file.

look at: components/com_fireboard/template/default/plugin/stats/stats.class.php, line 19:

New code:
Code:

$database->setQuery("SELECT COUNT(*) FROM #__users WHERE activation =''");


That should fix your problem.


Thank you... but it is NOT working.
I need to put something at the end of the code (users WHERE activation = (here) )
albvital (User)
Fresh Boarder
Posts: 16
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
 
#62580
Re:latest member in stats not updating 1 Month ago  
same prob here
Lambass (User)
Fresh Boarder
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Birthdate: 1974-05-25
Logged Logged
 
 
#62629
Re:latest member in stats not updating 1 Month ago  
I also have the same issue. In the FireBoard Control Panel it shows the correct amount of Members:, 5, and it shows me the correct Latest member:, but in the User Administration area it only shows 3 of the members. I've tried syncing also but to no avail.

Even in MySQL in the jos_fb_users table there is only 3 users. So for some reason it's not syncing up. I'm not even sure how the first 3 got on there then.

Any help in this area would be greatly appreciated.
tazboy (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
Last Edit: 2008/12/06 21:24 By tazboy.
 
 
#62886
Re:latest member in stats not updating 3 Weeks, 3 Days ago  
I had the same problem, but in my case it was because i had stopped automatic user activation. So when the users register, they don't get the activation url. Instead, I would then activate the user manually.

What happens is that the activation code is not reset from the user details when the user is manually activated from backend. Which then causes fireboard to exclude these users.
stilester (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
 
Go to top