Files remain & url not rewritten

Anyone with the same issue ?
It’s really bothering both me and my host.

This did not affect previously uploaded files.

I am assuming your previously uploaded files are still served by their s3 urls, but your newly uploaded files are not. So I need your to check your postmeta table using a post_id of any one of your newly uploaded attachment and see when there is a row in the table for that file with meta_key ‘amazonS3_info’.

but one of the other admins might have.

Also is this a multi site install?.

Hi, thank you for your help !

The site is not a multi-site but I’m not the only one to manage it.

I followed your instructions and here’s the conclusion :
The files whose urls were not matching my S3 bucket didn’t have that “amazonS3_info” value, where older working files had it.

After reinstalling the “S3 & Cloudfront plugin” for the third time, everything went back to normal. Now I can upload files and those files are quickly removed from the main server and served from S3 again, as expected.

However I still need to manually correct the url of the files uploaded while the plugin was acting erratically…

If you have any idea of what the problem was I would still really appreciate your help. It might happen again.

The issue is kind of strange because the codes that handles upload to s3 and the code that insert the ‘amazonS3_info’ post meta value are all located in the same function. In fact right after the main file is uploaded to s3 the next line of code is to insert the post meta value,then uploading the remaining thumbs to s3.
I need you to do one more check, for all the files that you uploaded while the malfunction occurred. Check your s3 bucket to see whether the main file and all its thumbs where actually uploaded to s3.
If the check above check is true, then we need to do a db upgrade so that these files are also served with their corresponding s3 url. Insert the below function in your functions.php file.

$s3_settings = get_option( 'tantan_wordpress_s3' );
        $bucket = $s3_settings['bucket'] ;
        $region = $s3_settings['region'];

	$args = array(
		'post_type' => 'attachment',
		'numberposts' => -1,
		'suppress_filters' => false
	);

	function filter_where( $where = '' ) {
		// change to the right start and end date
		$start_date = '2015-04-03'; $end_date = '2015-04-07';
		$where .= "AND post_date >= '{$start_date}' AND post_date <= '{$end_date}'";
		return $where;
	}
	add_filter( 'posts_where', 'filter_where' );
	$attachments = get_posts( $args );
	remove_filter( 'posts_where', 'filter_where' );

	$att_ids = array();
	foreach( $attachments as $attachment ) {
		$att_ids []= $attachment->ID;
	}

	$atts_info = array();
	foreach( $att_ids as $id ) {
		$prefix = $s3_settings['object-prefix'];
		$att_file = get_post_meta( $id , '_wp_attached_file', true );
		$att_basename = basename($att_file);
		if ( !empty( $prefix) ){
			$key = $prefix.$att_basename;
		} else {
			$key = $att_basename;
		}
		$args = array(
			'id' => $id,
			'key' => $key
		);
		$atts_info []= $args;
	}

	foreach( $atts_info as $att_info ) {
		$args = array (
			'bucket' => $bucket,
			'key' => $att_info['key'],
			'region' => $region,
		);
		update_post_meta( $att_info['id'], 'amazonS3_info', $args );
	}

Make sure the plugin settings is actually the same when you had the issue please, because the code will be using the bucket, prefix and region settings of the plugin.

$start_date and $end_date should be the dates in between the malfunction, so we should be working only with the needed attachments and should be in the format `$tart_date = ‘yyyy-mm-dd’ for example.
After running the above db upgrade you should be good. Please don’t forget to remove the codes after you are done.

Thank you for the code you provided.
It worked and corrected the domain.
However, when rewriting the url it looks like it forgot the /year/month path and my medias are still not correctly called. They appear missing on my website.

Example below.
Before using the code, one link was :
https://neuchvox.ch/wp-content/uploads/2015/03/name.png
After using your code, the link became :
https://static.neuchvox.ch/wp-content/uploads/name.png
However, the file is at :
https://static.neuchvox.ch/wp-content/uploads/2015/03/name.png

The domain became the correct one, but the path is still not adequate.
Is there anyway we could scan the content of the /uploads/ folder to update the links according to the path of the files ?

Thank you a lot again for helping me.
Terence

Hey… your are right, the codes did not take care of the year/month settings, we are almost close. So here we go again, change these lines:

if ( !empty( $prefix) ){
	$key = $prefix.$att_basename;
} else {
	$key = $att_basename;
}

to these:

if (  $s3_settings['enable-object-prefix'] ){
	if ( $s3_settings['use-yearmonth-folders'] ) {
		$key = $prefix.$att_file;
	} else {
		$key = $prefix.$att_basename;
	}
} else {
	if ( $s3_settings['use-yearmonth-folders'] ) {
		$key = $att_file;
	} else {
		$key = $att_basename;
	}
}

And run the script again to update the db. I believe this time we should be good.

This is simply astounding.
All paths are corrected and served from my S3 bucket again.

You are the most helpful person on the entire wordpress support plateforme and a true Php Marksman.

Is there anyway we can leave a review somewhere ?

I’m very grateful !