[wp-trac] [WordPress Trac] #28139: WP MU legacy problems: missing database tables

[WordPress Trac]

#28139: WP MU legacy problems: missing database tables
---------------------------------------+-----------------------------
 Reporter:  bi0xid                     |      Owner:
     Type:  defect (bug)               |     Status:  new
 Priority:  normal                     |  Milestone:  Awaiting Review
Component:  Networks and Sites         |    Version:  3.9
 Severity:  normal                     |   Keywords:
  Focuses:  administration, multisite  |
---------------------------------------+-----------------------------
 Helo there.

 We have found that WordPress Multisite sites updated from former WordPress
 MU are not working as expected. There are some missing tables that give
 problems with some plugins. The lack of tables doesn't allow you to access
 to the network configuration either.

 === '''Steps to reproduce''' ===

 1. Install WP MU 2.9.2 (last WP MU release - works as expected)
 2. Update to WP 3.0 or directly to WP 3.9. (tested in 3.0, 3.0 and then
 3.9, and 3.9 directly)
 3. Try to access /wp-admin/network.php.
 You will have the message `The Network creation panel is not for WordPress
 MU networks.`, which is odd in a WP 3.9 Multisite.
 4. Look for the source of the message in wp-admin/network.php
 {{{
         if ( ! defined( 'MULTISITE' ) )
                 wp_die( __( 'The Network creation panel is not for
 WordPress MU networks.' ) );
 }}}
 5. Add `define ('MULTISITE', true);` to wp-config.php. You will need to
 repair the database.
 6. Add `define('WP_ALLOW_REPAIR', true);` and proceed to repair the
 database. Assuming a `testing` database, you will get this message:
 {{{
 wp_posts: Table 'testing.wp_posts' doesn't exist
 wp_comments: Table 'testing.wp_comments' doesn't exist
 wp_links: Table 'testing.wp_links' doesn't exist
 wp_options: Table 'testing.wp_options' doesn't exist
 wp_postmeta: Table 'testing.wp_postmeta' doesn't exist
 wp_terms: Table 'testing.wp_terms' doesn't exist
 wp_term_taxonomy: Table 'testing.wp_term_taxonomy' doesn't exist
 wp_term_relationships: Table 'testing.wp_term_relationships' doesn't exist
 wp_commentmeta: Table 'testing.wp_commentmeta' doesn't exist
 }}}

 === '''Problems found''' ===


 1. The lack of the `wp_options` table is especially problematic with
 plugins (Jetpack is unable to work with its new multisite option - thanks
 kraftbj for the help)
 2. The message assumes `wp_links` as a needed table

--
Ticket URL: <https://core.trac.wordpress.org/ticket/28139>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform