Template absolute path and migration to other hosting

Same problem here, migrating the website to production I get this develop server path:

(fresh install no legacy update)

/home8/webserver/public_html/cns/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/ngglegacy/view/gallery-caption.php

In the dropdown of the template there is the right one:
NEXTGEN:gallery-caption.php (that should be selected if the relative paths is keeped, but there is the absolute path mentioned before).

and it is obviously different on the production server.

There is no reference on the db to manually change it, I have almost 140 galleries with the wrong path in the same number of pages. It is a crazy works to do manually.

Resetting NextGen preferences does not works.
Please help this is insane.

I just installed two clean version of latest WP with latest NextGen Plugin v2.0.66.37, the problem still persist.

If I add a gallery on a page on first wp installation and migrate all the db to the second installation (obviously changing all the path on the db to point the second wp) I get a [Not a valid template].

Looks like there is an ABSOLUTE PATH ENCODED BASE64 (WHYYY!!!) on Table WP_POSTS with post type “displayed gallery” field post_content and post_content_filtered.

Take a look the the absolute path in “template” that is impossible to works on different wp installation when migrating… and migrate to dev to production wordpress is a common use.

Please give me some hope I can’t manually relink 140 galleries.

PICTURE

DECODED CONTENTS
{“display_settings”:{“use_lightbox_effect”:true,”images_per_page”:”20″,”number_of_columns”:”0″,”thumbnail_width”:”120″,”thumbnail_height”:”90″,”show_all_in_lightbox”:”0″,”ajax_pagination”:”0″,”use_imagebrowser_effect”:”0″,”template”:”\/Volumes\/WORKS\/WebDev\/wp1\/wp-content\/plugins\/nextgen-gallery\/products\/photocrati_nextgen\/modules\/ngglegacy\/view\/gallery-caption.php“,”display_no_images_error”:1,”disable_pagination”:0,”show_slideshow_link”:”1″,”slideshow_link_text”:”
etc….

Same problem here. This fix (put in root of website, for big databases execute via CLI)

require_once('wp-blog-header.php');

FixGalleryTemplatePath();

// ******************************************************************************
// FixGalleryTemplatePath
Function FixGalleryTemplatePath()
{

echo "FixGalleryTemplatePath\n\n";

global $wpdb;
$prefix=$wpdb->prefix;

$oldpath='\/home\/oldpath\/public_html\/wp-content'; // change OLD path here
$newpath='\/home\/httpd\/vhosts\/newpath\/wp-content'; // change NEW path here

 $sql="SELECT ID,post_content,post_content_filtered FROM {$prefix}posts WHERE post_type='displayed_gallery'";

 $result = $wpdb->get_results($sql);

foreach ($result as $code)
{

	$id=$code->ID;
	$decodedpost_content_filtered=base64_decode($code->post_content_filtered);
	$decodedpost_content_filtered=str_replace($oldpath,$newpath,$decodedpost_content_filtered);
	$encodedpost_content_filtered=base64_encode($decodedpost_content_filtered);

	$decodedpost_content=base64_decode($code->post_content);
	$decodedpost_content=str_replace($oldpath,$newpath,$decodedpost_content);
	$encodedpost_content=base64_encode($decodedpost_content);

	$sql="UPDATE '{$prefix}posts' SET 'post_content'='$encodedpost_content','post_content_filtered'='$encodedpost_content_filtered' WHERE ('ID'='$id')";
	$wpdb->query($sql);

} 

echo "Fixed!";

}

The reset option does not fix anything, I had to write a code in nodejs to fix it, same as mmorselli did in php.

var mysql = require('mysql');

var connection = mysql.createConnection(
    {
      host     : 'localhost',
      user     : 'root',
      password : 'root',
      database : 'cns_yachts',
    }
);

connection.connect();
var queryString = "SELECT * FROM cns_posts where post_type = 'displayed_gallery'";
connection.query(queryString, function(err, rows, fields) {

    if (err) throw err;
    for (var i in rows) {

      str = new Buffer(rows[i].post_content, 'base64').toString('ascii');
      var newstr = str.replace(/template":"(.*?)"/g,'template":"gallery-caption.php"');

      strEncoded = new Buffer(newstr).toString('base64');
      console.log(strEncoded + " \n");

 connection.query('UPDATE cns_posts SET post_content = ?, post_content_filtered = ? WHERE ID = ?', [strEncoded, strEncoded, rows[i].ID],function (err,results){
      console.log(err,results);
    }
});
console.log("fine");