Support » Networking WordPress » Removed multisite, now cannot upload themes, plugins

  • Resolved czeller

    (@czeller)


    removed multisite code from wp-config, finally got all working

    now cannot upload plugins, themes- have to do by ftp

    have checked database for user capabilities, etc, but all looks good

    can you help?

Viewing 15 replies - 1 through 15 (of 15 total)
  • What error message do you get when you try to upload? Is the option to Add New there or is it missing?

    it’s missing altogether, on plugins and themes-

    thanks for listening!

    Hmm, then it doesn’t think you’re the Super Admin, which of course you’re not as you’re no longer on MultiSite. It’s hard to remove it completely.

    I would try deleting .htaccess (take a copy first) and then recreating it via Settings > Permalinks and saving. This will remove the MS specific .htaccess directives.

    There are some database tables in the database that need deleting to completely uninstall e.g

    wp_blogs
    wp_blog_versions
    wp_registration_log
    wp_signups
    wp_site
    wp_meta

    but try the .htaccess trick first.

    At the bottom of this post below Mika suggests installing a clean version of WordPress and exporting the content from your current installation into the new one:

    http://wordpress.org/support/topic/multisite-proper-removal?replies=15

    In the past I’ve had to fix User roles in wp_usermeta but that gets complicated 🙂

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    Lead Plugin Wrangler

    Unless you’ve diddled with user roles, the wp_usermeta stuff shouldn’t matter. Super_admin is a separate DB field from user roles (in part) for this reason.

    have checked database for user capabilities, etc, but all looks good

    By this I’m taking it to mean you checked to make sure your current ID was the admin?

    well, i made sure that my user_id (110) for my user in wp_user matched up to wp_usermeta, where it reads that the the user with my name and same id (110) has:
    wp_1_capabilities a:1:{s:13:”administrator”;b:1;}
    wp_1_user_level 10

    Is there something else I should look for?

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    Lead Plugin Wrangler

    Yeah, what’s the actual table name? Is it wp_1_usermeta or wp_usermeta?

    This wp_1_capabilities should match the tables 🙂 So if you have wp_usermeta, it’s wp_capabilities

    Sorry, it’s wp_1_usermeta, it’s all wp_1_

    that is the prefix that was specified in wp-config- all the tables are named with that prefix-

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    Lead Plugin Wrangler

    o.O

    In wp_1_options is there an option for wp_1_user_roles ?

    Also are you showing as an admin in the Users lists?

    Finally … did you set DISALLOW_FILE_EDITS in the wp-config?

    I was just thinking DISALLOW_FILE_EDITS might be set as well, thanks Mika!

    Yes, in wp_1_options, there is wp_1_user_roles, and this is the value that shows in that field:
    a:8:{s:13:”administrator”;a:2:{s:4:”name”;s:13:”Administrator”;s:12:”capabilities”;a:66:{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: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:14:”edit_dashboard”;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:22:”tablepress_edit_tables”;b:1;s:24:”tablepress_delete_tables”;b:1;s:22:”tablepress_list_tables”;b:1;s:21:”tablepress_add_tables”;b:1;s:22:”tablepress_copy_tables”;b:1;s:24:”tablepress_import_tables”;b:1;s:24:”tablepress_export_tables”;b:1;s:32:”tablepress_access_options_screen”;b:1;s:30:”tablepress_access_about_screen”;b:1;s:29:”tablepress_import_tables_wptr”;b:1;s:23:”tablepress_edit_options”;b:1;}}s:6:”editor”;a:2:{s:4:”name”;s:6:”Editor”;s:12:”capabilities”;a:42:{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: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:22:”tablepress_edit_tables”;b:1;s:24:”tablepress_delete_tables”;b:1;s:22:”tablepress_list_tables”;b:1;s:21:”tablepress_add_tables”;b:1;s:22:”tablepress_copy_tables”;b:1;s:24:”tablepress_import_tables”;b:1;s:24:”tablepress_export_tables”;b:1;s:32:”tablepress_access_options_screen”;b:1;s:30:”tablepress_access_about_screen”;b:1;}}s:6:”author”;a:2:{s:4:”name”;s:6:”Author”;s:12:”capabilities”;a:19:{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:22:”tablepress_edit_tables”;b:1;s:24:”tablepress_delete_tables”;b:1;s:22:”tablepress_list_tables”;b:1;s:21:”tablepress_add_tables”;b:1;s:22:”tablepress_copy_tables”;b:1;s:24:”tablepress_import_tables”;b:1;s:24:”tablepress_export_tables”;b:1;s:32:”tablepress_access_options_screen”;b:1;s:30:”tablepress_access_about_screen”;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;}}s:14:”backwpup_admin”;a:2:{s:4:”name”;s:14:”BackWPup Admin”;s:12:”capabilities”;a:10:{s:8:”backwpup”;b:1;s:13:”backwpup_jobs”;b:1;s:18:”backwpup_jobs_edit”;b:1;s:19:”backwpup_jobs_start”;b:1;s:16:”backwpup_backups”;b:1;s:25:”backwpup_backups_download”;b:1;s:23:”backwpup_backups_delete”;b:1;s:13:”backwpup_logs”;b:1;s:20:”backwpup_logs_delete”;b:1;s:17:”backwpup_settings”;b:1;}}s:14:”backwpup_check”;a:2:{s:4:”name”;s:21:”BackWPup jobs checker”;s:12:”capabilities”;a:10:{s:8:”backwpup”;b:1;s:13:”backwpup_jobs”;b:1;s:18:”backwpup_jobs_edit”;b:0;s:19:”backwpup_jobs_start”;b:0;s:16:”backwpup_backups”;b:1;s:25:”backwpup_backups_download”;b:0;s:23:”backwpup_backups_delete”;b:0;s:13:”backwpup_logs”;b:1;s:20:”backwpup_logs_delete”;b:0;s:17:”backwpup_settings”;b:0;}}s:15:”backwpup_helper”;a:2:{s:4:”name”;s:20:”BackWPup jobs helper”;s:12:”capabilities”;a:10:{s:8:”backwpup”;b:1;s:13:”backwpup_jobs”;b:1;s:18:”backwpup_jobs_edit”;b:0;s:19:”backwpup_jobs_start”;b:1;s:16:”backwpup_backups”;b:1;s:25:”backwpup_backups_download”;b:1;s:23:”backwpup_backups_delete”;b:1;s:13:”backwpup_logs”;b:1;s:20:”backwpup_logs_delete”;b:1;s:17:”backwpup_settings”;b:0;}}}

    Yes, I show as an administrator in the users list.

    Unfortunately, no DISALLOW_FILE_EDITS in my wp-config file.

    Thank you for all these suggestions-

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    Lead Plugin Wrangler

    Ah. So when I said “unless you diddled with user roles” I meant stuff like this:

    {s:4:"name";s:14:"BackWPup Admin

    It’s VERY possible that killed you :/ Not your fault, I HATE when plugins do that *sigh*

    Easiest way to fix would be to make a clean install of WP somewhere (locally is fine), get the info from wp_1_user_roles, and paste it in.

    I’m 80% sure this is the default:

    a:5:{
    s:13:"administrator";a:2:{s:4:"name";s:13:"Administrator";s:12:"capabilities";a:54:{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: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;}}}

    Thank you Ipstenu (Mika Epstein). That particular version did not work, but I found one that did. Definitely the user role in db was lacking install theme/plugins.

    Of course, then my user was unable to access some of the plugins- and those particular plugins had a lot of data stored in them (tablepress especially). I tried just adding the values that were missing (install, delete theme and plugins) but I could never get that to work. Instead, I had to add a user with just default user roles so I could add plugins/themes with that user.

    Any idea why I couldn’t just add those roles to the user_roles?

    Anyways, thank you SO much for your help- it got me to a solution, albeit an imperfect one 🙂

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    Lead Plugin Wrangler

    Any idea why I couldn’t just add those roles to the user_roles?

    Because diddling with user roles is a science? It’s VERY complicated and messy and easy to goof up :/

Viewing 15 replies - 1 through 15 (of 15 total)
  • The topic ‘Removed multisite, now cannot upload themes, plugins’ is closed to new replies.