The migrate_1.8-to-1.9.sql script incorrectly migrated act.customerNote to act.customerCommunicationNote.
It renames the 'category' node to 'reason' when it should be actually assigning it to the reason column of acts.
To correct this:
1. The acts.reason column should be updated for act.customerCommunicationNote acts where there is an act_details reason row, but only if users haven't subsequently changed the reason column
2. the act_details reason row should be deleted for act.customerCommunicationNote acts, if it exists