CiviCRM Community Forums (archive)

When CiviCRM 2.0 upgrades a schema from 1.9, it merges some of the civicrm_activity_history table into the civicrm_activity table, but does not merge any activity history row with a label that is not one of the pre-defined labels.  Here is a patch to fix that:

https://svn.dharmatech.org/svn/civicrm/2.0/branches/devl/merge_activity_history.patch

You need to accept our self-signed certificate to access our repository.

This patch is against CiviCRM 2.0.6.  Apply it to the CiviCRM 2.0 code before you start the upgrade process.  It works by finding all your self-defined activity labels and adding them to the civicrm_option_values table before the table conversion.

Peace.  Out.
DharmaTech

There is now an alternative to patching the code.  You can download and run the CiviCRM DB Tools from http://wiki.civicrm.org/confluence/display/CRMDOC/Database+Troubleshooting+Tools.  The repair tool will add user-defined activity to the civicrm_option_value table so that the upgrade to 2.0 will not destroy the activity history.