#4133 - activities not syncing
I've had SugarChimp installed for a couple of weeks now and have noticed that past campaigns with emojis in the subject line have not been syncing from MailChimp to Sugar. I reset day_to_sync_activities to 150 in order to pull in more of our past campaign activities. In order to re-sync all past campaigns within that time period, I also reset the initial_activity_table_fetched to 0, as the "Syncing prior campaigns from Mailchimp to CRM" article suggests. This caused failures in the job_queue for the job 'SugarChimp: Grab campaigns from existing SugarChimpActivity records, add to table and dropdown' pertaining to 'incorrect string value for column subject at row 1.'
Is there a workaround for this issue? We have campaigns in MailChimp sent within the last 150 days that do not have an emoji in the subject line, and some of these have not synced any activities between MailChimp and Sugar either.