Tweet
When creating a target list from the log I get a "Bad server response" error, The log shows the next error:
[2017-02-18 13:56:31] Espo.ERROR: Job CheckInboundEmails 5887967c0145a8a7b: [0] cannot connect to host ; error = fsockopen(): unable to connect to ssl://imappro.zoho.com:993 (Unknown error) (errno = 0 ) [] []
[2017-02-18 16:12:06] Espo.ERROR: API [POST]:/:controller, Params:Array ( [controller] => TargetList ) , InputData: {"sourceCampaignId":"58a3414152d3f9b4d","sourceCam paignName":"Verzenden notulen tweede ALV","includingActionList":["Sent"],"name":"Test","excludingActionList":["Opened"],"description":"","assignedUserName":null,"assigne dUserId":null,"teamsIds":[],"teamsNames":{}} - SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'Espo.campaign_log_record.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [] []
[2017-02-18 16:12:06] Espo.ERROR: Display Error: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'Espo.campaign_log_record.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by, Code: 42000 URL: /crm/api/v1/TargetList [] []
I used the following settings:
Name: not opened
Including: Send
Excluding: Opened
[2017-02-18 13:56:31] Espo.ERROR: Job CheckInboundEmails 5887967c0145a8a7b: [0] cannot connect to host ; error = fsockopen(): unable to connect to ssl://imappro.zoho.com:993 (Unknown error) (errno = 0 ) [] []
[2017-02-18 16:12:06] Espo.ERROR: API [POST]:/:controller, Params:Array ( [controller] => TargetList ) , InputData: {"sourceCampaignId":"58a3414152d3f9b4d","sourceCam paignName":"Verzenden notulen tweede ALV","includingActionList":["Sent"],"name":"Test","excludingActionList":["Opened"],"description":"","assignedUserName":null,"assigne dUserId":null,"teamsIds":[],"teamsNames":{}} - SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'Espo.campaign_log_record.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [] []
[2017-02-18 16:12:06] Espo.ERROR: Display Error: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'Espo.campaign_log_record.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by, Code: 42000 URL: /crm/api/v1/TargetList [] []
I used the following settings:
Name: not opened
Including: Send
Excluding: Opened
Comment