Make life easier by reducing the need to flip between apps. If you are using Outlook Web App, Outlook 2013, or Outlook 2016 connected to Office365 or Exchange Server 2013 then be sure to take advantage of this email and contact synchronization add-on. Smartly links emails to your SuiteCRM records and keeps your contacts in sync.
#1892 - Incorrect date value: '0000-00-00' for column 'birthdate'
When attempting to run the first sync, I get the following error in the suitecrm.log file:
MySQL error 1292: Incorrect date value: '0000-00-00' for column 'birthdate' at row 1
If I go to Exchange OWA and enter any date on the contact's birthdate field, the record syncs without problems.
I am currently using SuiteCRM version 7.11.3 and GM Sync Addon Version 1.9.4
Do you have a solution that will not require us to enter a birthdate for each contact?
Thank you,
Ismael
Cam Russell
5 years ago
Hi Ismael,
This is not a problem, even if a contact does not have birthday it will be synchronized. The error you see in the log does not affect anything.
Regards, Max
5 years ago
Hello Max,
I understand about the log but every time that I do a Synchronize, an error notification email is also generated for each contact. The error message is as follows:
Client found response content type of 'text/html; charset=UTF-8', but expected 'text/xml'. The request failed with an empty response.
Is there any way to correct this on my end?
Thank you,
Ismael
5 years ago
Hi Ismael,
I've applied the message filter. You won't be receiving those emails any more.
Best, Max
5 years ago
Hey Max,
I just tried to do a Sync and I am still getting the email messages. Also, clicking on the "Stop" button does not stop the Synchronization process. If I refresh the Office 365 page and try to access the Syncronization menu item again, I get a blank panel where the "Stop" button and sync options should be.
Thanks,
Ismael
5 years ago
Hi Ismael,
I did a couple more tweaks that should resolve email messages issue. However, after looking into logs I found that Synchronization of contacts from Exchange to CRM does not work at all. Because set_entry SOAP request returns invalid response.
System.InvalidOperationException: Client found response content type of 'text/html; charset=UTF-8', but expected 'text/xml'.
Something is broken at CRM side or the user does not have permissions to save Contacts.in CRM.
Regards, Max