Support Forum

Stats not correct on my forum

CM Carley A Morrow
Carley A Morrow
Member

Not sure what the problem is…probably easiest to have a look;

http://www.socialots.co.uk/forums/

There are hundreds of members, however member/forum stats are incorrect. I’m not too bothered about this as I was thinking of removing them anyway, but would be good to know what the issue is 🙂

21 Answers

New Answer

MP Mr Papa
Mr Papa
Member

well, I can see the stats, but not really sure what they are supposed to be…

the stats are cached… but its only 1 hour right now… in 5.0.5, you will be able to choose…

please look in your db… how many rows do you have for the wp users table?  and how many rows for the sfmembers table?

did the users exist before you installed simple press?  how did they register?

DH Debbie Hodge
Debbie Hodge
Member

I have a similar problem.

My users all existed before the simple press install.

They registered via Wishlist.

TB Tony Bandalos
Tony Bandalos
Member

Same issue here,

my sfmembers table is showing 2337 members the same as the wp users, however only 765 members are registered in the forum.

 

Any ideas?

TB Tony Bandalos
Tony Bandalos
Member

Hold on, I take it back. The IDs go up as high but there are gaps, hence the missing members. They were in the system prior to installing

MP Mr Papa
Mr Papa
Member

wow. too many different issues in one post! wink

Debbie, so you have to go to forum – usergroups – manage usergroups and manually add the members to the desired usergroup…  the auto only works on new users… we have a ticket to add a tool to add in this, but no eta…

Tony, confused…  how many rows in sfmembers?  that should be the number of users the stats displays…  stats are cached at 1 hour (user selected in 5.0.5)…

Do you know that your wp cron stuff is running and working?   the stats use the wp cron to  do their thing…  you could try deactivating (DO NOT uninstall) and then reactivating SP…  That will make sure our cron jobs get restarted, but wont help if its wp issue…

if that does not help, go to your blog and create a new wp post… just a test post… schedule it to be created in 10 minutes… and see if it appears… should verify if wp cron stuff is working…

also, edit your spFunctions.php in your sp theme… add this line at the top:

sp_cron_generate_stats();

and see if the stats update…  that will force the stats to generate on every page load… wasteful and overhead but at least verify the functionality is working…

DH Debbie Hodge
Debbie Hodge
Member

Thanks. I’ve got everyone added. Disabling and then restarting the Simple:Press plugin got my stats in order.

TB Tony Bandalos
Tony Bandalos
Member

hey Papa,

I misled you. The stats are reading correctly but the table is missing members from the wp users table. There were 2337 users before installing simple press, only 765 are showing in the members directory and this reflects the same in the mySQL table.

MP Mr Papa
Mr Papa
Member

hmmm… did you have any issues on install?  because every user is copied over to sfmembers at install… and frankly, we have not had any problem with that in many years…

TB Tony Bandalos
Tony Bandalos
Member

hey Papa,

based on this I uninstalled and reinstalled the forum. It did much better however it seems like there are 100 members or so still missing. They also appear to be members that have a lot of numbers in front of their name, if that helps.

MP Mr Papa
Mr Papa
Member

uninstalled?  yikes… hope no data you needed… wink

so why would it not be creating the members? rhetorical, I know…  any messages during the install?  anything in the error log?

so the users with numbers in front of their name, are those that are in wp users, but not sfmembers?  or vice versa?  for the ones created in sfmembers, does the display name match the display name in the wp users table?

CM Carley A Morrow
Carley A Morrow
Member

@ Mr Papa

 

please look in your db… how many rows do you have for the wp users table?  and how many rows for the sfmembers table?

did the users exist before you installed simple press?  how did they register?

 

wp users = 5464

sf members = 5466

There were about 10 users before simple-press install

Members register using Buddypress system

 

Thanks, Carley

YS Yellow Swordfish
Yellow Swordfish
Member

Clearly should have read this one before the other thread on the same issue.
There have been issues with user registered via BuddyPress in the past as BP was not firing the necessary WP hooks that enable SP to pick them up. But I thought that was resolved by the BP team a long time ago. Is this, by any chance, an older version?