how can i modifie capabilities with phpmyadmin ?

  • Resolved John Bee

    (@john-bee)


    10 years, 8 months ago

    Hello,

    After some troubles with a plug in, so i want to restore some capabilities to admin role. But unfortunately, i can’t access to wp-admin panel.

    So can you tell me :
    – If i can modifie capabilities using phpmyadmin
    – what are the differents tables to modified
    – the process to modified (delete or add) capabilities.

    Thank you for helping,

Viewing 15 replies - 1 through 15 (of 17 total)

  • Hi John,

    You can modify capabilities using phpMyAdmin (although I wouldn’t recommend doing so for anything other than this type of emergency restoration).

    The table you’re looking for is {prefix}_options (usually ‘wp_options’ but may be different).

    The option name is (if I recall correctly) ‘wp_user_roles’ and the value will be serialized data.

    I’m on free wifi at the mechanic’s shop right now and they seem to have blocked secure ports, so I’m unable to get you the value used on a default WP installation at the moment, but will endeavor to do so a little later this afternoon.

    Thanks,
    Lucas

    Try this:

    a:5:{s:13:"administrator";a:2:{s:4:"name";s:13:"Administrator";s:12:"capabilities";a:62:{s:13:"switch_themes";b:1;s:11:"edit_themes";b:1;s:16:"activate_plugins";b:1;s:12:"edit_plugins";b:1;s:10:"edit_users";b:1;s:10:"edit_files";b:1;s:14:"manage_options";b:1;s:17:"moderate_comments";b:1;s:17:"manage_categories";b:1;s:12:"manage_links";b:1;s:12:"upload_files";b:1;s:6:"import";b:1;s:15:"unfiltered_html";b:1;s:10:"edit_posts";b:1;s:17:"edit_others_posts";b:1;s:20:"edit_published_posts";b:1;s:13:"publish_posts";b:1;s:10:"edit_pages";b:1;s:4:"read";b:1;s:8:"level_10";b:1;s:7:"level_9";b:1;s:7:"level_8";b:1;s:7:"level_7";b:1;s:7:"level_6";b:1;s:7:"level_5";b:1;s:7:"level_4";b:1;s:7:"level_3";b:1;s:7:"level_2";b:1;s:7:"level_1";b:1;s:7:"level_0";b:1;s:17:"edit_others_pages";b:1;s:20:"edit_published_pages";b:1;s:13:"publish_pages";b:1;s:12:"delete_pages";b:1;s:19:"delete_others_pages";b:1;s:22:"delete_published_pages";b:1;s:12:"delete_posts";b:1;s:19:"delete_others_posts";b:1;s:22:"delete_published_posts";b:1;s:20:"delete_private_posts";b:1;s:18:"edit_private_posts";b:1;s:18:"read_private_posts";b:1;s:20:"delete_private_pages";b:1;s:18:"edit_private_pages";b:1;s:18:"read_private_pages";b:1;s:12:"delete_users";b:1;s:12:"create_users";b:1;s:17:"unfiltered_upload";b:1;s:14:"edit_dashboard";b:1;s:14:"update_plugins";b:1;s:14:"delete_plugins";b:1;s:15:"install_plugins";b:1;s:13:"update_themes";b:1;s:14:"install_themes";b:1;s:11:"update_core";b:1;s:10:"list_users";b:1;s:12:"remove_users";b:1;s:9:"add_users";b:1;s:13:"promote_users";b:1;s:18:"edit_theme_options";b:1;s:13:"delete_themes";b:1;s:6:"export";b:1;}}s:6:"editor";a:2:{s:4:"name";s:6:"Editor";s:12:"capabilities";a:34:{s:17:"moderate_comments";b:1;s:17:"manage_categories";b:1;s:12:"manage_links";b:1;s:12:"upload_files";b:1;s:15:"unfiltered_html";b:1;s:10:"edit_posts";b:1;s:17:"edit_others_posts";b:1;s:20:"edit_published_posts";b:1;s:13:"publish_posts";b:1;s:10:"edit_pages";b:1;s:4:"read";b:1;s:7:"level_7";b:1;s:7:"level_6";b:1;s:7:"level_5";b:1;s:7:"level_4";b:1;s:7:"level_3";b:1;s:7:"level_2";b:1;s:7:"level_1";b:1;s:7:"level_0";b:1;s:17:"edit_others_pages";b:1;s:20:"edit_published_pages";b:1;s:13:"publish_pages";b:1;s:12:"delete_pages";b:1;s:19:"delete_others_pages";b:1;s:22:"delete_published_pages";b:1;s:12:"delete_posts";b:1;s:19:"delete_others_posts";b:1;s:22:"delete_published_posts";b:1;s:20:"delete_private_posts";b:1;s:18:"edit_private_posts";b:1;s:18:"read_private_posts";b:1;s:20:"delete_private_pages";b:1;s:18:"edit_private_pages";b:1;s:18:"read_private_pages";b:1;}}s:6:"author";a:2:{s:4:"name";s:6:"Author";s:12:"capabilities";a:10:{s:12:"upload_files";b:1;s:10:"edit_posts";b:1;s:20:"edit_published_posts";b:1;s:13:"publish_posts";b:1;s:4:"read";b:1;s:7:"level_2";b:1;s:7:"level_1";b:1;s:7:"level_0";b:1;s:12:"delete_posts";b:1;s:22:"delete_published_posts";b:1;}}s:11:"contributor";a:2:{s:4:"name";s:11:"Contributor";s:12:"capabilities";a:5:{s:10:"edit_posts";b:1;s:4:"read";b:1;s:7:"level_1";b:1;s:7:"level_0";b:1;s:12:"delete_posts";b:1;}}s:10:"subscriber";a:2:{s:4:"name";s:10:"Subscriber";s:12:"capabilities";a:2:{s:4:"read";b:1;s:7:"level_0";b:1;}}}

    If you’re curious what this unserializes as:

    Array
(
    [administrator] => Array
        (
            [name] => Administrator
            [capabilities] => Array
                (
                    [switch_themes] => 1
                    [edit_themes] => 1
                    [activate_plugins] => 1
                    [edit_plugins] => 1
                    [edit_users] => 1
                    [edit_files] => 1
                    [manage_options] => 1
                    [moderate_comments] => 1
                    [manage_categories] => 1
                    [manage_links] => 1
                    [upload_files] => 1
                    [import] => 1
                    [unfiltered_html] => 1
                    [edit_posts] => 1
                    [edit_others_posts] => 1
                    [edit_published_posts] => 1
                    [publish_posts] => 1
                    [edit_pages] => 1
                    [read] => 1
                    [level_10] => 1
                    [level_9] => 1
                    [level_8] => 1
                    [level_7] => 1
                    [level_6] => 1
                    [level_5] => 1
                    [level_4] => 1
                    [level_3] => 1
                    [level_2] => 1
                    [level_1] => 1
                    [level_0] => 1
                    [edit_others_pages] => 1
                    [edit_published_pages] => 1
                    [publish_pages] => 1
                    [delete_pages] => 1
                    [delete_others_pages] => 1
                    [delete_published_pages] => 1
                    [delete_posts] => 1
                    [delete_others_posts] => 1
                    [delete_published_posts] => 1
                    [delete_private_posts] => 1
                    [edit_private_posts] => 1
                    [read_private_posts] => 1
                    [delete_private_pages] => 1
                    [edit_private_pages] => 1
                    [read_private_pages] => 1
                    [delete_users] => 1
                    [create_users] => 1
                    [unfiltered_upload] => 1
                    [edit_dashboard] => 1
                    [update_plugins] => 1
                    [delete_plugins] => 1
                    [install_plugins] => 1
                    [update_themes] => 1
                    [install_themes] => 1
                    [update_core] => 1
                    [list_users] => 1
                    [remove_users] => 1
                    [add_users] => 1
                    [promote_users] => 1
                    [edit_theme_options] => 1
                    [delete_themes] => 1
                    [export] => 1
                )

        )

    [editor] => Array
        (
            [name] => Editor
            [capabilities] => Array
                (
                    [moderate_comments] => 1
                    [manage_categories] => 1
                    [manage_links] => 1
                    [upload_files] => 1
                    [unfiltered_html] => 1
                    [edit_posts] => 1
                    [edit_others_posts] => 1
                    [edit_published_posts] => 1
                    [publish_posts] => 1
                    [edit_pages] => 1
                    [read] => 1
                    [level_7] => 1
                    [level_6] => 1
                    [level_5] => 1
                    [level_4] => 1
                    [level_3] => 1
                    [level_2] => 1
                    [level_1] => 1
                    [level_0] => 1
                    [edit_others_pages] => 1
                    [edit_published_pages] => 1
                    [publish_pages] => 1
                    [delete_pages] => 1
                    [delete_others_pages] => 1
                    [delete_published_pages] => 1
                    [delete_posts] => 1
                    [delete_others_posts] => 1
                    [delete_published_posts] => 1
                    [delete_private_posts] => 1
                    [edit_private_posts] => 1
                    [read_private_posts] => 1
                    [delete_private_pages] => 1
                    [edit_private_pages] => 1
                    [read_private_pages] => 1
                )

        )

    [author] => Array
        (
            [name] => Author
            [capabilities] => Array
                (
                    [upload_files] => 1
                    [edit_posts] => 1
                    [edit_published_posts] => 1
                    [publish_posts] => 1
                    [read] => 1
                    [level_2] => 1
                    [level_1] => 1
                    [level_0] => 1
                    [delete_posts] => 1
                    [delete_published_posts] => 1
                )

        )

    [contributor] => Array
        (
            [name] => Contributor
            [capabilities] => Array
                (
                    [edit_posts] => 1
                    [read] => 1
                    [level_1] => 1
                    [level_0] => 1
                    [delete_posts] => 1
                )

        )

    [subscriber] => Array
        (
            [name] => Subscriber
            [capabilities] => Array
                (
                    [read] => 1
                    [level_0] => 1
                )

        )

)
    Thread Starter John Bee

    (@john-bee)

    Hello karpstrucking,

    Thank you a lot for helping me.

    I found the table and the row wp_user_roles.

    I don’t really understand what you share me, because i’m really not a developper, but in my configuration i have the following code :

    Questions :
    – what is the second one you share me ? Php ?
    – If i juste switch my code by your code, it will solve my issue ? Or there is an other step to resolve it ?

    a:6:{s:13:"administrator";a:2:{s:4:"name";s:13:"Administrator";s:12:"capabilities";a:107:{s:19:"delete_others_pages";b:1;s:19:"delete_others_posts";b:1;s:12:"delete_pages";b:1;s:12:"delete_posts";b:1;s:20:"delete_private_pages";b:1;s:20:"delete_private_posts";b:1;s:22:"delete_published_pages";b:1;s:22:"delete_published_posts";b:1;s:17:"edit_others_pages";b:1;s:17:"edit_others_posts";b:1;s:10:"edit_pages";b:1;s:14:"edit_permalink";b:1;s:10:"edit_posts";b:1;s:18:"edit_private_pages";b:1;s:18:"edit_private_posts";b:1;s:20:"edit_published_pages";b:1;s:20:"edit_published_posts";b:1;s:13:"publish_pages";b:1;s:13:"publish_posts";b:1;s:4:"read";b:1;s:18:"read_private_pages";b:1;s:18:"read_private_posts";b:1;s:15:"approve_comment";b:1;s:14:"delete_comment";b:1;s:12:"edit_comment";b:1;s:17:"moderate_comments";b:1;s:18:"quick_edit_comment";b:1;s:13:"reply_comment";b:1;s:12:"spam_comment";b:1;s:13:"trash_comment";b:1;s:17:"unapprove_comment";b:1;s:14:"unspam_comment";b:1;s:15:"untrash_comment";b:1;s:16:"activate_plugins";b:1;s:9:"add_users";b:1;s:12:"create_users";b:1;s:14:"delete_plugins";b:1;s:13:"delete_themes";b:1;s:12:"delete_users";b:1;s:14:"edit_dashboard";b:1;s:10:"edit_files";b:1;s:12:"edit_plugins";b:1;s:18:"edit_theme_options";b:1;s:11:"edit_themes";b:1;s:10:"edit_users";b:1;s:6:"export";b:1;s:6:"import";b:1;s:15:"install_plugins";b:1;s:14:"install_themes";b:1;s:10:"list_users";b:1;s:17:"manage_categories";b:1;s:12:"manage_links";b:1;s:14:"manage_options";b:1;s:13:"switch_themes";b:1;s:15:"unfiltered_html";b:1;s:17:"unfiltered_upload";b:1;s:11:"update_core";b:1;s:14:"update_plugins";b:1;s:13:"update_themes";b:1;s:12:"upload_files";b:1;s:7:"level_0";b:1;s:7:"level_1";b:1;s:7:"level_2";b:1;s:7:"level_3";b:1;s:7:"level_4";b:1;s:7:"level_5";b:1;s:7:"level_6";b:1;s:7:"level_7";b:1;s:7:"level_8";b:1;s:7:"level_9";b:1;s:8:"level_10";b:1;s:12:"remove_users";b:1;s:13:"promote_users";b:1;s:20:"theme_edit_portfolio";b:1;s:20:"theme_read_portfolio";b:1;s:22:"theme_delete_portfolio";b:1;s:21:"theme_edit_portfolios";b:1;s:28:"theme_edit_others_portfolios";b:1;s:24:"theme_publish_portfolios";b:1;s:29:"theme_read_private_portfolios";b:1;s:23:"theme_delete_portfolios";b:1;s:31:"theme_delete_private_portfolios";b:1;s:33:"theme_delete_published_portfolios";b:1;s:30:"theme_delete_others_portfolios";b:1;s:29:"theme_edit_private_portfolios";b:1;s:31:"theme_edit_published_portfolios";b:1;s:28:"theme_manage_portfolio_terms";b:1;s:26:"theme_edit_portfolio_terms";b:1;s:28:"theme_delete_portfolio_terms";b:1;s:28:"theme_assign_portfolio_terms";b:1;s:20:"theme_edit_slideshow";b:1;s:20:"theme_read_slideshow";b:1;s:22:"theme_delete_slideshow";b:1;s:21:"theme_edit_slideshows";b:1;s:28:"theme_edit_others_slideshows";b:1;s:24:"theme_publish_slideshows";b:1;s:29:"theme_read_private_slideshows";b:1;s:23:"theme_delete_slideshows";b:1;s:31:"theme_delete_private_slideshows";b:1;s:33:"theme_delete_published_slideshows";b:1;s:30:"theme_delete_others_slideshows";b:1;s:29:"theme_edit_private_slideshows";b:1;s:31:"theme_edit_published_slideshows";b:1;s:28:"theme_manage_slideshow_terms";b:1;s:26:"theme_edit_slideshow_terms";b:1;s:28:"theme_delete_slideshow_terms";b:1;s:28:"theme_assign_slideshow_terms";b:1;}}s:6:"editor";a:2:{s:4:"name";s:6:"Editor";s:12:"capabilities";a:34:{s:19:"delete_others_pages";i:1;s:19:"delete_others_posts";i:1;s:12:"delete_pages";i:1;s:12:"delete_posts";i:1;s:20:"delete_private_pages";i:1;s:20:"delete_private_posts";i:1;s:22:"delete_published_pages";i:1;s:22:"delete_published_posts";i:1;s:17:"edit_others_pages";i:1;s:17:"edit_others_posts";i:1;s:10:"edit_pages";i:1;s:10:"edit_posts";i:1;s:18:"edit_private_pages";i:1;s:18:"edit_private_posts";i:1;s:20:"edit_published_pages";i:1;s:20:"edit_published_posts";i:1;s:13:"publish_pages";i:1;s:13:"publish_posts";i:1;s:4:"read";i:1;s:18:"read_private_pages";i:1;s:18:"read_private_posts";i:1;s:17:"moderate_comments";i:1;s:17:"manage_categories";i:1;s:12:"manage_links";i:1;s:15:"unfiltered_html";i:1;s:12:"upload_files";i:1;s:7:"level_0";i:1;s:7:"level_1";i:1;s:7:"level_2";i:1;s:7:"level_3";i:1;s:7:"level_4";i:1;s:7:"level_5";i:1;s:7:"level_6";i:1;s:7:"level_7";i:1;}}s:6:"author";a:2:{s:4:"name";s:6:"Author";s:12:"capabilities";a:15:{s:12:"delete_posts";i:1;s:22:"delete_published_posts";i:1;s:10:"edit_posts";i:1;s:20:"edit_published_posts";i:1;s:4:"read";i:1;s:12:"upload_files";i:1;s:7:"level_0";i:1;s:7:"level_1";i:1;s:7:"level_2";i:1;s:10:"edit_pages";i:1;s:13:"publish_pages";i:1;s:17:"edit_others_posts";i:1;s:13:"publish_posts";i:1;s:19:"delete_others_posts";i:1;s:20:"edit_published_pages";i:1;}}s:11:"contributor";a:2:{s:4:"name";s:11:"Contributor";s:12:"capabilities";a:10:{s:12:"delete_posts";i:1;s:22:"delete_published_posts";i:1;s:10:"edit_posts";i:1;s:20:"edit_published_posts";i:1;s:4:"read";i:1;s:7:"level_0";i:1;s:7:"level_1";i:1;s:12:"upload_files";i:1;s:7:"level_2";i:1;s:13:"publish_posts";i:1;}}s:10:"subscriber";a:2:{s:4:"name";s:10:"Subscriber";s:12:"capabilities";a:7:{s:20:"edit_published_posts";i:1;s:4:"read";i:1;s:7:"level_0";i:1;s:12:"delete_posts";i:1;s:22:"delete_published_posts";i:1;s:13:"publish_posts";i:1;s:12:"upload_files";i:1;}}s:11:"super_admin";a:2:{s:4:"name";s:11:"Super Admin";s:12:"capabilities";a:73:{s:13:"switch_themes";b:1;s:11:"edit_themes";b:1;s:16:"activate_plugins";b:1;s:12:"edit_plugins";b:1;s:10:"edit_users";b:1;s:10:"edit_files";b:1;s:14:"manage_options";b:1;s:17:"moderate_comments";b:1;s:17:"manage_categories";b:1;s:12:"manage_links";b:1;s:12:"upload_files";b:1;s:6:"import";b:1;s:15:"unfiltered_html";b:1;s:10:"edit_posts";b:1;s:17:"edit_others_posts";b:1;s:20:"edit_published_posts";b:1;s:13:"publish_posts";b:1;s:10:"edit_pages";b:1;s:4:"read";b:1;s:8:"level_10";b:1;s:7:"level_9";b:1;s:7:"level_8";b:1;s:7:"level_7";b:1;s:7:"level_6";b:1;s:7:"level_5";b:1;s:7:"level_4";b:1;s:7:"level_3";b:1;s:7:"level_2";b:1;s:7:"level_1";b:1;s:7:"level_0";b:1;s:17:"edit_others_pages";b:1;s:20:"edit_published_pages";b:1;s:13:"publish_pages";b:1;s:12:"delete_pages";b:1;s:19:"delete_others_pages";b:1;s:22:"delete_published_pages";b:1;s:12:"delete_posts";b:1;s:19:"delete_others_posts";b:1;s:22:"delete_published_posts";b:1;s:20:"delete_private_posts";b:1;s:18:"edit_private_posts";b:1;s:18:"read_private_posts";b:1;s:20:"delete_private_pages";b:1;s:18:"edit_private_pages";b:1;s:18:"read_private_pages";b:1;s:12:"delete_users";b:1;s:12:"create_users";b:1;s:17:"unfiltered_upload";b:1;s:14:"edit_dashboard";b:1;s:14:"update_plugins";b:1;s:14:"delete_plugins";b:1;s:15:"install_plugins";b:1;s:13:"update_themes";b:1;s:14:"install_themes";b:1;s:11:"update_core";b:1;s:10:"list_users";b:1;s:12:"remove_users";b:1;s:9:"add_users";b:1;s:13:"promote_users";b:1;s:18:"edit_theme_options";b:1;s:13:"delete_themes";b:1;s:6:"export";b:1;s:12:"edit_comment";i:1;s:15:"approve_comment";i:1;s:17:"unapprove_comment";i:1;s:13:"reply_comment";i:1;s:18:"quick_edit_comment";i:1;s:12:"spam_comment";i:1;s:14:"unspam_comment";i:1;s:13:"trash_comment";i:1;s:15:"untrash_comment";i:1;s:14:"delete_comment";i:1;s:14:"edit_permalink";i:1;}}}

    Thread Starter John Bee

    (@john-bee)

    Re,

    So for helping me, i have download an other table of another wp website withe same plugins, same theme, same versions.

    So i try to copy/paste some capabilities but now i have a “Access Denied” on my WP back office …

    I have done a dump and a copy/paste of the content of this row (wp_user_roles) on a simple text doc, but when i copy/paste from this simple text document to the sql wp_user_roles row … it don’t work.

    Very strange.

    There is something i have miss ?

    Thread Starter John Bee

    (@john-bee)

    This is the first WP wp_user_roles row content (i have insert some line breaks to help me understand) : 

    a:6:{

s:13:"administrator";a:2:{

s:4:"name";
s:13:"Administrator";
s:12:"capabilities";a:107:{

s:19:"delete_others_pages";b:1;
s:19:"delete_others_posts";b:1;
s:12:"delete_pages";b:1;
s:12:"delete_posts";b:1;
s:20:"delete_private_pages";b:1;
s:20:"delete_private_posts";b:1;
s:22:"delete_published_pages";b:1;
s:22:"delete_published_posts";b:1;
s:17:"edit_others_pages";b:1;
s:17:"edit_others_posts";b:1;
s:10:"edit_pages";b:1;
s:14:"edit_permalink";b:1;
s:10:"edit_posts";b:1;
s:18:"edit_private_pages";b:1;
s:18:"edit_private_posts";b:1;
s:20:"edit_published_pages";b:1;
s:20:"edit_published_posts";b:1;
s:13:"publish_pages";b:1;
s:13:"publish_posts";b:1;
s:4:"read";b:1;
s:18:"read_private_pages";b:1;
s:18:"read_private_posts";b:1;
s:15:"approve_comment";b:1;
s:14:"delete_comment";b:1;
s:12:"edit_comment";b:1;
s:17:"moderate_comments";b:1;
s:18:"quick_edit_comment";b:1;
s:13:"reply_comment";b:1;
s:12:"spam_comment";b:1;
s:13:"trash_comment";b:1;
s:17:"unapprove_comment";b:1;
s:14:"unspam_comment";b:1;
s:15:"untrash_comment";b:1;
s:16:"activate_plugins";b:1;
s:9:"add_users";b:1;
s:12:"create_users";b:1;
s:14:"delete_plugins";b:1;
s:13:"delete_themes";b:1;
s:12:"delete_users";b:1;
s:14:"edit_dashboard";b:1;
s:10:"edit_files";b:1;
s:12:"edit_plugins";b:1;
s:18:"edit_theme_options";b:1;
s:11:"edit_themes";b:1;
s:10:"edit_users";b:1;
s:6:"export";b:1;
s:6:"import";b:1;
s:15:"install_plugins";b:1;
s:14:"install_themes";b:1;
s:10:"list_users";b:1;
s:17:"manage_categories";b:1;
s:12:"manage_links";b:1;
s:14:"manage_options";b:1;
s:13:"switch_themes";b:1;
s:15:"unfiltered_html";b:1;
s:17:"unfiltered_upload";b:1;
s:11:"update_core";b:1;
s:14:"update_plugins";b:1;
s:13:"update_themes";b:1;
s:12:"upload_files";b:1;
s:7:"level_0";b:1;
s:7:"level_1";b:1;
s:7:"level_2";b:1;
s:7:"level_3";b:1;
s:7:"level_4";b:1;
s:7:"level_5";b:1;
s:7:"level_6";b:1;
s:7:"level_7";b:1;
s:7:"level_8";b:1;
s:7:"level_9";b:1;
s:8:"level_10";b:1;
s:12:"remove_users";b:1;
s:13:"promote_users";b:1;
s:20:"theme_edit_portfolio";b:1;
s:20:"theme_read_portfolio";b:1;
s:22:"theme_delete_portfolio";b:1;
s:21:"theme_edit_portfolios";b:1;
s:28:"theme_edit_others_portfolios";b:1;
s:24:"theme_publish_portfolios";b:1;
s:29:"theme_read_private_portfolios";b:1;
s:23:"theme_delete_portfolios";b:1;
s:31:"theme_delete_private_portfolios";b:1;
s:33:"theme_delete_published_portfolios";b:1;
s:30:"theme_delete_others_portfolios";b:1;
s:29:"theme_edit_private_portfolios";b:1;
s:31:"theme_edit_published_portfolios";b:1;
s:28:"theme_manage_portfolio_terms";b:1;
s:26:"theme_edit_portfolio_terms";b:1;
s:28:"theme_delete_portfolio_terms";b:1;
s:28:"theme_assign_portfolio_terms";b:1;
s:20:"theme_edit_slideshow";b:1;
s:20:"theme_read_slideshow";b:1;
s:22:"theme_delete_slideshow";b:1;
s:21:"theme_edit_slideshows";b:1;
s:28:"theme_edit_others_slideshows";b:1;
s:24:"theme_publish_slideshows";b:1;
s:29:"theme_read_private_slideshows";b:1;
s:23:"theme_delete_slideshows";b:1;
s:31:"theme_delete_private_slideshows";b:1;
s:33:"theme_delete_published_slideshows";b:1;
s:30:"theme_delete_others_slideshows";b:1;
s:29:"theme_edit_private_slideshows";b:1;
s:31:"theme_edit_published_slideshows";b:1;
s:28:"theme_manage_slideshow_terms";b:1;
s:26:"theme_edit_slideshow_terms";b:1;
s:28:"theme_delete_slideshow_terms";b:1;
s:28:"theme_assign_slideshow_terms";b:1;}}

s:6:"editor";a:2:{

s:4:"name";
s:6:"Editor";
s:12:"capabilities";a:34:{

s:19:"delete_others_pages";i:1;
s:19:"delete_others_posts";i:1;
s:12:"delete_pages";i:1;
s:12:"delete_posts";i:1;
s:20:"delete_private_pages";i:1;
s:20:"delete_private_posts";i:1;
s:22:"delete_published_pages";i:1;
s:22:"delete_published_posts";i:1;
s:17:"edit_others_pages";i:1;
s:17:"edit_others_posts";i:1;
s:10:"edit_pages";i:1;
s:10:"edit_posts";i:1;
s:18:"edit_private_pages";i:1;
s:18:"edit_private_posts";i:1;
s:20:"edit_published_pages";i:1;
s:20:"edit_published_posts";i:1;
s:13:"publish_pages";i:1;
s:13:"publish_posts";i:1;
s:4:"read";i:1;
s:18:"read_private_pages";i:1;
s:18:"read_private_posts";i:1;
s:17:"moderate_comments";i:1;
s:17:"manage_categories";i:1;
s:12:"manage_links";i:1;
s:15:"unfiltered_html";i:1;
s:12:"upload_files";i:1;
s:7:"level_0";i:1;
s:7:"level_1";i:1;
s:7:"level_2";i:1;
s:7:"level_3";i:1;
s:7:"level_4";i:1;
s:7:"level_5";i:1;
s:7:"level_6";i:1;
s:7:"level_7";i:1;}}

s:6:"author";a:2:{

s:4:"name";
s:6:"Author";
s:12:"capabilities";a:15:{

s:12:"delete_posts";i:1;
s:22:"delete_published_posts";i:1;
s:10:"edit_posts";i:1;
s:20:"edit_published_posts";i:1;
s:4:"read";i:1;
s:12:"upload_files";i:1;
s:7:"level_0";i:1;
s:7:"level_1";i:1;
s:7:"level_2";i:1;
s:10:"edit_pages";i:1;
s:13:"publish_pages";i:1;
s:17:"edit_others_posts";i:1;
s:13:"publish_posts";i:1;
s:19:"delete_others_posts";i:1;
s:20:"edit_published_pages";i:1;}}

s:11:"contributor";a:2:{

s:4:"name";
s:11:"Contributor";
s:12:"capabilities";a:10:{

s:12:"delete_posts";i:1;
s:22:"delete_published_posts";i:1;
s:10:"edit_posts";i:1;
s:20:"edit_published_posts";i:1;
s:4:"read";i:1;
s:7:"level_0";i:1;
s:7:"level_1";i:1;
s:12:"upload_files";i:1;
s:7:"level_2";i:1;
s:13:"publish_posts";i:1;}}

s:10:"subscriber";a:2:{

s:4:"name";
s:10:"Subscriber";
s:12:"capabilities";a:7:{

s:20:"edit_published_posts";i:1;
s:4:"read";i:1;
s:7:"level_0";i:1;
s:12:"delete_posts";i:1;
s:22:"delete_published_posts";i:1;
s:13:"publish_posts";i:1;
s:12:"upload_files";i:1;}}

s:11:"super_admin";a:2:{

s:4:"name";
s:11:"Super Admin";
s:12:"capabilities";a:73:{

s:13:"switch_themes";b:1;
s:11:"edit_themes";b:1;
s:16:"activate_plugins";b:1;
s:12:"edit_plugins";b:1;
s:10:"edit_users";b:1;
s:10:"edit_files";b:1;
s:14:"manage_options";b:1;
s:17:"moderate_comments";b:1;
s:17:"manage_categories";b:1;
s:12:"manage_links";b:1;
s:12:"upload_files";b:1;
s:6:"import";b:1;
s:15:"unfiltered_html";b:1;
s:10:"edit_posts";b:1;
s:17:"edit_others_posts";b:1;
s:20:"edit_published_posts";b:1;
s:13:"publish_posts";b:1;
s:10:"edit_pages";b:1;
s:4:"read";b:1;
s:8:"level_10";b:1;
s:7:"level_9";b:1;
s:7:"level_8";b:1;
s:7:"level_7";b:1;
s:7:"level_6";b:1;
s:7:"level_5";b:1;
s:7:"level_4";b:1;
s:7:"level_3";b:1;
s:7:"level_2";b:1;
s:7:"level_1";b:1;
s:7:"level_0";b:1;
s:17:"edit_others_pages";b:1;
s:20:"edit_published_pages";b:1;
s:13:"publish_pages";b:1;
s:12:"delete_pages";b:1;
s:19:"delete_others_pages";b:1;
s:22:"delete_published_pages";b:1;
s:12:"delete_posts";b:1;
s:19:"delete_others_posts";b:1;
s:22:"delete_published_posts";b:1;
s:20:"delete_private_posts";b:1;
s:18:"edit_private_posts";b:1;
s:18:"read_private_posts";b:1;
s:20:"delete_private_pages";b:1;
s:18:"edit_private_pages";b:1;
s:18:"read_private_pages";b:1;
s:12:"delete_users";b:1;
s:12:"create_users";b:1;
s:17:"unfiltered_upload";b:1;
s:14:"edit_dashboard";b:1;
s:14:"update_plugins";b:1;
s:14:"delete_plugins";b:1;
s:15:"install_plugins";b:1;
s:13:"update_themes";b:1;
s:14:"install_themes";b:1;
s:11:"update_core";b:1;
s:10:"list_users";b:1;
s:12:"remove_users";b:1;
s:9:"add_users";b:1;
s:13:"promote_users";b:1;
s:18:"edit_theme_options";b:1;
s:13:"delete_themes";b:1;
s:6:"export";b:1;
s:12:"edit_comment";i:1;
s:15:"approve_comment";i:1;
s:17:"unapprove_comment";i:1;
s:13:"reply_comment";i:1;
s:18:"quick_edit_comment";i:1;
s:12:"spam_comment";i:1;
s:14:"unspam_comment";i:1;
s:13:"trash_comment";i:1;
s:15:"untrash_comment";i:1;
s:14:"delete_comment";i:1;
s:14:"edit_permalink";i:1;}}}

    And this is the WP similar website wp_user_roles row content witch i download to compare :

    a:6:{

s:13:"administrator";a:2:{

s:4:"name";
s:13:"Administrator";
s:12:"capabilities";a:107:{

s:13:"switch_themes";b:1;
s:11:"edit_themes";b:1;
s:16:"activate_plugins";b:1;
s:12:"edit_plugins";b:1;
s:10:"edit_users";b:1;
s:10:"edit_files";b:1;
s:14:"manage_options";b:1;
s:17:"moderate_comments";b:1;
s:17:"manage_categories";b:1;
s:12:"manage_links";b:1;
s:12:"upload_files";b:1;
s:6:"import";b:1;
s:15:"unfiltered_html";b:1;
s:10:"edit_posts";b:1;
s:17:"edit_others_posts";b:1;
s:20:"edit_published_posts";b:1;
s:13:"publish_posts";b:1;
s:10:"edit_pages";b:1;
s:4:"read";b:1;
s:8:"level_10";b:1;
s:7:"level_9";b:1;
s:7:"level_8";b:1;
s:7:"level_7";b:1;
s:7:"level_6";b:1;
s:7:"level_5";b:1;
s:7:"level_4";b:1;
s:7:"level_3";b:1;
s:7:"level_2";b:1;
s:7:"level_1";b:1;
s:7:"level_0";b:1;
s:17:"edit_others_pages";b:1;
s:20:"edit_published_pages";b:1;
s:13:"publish_pages";b:1;
s:12:"delete_pages";b:1;
s:19:"delete_others_pages";b:1;
s:22:"delete_published_pages";b:1;
s:12:"delete_posts";b:1;
s:19:"delete_others_posts";b:1;
s:22:"delete_published_posts";b:1;
s:20:"delete_private_posts";b:1;
s:18:"edit_private_posts";b:1;
s:18:"read_private_posts";b:1;
s:20:"delete_private_pages";b:1;
s:18:"edit_private_pages";b:1;
s:18:"read_private_pages";b:1;
s:12:"delete_users";b:1;
s:12:"create_users";b:1;
s:17:"unfiltered_upload";b:1;
s:14:"edit_dashboard";b:1;
s:14:"update_plugins";b:1;
s:14:"delete_plugins";b:1;
s:15:"install_plugins";b:1;
s:13:"update_themes";b:1;
s:14:"install_themes";b:1;
s:11:"update_core";b:1;
s:10:"list_users";b:1;
s:12:"remove_users";b:1;
s:9:"add_users";b:1;
s:13:"promote_users";b:1;
s:18:"edit_theme_options";b:1;
s:13:"delete_themes";b:1;
s:6:"export";b:1;
s:12:"edit_comment";i:1;
s:15:"approve_comment";i:1;
s:17:"unapprove_comment";i:1;
s:13:"reply_comment";i:1;
s:18:"quick_edit_comment";i:1;
s:12:"spam_comment";i:1;
s:14:"unspam_comment";i:1;
s:13:"trash_comment";i:1;
s:15:"untrash_comment";i:1;
s:14:"delete_comment";i:1;
s:14:"edit_permalink";i:1;
s:20:"theme_edit_portfolio";b:1;
s:20:"theme_read_portfolio";b:1;
s:22:"theme_delete_portfolio";b:1;
s:21:"theme_edit_portfolios";b:1;
s:28:"theme_edit_others_portfolios";b:1;
s:24:"theme_publish_portfolios";b:1;
s:29:"theme_read_private_portfolios";b:1;
s:23:"theme_delete_portfolios";b:1;
s:31:"theme_delete_private_portfolios";b:1;
s:33:"theme_delete_published_portfolios";b:1;
s:30:"theme_delete_others_portfolios";b:1;
s:29:"theme_edit_private_portfolios";b:1;
s:31:"theme_edit_published_portfolios";b:1;
s:28:"theme_manage_portfolio_terms";b:1;
s:26:"theme_edit_portfolio_terms";b:1;
s:28:"theme_delete_portfolio_terms";b:1;
s:28:"theme_assign_portfolio_terms";b:1;
s:20:"theme_edit_slideshow";b:1;
s:20:"theme_read_slideshow";b:1;
s:22:"theme_delete_slideshow";b:1;
s:21:"theme_edit_slideshows";b:1;
s:28:"theme_edit_others_slideshows";b:1;
s:24:"theme_publish_slideshows";b:1;
s:29:"theme_read_private_slideshows";b:1;
s:23:"theme_delete_slideshows";b:1;
s:31:"theme_delete_private_slideshows";b:1;
s:33:"theme_delete_published_slideshows";b:1;
s:30:"theme_delete_others_slideshows";b:1;
s:29:"theme_edit_private_slideshows";b:1;
s:31:"theme_edit_published_slideshows";b:1;
s:28:"theme_manage_slideshow_terms";b:1;
s:26:"theme_edit_slideshow_terms";b:1;
s:28:"theme_delete_slideshow_terms";b:1;
s:28:"theme_assign_slideshow_terms";b:1;}}

s:6:"editor";a:2:{

s:4:"name";
s:6:"Editor";
s:12:"capabilities";a:34:{

s:17:"moderate_comments";b:1;
s:17:"manage_categories";b:1;
s:12:"manage_links";b:1;
s:12:"upload_files";b:1;
s:15:"unfiltered_html";b:1;
s:10:"edit_posts";b:1;
s:17:"edit_others_posts";b:1;
s:20:"edit_published_posts";b:1;
s:13:"publish_posts";b:1;
s:10:"edit_pages";b:1;
s:4:"read";b:1;
s:7:"level_7";b:1;
s:7:"level_6";b:1;
s:7:"level_5";b:1;
s:7:"level_4";b:1;
s:7:"level_3";b:1;
s:7:"level_2";b:1;
s:7:"level_1";b:1;
s:7:"level_0";b:1;
s:17:"edit_others_pages";b:1;
s:20:"edit_published_pages";b:1;
s:13:"publish_pages";b:1;
s:12:"delete_pages";b:1;
s:19:"delete_others_pages";b:1;
s:22:"delete_published_pages";b:1;
s:12:"delete_posts";b:1;
s:19:"delete_others_posts";b:1;
s:22:"delete_published_posts";b:1;
s:20:"delete_private_posts";b:1;
s:18:"edit_private_posts";b:1;
s:18:"read_private_posts";b:1;
s:20:"delete_private_pages";b:1;
s:18:"edit_private_pages";b:1;
s:18:"read_private_pages";b:1;}}

s:6:"author";a:2:{

s:4:"name";
s:6:"Author";
s:12:"capabilities";a:10:{

s:12:"delete_posts";
s:1:"1";
s:22:"delete_published_posts";
s:1:"1";
s:10:"edit_posts";
s:1:"1";
s:20:"edit_published_posts";
s:1:"1";
s:13:"publish_posts";
s:1:"1";
s:4:"read";
s:1:"1";
s:12:"upload_files";
s:1:"1";
s:7:"level_0";
s:1:"1";
s:7:"level_1";
s:1:"1";
s:7:"level_2";
s:1:"1";}}

s:11:"contributor";a:2:{

s:4:"name";
s:11:"Contributor";
s:12:"capabilities";a:5:{

s:10:"edit_posts";b:1;
s:4:"read";b:1;
s:7:"level_1";b:1;
s:7:"level_0";b:1;
s:12:"delete_posts";b:1;}}

s:10:"subscriber";a:2:{

s:4:"name";
s:10:"Subscriber";
s:12:"capabilities";a:2:{

s:4:"read";b:1;
s:7:"level_0";b:1;}}

s:11:"super_admin";a:2:{

s:4:"name";
s:11:"Super Admin";
s:12:"capabilities";a:73:{

s:13:"switch_themes";b:1;
s:11:"edit_themes";b:1;
s:16:"activate_plugins";b:1;
s:12:"edit_plugins";b:1;
s:10:"edit_users";b:1;
s:10:"edit_files";b:1;
s:14:"manage_options";b:1;
s:17:"moderate_comments";b:1;
s:17:"manage_categories";b:1;
s:12:"manage_links";b:1;
s:12:"upload_files";b:1;
s:6:"import";b:1;
s:15:"unfiltered_html";b:1;
s:10:"edit_posts";b:1;
s:17:"edit_others_posts";b:1;
s:20:"edit_published_posts";b:1;
s:13:"publish_posts";b:1;
s:10:"edit_pages";b:1;
s:4:"read";b:1;
s:8:"level_10";b:1;
s:7:"level_9";b:1;
s:7:"level_8";b:1;
s:7:"level_7";b:1;
s:7:"level_6";b:1;
s:7:"level_5";b:1;
s:7:"level_4";b:1;
s:7:"level_3";b:1;
s:7:"level_2";b:1;
s:7:"level_1";b:1;
s:7:"level_0";b:1;
s:17:"edit_others_pages";b:1;
s:20:"edit_published_pages";b:1;
s:13:"publish_pages";b:1;
s:12:"delete_pages";b:1;
s:19:"delete_others_pages";b:1;
s:22:"delete_published_pages";b:1;
s:12:"delete_posts";b:1;
s:19:"delete_others_posts";b:1;
s:22:"delete_published_posts";b:1;
s:20:"delete_private_posts";b:1;
s:18:"edit_private_posts";b:1;
s:18:"read_private_posts";b:1;
s:20:"delete_private_pages";b:1;
s:18:"edit_private_pages";b:1;
s:18:"read_private_pages";b:1;
s:12:"delete_users";b:1;
s:12:"create_users";b:1;
s:17:"unfiltered_upload";b:1;
s:14:"edit_dashboard";b:1;
s:14:"update_plugins";b:1;
s:14:"delete_plugins";b:1;
s:15:"install_plugins";b:1;
s:13:"update_themes";b:1;
s:14:"install_themes";b:1;
s:11:"update_core";b:1;
s:10:"list_users";b:1;
s:12:"remove_users";b:1;
s:9:"add_users";b:1;
s:13:"promote_users";b:1;
s:18:"edit_theme_options";b:1;
s:13:"delete_themes";b:1;
s:6:"export";b:1;
s:12:"edit_comment";i:1;
s:15:"approve_comment";i:1;
s:17:"unapprove_comment";i:1;
s:13:"reply_comment";i:1;
s:18:"quick_edit_comment";i:1;
s:12:"spam_comment";i:1;
s:14:"unspam_comment";i:1;
s:13:"trash_comment";i:1;
s:15:"untrash_comment";i:1;
s:14:"delete_comment";i:1;
s:14:"edit_permalink";i:1;}}}

    John,

    Check the wp_usermeta table for an entry where user_id is your user id (likely 1), meta_key is wp_capabilities. On a fresh install, this entry has a value of a:1:{s:13:"administrator";b:1;} for me.

    Thanks,
    Lucas

    Thread Starter John Bee

    (@john-bee)

    Hello Lucas,

    Thank for your quick answers.

    So the content of the row is :

    a:1:{s:13:”administrator”;b:1;}

    But it has been changed few days ago by the plug in developer … and don’t have a BackUp for this.

    The similar WP table i use to compare is :

    a:2:{s:13:”administrator”;s:1:”1″;s:11:”super_admin”;s:1:”1″;}

    So i test changing wp_capabilities content with both of these but it don’t work too.

    It’s possible i have done a mistake by adding line breaks and by doing copy/paste …

    Or i really don’t now …

    It’s strange …

    Any idea

    Is this a multi-site installation?

    Thread Starter John Bee

    (@john-bee)

    No

    The similar WP table you’re comparing to looks like it might be, so perhaps not a good comparison.

    This might be the kind of thing that requires a more hands-on approach to truly be helpful. If you’re willing to let me dive into it, I’m happy to give it a try.

    Andrew Nevins

    (@anevins)

    WCLDN 2018 Contributor | Volunteer support

    If you’re willing to let me dive into it, I’m happy to give it a try.

    What are you asking to dive into?

    What are you asking to dive into?

    The database and/or WP installation. Is that a support forum faux-pas?

    Andrew Nevins

    (@anevins)

    WCLDN 2018 Contributor | Volunteer support

    That would be beyond your capabilities on these forums, all you can do here is give advice.

    That would be beyond your capabilities on these forums, all you can do here is give advice.

    Noted.

    Thread Starter John Bee

    (@john-bee)

    Thank you for helping.

    I have done another test : just copy/paste from the similar WP website … and it works.

    It still missing some capabilities, but i think i can restore them back now by just modifiying theme one by one.

    I will let you know the following steps.

    Best,

Viewing 15 replies - 1 through 15 (of 17 total)
  • The topic ‘how can i modifie capabilities with phpmyadmin ?’ is closed to new replies.