How to delete user_roles from more_fields DB
-
I used a role editor recently and needed to delete a role. After deleting it I noticed that it began to appear as blank in the edit user role drop-down. After a bit of investigating and deleting entries from the database. I renabled more_fields and the blank boxes reappeared. I then did a db search and found multiple entries in
wp_options
more_fields
asa:12:{i:0;s:13:"administrator";i:1;s:6:"editor";i:2;s:6:"author";i:3;s:11:"contributor";i:4;s:10:"subscriber";i:5;s:11:"distributor";i:6;s:10:"integrator";i:7;s:5:"sales";i:8;s:7:"support";i:9;s:7:"revisor";i:10;s:7:"premier";i:11;s:9:"marketing";}
I’ve tried adjusting it back to wps default roles, something like
a:5:{i:0;s:13:"administrator";i:1;s:6:"editor";i:2;s:6:"author";i:3;s:11:"contributor";i:4;s:10:"subscriber";}
and it causes the site to 404. I simply haven’t been able to resolve this issueI’ve added the database details to pastebin
And also posted the problem on stackexchange
Any help would be greatly appreciated.
- The topic ‘How to delete user_roles from more_fields DB’ is closed to new replies.