cforms II Support Forum » delicious:days

[SOLVED] Forms lost and Admin area disabled when restore to new directory

Page: 1	Add a New Topic Reply to Post

Post

New Member

itsfridaymoanin

posts 2

1:15 am June 8, 2010

Quote and Reply

This problem took me a while to figure out so I thought I'd post my story for anyone having the same problem:

I had the combination of needing to upgrade cForms and also upgrade WordPress, which of course needed to be developed at a different location than the original WP install.

First, installed new version of cForms plugin in new WP install. Then tried to transfer old cForms settings with the backup/restore function which downloads a file with the wp_options row (option_name = "cforms_settings") which holds all the form data. However, after restoring, the "Navigate To" menu was blank. No forms in the list. SOLUTION: I then copied over the tables wp_cformsdata and wp_cformssubmissions to the new database, and they populated.

Then I noticed all CSS and Javascript actions were not working for admin pages. Menus don't expand or display and form edit layouts are broken. It was because the page was referencing many pages from the old location, including some JS and CSS pages. Upon manually editing the cforms_settings wp_option row to reference my new stylesheets, the page displayed a "You do not have sufficient permissions to access this page." message and the menu displayed a "Corrupted Settings" message.

I don't know exactly what the problem is with this, but I think it's something really deep like encoding or something. Even functions like MYSQL's REPLACE() functions corrupted the settings. BUT HERE'S THE SOLUTION!

First, reset cForms and re-restore the old settings using the download the backup built, so it's no longer corrupted. Then in cforms.php place this code at line 39, right after declaring the globals (importantly $wpdb):

$row = $wpdb->get_row("SELECT option_value FROM $wpdb->options WHERE option_name = 'cforms_settings' LIMIT 1");

$cfs = unserialize($row->option_value);

$globals = $cfs['global'];

/* Here, make the changes to your global settings – I had to change all the directory references to the new location. */

//This might help: print_r($globals);

foreach($globals AS $i => $v) {

$cfs['global'][$i] = str_replace("old_wp_directory", "new_wp_directory", $v);

}

update_option("cforms_settings", $cfs);

LAST STEP! With this code in, we have manually manipulated the cForms settings, now just load the cForms Admin page and hit "Update Settings" in the Admin Actions menu and it should save all the settings to the DB. Now everything should be good and you can go back and remove that code.

Hope this helps!