Activities Sync - Meetings, Task and Calls

Also, when I browse to the URL I am adding to my Phone get a 404 error page. http://syncupcrm.realwired.com/sas.php/calendars/USERNAME/default

Hi Sunda,

We do our best to ensure compatibility with MSSQL by avoiding database specific calls such as UTC_TIMESTAMP, however this one appears to have slipped through. We will get a patch to remedy this issue uploaded as soon as possible.

We were unable to wait for a fix so we completed the fix ourselves. To assist in getting this version compatible with MSSQL we had to change the items below. Maybe you could make sure this is accounted for in future versions so we do not have to figure out the issue and fix it. Thanks, hope this helps!

We use SQL (not MSSQL) and so we had to add code to handle the UTC conversion in the database for SQL vs MSSQL and change the below items (hope this helps you):

Opacus was throwing errors, and I fixed a couple. The crucial ones were like this one:

sas/lib/opacus/sugartovcal/SugarObjectToVcalObject.php line ~158 $convertedDateTime = DateTime::createFromFormat('Y-m-d H:i:s.u', $dateTime, new DateTimeZone('UTC'));

That line (and a few other places and files) calls the method createFromFormat(). That was not working. The content of the variable $dateTime includes a .000 after the seconds. Those are microseconds.

Well, when you follow this link: http://php.net/manual/en/class.datetime.php#108970 You see this quote by a commenter:

"DateTime does not support split seconds (microseconds or milliseconds etc.) I don't know why this isn't documented.”

Ok, so DateTime doesn’t accept microseconds Then a better approach than what I did would be to find the place $dateTime was created, and strip off the microseconds. That’d be the “right way”.

What I did was just add ‘.u’ after Y-m-d H:i:s because DateTime wasn’t even accepting it… because the programmer did not specify microseconds. (even though dateTime discards them).

So, I searched for every instance of createFromFormat() and replaced the format string to include ‘.u’