WordPress.org

Make WordPress Core

Opened 5 years ago

Last modified 5 months ago

#28139 new defect (bug)

WP MU legacy problems: missing database tables

Reported by: bi0xid Owned by:
Milestone: Priority: normal
Severity: normal Version: 3.0
Component: Database Keywords: needs-patch
Focuses: administration, multisite Cc:
PR Number:

Description

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.

  1. 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.' ) );
    
  2. Add define ('MULTISITE', true); to wp-config.php. You will need to repair the database.
  3. 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

Change History (2)

#1 @kraftbj
5 years ago

  • Component changed from Networks and Sites to Database
  • Version changed from 3.9 to 3.0

#2 @chriscct7
4 years ago

  • Keywords needs-patch added
Note: See TracTickets for help on using tickets.