site_iri: web/wp-admin/maint/repair.php@32102edaa81b (annotated)

136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	1	<?php
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	2	/**
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	3	* Database Repair and Optimization Script.
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	4	*
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	5	* @package WordPress
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	6	* @subpackage Database
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	7	*/
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	8	define('WP_REPAIRING', true);
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	9
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	10	require_once('../../wp-load.php');
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	11
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	12	header( 'Content-Type: text/html; charset=utf-8' );
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	13	?>
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	14	<!DOCTYPE html>
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	15	<html xmlns="http://www.w3.org/1999/xhtml" <?php language_attributes(); ?>>
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	16	<head>
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	17	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	18	<title><?php _e( 'WordPress &rsaquo; Database Repair' ); ?></title>
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	19	<?php wp_admin_css( 'install', true ); ?>
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	20	</head>
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	21	<body>
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	22	<h1 id="logo"><img alt="WordPress" src="../images/wordpress-logo.png?ver=20120216" /></h1>
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	23
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	24	<?php
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	25
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	26	if ( ! defined( 'WP_ALLOW_REPAIR' ) ) {
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	27	echo '<p>' . __( 'To allow use of this page to automatically repair database problems, please add the following line to your <code>wp-config.php</code> file. Once this line is added to your config, reload this page.' ) . "</p><code>define('WP_ALLOW_REPAIR', true);</code>";
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	28	} elseif ( isset( $_GET['repair'] ) ) {
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	29	$optimize = 2 == $_GET['repair'];
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	30	$okay = true;
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	31	$problems = array();
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	32
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	33	$tables = $wpdb->tables();
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	34
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	35	// Sitecategories may not exist if global terms are disabled.
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	36	if ( is_multisite() && ! $wpdb->get_var( "SHOW TABLES LIKE '$wpdb->sitecategories'" ) )
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	37	unset( $tables['sitecategories'] );
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	38
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	39	$tables = array_merge( $tables, (array) apply_filters( 'tables_to_repair', array() ) ); // Return tables with table prefixes.
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	40
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	41	// Loop over the tables, checking and repairing as needed.
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	42	foreach ( $tables as $table ) {
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	43	$check = $wpdb->get_row( "CHECK TABLE $table" );
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	44
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	45	echo '<p>';
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	46	if ( 'OK' == $check->Msg_text ) {
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	47	/* translators: %s: table name */
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	48	printf( __( 'The %s table is okay.' ), "<code>$table</code>" );
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	49	} else {
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	50	/* translators: 1: table name, 2: error message, */
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	51	printf( __( 'The %1$s table is not okay. It is reporting the following error: %2$s. WordPress will attempt to repair this table…' ) , "<code>$table</code>", "<code>$check->Msg_text</code>" );
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	52
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	53	$repair = $wpdb->get_row( "REPAIR TABLE $table" );
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	54
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	55	echo '<br />    ';
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	56	if ( 'OK' == $check->Msg_text ) {
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	57	/* translators: %s: table name */
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	58	printf( __( 'Successfully repaired the %s table.' ), "<code>$table</code>" );
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	59	} else {
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	60	/* translators: 1: table name, 2: error message, */
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	61	echo sprintf( __( 'Failed to repair the %1$s table. Error: %2$s' ), "<code>$table</code>", "<code>$check->Msg_text</code>" ) . '<br />';
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	62	$problems[$table] = $check->Msg_text;
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	63	$okay = false;
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	64	}
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	65	}
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	66
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	67	if ( $okay && $optimize ) {
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	68	$check = $wpdb->get_row( "ANALYZE TABLE $table" );
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	69
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	70	echo '<br />    ';
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	71	if ( 'Table is already up to date' == $check->Msg_text ) {
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	72	/* translators: %s: table name */
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	73	printf( __( 'The %s table is already optimized.' ), "<code>$table</code>" );
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	74	} else {
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	75	$check = $wpdb->get_row( "OPTIMIZE TABLE $table" );
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	76
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	77	echo '<br />    ';
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	78	if ( 'OK' == $check->Msg_text \|\| 'Table is already up to date' == $check->Msg_text ) {
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	79	/* translators: %s: table name */
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	80	printf( __( 'Successfully optimized the %s table.' ), "<code>$table</code>" );
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	81	} else {
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	82	/* translators: 1: table name, 2: error message, */
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	83	printf( __( 'Failed to optimize the %1$s table. Error: %2$s' ), "<code>$table</code>", "<code>$check->Msg_text</code>" );
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	84	}
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	85	}
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	86	}
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	87	echo '</p>';
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	88	}
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	89
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	90	if ( $problems ) {
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	91	printf( '<p>' . __('Some database problems could not be repaired. Please copy-and-paste the following list of errors to the <a href="%s">WordPress support forums</a> to get additional assistance.') . '</p>', __( 'http://wordpress.org/support/forum/how-to-and-troubleshooting' ) );
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	92	$problem_output = '';
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	93	foreach ( $problems as $table => $problem )
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	94	$problem_output .= "$table: $problem\n";
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	95	echo '<p><textarea name="errors" id="errors" rows="20" cols="60">' . esc_textarea( $problem_output ) . '</textarea></p>';
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	96	} else {
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	97	echo '<p>' . __( 'Repairs complete. Please remove the following line from wp-config.php to prevent this page from being used by unauthorized users.' ) . "</p><code>define('WP_ALLOW_REPAIR', true);</code>";
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	98	}
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	99	} else {
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	100	if ( isset( $_GET['referrer'] ) && 'is_blog_installed' == $_GET['referrer'] )
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	101	echo '<p>' . __( 'One or more database tables are unavailable. To allow WordPress to attempt to repair these tables, press the “Repair Database” button. Repairing can take a while, so please be patient.' ) . '</p>';
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	102	else
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	103	echo '<p>' . __( 'WordPress can automatically look for some common database problems and repair them. Repairing can take a while, so please be patient.' ) . '</p>';
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	104	?>
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	105	<p class="step"><a class="button" href="repair.php?repair=1"><?php _e( 'Repair Database' ); ?></a></p>
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	106	<p><?php _e( 'WordPress can also attempt to optimize the database. This improves performance in some situations. Repairing and optimizing the database can take a long time and the database will be locked while optimizing.' ); ?></p>
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	107	<p class="step"><a class="button" href="repair.php?repair=2"><?php _e( 'Repair and Optimize Database' ); ?></a></p>
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	108	<?php
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	109	}
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	110	?>
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	111	</body>
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	112	</html>

author	Anthony Ly <anthonyly.com@gmail.com>
	Mon, 19 Nov 2012 18:26:13 +0100
changeset 194	32102edaa81b
parent 136	bde1974c263b
child 204	09a1c134465b
permissions	-rw-r--r--