Remove WP Affiliate Manager database entries

[nextstep]

I have removed WP Affilate Manager plugin (I’m not going to have anysort of affiliate program) and have used a Database Cleaner to remove the tables that remained after installation. However in the Users Drop down for WP roles Affiliate & Pending still remain as choices.
Would you please advise where I need to go in the phpMyAdmin Mysql database to remove these please.
Thankyou

[Shadow Labs]

Hi, Those users are created by WordPress. So you will probably need to look at the WordPress user table.

[nextstep]

No I can’t locate them in User table or Usermeta for that matter. Roles don’t appear to be included in User.

The two terms Affiliate and Pending I believe come from your plugin: Affiliate and Pending (acceptance) as I haven’t installed any other affiliate plugins.

This is found in capabilities table in usermeta
a:2:{s:14:”wpam_affiliate”;b:1;s:9:”affiliate”;b:1;}
a:2:{s:14:”wpam_affiliate”;b:1;s:7:”pending”;b:1;}

What I don’t understand is when other plugins add roles and I uninstall the plugin those roles go with it, nevertheless I located a plugin that allowed me to delelte the two roles.

FYI (& others) it was User Roles and Capabilities by mahabub

User Roles and Capabilities

Thanks for your help, you can mark this as “resolved”

[Author]

Posts