Fixed – WordPress User Role dropdown is blank

By | January 28, 2020 | 0 Comment
Category: WordPress

Issue

When I try to add a new user in WordPress under Admin > Users > Add New User, it shows blank dropdown.

Root Cause

I manually tried to change the WordPress prefix after WordPress blog was created. I made change only within wp-config.php and renamed tables but it required change in data as well. This caused the issue.

Fix

Table PREFIX_options has a record with option_name = ‘wp_user_roles’. Change the option_name to ‘PREFIX_user_roles’.

Table PREFIX_usermeta has a record with meta_key = ‘wp_capabilities’ and ‘wp_user_level’. Change meta_key to ‘PREFIX_capabilities’ and ‘PREFIX_user_level’.


About Vishal Monpara

Vishal Monpara is a full stack Solution Developer/Architect with 13 years of experience primarily using Microsoft stack. He is currently working in Retail industry and moving 1's and 0's from geographically dispersed hard disks to geographically dispersed user leveraging geographically dispersed team members.