Support Forum
Support Forum
Offline
It's been a while I am experiencing a problem when adding a member to a user group, I am getting the wait box below showing forever...
This happens in SP Administration, when going to Users Groups / Manage User Groups, in one of my User Groups. I can show the existing members with "Show/Hide Members" button. The problem comes when I press the "Add Members" button, the wait box shows and seems to run forever.
So far, I found in my mysql server logs that this operation creates the following query:
(extract)
SELECT wp_sfmembers.user_id, display_name, admin
FROM wp_sfmembers
WHERE user_id NOT
IN (
SEL....
which goes in "Sending data" for a very long time. I never let it timeout, since it's locking all my other forum queries and I have to kill it manually.
My forum/Wordpress setup has ~80 000 users, the User Group I want to add members on contains just 5 users.
What could be the problem cause, is there a quick fix ?
Thank you.
Offline
let me take a look and come back on this...
 |
YELLOW
SWORDFISH
|
Offline
are you up to making code changes?
|
YELLOW
SWORDFISH
|
Offline
I am up for it if the change scope is expected to be limited to the member adding feature.
My forum is live, I have no staging or pre-production instance and I'd really don't want to break anything 
Cheers.
Offline
Yes that would have been the case but I am going to need to investigate further.
I think the current query there is probably inefficient but constructing an alternative may not be quite as straightforward as I first thought. So - still looking into it but not necessarily an instant fix...
|
YELLOW
SWORDFISH
|
Offline
Ok, I'll wait.
In the meantime, if you have an SQL tip so I can do the operation by hand, manually adding a user_id to a group_id (wp_sfgroups) ?
Thank you.
Offline
Well that is held relationally in the 'sfmemberships' table which holds the user_id and the usergroup_id combinations... So quite easy to manually adjust and add rows to.
|
YELLOW
SWORDFISH
|
Offline
Thanks, that does the job for the moment, but I'll be fine to test any fix you will provide.
Cheers.
Offline
I have opened a ticket. I need to get some test data re-arranged so that I can test things a little more reliably.
|
YELLOW
SWORDFISH
|
Offline
I believe the issue mentionned in that post was marked as fixed in Mantis bugtracker, but can't find it again.
I have recently updated Simple Press to latest version 5.3, hoping to get the database lockup issue would be gone, unfortunately the problem is still there 
All RSS1 Guest(s)