| 1 |
---------------------------------------------- |
|---|
| 2 |
Custom Fields Upgrade Assistant |
|---|
| 3 |
---------------------------------------------- |
|---|
| 4 |
|
|---|
| 5 |
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. |
|---|
| 6 |
|
|---|
| 7 |
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. |
|---|
| 8 |
|
|---|
| 9 |
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. |
|---|
| 10 |
|
|---|
| 11 |
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 |
|---|
| 12 |
|
|---|
| 13 |
|
|---|
| 14 |
---------------------------------------------- |
|---|
| 15 |
Upgrade Process |
|---|
| 16 |
|
|---|
| 17 |
1. Remove existing CustomFields plugin |
|---|
| 18 |
|
|---|
| 19 |
$MTDIR/plugins/CustomFields |
|---|
| 20 |
|
|---|
| 21 |
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. |
|---|
| 22 |
|
|---|
| 23 |
3. Removing orphans via MySQL. |
|---|
| 24 |
|
|---|
| 25 |
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: |
|---|
| 26 |
|
|---|
| 27 |
DELETE FROM mt_plugindata WHERE |
|---|
| 28 |
LEFT( plugindata_key, 6 ) = 'entry_' |
|---|
| 29 |
AND plugindata_plugin = 'CustomFields' |
|---|
| 30 |
AND (SELECT entry_id FROM mt_entry |
|---|
| 31 |
WHERE LEFT( plugindata_key, 6 ) = 'entry_' |
|---|
| 32 |
AND plugindata_plugin = 'CustomFields' |
|---|
| 33 |
AND SUBSTRING( plugindata_key, 7 ) = entry_id) IS NULL; |
|---|
| 34 |
|
|---|
| 35 |
DELETE FROM mt_plugindata WHERE |
|---|
| 36 |
LEFT( plugindata_key, 1 ) = '_' |
|---|
| 37 |
AND plugindata_plugin = 'CustomFields' |
|---|
| 38 |
AND (SELECT author_id FROM mt_author |
|---|
| 39 |
WHERE LEFT( plugindata_key, 1 ) = '_' |
|---|
| 40 |
AND plugindata_plugin = 'CustomFields' |
|---|
| 41 |
AND SUBSTRING( plugindata_key, 2 ) = author_id) IS NULL; |
|---|
| 42 |
|
|---|
| 43 |
4. Fix a bug in Custom Fields |
|---|
| 44 |
|
|---|
| 45 |
Open $MTDIR/addons/Commercial.pack/lib/CustomFields/Util.pm |
|---|
| 46 |
|
|---|
| 47 |
Go to line 322, which looks like this: |
|---|
| 48 |
|
|---|
| 49 |
my $text = ($entry->text || '') . "\n" . ($entry->text_more || ''); |
|---|
| 50 |
|
|---|
| 51 |
And change to: |
|---|
| 52 |
|
|---|
| 53 |
my $text = ($obj->text || '') . "\n" . ($obj->text_more || ''); |
|---|
| 54 |
|
|---|
| 55 |
Note: This bug has been fixed and it'll be included in the next Commercial release of MT (most-likely MT4.1.5) |
|---|
| 56 |
|
|---|
| 57 |
5. Access your MT install, and you will be prompted to upgrade. Click "upgrade" and you're done with the upgrade. |
|---|
| 58 |
|
|---|
| 59 |
|
|---|
| 60 |
---------------------------------------------- |
|---|
| 61 |
Authors and Contributors |
|---|
| 62 |
|
|---|
| 63 |
Fumiaki Yoshimatsu, Six Apart Japan (SAKK) |
|---|
| 64 |
Beau Smith, Six Apart |
|---|
| 65 |
|
|---|
| 66 |
---------------------------------------------- |
|---|
| 67 |
Source |
|---|
| 68 |
|
|---|
| 69 |
SVN Repo: http://code.sixapart.com/svn/mtplugins/trunk/CustomFieldsUpgradeAssistant/ |
|---|
| 70 |
Trac View: http://code.sixapart.com/trac/mtplugins/log/trunk/CustomFieldsUpgradeAssistant |
|---|
| 71 |
Plugins: http://plugins.movabletype.org/customfieldsupgradeassistant/ |
|---|
| 72 |
|
|---|
| 73 |
---------------------------------------------- |
|---|
| 74 |
History |
|---|
| 75 |
|
|---|
| 76 |
1.0 |
|---|
| 77 |
- documented process for upgrading based upon Jesse Gardner's tutorial |
|---|
| 78 |
|
|---|