Not Able To Send Mail

[sachin]

I am added my account(gmail) as create account.Account was added successfully.But when I send mail to specific user it's give me following error

[Maxim]

Hello Sachin!
Send us (support@onlyoffice.com with link to that topic in subject or body) please logs if you have docker version on /app/onlyoffice/CommunityServer/logs/ or /var/log/onlyoffice/ in Linux version.

[sachin]

I am using Windows 8.1,My SQL 5.7.14,Microsoft Windows Server 2012,Microsoft .NET Framework 4.5,IIS 8,Visual Studio 2012
I also attached Log File Here .Please Find Attachment.

Code: Select all

2016-12-23 12:19:32,465 ERROR [9] ASC.Web - Page is not avaliable by url http://localhost/tariffs.aspx?warmup=true
System.Net.WebException: The operation has timed out
   at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
   at System.Net.WebClient.DownloadData(Uri address)
   at System.Net.WebClient.DownloadData(String address)
   at ASC.Web.Studio.Core.WarmUp.MakeRequest(String requestUrl) in d:\ZITIMA\sachin\Projects\OnlyOffice\CommunityServer-master\web\studio\ASC.Web.Studio\Core\WarmUp.cs:line 322
2016-12-23 12:19:32,731 ERROR [5] ASC.Web - Page is not avaliable by url http://localhost/wizard.aspx?warmup=true
System.Net.WebException: The operation has timed out
   at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
   at System.Net.WebClient.DownloadData(Uri address)
   at System.Net.WebClient.DownloadData(String address)
   at ASC.Web.Studio.Core.WarmUp.MakeRequest(String requestUrl) in d:\ZITIMA\sachin\Projects\OnlyOffice\CommunityServer-master\web\studio\ASC.Web.Studio\Core\WarmUp.cs:line 322
2016-12-23 12:19:32,903 ERROR [15] ASC.Web - Page is not avaliable by url http://localhost/products/crm/tasks.aspx?warmup=true
System.Net.WebException: The operation has timed out
   at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
   at System.Net.WebClient.DownloadData(Uri address)
   at System.Net.WebClient.DownloadData(String address)
   at ASC.Web.Studio.Core.WarmUp.MakeRequest(String requestUrl) in d:\ZITIMA\sachin\Projects\OnlyOffice\CommunityServer-master\web\studio\ASC.Web.Studio\Core\WarmUp.cs:line 322
2016-12-23 12:19:32,623 ERROR [16] ASC.Web - Page is not avaliable by url http://localhost/products/projects/projecttemplates.aspx?warmup=true
System.Net.WebException: The operation has timed out
   at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
   at System.Net.WebClient.DownloadData(Uri address)
   at System.Net.WebClient.DownloadData(String address)
   at ASC.Web.Studio.Core.WarmUp.MakeRequest(String requestUrl) in d:\ZITIMA\sachin\Projects\OnlyOffice\CommunityServer-master\web\studio\ASC.Web.Studio\Core\WarmUp.cs:line 322
2016-12-23 12:21:21,625 ERROR [9] ASC.Web - Page is not avaliable by url http://localhost/products/files/default.aspx?warmup=true
System.Net.WebException: The operation has timed out
   at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
   at System.Net.WebClient.DownloadData(Uri address)
   at System.Net.WebClient.DownloadData(String address)
   at ASC.Web.Studio.Core.WarmUp.MakeRequest(String requestUrl) in d:\ZITIMA\sachin\Projects\OnlyOffice\CommunityServer-master\web\studio\ASC.Web.Studio\Core\WarmUp.cs:line 322
2016-12-23 12:21:21,786 ERROR [15] ASC.Web - Page is not avaliable by url http://localhost/products/projects/contacts.aspx?warmup=true
System.Net.WebException: The operation has timed out
   at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
   at System.Net.WebClient.DownloadData(Uri address)
   at System.Net.WebClient.DownloadData(String address)
   at ASC.Web.Studio.Core.WarmUp.MakeRequest(String requestUrl) in d:\ZITIMA\sachin\Projects\OnlyOffice\CommunityServer-master\web\studio\ASC.Web.Studio\Core\WarmUp.cs:line 322
2016-12-23 12:21:21,625 ERROR [16] ASC.Web - Page is not avaliable by url http://localhost/products/projects/reports.aspx?warmup=true
System.Net.WebException: The operation has timed out
   at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
   at System.Net.WebClient.DownloadData(Uri address)
   at System.Net.WebClient.DownloadData(String address)
   at ASC.Web.Studio.Core.WarmUp.MakeRequest(String requestUrl) in d:\ZITIMA\sachin\Projects\OnlyOffice\CommunityServer-master\web\studio\ASC.Web.Studio\Core\WarmUp.cs:line 322
2016-12-23 12:21:22,101 ERROR [5] ASC.Web - Page is not avaliable by url http://localhost/auth.aspx?warmup=true
System.Net.WebException: The operation has timed out
   at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
   at System.Net.WebClient.DownloadData(Uri address)
   at System.Net.WebClient.DownloadData(String address)
   at ASC.Web.Studio.Core.WarmUp.MakeRequest(String requestUrl) in d:\ZITIMA\sachin\Projects\OnlyOffice\CommunityServer-master\web\studio\ASC.Web.Studio\Core\WarmUp.cs:line 322
2016-12-23 12:23:05,983 ERROR [9] ASC.Web - Page is not avaliable by url http://localhost/products/crm/cases.aspx?warmup=true
System.Net.WebException: The operation has timed out
   at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
   at System.Net.WebClient.DownloadData(Uri address)
   at System.Net.WebClient.DownloadData(String address)
   at ASC.Web.Studio.Core.WarmUp.MakeRequest(String requestUrl) in d:\ZITIMA\sachin\Projects\OnlyOffice\CommunityServer-master\web\studio\ASC.Web.Studio\Core\WarmUp.cs:line 322
2016-12-23 12:23:06,315 ERROR [15] ASC.Web - Page is not avaliable by url http://localhost/products/projects/default.aspx?warmup=true
System.Net.WebException: The operation has timed out
   at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
   at System.Net.WebClient.DownloadData(Uri address)
   at System.Net.WebClient.DownloadData(String address)
   at ASC.Web.Studio.Core.WarmUp.MakeRequest(String requestUrl) in d:\ZITIMA\sachin\Projects\OnlyOffice\CommunityServer-master\web\studio\ASC.Web.Studio\Core\WarmUp.cs:line 322
2016-12-23 12:23:06,428 ERROR [16] ASC.Web - Page is not avaliable by url http://localhost/products/projects/tasks.aspx?warmup=true
System.Net.WebException: The operation has timed out
   at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
   at System.Net.WebClient.DownloadData(Uri address)
   at System.Net.WebClient.DownloadData(String address)
   at ASC.Web.Studio.Core.WarmUp.MakeRequest(String requestUrl) in d:\ZITIMA\sachin\Projects\OnlyOffice\CommunityServer-master\web\studio\ASC.Web.Studio\Core\WarmUp.cs:line 322



[Maxim]

Hello!
Please send us web.api.log

[sachin]

Hello,
Maxim
Here I Attached Web.api.log File Code.Please Find It.

Code: Select all

2016-11-07 11:34:49,732 ERROR [16] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=642542 - Server error
System.Exception: Unknown mail provider settings.
   at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-11-07 11:37:44,533 ERROR [17] ASC.Api - method error: http://localhost/api/2.0/mail/accounts.json?__=369845 - Server error
System.Exception: <span class="attempt_header">POP3 response:</span><br/>Authentication failed.
<span class="attempt_header">SMTP response:</span><br/>Authentication failed.
   at ASC.Api.Mail.MailApi.CreateAccount(String name, String email, String account, String password, Int32 port, String server, String smtp_account, String smtp_password, Int32 smtp_port, String smtp_server, Boolean smtp_auth, Boolean imap, Boolean restrict, EncryptionType incoming_encryption_type, EncryptionType outcoming_encryption_type, SaslMechanism auth_type_in, SaslMechanism auth_type_smtp)
2016-11-07 11:42:00,671 ERROR [18] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=79418 - Server error
System.Exception: Unknown mail provider settings.
   at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-11-07 11:48:53,861 ERROR [17] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=958826 - Server error
System.Exception: Unknown mail provider settings.
   at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-11-07 11:51:39,134 ERROR [16] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=411568 - Server error
System.Exception: #1:<br><span class="attempt_header">IMAP response:</span><br/>Invalid credentials (Failure)<br><span class="attempt_header">SMTP response:</span><br/>Authentication failed.<br>#2:<br><span class="attempt_header">POP3 response:</span><br/>Authentication failed.<br><span class="attempt_header">SMTP response:</span><br/>Authentication failed.<br>
   at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-11-07 11:54:04,787 ERROR [5] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=295605 - Server error
System.Exception: #1:<br><span class="attempt_header">IMAP response:</span><br/>Invalid credentials (Failure)<br><span class="attempt_header">SMTP response:</span><br/>Authentication failed.<br>#2:<br><span class="attempt_header">POP3 response:</span><br/>Authentication failed.<br><span class="attempt_header">SMTP response:</span><br/>Authentication failed.<br>
   at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-11-07 11:59:58,841 ERROR [5] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=653506 - Server error
System.Exception: #1:<br><span class="attempt_header">IMAP response:</span><br/>Invalid credentials (Failure)<br><span class="attempt_header">SMTP response:</span><br/>Authentication failed.<br>#2:<br><span class="attempt_header">POP3 response:</span><br/>Authentication failed.<br><span class="attempt_header">SMTP response:</span><br/>Authentication failed.<br>
   at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-11-07 12:38:14,886 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/people.json?__=108768 - Server error
System.Exception: Member with this email is already registered
   at ASC.Web.Studio.Core.Users.UserManagerWrapper.AddUser(UserInfo userInfo, String password, Boolean afterInvite, Boolean notify, Boolean isVisitor, Boolean fromInviteLink, Boolean makeUniqueName)
   at ASC.Api.Employee.EmployeeApi.AddMember(Boolean isVisitor, String email, String firstname, String lastname, Guid[] department, String title, String location, String sex, ApiDateTime birthday, ApiDateTime worksfrom, String comment, IEnumerable`1 contacts, String files)
2016-11-08 15:20:49,658 ERROR [17] ASC.Api - method error: http://localhost/api/2.0/project/1/task.json?__=167349 - Server error
MySql.Data.MySqlClient.MySqlException (0x80004005): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.core_subscriptionmethod.tenant' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at ASC.Common.Data.DataExtensions.ExecuteListReader(IDbCommand command)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, String sql, Object[] parameters)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, ISqlInstruction sql, ISqlDialect dialect)
   at ASC.Common.Data.DbManager.ExecuteList(ISqlInstruction sql)
   at ASC.Core.Data.DbBaseService.ExecList(ISqlInstruction sql)
   at ASC.Core.Data.DbSubscriptionService.GetSubscriptionMethods(Int32 tenant, String sourceId, String actionId, String recipientId)
   at ASC.Core.Caching.CachedSubscriptionService.GetSubsciptionsStore(Int32 tenant, String sourceId, String actionId)
   at ASC.Core.Caching.CachedSubscriptionService.GetSubscription(Int32 tenant, String sourceId, String actionId, String recipientId, String objectId)
   at ASC.Core.SubscriptionManager.IsUnsubscribe(String sourceID, String recipientID, String actionID, String objectID)
   at ASC.Core.Notify.DirectSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
   at ASC.Notify.Model.TopSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
   at ASC.Projects.Engine.ProjectEntityEngine.IsUnsubscribed(ProjectEntity entity, Guid recipientID)
   at ASC.Projects.Engine.ProjectEntityEngine.Subscribe(ProjectEntity entity, Guid recipientID)
   at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible, Boolean isImport)
   at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible)
   at ASC.Api.Projects.ProjectApi.AddProjectTask(Int32 projectid, String description, ApiDateTime deadline, TaskPriority priority, String title, Int32 milestoneid, IEnumerable`1 responsibles, Boolean notify, ApiDateTime startDate)
2016-11-08 15:20:56,340 ERROR [21] ASC.Api - method error: http://localhost/api/2.0/project/1/task.json?__=144593 - Server error
MySql.Data.MySqlClient.MySqlException (0x80004005): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.core_subscriptionmethod.tenant' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at ASC.Common.Data.DataExtensions.ExecuteListReader(IDbCommand command)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, String sql, Object[] parameters)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, ISqlInstruction sql, ISqlDialect dialect)
   at ASC.Common.Data.DbManager.ExecuteList(ISqlInstruction sql)
   at ASC.Core.Data.DbBaseService.ExecList(ISqlInstruction sql)
   at ASC.Core.Data.DbSubscriptionService.GetSubscriptionMethods(Int32 tenant, String sourceId, String actionId, String recipientId)
   at ASC.Core.Caching.CachedSubscriptionService.GetSubsciptionsStore(Int32 tenant, String sourceId, String actionId)
   at ASC.Core.Caching.CachedSubscriptionService.GetSubscription(Int32 tenant, String sourceId, String actionId, String recipientId, String objectId)
   at ASC.Core.SubscriptionManager.IsUnsubscribe(String sourceID, String recipientID, String actionID, String objectID)
   at ASC.Core.Notify.DirectSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
   at ASC.Notify.Model.TopSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
   at ASC.Projects.Engine.ProjectEntityEngine.IsUnsubscribed(ProjectEntity entity, Guid recipientID)
   at ASC.Projects.Engine.ProjectEntityEngine.Subscribe(ProjectEntity entity, Guid recipientID)
   at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible, Boolean isImport)
   at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible)
   at ASC.Api.Projects.ProjectApi.AddProjectTask(Int32 projectid, String description, ApiDateTime deadline, TaskPriority priority, String title, Int32 milestoneid, IEnumerable`1 responsibles, Boolean notify, ApiDateTime startDate)
2016-11-08 15:21:01,478 ERROR [21] ASC.Api - method error: http://localhost/api/2.0/project/1/task.json?__=143658 - Server error
MySql.Data.MySqlClient.MySqlException (0x80004005): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.core_subscriptionmethod.tenant' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at ASC.Common.Data.DataExtensions.ExecuteListReader(IDbCommand command)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, String sql, Object[] parameters)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, ISqlInstruction sql, ISqlDialect dialect)
   at ASC.Common.Data.DbManager.ExecuteList(ISqlInstruction sql)
   at ASC.Core.Data.DbBaseService.ExecList(ISqlInstruction sql)
   at ASC.Core.Data.DbSubscriptionService.GetSubscriptionMethods(Int32 tenant, String sourceId, String actionId, String recipientId)
   at ASC.Core.Caching.CachedSubscriptionService.GetSubsciptionsStore(Int32 tenant, String sourceId, String actionId)
   at ASC.Core.Caching.CachedSubscriptionService.GetSubscription(Int32 tenant, String sourceId, String actionId, String recipientId, String objectId)
   at ASC.Core.SubscriptionManager.IsUnsubscribe(String sourceID, String recipientID, String actionID, String objectID)
   at ASC.Core.Notify.DirectSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
   at ASC.Notify.Model.TopSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
   at ASC.Projects.Engine.ProjectEntityEngine.IsUnsubscribed(ProjectEntity entity, Guid recipientID)
   at ASC.Projects.Engine.ProjectEntityEngine.Subscribe(ProjectEntity entity, Guid recipientID)
   at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible, Boolean isImport)
   at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible)
   at ASC.Api.Projects.ProjectApi.AddProjectTask(Int32 projectid, String description, ApiDateTime deadline, TaskPriority priority, String title, Int32 milestoneid, IEnumerable`1 responsibles, Boolean notify, ApiDateTime startDate)
2016-11-08 15:21:05,926 ERROR [5] ASC.Api - method error: http://localhost/api/2.0/project/1/task.json?__=623934 - Server error
MySql.Data.MySqlClient.MySqlException (0x80004005): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.core_subscriptionmethod.tenant' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at ASC.Common.Data.DataExtensions.ExecuteListReader(IDbCommand command)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, String sql, Object[] parameters)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, ISqlInstruction sql, ISqlDialect dialect)
   at ASC.Common.Data.DbManager.ExecuteList(ISqlInstruction sql)
   at ASC.Core.Data.DbBaseService.ExecList(ISqlInstruction sql)
   at ASC.Core.Data.DbSubscriptionService.GetSubscriptionMethods(Int32 tenant, String sourceId, String actionId, String recipientId)
   at ASC.Core.Caching.CachedSubscriptionService.GetSubsciptionsStore(Int32 tenant, String sourceId, String actionId)
   at ASC.Core.Caching.CachedSubscriptionService.GetSubscription(Int32 tenant, String sourceId, String actionId, String recipientId, String objectId)
   at ASC.Core.SubscriptionManager.IsUnsubscribe(String sourceID, String recipientID, String actionID, String objectID)
   at ASC.Core.Notify.DirectSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
   at ASC.Notify.Model.TopSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
   at ASC.Projects.Engine.ProjectEntityEngine.IsUnsubscribed(ProjectEntity entity, Guid recipientID)
   at ASC.Projects.Engine.ProjectEntityEngine.Subscribe(ProjectEntity entity, Guid recipientID)
   at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible, Boolean isImport)
   at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible)
   at ASC.Api.Projects.ProjectApi.AddProjectTask(Int32 projectid, String description, ApiDateTime deadline, TaskPriority priority, String title, Int32 milestoneid, IEnumerable`1 responsibles, Boolean notify, ApiDateTime startDate)
2016-11-08 15:21:10,390 ERROR [10] ASC.Api - method error: http://localhost/api/2.0/project/1/task.json?__=941972 - Server error
MySql.Data.MySqlClient.MySqlException (0x80004005): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.core_subscriptionmethod.tenant' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at ASC.Common.Data.DataExtensions.ExecuteListReader(IDbCommand command)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, String sql, Object[] parameters)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, ISqlInstruction sql, ISqlDialect dialect)
   at ASC.Common.Data.DbManager.ExecuteList(ISqlInstruction sql)
   at ASC.Core.Data.DbBaseService.ExecList(ISqlInstruction sql)
   at ASC.Core.Data.DbSubscriptionService.GetSubscriptionMethods(Int32 tenant, String sourceId, String actionId, String recipientId)
   at ASC.Core.Caching.CachedSubscriptionService.GetSubsciptionsStore(Int32 tenant, String sourceId, String actionId)
   at ASC.Core.Caching.CachedSubscriptionService.GetSubscription(Int32 tenant, String sourceId, String actionId, String recipientId, String objectId)
   at ASC.Core.SubscriptionManager.IsUnsubscribe(String sourceID, String recipientID, String actionID, String objectID)
   at ASC.Core.Notify.DirectSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
   at ASC.Notify.Model.TopSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
   at ASC.Projects.Engine.ProjectEntityEngine.IsUnsubscribed(ProjectEntity entity, Guid recipientID)
   at ASC.Projects.Engine.ProjectEntityEngine.Subscribe(ProjectEntity entity, Guid recipientID)
   at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible, Boolean isImport)
   at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible)
   at ASC.Api.Projects.ProjectApi.AddProjectTask(Int32 projectid, String description, ApiDateTime deadline, TaskPriority priority, String title, Int32 milestoneid, IEnumerable`1 responsibles, Boolean notify, ApiDateTime startDate)
2016-11-08 15:21:15,956 ERROR [8] ASC.Api - method error: http://localhost/api/2.0/project/1/task.json?__=275735 - Server error
MySql.Data.MySqlClient.MySqlException (0x80004005): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.core_subscriptionmethod.tenant' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at ASC.Common.Data.DataExtensions.ExecuteListReader(IDbCommand command)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, String sql, Object[] parameters)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, ISqlInstruction sql, ISqlDialect dialect)
   at ASC.Common.Data.DbManager.ExecuteList(ISqlInstruction sql)
   at ASC.Core.Data.DbBaseService.ExecList(ISqlInstruction sql)
   at ASC.Core.Data.DbSubscriptionService.GetSubscriptionMethods(Int32 tenant, String sourceId, String actionId, String recipientId)
   at ASC.Core.Caching.CachedSubscriptionService.GetSubsciptionsStore(Int32 tenant, String sourceId, String actionId)
   at ASC.Core.Caching.CachedSubscriptionService.GetSubscription(Int32 tenant, String sourceId, String actionId, String recipientId, String objectId)
   at ASC.Core.SubscriptionManager.IsUnsubscribe(String sourceID, String recipientID, String actionID, String objectID)
   at ASC.Core.Notify.DirectSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
   at ASC.Notify.Model.TopSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
   at ASC.Projects.Engine.ProjectEntityEngine.IsUnsubscribed(ProjectEntity entity, Guid recipientID)
   at ASC.Projects.Engine.ProjectEntityEngine.Subscribe(ProjectEntity entity, Guid recipientID)
   at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible, Boolean isImport)
   at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible)
   at ASC.Api.Projects.ProjectApi.AddProjectTask(Int32 projectid, String description, ApiDateTime deadline, TaskPriority priority, String title, Int32 milestoneid, IEnumerable`1 responsibles, Boolean notify, ApiDateTime startDate)
2016-11-08 15:21:19,986 ERROR [17] ASC.Api - method error: http://localhost/api/2.0/project/1/task.json?__=116578 - Server error
MySql.Data.MySqlClient.MySqlException (0x80004005): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.core_subscriptionmethod.tenant' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at ASC.Common.Data.DataExtensions.ExecuteListReader(IDbCommand command)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, String sql, Object[] parameters)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, ISqlInstruction sql, ISqlDialect dialect)
   at ASC.Common.Data.DbManager.ExecuteList(ISqlInstruction sql)
   at ASC.Core.Data.DbBaseService.ExecList(ISqlInstruction sql)
   at ASC.Core.Data.DbSubscriptionService.GetSubscriptionMethods(Int32 tenant, String sourceId, String actionId, String recipientId)
   at ASC.Core.Caching.CachedSubscriptionService.GetSubsciptionsStore(Int32 tenant, String sourceId, String actionId)
   at ASC.Core.Caching.CachedSubscriptionService.GetSubscription(Int32 tenant, String sourceId, String actionId, String recipientId, String objectId)
   at ASC.Core.SubscriptionManager.IsUnsubscribe(String sourceID, String recipientID, String actionID, String objectID)
   at ASC.Core.Notify.DirectSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
   at ASC.Notify.Model.TopSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
   at ASC.Projects.Engine.ProjectEntityEngine.IsUnsubscribed(ProjectEntity entity, Guid recipientID)
   at ASC.Projects.Engine.ProjectEntityEngine.Subscribe(ProjectEntity entity, Guid recipientID)
   at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible, Boolean isImport)
   at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible)
   at ASC.Api.Projects.ProjectApi.AddProjectTask(Int32 projectid, String description, ApiDateTime deadline, TaskPriority priority, String title, Int32 milestoneid, IEnumerable`1 responsibles, Boolean notify, ApiDateTime startDate)
2016-11-08 15:21:24,343 ERROR [8] ASC.Api - method error: http://localhost/api/2.0/project/1/task.json?__=423388 - Server error
MySql.Data.MySqlClient.MySqlException (0x80004005): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.core_subscriptionmethod.tenant' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at ASC.Common.Data.DataExtensions.ExecuteListReader(IDbCommand command)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, String sql, Object[] parameters)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, ISqlInstruction sql, ISqlDialect dialect)
   at ASC.Common.Data.DbManager.ExecuteList(ISqlInstruction sql)
   at ASC.Core.Data.DbBaseService.ExecList(ISqlInstruction sql)
   at ASC.Core.Data.DbSubscriptionService.GetSubscriptionMethods(Int32 tenant, String sourceId, String actionId, String recipientId)
   at ASC.Core.Caching.CachedSubscriptionService.GetSubsciptionsStore(Int32 tenant, String sourceId, String actionId)
   at ASC.Core.Caching.CachedSubscriptionService.GetSubscription(Int32 tenant, String sourceId, String actionId, String recipientId, String objectId)
   at ASC.Core.SubscriptionManager.IsUnsubscribe(String sourceID, String recipientID, String actionID, String objectID)
   at ASC.Core.Notify.DirectSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
   at ASC.Notify.Model.TopSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
   at ASC.Projects.Engine.ProjectEntityEngine.IsUnsubscribed(ProjectEntity entity, Guid recipientID)
   at ASC.Projects.Engine.ProjectEntityEngine.Subscribe(ProjectEntity entity, Guid recipientID)
   at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible, Boolean isImport)
   at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible)
   at ASC.Api.Projects.ProjectApi.AddProjectTask(Int32 projectid, String description, ApiDateTime deadline, TaskPriority priority, String title, Int32 milestoneid, IEnumerable`1 responsibles, Boolean notify, ApiDateTime startDate)
2016-11-08 15:21:28,524 ERROR [25] ASC.Api - method error: http://localhost/api/2.0/project/1/task.json?__=981794 - Server error
MySql.Data.MySqlClient.MySqlException (0x80004005): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.core_subscriptionmethod.tenant' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at ASC.Common.Data.DataExtensions.ExecuteListReader(IDbCommand command)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, String sql, Object[] parameters)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, ISqlInstruction sql, ISqlDialect dialect)
   at ASC.Common.Data.DbManager.ExecuteList(ISqlInstruction sql)
   at ASC.Core.Data.DbBaseService.ExecList(ISqlInstruction sql)
   at ASC.Core.Data.DbSubscriptionService.GetSubscriptionMethods(Int32 tenant, String sourceId, String actionId, String recipientId)
   at ASC.Core.Caching.CachedSubscriptionService.GetSubsciptionsStore(Int32 tenant, String sourceId, String actionId)
   at ASC.Core.Caching.CachedSubscriptionService.GetSubscription(Int32 tenant, String sourceId, String actionId, String recipientId, String objectId)
   at ASC.Core.SubscriptionManager.IsUnsubscribe(String sourceID, String recipientID, String actionID, String objectID)
   at ASC.Core.Notify.DirectSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
   at ASC.Notify.Model.TopSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
   at ASC.Projects.Engine.ProjectEntityEngine.IsUnsubscribed(ProjectEntity entity, Guid recipientID)
   at ASC.Projects.Engine.ProjectEntityEngine.Subscribe(ProjectEntity entity, Guid recipientID)
   at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible, Boolean isImport)
   at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible)
   at ASC.Api.Projects.ProjectApi.AddProjectTask(Int32 projectid, String description, ApiDateTime deadline, TaskPriority priority, String title, Int32 milestoneid, IEnumerable`1 responsibles, Boolean notify, ApiDateTime startDate)
2016-11-08 15:21:32,514 ERROR [8] ASC.Api - method error: http://localhost/api/2.0/project/1/task.json?__=831564 - Server error
MySql.Data.MySqlClient.MySqlException (0x80004005): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.core_subscriptionmethod.tenant' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at ASC.Common.Data.DataExtensions.ExecuteListReader(IDbCommand command)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, String sql, Object[] parameters)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, ISqlInstruction sql, ISqlDialect dialect)
   at ASC.Common.Data.DbManager.ExecuteList(ISqlInstruction sql)
   at ASC.Core.Data.DbBaseService.ExecList(ISqlInstruction sql)
   at ASC.Core.Data.DbSubscriptionService.GetSubscriptionMethods(Int32 tenant, String sourceId, String actionId, String recipientId)
   at ASC.Core.Caching.CachedSubscriptionService.GetSubsciptionsStore(Int32 tenant, String sourceId, String actionId)
   at ASC.Core.Caching.CachedSubscriptionService.GetSubscription(Int32 tenant, String sourceId, String actionId, String recipientId, String objectId)
   at ASC.Core.SubscriptionManager.IsUnsubscribe(String sourceID, String recipientID, String actionID, String objectID)
   at ASC.Core.Notify.DirectSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
   at ASC.Notify.Model.TopSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
   at ASC.Projects.Engine.ProjectEntityEngine.IsUnsubscribed(ProjectEntity entity, Guid recipientID)
   at ASC.Projects.Engine.ProjectEntityEngine.Subscribe(ProjectEntity entity, Guid recipientID)
   at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible, Boolean isImport)
   at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible)
   at ASC.Api.Projects.ProjectApi.AddProjectTask(Int32 projectid, String description, ApiDateTime deadline, TaskPriority priority, String title, Int32 milestoneid, IEnumerable`1 responsibles, Boolean notify, ApiDateTime startDate)
2016-11-09 15:01:04,195 WARN  [5] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:04,281 ERROR [5] ASC.Api - method error: http://localhost/api/2.0/crm/invoice/filter.json?startIndex=0&count=25&sortBy=number&sortOrder=descending&__=426970 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-09 15:01:06,116 WARN  [9] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:06,116 ERROR [9] ASC.Api - method error: http://localhost/api/2.0/crm/invoice/filter.json?startIndex=0&count=25&sortBy=number&sortOrder=descending&__=426970&__=426970 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-09 15:01:06,158 WARN  [9] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:06,158 ERROR [9] ASC.Api - method error: http://localhost/api/2.0/crm/invoice/filter.json?startIndex=0&count=25&sortBy=number&sortOrder=descending&__=426970&__=426970&__=426970 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-09 15:01:38,196 WARN  [19] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:38,196 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/crm/invoice/filter.json?startIndex=0&count=25&sortBy=number&sortOrder=descending&__=779628 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-09 15:01:38,317 WARN  [19] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:38,317 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/crm/invoice/filter.json?startIndex=0&count=25&sortBy=number&sortOrder=descending&__=779628&__=779628 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-09 15:01:38,353 WARN  [19] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:38,353 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/crm/invoice/filter.json?startIndex=0&count=25&sortBy=number&sortOrder=descending&__=779628&__=779628&__=779628 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-09 15:01:44,893 WARN  [19] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:44,893 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/crm/case/filter.json?startIndex=0&count=25&sortBy=title&sortOrder=ascending&__=860260 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-09 15:01:44,981 WARN  [19] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:44,981 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/crm/case/filter.json?startIndex=0&count=25&sortBy=title&sortOrder=ascending&__=860260&__=860260 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-09 15:01:45,045 WARN  [19] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:45,045 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/crm/case/filter.json?startIndex=0&count=25&sortBy=title&sortOrder=ascending&__=860260&__=860260&__=860260 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-09 15:01:52,411 WARN  [19] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:52,411 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/crm/invoice/filter.json?startIndex=0&count=25&sortBy=number&sortOrder=descending&__=442471 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-09 15:01:52,515 WARN  [19] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:52,515 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/crm/invoice/filter.json?startIndex=0&count=25&sortBy=number&sortOrder=descending&__=442471&__=442471 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-09 15:01:52,731 WARN  [19] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:52,732 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/crm/invoice/filter.json?startIndex=0&count=25&sortBy=number&sortOrder=descending&__=442471&__=442471&__=442471 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-11 11:44:08,667 ERROR [17] ASC.Api - method error: http://localhost/api/2.0/files/4.json?__=810978 - Server error
System.InvalidOperationException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.d.folder_type' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by ---> MySql.Data.MySqlClient.MySqlException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.d.folder_type' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at ASC.Common.Data.DataExtensions.ExecuteListReader(IDbCommand command)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, String sql, Object[] parameters)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command)
   at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, ISqlInstruction sql, ISqlDialect dialect)
   at ASC.Common.Data.DbManager.ExecuteList(ISqlInstruction sql)
   at ASC.Files.Core.Data.FolderDao.GetFolder(Object folderId)
   at ASC.Files.Thirdparty.ProviderDao.ProviderFolderDao.GetFolder(Object folderId)
   at ASC.Web.Files.Services.WCFService.FileStorageServiceController.GetFolderItems(String parentId, Int32 from, Int32 count, FilterType filter, OrderBy orderBy, String ssubject, String searchText)
   --- End of inner exception stack trace ---
   at ASC.Web.Files.Services.WCFService.FileStorageServiceController.GetFolderItems(String parentId, Int32 from, Int32 count, FilterType filter, OrderBy orderBy, String ssubject, String searchText)
   at ASC.Api.Documents.DocumentsApi.ToFolderContentWrapper(Object folderId, Guid userIdOrGroupId, FilterType filterType)
   at ASC.Api.Documents.DocumentsApi.GetFolder(String folderId, Guid userIdOrGroupId, FilterType filterType)
2016-11-11 11:48:31,601 ERROR [10] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=85873 - Server error
System.Exception: Unknown mail provider settings.
   at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-11-11 12:52:36,637 ERROR [10] ASC.Api - method error: http://localhost/api/2.0/people.json?__=68209 - Server error
System.Exception: Member with this email is already registered
   at ASC.Web.Studio.Core.Users.UserManagerWrapper.AddUser(UserInfo userInfo, String password, Boolean afterInvite, Boolean notify, Boolean isVisitor, Boolean fromInviteLink, Boolean makeUniqueName)
   at ASC.Api.Employee.EmployeeApi.AddMember(Boolean isVisitor, String email, String firstname, String lastname, Guid[] department, String title, String location, String sex, ApiDateTime birthday, ApiDateTime worksfrom, String comment, IEnumerable`1 contacts, String files)
2016-12-22 10:59:11,584 ERROR [14] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=601779 - Server error
System.Exception: Unknown mail provider settings.
   at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-12-22 11:00:42,751 ERROR [14] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=820329 - Server error
System.Exception: Unknown mail provider settings.
   at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-12-22 11:00:54,619 ERROR [14] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=521085 - Server error
System.Exception: Unknown mail provider settings.
   at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-12-22 11:00:57,356 ERROR [26] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=257108 - Server error
System.Exception: Unknown mail provider settings.
   at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-12-22 11:00:59,585 ERROR [26] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=772516 - Server error
System.Exception: Unknown mail provider settings.
   at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-12-22 11:01:01,636 ERROR [26] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=598017 - Server error
System.Exception: Unknown mail provider settings.
   at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-12-22 11:03:00,839 ERROR [29] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=924703 - Server error
System.Exception: Unknown mail provider settings.
   at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-12-22 11:06:16,289 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=45959 - Server error
System.Exception: Unknown mail provider settings.
   at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-12-22 12:01:41,747 ERROR [26] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=862518 - Server error
System.Exception: Unknown mail provider settings.
   at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-12-22 12:46:57,941 ERROR [9] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=391272 - Server error
System.Exception: Unknown mail provider settings.
   at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-12-22 13:02:36,935 ERROR [20] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=331058 - Server error
System.Exception: Unknown mail provider settings.
   at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-12-22 13:06:21,356 ERROR [5] ASC.Api - method error: http://localhost/api/2.0/mail/accounts.json?__=711716 - Server error
System.Exception: <span class="attempt_header">SMTP response:</span><br/>Authentication failed.
   at ASC.Api.Mail.MailApi.CreateAccount(String name, String email, String account, String password, Int32 port, String server, String smtp_account, String smtp_password, Int32 smtp_port, String smtp_server, Boolean smtp_auth, Boolean imap, Boolean restrict, EncryptionType incoming_encryption_type, EncryptionType outcoming_encryption_type, SaslMechanism auth_type_in, SaslMechanism auth_type_smtp)
2016-12-22 13:25:51,285 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/mail/folders.json?__=71764 - Server error
System.TimeoutException: Timeout in IO operation
   at MySql.Data.MySqlClient.TimedStream.StopTimer()
   at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.ReadOk(Boolean read)
   at MySql.Data.MySqlClient.MySqlConnection.ChangeDatabase(String databaseName)
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at ASC.Common.Data.DbManager.OpenConnection()
   at ASC.Common.Data.DbManager.get_Command()
   at ASC.Common.Data.DbManager.ExecuteNonQuery(ISqlInstruction sql)
   at ASC.Mail.Aggregator.MailBoxManager.UpdateUserActivity(Int32 tenant, String user, Boolean userOnline)
   at ASC.Api.Mail.MailApi.GetFolders()
2016-12-22 14:53:55,075 WARN  [51] ASC.Api - Product mail denied for user Administrator
2016-12-22 14:53:55,137 ERROR [51] ASC.Api - method error: http://localhost/api/2.0/mail/folders.json?__=292335 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-12-22 15:37:51,899 WARN  [49] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:37:52,946 WARN  [5] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:38:10,349 WARN  [43] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:38:48,346 WARN  [43] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:39:11,600 WARN  [42] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:39:38,092 WARN  [51] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:40:08,718 WARN  [46] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:40:38,259 WARN  [45] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:41:08,007 WARN  [41] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:41:37,913 WARN  [15] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:42:07,805 WARN  [42] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:42:37,865 WARN  [19] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:43:07,783 WARN  [44] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:43:38,503 WARN  [5] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:44:07,686 WARN  [15] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:44:08,108 WARN  [41] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:44:08,265 WARN  [19] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:44:42,970 WARN  [5] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:45:08,626 WARN  [15] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:45:40,549 WARN  [5] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:46:07,964 WARN  [39] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:46:38,090 WARN  [51] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:47:07,958 WARN  [45] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x


[Maxim]

Hello!
1 There are no settings for mail provider
2 "2016-12-22 13:25:51,285 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/mail/folders.json?__=71764 - Server error
System.TimeoutException: Timeout in IO operation" Problems with Database.
3 What are you trying to do? It's very interesting for me ))))))

[sachin]

Hello,
Maxim
1) All Other Functionality Like Add Project,Add People,Calendar Are Working Fine.So I Think My Database Working Properly ..
2) I All Ready Set Smtp Setting For Mail Services And I also Test It (Using Send Test Mail). It's Working Fine ...
Please Can You Tall Me What is Problem With Mail Services?

[Maxim]

Hello!
I saw your post.....do you still have problems with mail server?

[sachin]

Thaks,For Replay Maxim
Yes,I Have Still Problem With Mail Server.I Checked Console In Browser When I Was Click On Send Button In Mailbox .Here I attached Screenshot Please Find It.