site_iri: web/wp-admin/maint/repair.php@919b4ddb13fa (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>
204 09a1c134465b man wordpress + plugins order post + slideshow Anthony Ly <anthonyly.com@gmail.com> parents: 194 diff changeset	19	<?php
09a1c134465b man wordpress + plugins order post + slideshow Anthony Ly <anthonyly.com@gmail.com> parents: 194 diff changeset	20	wp_admin_css( 'install', true );
09a1c134465b man wordpress + plugins order post + slideshow Anthony Ly <anthonyly.com@gmail.com> parents: 194 diff changeset	21	?>
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	22	</head>
204 09a1c134465b man wordpress + plugins order post + slideshow Anthony Ly <anthonyly.com@gmail.com> parents: 194 diff changeset	23	<body class="wp-core-ui">
09a1c134465b man wordpress + plugins order post + slideshow Anthony Ly <anthonyly.com@gmail.com> parents: 194 diff changeset	24	<h1 id="logo"><a href="<?php esc_attr_e( 'http://wordpress.org/' ); ?>"><?php _e( 'WordPress' ); ?></a></h1>
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	25
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	26	<?php
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	27
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	28	if ( ! defined( 'WP_ALLOW_REPAIR' ) ) {
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	29	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	30	} elseif ( isset( $_GET['repair'] ) ) {
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	31	$optimize = 2 == $_GET['repair'];
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	32	$okay = true;
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	33	$problems = array();
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	34
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	35	$tables = $wpdb->tables();
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	36
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	37	// 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	38	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	39	unset( $tables['sitecategories'] );
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	40
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	41	$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	42
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	43	// 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	44	foreach ( $tables as $table ) {
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	45	$check = $wpdb->get_row( "CHECK TABLE $table" );
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	46
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	47	echo '<p>';
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	48	if ( 'OK' == $check->Msg_text ) {
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	49	/* translators: %s: table name */
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	50	printf( __( 'The %s table is okay.' ), "<code>$table</code>" );
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	51	} else {
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	52	/* translators: 1: table name, 2: error message, */
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	53	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	54
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	55	$repair = $wpdb->get_row( "REPAIR TABLE $table" );
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	56
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	57	echo '<br />    ';
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	58	if ( 'OK' == $check->Msg_text ) {
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	59	/* translators: %s: table name */
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	60	printf( __( 'Successfully repaired the %s table.' ), "<code>$table</code>" );
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	61	} else {
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	62	/* translators: 1: table name, 2: error message, */
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	63	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	64	$problems[$table] = $check->Msg_text;
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	65	$okay = false;
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	66	}
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	67	}
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	68
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	69	if ( $okay && $optimize ) {
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	70	$check = $wpdb->get_row( "ANALYZE TABLE $table" );
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	71
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	72	echo '<br />    ';
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	73	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	74	/* translators: %s: table name */
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	75	printf( __( 'The %s table is already optimized.' ), "<code>$table</code>" );
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	76	} else {
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	77	$check = $wpdb->get_row( "OPTIMIZE TABLE $table" );
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	78
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	79	echo '<br />    ';
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	80	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	81	/* translators: %s: table name */
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	82	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	83	} else {
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	84	/* translators: 1: table name, 2: error message, */
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	85	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	86	}
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	87	}
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	echo '</p>';
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	90	}
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	91
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	92	if ( $problems ) {
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	93	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	94	$problem_output = '';
136 bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	95	foreach ( $problems as $table => $problem )
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	96	$problem_output .= "$table: $problem\n";
32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	97	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	98	} else {
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	99	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	100	}
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	101	} else {
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	102	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	103	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	104	else
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	105	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	106	?>
204 09a1c134465b man wordpress + plugins order post + slideshow Anthony Ly <anthonyly.com@gmail.com> parents: 194 diff changeset	107	<p class="step"><a class="button button-large" href="repair.php?repair=1"><?php _e( 'Repair Database' ); ?></a></p>
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	108	<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>
204 09a1c134465b man wordpress + plugins order post + slideshow Anthony Ly <anthonyly.com@gmail.com> parents: 194 diff changeset	109	<p class="step"><a class="button button-large" 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	110	<?php
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	111	}
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	112	?>
bde1974c263b merge from wordpress ymh@caf4f556-3d62-0410-8435-a86758001935 parents: diff changeset	113	</body>
194 32102edaa81b MAJ wordpress et ajout de plugin Anthony Ly <anthonyly.com@gmail.com> parents: 136 diff changeset	114	</html>

author	Anthony Ly <anthonyly.com@gmail.com>
	Tue, 12 Mar 2013 18:21:39 +0100
changeset 206	919b4ddb13fa
parent 204	09a1c134465b
permissions	-rw-r--r--