AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

Filter by custom fields

Topic prefix

AI Assistant
Notifications
Clear all

[Closed] users into usergroups, impossible to move/view

14 Posts
3 Users
0 Reactions
1,745 Views
Posts: 58
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@agendavolo)
Trusted Member
Joined: 9 years ago
[#16473]

I had discussed about deleting and recreating my dummy users. Now I seem to have a problem in the backend, as I need to assign over 12K users to my custom role:

1) there's no way of bulk doing that, I must do it manually

2) even by doing so, the total users list don't diminish and I have to go to next page each time

3) even by doing so, users' count from the original group don't diminish so it's impossible to filter the ones already added in step 1

4) if I re-assign a custom role to the original role, the custom role users' count is stuck and doesn't diminish

Something has gone wrong here. I need some automation. Can I do anything from Usergroups page? Please advice.


13 Replies
1 Reply
(@johndik)
Joined: 7 years ago

Active Member
Posts: 6
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
Posted by: @agendavolo

I had discussed about deleting and recreating my dummy users. Now I seem to have a problem in the backend, as I need to assign over 12K users to my custom role:

1) there's no way of bulk doing that, I must do it manually

2) even by doing so, the total users list don't diminish and I have to go to next page each time

3) even by doing so, users' count from the original group don't diminish so it's impossible to filter the ones already added in step 1

4) if I re-assign a custom role to the original role, the custom role users' count is stuck and doesn't diminish

Something has gone wrong here. I need some automation. Can I do anything from Usergroups page? Please advice.

Yea I do experience the same too.


Robert
Posts: 10718
Admin
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@robert)
Support Team
Joined: 2 months ago

@agendavolo,

Please leave a screenshot of the usergroup admin page and let me know the current usergroup of the users you want to attach to the custom usergroup.


Posts: 58
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@agendavolo)
Trusted Member
Joined: 9 years ago

in the screenshot you can see how my custom usergroup (fake users) is still showing the few I added manually but then un-assigned.

I want to move all "registered" into "fake users", I need to do it in one go (you can see how many they are), and I need the counting to be real

usergroups

10 Replies
Robert
Admin
(@robert)
Joined: 2 months ago

Support Team
Posts: 10718
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian

@agendavolo,

Please take a full width/height screenshot of this page.


(@agendavolo)
Joined: 9 years ago

Trusted Member
Posts: 58
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian

@robert see file attached

 usergroupsfull

Robert
Admin
(@robert)
Joined: 2 months ago

Support Team
Posts: 10718
Robert
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian

@agendavolo,

Ok, this SQl will move all users from the Registered usergroup (ID:3) to fake usergroup (ID:6). Use your hosting cPanel > phpMyAdmin database manager, backup the wp_wpforo_profiles table, then execute this SQl in the SQl Tab, make sure the table prefix wp_ is correct, if your tables' prefix is different, change it in the SQL command:

UPDATE `wp_wpforo_profiles` SET `groupid` = 6 WHERE `groupid` = 3

Robert
Admin
(@robert)
Joined: 2 months ago

Support Team
Posts: 10718
Robert
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian

After executing his SQl, go to Dashboard > Forums > Dashboard and click the [Delete all caches] button.


(@agendavolo)
Joined: 9 years ago

Trusted Member
Posts: 58
Robert
Robert
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian

easy as pie, my usergroups now show all right... yet, the counts in the users page (WP dashboard) are still showing as in my previous screenshot


Robert
Admin
(@robert)
Joined: 2 months ago

Support Team
Posts: 10718
Robert
Robert
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian

@agendavolo,

Usergroups don't have any relation to WP users page, there is no usergroups in the WP users page. If you mean the members page then please specify, be more clear.


(@agendavolo)
Joined: 9 years ago

Trusted Member
Posts: 58
Robert
Robert
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian

@robert see the image attached (it's from the "user page", not the "forum members page"): what I mean is that after I successfully run the SQL query and assigned users to my custom-role, Wordpress is still counting them as when I opened this post

 user counts

Robert
Admin
(@robert)
Joined: 2 months ago

Support Team
Posts: 10718
Robert
Robert
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian

@agendavolo,

These are User Roles, these are not usergroups. User Roles are WordPress parts, it doesn't have any relation to wpForo. You should find a solution in WordPress support forum or in a Wp plugin: https://www.google.com/search?q=WordPress+bulk+change+user+roles


Robert
Admin
(@robert)
Joined: 2 months ago

Support Team
Posts: 10718
Robert
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian

Something like this: https://www.wordpresspluginfinder.com/bulk-role-change/


(@agendavolo)
Joined: 9 years ago

Trusted Member
Posts: 58
Robert
Robert
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian

but actually, if I look at each user individually it is set with my normal role, so I don't understand why the roles' count doesn't reflect that


Share: