mailchimpsync issueshttps://lab.civicrm.org/extensions/mailchimpsync/-/issues2021-09-14T00:25:50Zhttps://lab.civicrm.org/extensions/mailchimpsync/-/issues/2Show recent failures2021-09-14T00:25:50ZRichShow recent failuresThe status says "in sync" despite there being people who can't be sync-ed. It's more that it's 'reconciled' rather than actually in sync.
Some failures are longstanding and uninteresting, e.g. the person who has 2 email addresses on one...The status says "in sync" despite there being people who can't be sync-ed. It's more that it's 'reconciled' rather than actually in sync.
Some failures are longstanding and uninteresting, e.g. the person who has 2 email addresses on one contact record, one email is unsubscribed at Mailchimp and the other is subscribed. They can safely be left as faliures.
But others might need investigation, especially when they're recent.
Showing a count per list of recent failures might help people who monitor these things iron out awkward cases.
Something like this:
```sql
select count(*)
from civicrm_mailchimpsync_cache mc
inner join civicrm_mailchimpsync_update u on mc.id = u.mailchimpsync_cache_id
and u.error_response is not null and u.error_response != ''
inner join civicrm_mailchimpsync_batch b on u.mailchimpsync_batch_id = b.id
where b.completed_at >= CURRENT_TIMESTAMP - INTERVAL 1 WEEK;
```https://lab.civicrm.org/extensions/mailchimpsync/-/issues/3if webhook missing for list, then added, main screen still says missing2020-01-14T17:49:40ZRichif webhook missing for list, then added, main screen still says missinghttps://lab.civicrm.org/extensions/mailchimpsync/-/issues/4How to handle email changes done at CiviCRM?2020-01-15T13:11:51ZRichHow to handle email changes done at CiviCRM?Mailchimp provides a UX for members to update their email address. This results in a webhook which [will](https://docs.civicrm.org/mailchimpsync/en/latest/reference/sync-detail/#webhooks) add the address to the contact, if new, and updat...Mailchimp provides a UX for members to update their email address. This results in a webhook which [will](https://docs.civicrm.org/mailchimpsync/en/latest/reference/sync-detail/#webhooks) add the address to the contact, if new, and update our cache table with the new email address.
However any changes to any email in CiviCRM do not affect the process.
One of the challenges is that there's no "change email" UX in CiviCRM (for good reasons). You can edit an email, you can delete an email, you can add a new email, but all these are separate operations that might not have anything to do with someone changing the email that they use on a particular list.
One possibility would be this:
1. add a hook so that whenever an email is updated/created/deleted, the contact's mailchimp connections are flagged as to be included in the next sync run. Which then...
2. After checking that the contact we have for the email still exists (here we're assuming it does), then it should go on to check that the email mailchimp has still exists on the CiviCRM contact record. If so, all is well, nothing to do. If not...
3. This now looks like we need to change the email address at Mailchimp. We could **make the assumption** that this is a fairly rare case (even on a big list), and that we're therefore OK to action the change with a single synchronous call to Mailchimp's API, followed by updating our cache table with the new address.
We would select the address to use by first picking the first not-on-hold: Bulk Mail one, then the primary, then any of them, as we do for other subscriptions.
If, however, there are no email addresses at CiviCRM that we can use then we should **remove them from the group**? Or mark the sync as a **fail**?https://lab.civicrm.org/extensions/mailchimpsync/-/issues/8Unknown DB Error on job execute, Interests sync but not Audience2021-05-27T08:45:16ZscottwiltonUnknown DB Error on job execute, Interests sync but not AudienceI am able to sync Interests but my two main normal Audiences are failing to syncc.
![Screen_Shot_2020-03-25_at_9.44.28_AM](/uploads/b97b96526388c0bd06038fa6aa50174e/Screen_Shot_2020-03-25_at_9.44.28_AM.png)
The sync seems to stall on t...I am able to sync Interests but my two main normal Audiences are failing to syncc.
![Screen_Shot_2020-03-25_at_9.44.28_AM](/uploads/b97b96526388c0bd06038fa6aa50174e/Screen_Shot_2020-03-25_at_9.44.28_AM.png)
The sync seems to stall on the step `removeInvalidContactIds: beginning populateMissingContactIds`.
![Screen_Shot_2020-03-25_at_9.48.24_AM](/uploads/3b188df6286d556ed51b3b071fc85ff2/Screen_Shot_2020-03-25_at_9.48.24_AM.png)
When I look at the log in the Schedule Jobs, I see:
`Finished execution of Call Mailchimpsync.Fetchandreconcile API with result: Failure, Error message: DB Error: unknown error`
Happy to provide more diagnostics or logs, but I'm not sure what would be helpful.https://lab.civicrm.org/extensions/mailchimpsync/-/issues/11Looking for new maintainer2022-11-11T10:02:30ZRichLooking for new maintainerThere's a lot of people who still use Mailchimp, and CiviCRM deserves a reliable and efficient sync extension, which this hopes to be. But it's complex and hard because the two systems work very different ways.
All my clients that curre...There's a lot of people who still use Mailchimp, and CiviCRM deserves a reliable and efficient sync extension, which this hopes to be. But it's complex and hard because the two systems work very different ways.
All my clients that currently use Mailchimp are considering moving to something else (CiviCRM + Mosaico or another 3rd party marketer), which means I will no longer be able to access funds to maintain this. I'm happy to chip in expertise but obviously I'll have to drop its priority on my availability.
Both of these are reasons to seek a co-maintainer(s), so if interested please leave a comment here.https://lab.civicrm.org/extensions/mailchimpsync/-/issues/13Two-way sync is not working2020-12-15T15:15:21ZCristinaPTwo-way sync is not workingWhen running a **sync** between Mailchimp and CiviCRM, I only get **added to CiviCRM** the new subscribers in MailChimp, but the new contacts/members or changes in CiviCRM **never migrate into Mailchimp**.
I would be very grateful if you...When running a **sync** between Mailchimp and CiviCRM, I only get **added to CiviCRM** the new subscribers in MailChimp, but the new contacts/members or changes in CiviCRM **never migrate into Mailchimp**.
I would be very grateful if you could help me with that.https://lab.civicrm.org/extensions/mailchimpsync/-/issues/19Sync doesn't add contact in interest group2021-10-04T14:25:13ZcivideskSync doesn't add contact in interest groupHello Rich,
I have configured the sync with one audience and a certain number of interest groups. See screenshot.
And I am experiencing a couple of issues.
1- The sync doesn't add the contact in the corresponding interest group in Mail...Hello Rich,
I have configured the sync with one audience and a certain number of interest groups. See screenshot.
And I am experiencing a couple of issues.
1- The sync doesn't add the contact in the corresponding interest group in Mailchimp.
This is what happening:
1- In CiviCRM contact Susan Doe is added in 2 groups: Master Mailchimp list (do not delete) and Teachers.
2- After the sync ran, contact Susan Doe has been added to the MailChimp audience list CiviCRM sync - do not add contacts manually but not in the interest group Teachers.
3- The sync ran again and then the contact Susan Doe has been removed by the sync from the Civi group Teachers.
How can we make the sync add the contact Susan Doe in the audience list and in the interest group at the same time, during the 1st sync?
2- For a new contact the sync doesn't transfer the first name and last name of the contact to MailChimp. Only the email address is added in MailChimp.
Thanks for your help.!
![Screenshot](/uploads/75cac0c69e0fbe54a2b06fd082a7f7e4/Screenshot.png)https://lab.civicrm.org/extensions/mailchimpsync/-/issues/21Need to exclude sync tracking table from logging2023-01-08T20:36:00ZeileenNeed to exclude sync tracking table from loggingI discovered we had a massive database almost entirely made up of changes to the `log_civicrm_mailchimpsync` table - it can be excluded from logging by a hook.
If I patch it locally I will paste the patch in here - for some reason I can...I discovered we had a massive database almost entirely made up of changes to the `log_civicrm_mailchimpsync` table - it can be excluded from logging by a hook.
If I patch it locally I will paste the patch in here - for some reason I can't open the merge request tabs on this repo & obviously given the fact the extension is maintainer-wanted it probably won't get much attention even if I do (I'm not a heavy user - it is on one site that I suspect doesn't actually use it / won't exist for long)https://lab.civicrm.org/extensions/mailchimpsync/-/issues/22Removing new contacts from CiviCRM Group2023-06-08T08:04:35ZabucoRemoving new contacts from CiviCRM GroupHello, we have set interest sync from CiviCRM standard group to Mailchimp group. But there is problem with new contacts in the CiviCRM.
When we create new contact and add it to proper groups, than we run sync with Mailchimp.
Contact is a...Hello, we have set interest sync from CiviCRM standard group to Mailchimp group. But there is problem with new contacts in the CiviCRM.
When we create new contact and add it to proper groups, than we run sync with Mailchimp.
Contact is added to the Mailchimp Audience, but Groups(Interest) are not set. In CiviCRM is contacted removed from these Groups (Interest) with note that MCSync removed it.
If we add contact back to this group, than second sync is work normally and all groups all synced.
This very strange behaviour and I cannot find reason why is set like this. We propably find the part of the code which do this. Attached below
![image](/uploads/1aa77d71b1cabf3220da0a44eff26889/image.png)
I thing that is bug, because I cannot find why I want to remove new contact from Civi groups after first sync.
Thank you for the explanation
Regards
Lukas Halahttps://lab.civicrm.org/extensions/mailchimpsync/-/issues/23Batch Webhook Id Rejected but looks fine to me2023-07-25T00:34:46ZseamusleeBatch Webhook Id Rejected but looks fine to meOn a client site they had a batch webhook rejected because the id was invalid but I think this should be a legit id z46ox3jbydOn a client site they had a batch webhook rejected because the id was invalid but I think this should be a legit id z46ox3jbyd