Changeset 572 for branches/CustomFieldsUpgradeAssistant-bugfix
- Timestamp:
- 03/20/08 03:21:33 (21 months ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
branches/CustomFieldsUpgradeAssistant-bugfix/README
r568 r572 11 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 12 13 ---------------------------------------------- 14 Bug Fix Release 15 ---------------------------------------------- 16 This version which you downloaded from http://code.sixapart.com/svn/mtplugins/branches/CustomFieldsUpgradeAssistant-bugfix/, is a temporary bugfix release of the plugin. This version contains a fix to the issue Jesse Gardner and David Phillips found and resolved by running two SQL queries. The fix is going to be included in the next release of Movable Type Professional, therefore this version will be deprecated by the release. 17 18 This version is in a "branch", because after the new release of Movable Type Professional, this version should not be needed any longer (thus probably be removed). 13 19 14 20 ---------------------------------------------- … … 21 27 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 28 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 29 3. Fix a bug in Custom Fields - You still have to do this with this version of the plugin. 44 30 45 31 Open $MTDIR/addons/Commercial.pack/lib/CustomFields/Util.pm … … 55 41 Note: This bug has been fixed and it'll be included in the next Commercial release of MT (most-likely MT4.1.5) 56 42 57 5. Access your MT install, and you will be prompted to upgrade. Click "upgrade" and you're done with the upgrade.43 4. Access your MT install, and you will be prompted to upgrade. Click "upgrade" and you're done with the upgrade. 58 44 59 45 … … 67 53 Source 68 54 55 For this bugfix version 56 SVN Repo: http://code.sixapart.com/svn/mtplugins/branches/CustomFieldsUpgradeAssistant-bugfix/ 57 Trac View: http://code.sixapart.com/trac/mtplugins/log/branches/CustomFieldsUpgradeAssistant-bugfix 58 59 For the mainstream release (although contains bugs as of 2008-03-20) 69 60 SVN Repo: http://code.sixapart.com/svn/mtplugins/trunk/CustomFieldsUpgradeAssistant/ 70 61 Trac View: http://code.sixapart.com/trac/mtplugins/log/trunk/CustomFieldsUpgradeAssistant 62 71 63 Plugins: http://plugins.movabletype.org/customfieldsupgradeassistant/ 72 64 … … 74 66 History 75 67 68 1.0b 69 - removed the needs to run two DELETE queries in MySQL database by including the fixed version of code in the plugin. 70 76 71 1.0 77 72 - documented process for upgrading based upon Jesse Gardner's tutorial
