Opened 11 years ago
Last modified 6 years ago
#28139 new defect (bug)
WP MU legacy problems: missing database tables
Reported by: |
|
Owned by: | |
---|---|---|---|
Milestone: | Priority: | normal | |
Severity: | normal | Version: | 3.0 |
Component: | Database | Keywords: | needs-patch |
Focuses: | administration, multisite | Cc: |
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
- Install WP MU 2.9.2 (last WP MU release - works as expected)
- 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)
- 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.
- 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.' ) );
- Add
define ('MULTISITE', true);
to wp-config.php. You will need to repair the database. - Add
define('WP_ALLOW_REPAIR', true);
and proceed to repair the database. Assuming atesting
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
- 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) - The message assumes
wp_links
as a needed table
Change History (2)
Note: See
TracTickets for help on using
tickets.