AnsweredAssumed Answered

[ERROR] convert: Conversion from Y-m-d H:i:s to Y-m-d H:i failed

Question asked by dexcomm dexcomm on Sep 21, 2015
I migrated my on-site database from MSSQL to MySQL. I changed my sugar config file to point to MySQL.  All data is displayed correctly on webpage except dates.  No dates are displayed on the webpages.

My log file is filled with:
09/21/15 16:29:34 [1976][b7f6db13-2a97-8851-e467-4d8cd7028e17][ERROR] convert: Conversion of 2011-04-01 19:27:52.000000 from Y-m-d H:i:s to Y-m-d H:i failed

09/21/15 16:29:34 [1976][b7f6db13-2a97-8851-e467-4d8cd7028e17][ERROR] convert: Conversion of 2011-03-25 18:08:30.000000 from Y-m-d H:i:s to Y-m-d H:i failed

09/21/15 16:29:34 [1976][b7f6db13-2a97-8851-e467-4d8cd7028e17][ERROR] convert: Conversion of 2011-04-01 19:27:52.000000 from Y-m-d H:i:s to Y-m-d H:i failed

...

SugarCRM Professional 6.5.22
PHP 5.3.6
MySQL 5.6
Datatype on mysql: datetime(6)
Example: 2015-01-01 12:00:00.000000

Any ideas what is causing the conversion to fail?

Thank you!

Outcomes