Hi,
I have been testing an integration of CuteChat v2 recently (which on
the whole has gone well) and come up againast a Date format issue.
After reading the archives it is stated that this issue has been
resolved but even using the latest files I still encounter issues.
When connecting to the chatroom I get the following exception:
server side System.Data.SqlClient.SqlException:
System.Data.SqlClient.SqlException: Arithmetic overflow error converting expression to data type datetime.
The statement has been terminated.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at CuteSoft.Chat.CDQ.Providers.SqlClient.SqlClientQueryProvider.AdvancedExecute(String commandText, Object[] args)
at CuteSoft.Chat.CDQ.QueryService.ExecuteDataReader(String commandText, Object[] parameters)
at CuteSoft.Chat.CDQ.QueryService.ExecuteNonQuery(String commandText, Object[] parameters)
at QueryService_InsertDataItem_437353a5.ExecuteCodeInternal()
at CuteSoft.Chat.CDQ.CodeQueryService.ExecuteCode(QueryCommand cmd)
at CuteSoft.Chat.CDQ.QueryCommand.a(QueryMethodImplementCode A_0)
at CuteSoft.Chat.CDQ.QueryCommand.b()
at CuteSoft.Chat.CDQ.QueryCommand.Execute()
at ICuteChatDataAccessImplementation.CuteSoft.Chat.ICuteChatDataAccess.InsertDataItem(IDataItem item)
at aj.b(Chat_Message A_0)
at aj.a(Guid A_0, UserIdentity A_1, Guid A_2)
at e.g()
at e.DoSync(ChannelRequest syncRequest)
at CuteSoft.Chat.ChatApi.CHSync(ChannelRequest request)
at CuteSoft.Chat.DynamicAssembly.ServiceLayerChatApiDecoratorProxy.CHSync_InterceptedCall(ChannelRequest request)
at CuteSoft.Chat.DynamicAssembly.WebLayerChatApiDecoratorProxy.CHSync_InterceptedCall(ChannelRequest request)
at CuteSoft.Chat.ChatRaneService.CHSync(ChannelRequest request)
This occurs when the Database has British English Date culture set - if
I set the culture to us-english then the problem disappears.
Unfortunately I cannot do this on the live server so I am wondering if
this can be fixed - or perhaps I have downloaded the wrong files... I
am using the latest standalone version at the moment as I have
integrated the login entry system with our own setup, which
coincidentally worked well.
Kind regards
Richard Stockley