You should now disable and remove this plugin.', 'cf_guid_fix' ); ?>
' . esc_html( $this->error_msgs[ intval( $num ) ] ) . '';
}
?>
non-unique GUID bug.', 'cf_guid_fix' ); ?>
fix_guids();
if( empty( $this->errors ) ) {
wp_redirect( add_query_arg( array( 'success' => '' ), $this->page_url ) );
} else {
wp_redirect( add_query_arg( array( 'error' => implode( ',', $this->errors ) ), $this->page_url ) );
}
exit;
break;
}
}
}
private function fix_guids() {
global $wpdb;
// add index on GUID column
$r = $wpdb->query( "
ALTER TABLE $wpdb->posts
ADD INDEX (guid)
" );
// Error Handling
if( $r === false ) {
$this->add_error( 1 );
}
// find non-unique GUID values
// NOTE: not including revisions since that's a whole other mess to
// try to get the numbering right if we change the GUID
// this gets the GUIDs
// SELECT guid
// FROM $wpdb->posts
// WHERE post_type != 'revision'
// GROUP BY guid
// HAVING COUNT(guid) > 1
// WORKS - but is very slow
// SELECT ID
// FROM $wpdb->posts
// WHERE guid IN (
// SELECT guid
// FROM $wpdb->posts
// WHERE post_type != 'revision'
// GROUP BY guid
// HAVING COUNT(guid) > 1
// )
// AND post_type != 'revision'
$non_unique_guids = $wpdb->get_col( $wpdb->prepare( "
SELECT p1.ID
FROM $wpdb->posts p1
WHERE 1 < (
SELECT COUNT(ID)
FROM $wpdb->posts p2
WHERE p1.post_type != 'revision'
AND p1.guid = p2.guid
)
AND p1.post_type != 'revision'
" ) );
// make them unique
if( count( $non_unique_guids ) ) {
foreach( $non_unique_guids as $post_id ) {
$url = site_url( '?p=' . $post_id );
$r = $wpdb->query( $wpdb->prepare( "
UPDATE $wpdb->posts
SET guid = %s
WHERE ID = %d
", $url, $post_id ) );
// Error Handling
if( $r === false ) {
$this->add_error( 2 );
}
}
}
// remove index from GUID column
$r = $wpdb->query( "
ALTER TABLE $wpdb->posts
DROP INDEX guid
" );
// Error Handling
if( $r === false ) {
$this->add_error( 3 );
}
}
function add_error( $error_num ) {
if( !in_array( $error_num, $this->errors ) ) {
$this->errors[ ] = intval( $error_num );
}
}
}
}
}