define('WP_ALLOW_REPAIR', true);");
+} elseif ( isset($_GET['repair']) ) {
+ $problems = array();
+ check_admin_referer('repair_db');
+
+ if ( 2 == $_GET['repair'] )
+ $optimize = true;
+ else
+ $optimize = false;
+
+ $okay = true;
+
+ // Loop over the WP tables, checking and repairing as needed.
+ foreach ($wpdb->tables as $table) {
+ if ( in_array($table, $wpdb->old_tables) )
+ continue;
+
+ $check = $wpdb->get_row("CHECK TABLE {$wpdb->prefix}$table");
+ if ( 'OK' == $check->Msg_text ) {
+ echo "The {$wpdb->prefix}$table table is okay."; + } else { + echo "
The {$wpdb->prefix}$table table is not okay. It is reporting the following error: $check->Msg_text. WordPress will attempt to repair this table…";
+ $repair = $wpdb->get_row("REPAIR TABLE {$wpdb->prefix}$table");
+ if ( 'OK' == $check->Msg_text ) {
+ echo "
Sucessfully repaired the {$wpdb->prefix}$table table.";
+ } else {
+ echo "
Failed to repair the {$wpdb->prefix}$table table. Error: $check->Msg_text
";
+ $problems["{$wpdb->prefix}$table"] = $check->Msg_text;
+ $okay = false;
+ }
+ }
+ if ( $okay && $optimize ) {
+ $check = $wpdb->get_row("ANALYZE TABLE {$wpdb->prefix}$table");
+ if ( 'Table is already up to date' == $check->Msg_text ) {
+ echo "
The {$wpdb->prefix}$table table is already optimized.";
+ } else {
+ $check = $wpdb->get_row("OPTIMIZE TABLE {$wpdb->prefix}$table");
+ if ( 'OK' == $check->Msg_text || 'Table is already up to date' == $check->Msg_text )
+ echo "
Sucessfully optimized the {$wpdb->prefix}$table table.";
+ else
+ echo "
Failed to optimize the {$wpdb->prefix}$table table. Error: $check->Msg_text";
+ }
+ }
+ echo '
Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance.
'), 'http://wordpress.org/support/forum/3'); + $problem_output = array(); + foreach ( $problems as $table => $problem ) + $problem_output[] = "$table: $problem"; + echo ''; + } else { + _e("Repairs complete. Please remove the following line from wp-config.php to prevent this page from being used by unauthorized users.
define('WP_ALLOW_REPAIR', true);");
+ }
+} else {
+ if ( isset($_GET['referrer']) && 'is_blog_installed' == $_GET['referrer'] )
+ _e('One or more database tables is unavailable. To allow WordPress to attempt to repair these tables, press the "Repair Database" button. Repairing can take awhile, so please be patient.');
+ else
+ _e('WordPress can automatically look for some common database problems and repair them. Repairing can take awhile, so please be patient.')
+?>
+
+
+
+
+
+
\ No newline at end of file