“sufficient permissions” error for admin after duplicating WP database to new install

So you’ve duplicated the tables in the DB, with the new set having the dev_ prefix? In that case, the problem is probably that you have not updated the fields within the duplicated tables that inherit that prefix.

For instance, dev_usermeta will now have a meta_key called wp_capabilities. This needs to be dev_capabilities. Also, dev_options will contain an option_name called wp_user_roles. This needs to be dev_user_roles.

I’m not aware of any other instances, but I may be wrong.

Related Posts:

  1. Read only capability for custom post in admin area
  2. Text snippets shared across posts
  3. Add Admin User via SQL
  4. How can I restore admin capabilities?
  5. What determines whether admin toolbar is shown to a logged-in user?
  6. How do you set up a WordPress blog with multiple authors to allow something like StackExchange’s “community wiki” feature?
  7. Admin cannot publish
  8. WordPress Remove Submenus
  9. page not updating with database
  10. /wp-admin/install.php redirecting to 123-reg
  11. current_user_can(‘administrator’) not working in custom login
  12. Redirect admin 403 “Cheatin uh?” admin pages
  13. Having problem creating local instance of wordpress site
  14. Give admin_menu permission to specific users
  15. Cannot access wp-admin after installing SSL – user capabilities not being set
  16. How can I create multiple different admin roles with their own capabilities
  17. Capability to read/edit page in wp-admin only for administrators
  18. I don’t have permission to save the theme options I created myself?
  19. Where in WP can I check history or log of updates of plugins etc?
  20. How does admin-ajax.php work?
  21. Hide other users’ posts in admin panel
  22. Editor Styles and Typekit
  23. WordPress admin stylesheet
  24. Is it possible to create a WordPress tour? V3.3.1
  25. Securing Admin Accounts – Username Discovery
  26. Prevent author from changing their posts if admin has modified
  27. Showing WP_Error message with admin_notice action hook
  28. Set Featured Image programmatically (in admin) with JavaScript?
  29. Can I set a default dashboard layout for all users?
  30. Taxonomy/category hierarchy lost when editing posts [closed]
  31. Making the thumbnails in the backend Media section bigger
  32. How to remove “Super Admin” from All Users for those that are not a “Super Admin”?
  33. Customize the upload screen
  34. How to print the output of the get_num_queries function from frontend to backend?
  35. Where is custom template file chosen for a post stored in the DB?
  36. Setting Login with User Name and Password default option for Jetpack Admin Login
  37. Downloading entire site locally with httrack
  38. add_submenu_page set for multiple roles [duplicate]
  39. How To Create User Specific Admin User Pages?
  40. Adding markup to column text in “Edit Pages” admin page
  41. Disable HTML (Text) Tab in Post Editor
  42. How to remove “publish metabox” from each post type
  43. Change home-url in dashboard
  44. Admin doesn’t have sufficient permissions to plugin’s page
  45. Admin multiple column sorting
  46. How do I add a contact form?
  47. Adding html format on tinymce visual editor
  48. How can I show the contents of only a few users
  49. WordPress ACL (folder + permissions)
  50. Editors change a permalink on an unpublished post, but only admins change a permalink on a post that has ever been published?
  51. Locked out of admin and some pictures don’t show after failed SSL installation
  52. How-to turn off mobile admin mode?
  53. Grabbing the first image attached to a post and use it with the admin columns
  54. Add Custom Script in Other Plugin’s Options page
  55. I can’t access the login panel on my offline website
  56. Output the admin menu_position for each item
  57. Admin login not working
  58. WordPress custom admin functions security
  59. Adding and removing columns from the admin pages panel
  60. paginate_links on custom query in admin – ‘sufficient permissions’ error
  61. Hide admin notice when user profile updated
  62. WordPress Screen options does not show any fields
  63. Locked out of WordPress website from wrong amount of login attempts
  64. Black admin bar is being hidden by page elements
  65. admin edit link from a specific page
  66. Set Link Target Checkbox chcked on Edit Image MOdal Window in Admin Post Edit Screen?
  67. Help! I changed the domain and now I can’t log in via admin online
  68. Remove specific administrator’s capability
  69. Username was changed to “admin”
  70. Admin user roles/permissions
  71. Parsing post->ID in included plugin file
  72. remove “Edit” from select pages
  73. Gutenberg UI has changed
  74. Call require_once form admin page with checkbox
  75. How To Remove Import/Export Option From Tools?
  76. Highlight active Admin Menu when added though add_menu_page
  77. Unable to access admin web page
  78. Create WordPress Menu Item Without Linking to a Custom Page
  79. Search Only Works when Logged into Admin
  80. exclude ID on avatar
  81. Missing content on website. Admins cant sign in
  82. Different role for free and pro users in wordpress without using bbpress
  83. Is Post-Form Resubmission somehow prevented in WordPress 4.2.2?
  84. Enqueue script throws error in console
  85. How to sort post_meta in edit.php?
  86. Scripts are not called until I login from wordpress backend
  87. Link to all posts page?
  88. WP Logs me out after updating anything on dashboard
  89. Adding additional text fields and image upload to a Page?
  90. Calculate and save an average in a meta
  91. If the only thing I use MySQL for is WordPress, do I need MySQL’s timezone tables?
  92. plugin to upload to youtube via wordpress [closed]
  93. How to fix: Clicking ‘Quick Edit’ link in Admin (edit.php) makes posts disappear?
  94. My Account Lost Administrator permission
  95. WordPress admin panel is blank
  96. Use the wordpress admin table
  97. deploying a standard build of wordpress in WHM/cPanel
  98. Add custom css class to wp-list-table row for custom post type
  99. Custom column with post ID not working in CPT
  100. Modify ‘the_content’ appearance in the admin area