Converting datetime error

[worgi]

I just upgraded to 5.0.0e from d. I am now getting the following error when trying to sync using Outlander and am struggling trying to pinpoint the problem. Hoping someone might have a suggestion or two of where to look. I do see the absence of a value for the where clauses though.

Here is the Messages Error and the log:

Processing modified Outlook call events...

Exception caught: Client found response content type of 'text/html', but expected 'text/xml'.

The request failed with the error message:
--
SQL Error : Conversion failed when converting datetime from character string.
--.
at System.Web.Services.Protocols.SoapHttpClientProtoc ol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtoc ol.Invoke(String methodName, Object[] parameters)
at SugarCRMTools.net.hereware.app1.SugarCrmWebService s.sugarsoap.set_entry(String session, String module_name, name_value[] name_value_list)
at SugarCRMTools.Tools.addUpdateCrmItem(String moduleName, name_value[] fieldList)
at Frijoles.CalendarService.updateCrmCalendarEvent(Ca lendarEventDO calEvent)
at Frijoles.CalendarService.syncCalendarEvents(Status MessageHandler showStatusMessage, OverallProgressHandler updateOverallProgress)
at Frijoles.Form1.PerformSync(StatusLabelHandler showStatusLabel, StatusMessageHandler showStatusMessage, OverallProgressHandler updateOverallProgress)

------------------------------------------------------------
05/25/08 14:55:44,458 [5556] FATAL SugarCRM - Incorrect syntax near ')'.: SELECT meetings.id , meetings.id , meetings.name , meetings.description , meetings.date_end , meetings.location , meetings.date_start , meetings.duration_hours , meetings.duration_minutes , meetings.reminder_time , meetings.status , meetings.deleted , meetings.assigned_user_id , meetings.created_by FROM meetings where (meetings.id IN ) AND 1=1
05/25/08 14:55:44,458 [5556] FATAL SugarCRM - SQL Server error: Incorrect syntax near ')'.
05/25/08 14:55:46,275 [5556] FATAL SugarCRM - Incorrect syntax near ')'.: SELECT calls.id , calls.id , calls.name , calls.description , calls.date_end , calls.date_start , calls.duration_hours , calls.duration_minutes , calls.reminder_time , calls.status , calls.deleted , calls.assigned_user_id , calls.created_by FROM calls where (calls.id IN ) AND 1=1
05/25/08 14:55:46,276 [5556] FATAL SugarCRM - SQL Server error: Incorrect syntax near ')'.

[franklin_sugar]

I am now getting the following error when trying to sync using Outlander

Hi worgi,

Are you using Sugar's Outlook plug-in? If yes, which version do you have?
Also, can you share your environment with us? Like operating system, web server, database, and php version.

Thanks,
Franklin

[ptemplin7]

I've run into this error as well.

Sugar changed the datetime to Date type.

My solution was to change the type in the DB from Varchar (25) to date.

Sugar needs to be consistent here.

Good luck, PAris

[harkenman]

I've run into this error as well.

Sugar changed the datetime to Date type.

My solution was to change the type in the DB from Varchar (25) to date.

Sugar needs to be consistent here.

Good luck, PAris

Hello.
Which tables did you edit?

Thank you.