How to update all post at once?

Question

Is there a way to update all post at once?

The issue is, when i migrated content from another CMS, some of the permalinks are working fine and some of them are not, when i updated the posts all links are working fine.

I have tried some methods to perform this requirement, but it doesn't helped.

Answer 1

Try this out:

/*
Plugin Name: Post Bulk Update
Description: Updates certain fields of my posts at once. On Activation. Awesome
Author: Me. I did it
*/
add_action('init','post_bulk_update');

function post_bulk_update(){
 $posts_to_update = new WP_Query('cat=x&showposts=1000');
while($posts_to_update ->have_posts()) : $posts_to_update ->the_post();
$postUpdateArray = array();
$postUpdateArray ['ID'] = $post->ID;//Don't remove this. The ID is mandatory
$postUpdateArray ['post_title'] = 'Post Prefix: '.$post->post_title;
     wp_update_post( $postUpdateArray );
endwhile;

}

For more reference see this.

Answer 2

Thanks all,

The issue is resolved by removing special characters from wp_posts -> post_name.

Now all permalinks are working fine.