[Solved] How to Remove (Old) User Roles

Asti

Translate ▼

Hi @asti,

Well, we found the reason why there are so many "User Roles" in your plugin. Looks like they were purposely added to your plugin to support many "scenarios." (i.e., you added the most popular user roles to the plugin). Click here.

Not sure they need to be deleted at this point, but sure would be nice if your plugin loaded at first the basic WordPress "User Roles" and then, as website owners add new "User Roles, your plugin will detect them and add them/delete them, as applicable. That would be a dynamic operation with complex coding involved.

Oh well, your call on how to address this. Thank you.

Cheers!

Asti

Support

(@asti)

Joined: 8 years ago

Illustrious Member

Posts: 8205

Jun 12, 2020 9:09 am

Translate ▼

Those roles were saved in the database. They are not displayed in the frontend anyway, just in the wpDiscuz settings. Also, it doesn't have any effect on a plugin work. If they are somehow disturbed you please send us the login details. I'll ask the developers to remove those user roles for the list.

In case you want to say thank you! 🙂
We'd really appreciate if you leave a good review on the plugin page.
This is the best way to say thank you to this project and the support team.

AeroStar

(@aerostar)

Joined: 6 years ago

Estimable Member

Posts: 123

Jun 12, 2020 3:34 pm

Asti

Translate ▼

@asti,

As suspected, thank you!

For future reference, can you provide the name of the database containing these roles and the proper SQL command to delete these roles?

As an option, you can also provide the SQL search term(s) to find them.

Again, thank you!

Tom

Support

(@tomson)

Joined: 10 years ago

Honorable Member

Posts: 506

Jun 12, 2020 3:41 pm

Translate ▼

@aerostar

There are many plugins which allow removing user roles. Please use one of them: https://wordpress.org/plugins/search/delete+user+role/

AeroStar

(@aerostar)

Joined: 6 years ago

Estimable Member

Posts: 123

Jun 12, 2020 3:55 pm

Tom

Translate ▼

We already did that. The plugin(s) you are referring to delete "User Roles" at the admin level. They did not delete the "User Roles" that are hard-coded into your plugin (i.e., tables). @asti agrees and knows what we're talking about.

Again, if at all possible, kindly provide info requested.

Thank you!

Tom

Support

(@tomson)

Joined: 10 years ago

Honorable Member

Posts: 506

Jun 12, 2020 4:06 pm

Translate ▼

wpDiscuz doesn't have any hard coded roles. It seems the user roles are saved in each user usermeta table by WordPress.

AeroStar

(@aerostar)

Joined: 6 years ago

Estimable Member

Posts: 123

Jun 12, 2020 4:19 pm

Tom

Translate ▼

We'll explore this a bit more. We used several "User Role" editing plugins and they did not appear (nor delete) the "User Roles" displayed in your plugin settings (link provided above).

Also, we just checked our usermeta table and the "User Roles" do not appear there.

So, in short, your plugin is apparently "not communicating" with these other plugins.

While we work on this a bit more, can you tell us what file/hook generates or embeds the "User Roles" listed in your plugin settings? For example, the ones listed here: http://prntscr.com/sxfdth

Thank you.

AeroStar

(@aerostar)

Joined: 6 years ago

Estimable Member

Posts: 123

Jun 12, 2020 4:43 pm

Translate ▼

To be more specific, we installed the plugin Members, deleted all unwanted roles, and kept only the ones shown here. Afterwards, we deactivated your plugin, flushed all cache, then reactivated your plugin. The unwanted "User Roles" still show up in your plugin as shown here.

Cheers!

Tom

Support

(@tomson)

Joined: 10 years ago

Honorable Member

Posts: 506

Jun 12, 2020 5:02 pm

Translate ▼

Ok, the list of roles in the wpDiscuz settings page is correct, but the problem only exists with the label names. This is a serialized array in the database and it's not easy to update. You should copy it, unserialize, delete unnecessary once, then serialize it back and update the option. I'm sorry but I can't guide how to do that, there is no easy steps.

These options should not cause you any trouble, they should not be displayed on the front-end so you can ignore them.

AeroStar

(@aerostar)

Joined: 6 years ago

Estimable Member

Posts: 123

Jun 12, 2020 6:31 pm

Tom

Translate ▼

OK. I"ll buy that! 🙂

Do you know in what database table the array resides in?

Last, please know we appreciate very much your support. We already left an excellent review for your plugin, and expect to purchase your add-ons as our website (viewership) grows.

Again, thank you!

Asti

Support

(@asti)

Joined: 8 years ago

Illustrious Member

Posts: 8205

Jun 13, 2020 10:32 am

Translate ▼