Missing wp_posts etc in a WPMU -> WP3.x upgrade

  • nibb

    (@nibb)


    13 years, 8 months ago

    Hi folks,
    I have come across this issue whilst trying to sort out missing user roles in the various places within the admin that you can change the roles (the drop down list contains only wiki-editor as a role, no subscriber, editor etc), which we had put down to an incompatibility with Wiki Editor plugin.

    In an attempt to see whether the DB was fragged or the file structure, I installed a virginal copy of 3.01, then swapped our DB for the one thats created by default.

    Reloading causes a DB connection problem, going into wp-admin produces the prompt to repair the db, doing so shows that wp-posts through to wp-taxonomy etc are missing.

    Anyone with any knowledge of WPMU pre to its amalgamation in WP 3.0 series be able to tell me if I’m correct here; but – given our original installation was pure WPMU – the default blog/site is wp_1 isn’t it? Not wp_?

    To test the theory, I copied over all the wp_blah tables into the DB for our install ( a copy) and WP kicked in no fuss, well, a bit of whinging about certain tables not being closed by users.

    However of course, there isn’t a wp_ in our site installation, so the default blog is blank.

    All the user roles are back in again! Just not sure this is a neat way of fixing this.

    Andrea and Co – any ideas?

    best wishes and thanks in advance

    Steve / Nibb

Viewing 7 replies - 1 through 7 (of 7 total)
  • Andrea Rennick

    (@andrea_r)

    13 years, 8 months ago

    Yeah, the db structure is slightly different on the main blog between an upgraded wpmu and a 3.x network install. Don’t mix them. 😉

    And the wp-config file checks to see which one.

    the user role issue was also reported in this thread:
    (hang on while I find it)

    Thread Starter nibb

    (@nibb)

    13 years, 8 months ago

    Thanks Andrea,
    suspected that might the case. User role issue might have been me, spent a bit of time going loopy between ourselves and the plugin writers for the Wiki plugin. I’d rather not have to try and export the whole lot and import it somehow into a virginal install.

    thanks for having a look

    Thread Starter nibb

    (@nibb)

    13 years, 8 months ago

    Did you find it Andrea 🙂
    Still hanging, fingers getting sore 😉

    Andrea Rennick

    (@andrea_r)

    13 years, 8 months ago

    took me a bit as I know the user under two names, so it’s harder to remember (if I could search visually by gravatar, that’d be awesome 😀 )

    http://wordpress.org/support/topic/widgets-page-missing-from-wpmu-member-blog-admin/page/2?replies=37#post-1637724

    See if that gets you in the right direction.

    Thread Starter nibb

    (@nibb)

    13 years, 8 months ago

    Well, not sure if its a related issue, but I hadn’t thought of looking in the wp_x_options! lookee see what I found:

    a:1:{s:11:”wiki_editor”;a:2:{s:4:”name”;s:11:”Wiki Editor”;s:12:”capabilities”;a:7:{s:4:”read”;b:1;s:10:”edit_posts”;b:1;s:17:”edit_others_posts”;b:1;s:20:”edit_published_posts”;b:1;s:9:”edit_wiki”;b:1;s:10:”edit_pages”;b:1;s:9:”edit_post”;b:1;}}}

    Which could be conflicting with or even overwriting default roles potentially I guess.

    Thanks Andrea, flabber tired rather than gasted this time 🙂 Will see what else I can find with a prod and a poke and a vicious mysql drop command

    Thread Starter nibb

    (@nibb)

    13 years, 8 months ago

    Yoiks, the proper content from a virginal wp_options is (and I think we have the nub of the crux of the fiddly bit of the matter:

    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;}}}

    Gonna try replacing one with the other 🙂

    Thread Starter nibb

    (@nibb)

    13 years, 8 months ago

    Solution found, and tested
    Thanks Andrea for the hint, I have done a basic cut and paste of the virginal wp_options value for wp_user_roles, all the roles are now back in.

    Odd prob though, think it has to have been the plugin overwriting the values, but why?

    Odds Bodkins eh!

    Cheers all

    Steve

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Missing wp_posts etc in a WPMU -> WP3.x upgrade’ is closed to new replies.