Hello,

I have make a backup (a dump) of my MySQL in the previous webspace of my Wordpress site (with cforms installed). Now I have imported the dump to the new database of the new webspace of my site. But… in the string of MySQL for the settings, there is again the old website references. If I make some editing of this string (with SQL Yog, for example) I get the error Corrupted settings…

How can I set the new references in the cforms_settings string of MySQL?

Thanks in advantage.

After many hours of study…. I have found the Solution! :)

In the string of the cforms_settings, there are many string fields the coming as:

… s:nn:"string";s:nn:"another string"; …

where:

s: define a string field

nn: define the length of the string

So, for each form created, there are some string that contain the absolute path of the plugin. If I change the server, or I change the subdomain, the absolute path and his length changes too.

For example:

If I have a wordpress site in a server with path:

/var/www/vhosts/demosite.org/httpdocs

and I will move all to another server with this path:

/username/newsite.eu/public_html

the lenght of this path change. So, there are other strings similar in the configuration string that change too. So, what we need to do is:

1. Change all string about web address of the site, absolute path of the server, etc.

2. Calculate the new length of this string

3. Change the value of the length of the string

Example:

s:66:"/var/www/vhosts/demosite.org/httpdocs/wp-content/plugins/cforms$#$"

s:61:"/username/newsite.eu/public_html/wp-content/plugins/cforms$#$"

This modify will apply of ALL strings in relation of web address ("http://www.demosite.org/…") and absolute path, as in the example.

I wish this can help someone.

Thanks for post,U did a GREAT job!