Fixed – WordPress User Role dropdown is blank

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’.