Search Results for 'download link'

Good morning!

I have a question about download links in WPDM,
I will have to change my OVH server to another one, and got aroung 6000 links on wordpress download manager that point to an external server starting with ns3xxx…
The problem is that i don’t want to update links one by one….

So decided to check how to in MySQL directly

1st attempt :
update wp_postmeta set meta_value = replace(meta_value, "ns37xxxxx.ip-213-32-0.eu/XXX", "ns30xxxxx.ip-149-202-85.eu/YYY");
It seems working when checking the URL in PhpMyadmin database as it changed correctly this part of the link, but when checking the WPDM link setting (attached file), it got empty… no more url of the file anymore. Dont understand why.

If i revert back the URL with the revert SQL command :
update wp_postmeta set meta_value = replace(meta_value, "ns30xxxxx.ip-149-202-85.eu/YYY", "ns37xxxxx.ip-213-32-0.eu/XXX");
The link setting is back to normal (not empty anymore) and working.

2nd attempt :
Last year i posted a message here about the same problem, someone wrote this script :

<?php
include_once('wp-load.php' );

$link =  mysql_connect("xxxxxxx.mysql.db", "xxxxxxx", "yyyyyyy"); // Connexion à MySQL
mysql_select_db("xxxxxx"); // Sélection de la base

if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';

global $wpdb;
		$data = $wpdb->get_results( "select * from wp_postmeta where meta_key='__wpdm_files'" );
		foreach($data as $d){
		$newurl = array();
		$oldurl = maybe_unserialize($d->meta_value);
		foreach($oldurl as $id ► $url){
		$newurl[$id] = str_replace("ns37xxxxx.ip-213-32-0.eu/XXX", "ns30xxxxx.ip-149-202-85.eu/YYYY",$url);
		}
		update_post_meta($d->post_id, '__wpdm_files', $newurl);
		}
		
mysql_close($link);
?>

It was working great at this time, but not anymore, when using my website url with /change_url.php, got an error message on wordpress “Critical Error”

It’s getting really bad as in 2 weeks my old server will be offline and have to update all link to point to the new server.

Anyone know an easy way to replace a part of downloads links in SQL without the meta_value to become empty or plugin/script to do same?

Thanks a lot.
Renzu

I just received an email from Google regarding a ‘soft 404’ that resulted from me deleting a downloadable asset (package) I had setup, and it surprised me because I did not realize (or anticipate) that Google would index the downloadable assets directly instead of the Page they appear on (the pages that are created dynamically by the plugin using the templates).

I really don’t want Google indexing individual assets using the URL /mydomain.com/?wpdmdl=123456 – that is the download link, but rather I want Google to index the *Page* that download link appears on (where I have the asset embedded using the viewer)…..

What can I do to fix this? I’m not sure that if I tell Google to ignore any URLs that have /?wpdmdl= it won’t stop them from indexing my download pages (?)….I’m not an SEO expert but I want to fix this before it becomes a bigger problem for me….