Support Forum

Usergroup/membership problem

LI l2ickard
l2ickard
Member

Hello!

After I recently updated to the latest version of SP most of the members of the site/forum can no longer post/view the forum because they appear to no longer be in the “Members” group.

I’ve tried the “Map users to usergroup” function but it just times out for me. I can see in phpmyadmin in the “wp_sfmemberships” table that it runs for a while and process users (around 800-900 users) before it stops. Leaving no error in the error log of the forum.

I have quite a lot of members 177k, so I don’t know if it has anything to do with that the reason that the mapping of users times out.

Also in “Manage user groups” I cannot view the “Show/problem-with-post-edit-buttonide users without memberships”, if I press that button it locks up the mysql server and I have to restart it.

Site runs on a dedicated server with 32gb RAM.

I’m grateful for any help so I can get my members back to posting! :)

30 Answers

New Answer

YS Yellow Swordfish
Yellow Swordfish
Member

Can we start by knowing which version you upgraded from please? And as to ram – then how much is php being allocated?

LI l2ickard
l2ickard
Member

I upgraded from 5.3.

I’ve tried increasing the memory_limit for php a lot and even set it to have no memory limit but it didn’t help.

YS Yellow Swordfish
Yellow Swordfish
Member

5.3 to 5.3.1? The updates to the database in that sequence were very, very restricted – certainly nothing to do with user groups and memberships took place.

Still curious however – exactly what is the php memory allocation? What is reported on the forum admin > toolbox > environment panel?

LI l2ickard
l2ickard
Member

Hmm weird. If I look at the bottom of the forum where the stats are it says ~177k members. But if I go in “Manage user groups” and click the “show hide members” for the “Members” user group it says ~33k users.

I have it set at: Memory: 256M

BJ B. E. Johnson
B. E. Johnson
Member

I’m experiencing something along the same lines. I’ll start another thread but thought it might throw a bit of light on this issue if I replied here as well.

I’ve had two users so far that start out in the Members Group and some time later they also appear in No Membership on the frontend Members listing. Backend looks fine. Just happens all by itself. I’ve looked into the tables and see the phantom user and, from driving around in the settings, it appears that editing the database is the only way to clear the ghost. Probably have some conflicting setting somewhere but nothing jumps out.

MP Mr Papa
Mr Papa
Member

BE Johnson, so you saw this too only after upgrading to 5.3. like OP??

Isickard, is this standard wp or multisite?   any mermbeship plugin?

can you compare the rows in the wp users table to the rows in the sfmembers table?

LI l2ickard
l2ickard
Member

It’s standard WP. I don’t know if its classed as a membership plugin but I use “Register Plus” and “CaPa Protect” plugins.

wp_sfmembers: 177,367

wp_sfmemberships: 165,516

wp_users: 177,422

MP Mr Papa
Mr Papa
Member

well the three of those wouldnt necessarily match up…  the sfmembers and wp users should match… not sure why the slight discrepancy there…  though the sf membership count certainly indicates you have a lot of users with a membership…  what info cause you to say members didnt have any memberships?

no clue what capa protect is or does…

not sure how they would have moved out of any usergroup in last update… there was no change at all in that area of code and certainly no action to move users around…  are you using forum ranks?  and auto assigning membership based on post count?

 

LI l2ickard
l2ickard
Member

Mr Papa said

what info cause you to say members didnt have any memberships?

 

When I click the “show/problem-with-post-edit-buttonide members” of the usergroup “members” it lists 31474 users.

 

Mr Papa said

 are you using forum ranks?  and auto assigning membership based on post count?

 

Yes I’m using forum ranks and auto assigning membership, but it’s set to the “Members” group for all ranks.

MP Mr Papa
Mr Papa
Member

but members is a usergroup membership… so confused as to your statement…

LI l2ickard
l2ickard
Member

Maybe I misunderstood you because now I don’t know what you mean? :)

In the “Members Usergroup” there are 31k members. The rest of my members (~145k) are listed as “Members Not Belonging To Any Usergroup” and therefore cannot view or post in the forum.

How can I get these members to be listed in the “Members Usergroup” when the map users to usergroup function doesn’t work for me?

YS Yellow Swordfish
Yellow Swordfish
Member

it seems to me there are two important questions… (1) why did these users get separated and (2) why does the mapping stop after so few users have been processed. And both really need to be got to the bottom of.

But – thinking more about getting these users into their proper home have you tried the ‘Add Members’ tool? It might take a little longer as you will probably need to batch them into manageable chunks but it should do it for you.

LI l2ickard
l2ickard
Member

Unfortunately I cannot use the “add members” tool either, if I click on it just sits there forever loading and locks up mysql for the site so I have to restart the mysql server.

The process that locks it up looks like this:

Query 547 Copying to tmp table SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_sfmemberships.user_id, wp_sfmembers.display_name, wp_sfmember
BJ B. E. Johnson
B. E. Johnson
Member

Fixed mine. It’s a new forum, so not a lot of users & easier to manage.

In the backend, the Users not belonging to a user group display was empty. Only the frontend shows some members duplicated in Members and Members not belonging to a usergroup.

Found a pattern in the 22 members, 11 of which had spuriously shown up on the frontend Members listing as not belonging to a usergroup; when they also appear in the members group. It was only users who had posted.

Because I’m using ranks, as soon as a person posted, they would trigger the New Member rank. However, the New Member group hadn’t been created, so they went into limbo. I had thought that the Rank only changed the badge and that all were members. I created the usergroup and moved the members into it, thinking this would fix it. Nope. Then found that forum perms had to be set for the new group. Still didn’t fix it. Then found that the user mapping had to be done after the fact to remap users already signed up. Once that took place, the frontend fell in line.