root/trunk/CustomFieldsUpgradeAssistant/README

----------------------------------------------
Custom Fields Upgrade Assistant
----------------------------------------------

CustomFields Upgrade Assistant lets you upgrade the Custom Fields data and field structure created and maintained by the older versions of Custom Fields plugin (written by Arvind Satyanarayan of www.movalog.com) to the structure suitable to Movable Type 4.1.

The plugin is intended to overwrite your exisiting Custom Fields plugin.  This plugin includes the directory whose name is "Custom Fields", in the directory there is a plugin defition script whose name is "customfields.pl"; both the directory and the file were *not* mistakenly named.

Please make sure you backup the database and the plugin directories and files before upgrading, so if *something* happens, you can go back to the original state.

Jessee Gardner (with help from Six Apart's David Phillips aka TweezerMan) wrote a great CustomFields migration tutorial at: http://www.movabletweak.com/app/migrating_customfields_movable_type.php. The steps are repeated here


----------------------------------------------
Upgrade Process

1. Remove existing CustomFields plugin

    $MTDIR/plugins/CustomFields

2. Install the CustomFieldsUpgradeAssistant plugin. This upgrade plugin has the same name as the original plugin and should be placed in the same location as the original plugin.

3. Removing orphans via MySQL.

Arvind's plugin didn't delete custom field data when the objects it was attached to were deleted. These two MySQL queries will remove that data:

    DELETE FROM mt_plugindata WHERE 
    LEFT( plugindata_key, 6 ) = 'entry_' 
    AND plugindata_plugin = 'CustomFields' 
    AND (SELECT entry_id FROM mt_entry 
    WHERE LEFT( plugindata_key, 6 ) = 'entry_' 
    AND plugindata_plugin = 'CustomFields' 
    AND SUBSTRING( plugindata_key, 7 ) = entry_id) IS NULL;
    
    DELETE FROM mt_plugindata WHERE
    LEFT( plugindata_key, 1 ) = '_' 
    AND plugindata_plugin = 'CustomFields' 
    AND (SELECT author_id FROM mt_author 
    WHERE LEFT( plugindata_key, 1 ) = '_' 
    AND plugindata_plugin = 'CustomFields' 
    AND SUBSTRING( plugindata_key, 2 ) = author_id) IS NULL;

4. Fix a bug in Custom Fields

Open $MTDIR/addons/Commercial.pack/lib/CustomFields/Util.pm

Go to line 322, which looks like this:
    
    my $text = ($entry->text || '') . "\n" . ($entry->text_more || '');
    
And change to:
    
    my $text = ($obj->text || '') . "\n" . ($obj->text_more || '');

Note: This bug has been fixed and it'll be included in the next Commercial release of MT (most-likely MT4.1.5)

5. Access your MT install, and you will be prompted to upgrade. Click "upgrade" and you're done with the upgrade.


----------------------------------------------
Authors and Contributors

Fumiaki Yoshimatsu, Six Apart Japan (SAKK)
Beau Smith, Six Apart

----------------------------------------------
Source

SVN Repo: http://code.sixapart.com/svn/mtplugins/trunk/CustomFieldsUpgradeAssistant/
Trac View: http://code.sixapart.com/trac/mtplugins/log/trunk/CustomFieldsUpgradeAssistant
Plugins: http://plugins.movabletype.org/customfieldsupgradeassistant/

----------------------------------------------
History

1.0
- documented process for upgrading based upon Jesse Gardner's tutorial