Answers.Body: <p>I resolved this by going to Adminstrater > System Settings > Clean up cache and update paths. Click the Clean up cache button. </p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-21T15:42:58.063Z
Answers.Text: Thanks for your reply. 
  Unfortunately it seemed not to have worked for me.
Answers.UserDisplayName: user2445
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-21T16:01:02.060Z
Answers.Text: If your group is a smart group, make sure your rebuild smart group cache scheduled job is enabled. Also make sure your Clean up temporary data and files scheduled job is enabled and maybe manually execute it.   In my case, the system was still pointing to the previous civi version files, when i cleaned up the cache, that resolved it.
Answers.UserDisplayName: fdarn
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-21T18:57:43.517Z
Answers.Text: Thanks a lot. Could you tell me where I can check the
   rebuild smart group cache scheduled job &
  Clean up temporary data and files scheduled job
Answers.UserDisplayName: user2445
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-21T19:03:43.230Z
Answers.Text: Ah I found them. Scheduled jobs. Rebuild smart group cache was disabled.
Answers.UserDisplayName: user2445
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-21T19:14:36.800Z
Answers.Text: Unfortunately I still have "no recipients".
Answers.UserDisplayName: user2445
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-21T19:52:36.240Z
Answers.Text: (since I enabled "rebuild smart group cache" I get following cron job messages: read timeout at /usr/share/perl5/Net/HTTP/Methods.pm line 268.
Answers.UserDisplayName: user2445
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-27T19:48:37.613Z
Answers.Text: I have had that error when the problem was connection to the SMTP provider.   In that case the error message is misleading if not wrong.  Can you send a test message without an error?
Answers.UserDisplayName: Dave T
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-30T18:31:35.597Z
Answers.Text: I've seen the same thing and will have to look at caches etc. I logged it as an issue in the Mailing project in Gitlab.
Answers.UserDisplayName: Stephen Palmstrom
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-30T18:41:08.870Z
Answers.Text: I ran Rebuild Smart Group Cache, but it didn't help!
Answers.UserDisplayName: Stephen Palmstrom
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-31T14:01:00.987Z
Answers.Text: I did some extensive debugging, looking at the various SQL queries and found the following problem that affects those of us not using en_US as the language:
Answers.UserDisplayName: Stephen Palmstrom
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-21T15:29:01.257Z
Answers.LastActivityDate: 2018-03-21T15:34:09.473Z
Answers.LastEditDate: 2018-03-21T15:34:09.473Z
Answers.UserDisplayName: fdarn
Answers.Body: <p>I did some extensive debugging, looking at the various SQL queries and found the following problem that affects those of us not using en_US as the language:</p>
  
  <p>./CRM/Mailing/BAO/Mailing.php has the getRecipients function, and it has the following line:
  $dao = CRM_Utils_SQL_Select::from('civicrm_mailing_group')
               ->select('GROUP_CONCAT(entity_id SEPARATOR ",") as group_ids, group_type, entity_table')
               ->where('mailing_id = #mailing_id AND entity_table IN ("civicrm_group", "civicrm_mailing")')
               ->groupBy(array('group_type', 'entity_table'))
               ->param('#mailing_id', $mailingID)
               ->execute();</p>
  
  <p>The problem is that for non-en_US languages, civicrm_mailing_group table has the language-specific view as the entity table, so in my case civicrm_group_en_GB, not civicrm_group, so the recipients are never found. This code snippet solves the problem - I've yet to submit a patch.</p>
  
  <pre><code>$mailingGroup = new CRM_Mailing_DAO_MailingGroup();
  $mgtable = CRM_Mailing_DAO_MailingGroup::getTableName();
  $group = CRM_Contact_BAO_Group::getTableName();
  $recipientsGroup = $excludeSmartGroupIDs = $includeSmartGroupIDs = $priorMailingIDs = array();
  $dao = CRM_Utils_SQL_Select::from($mgtable)
           -&gt;select('GROUP_CONCAT(entity_id SEPARATOR ",") as group_ids, group_type, entity_table')
           -&gt;where('mailing_id = #mailing_id AND entity_table IN ("' . $group . '", "' . $mailing . '")')
           -&gt;groupBy(array('group_type', 'entity_table'))
           -&gt;param('#mailing_id', $mailingID)
           -&gt;execute();
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-31T16:56:51.000Z
Answers.Text: There is already [a commit that fixes this issue](https://github.com/civicrm/civicrm-core/pull/11906/files)
Answers.UserDisplayName: Marko
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-31T14:07:33.163Z
Answers.LastActivityDate: 2018-03-31T15:18:24.260Z
Answers.LastEditDate: 2018-03-31T15:18:24.260Z
Answers.UserDisplayName: Stephen Palmstrom
Answers.Body: <p>This bug is marked as being fixed in 5.0 - you should upgrade to the latest  release (currently 5.1.2) to get the fix</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-05-17T07:07:04.197Z
Answers.LastActivityDate: 2018-05-17T07:07:04.197Z
Answers.UserDisplayName: user4278
Body: <p>After upgrade to 4.7.31 / working with Wordpress 4.9.4
  I face problems with sending mass e-mails (Rundschreiben): I can choose groups (mailing list groups) in the recipients section, but the estimation shows "no recepients"; I can send test emails to a single email address or a group, and it works. I can start the sending process, but no e-mails are being sent. Any hints on how to solve this problem?
  <a href="https://i.sstatic.net/88hdO.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/88hdO.png" alt="enter image description here"></a>
  <a href="https://i.sstatic.net/nMHhz.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/nMHhz.png" alt="enter image description here"></a></p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-03-25T13:30:22.540Z
Comments.Text: Can you post the AJAX POST request when you add the group to the list, and what response you get?
  
  https://yoursite.de/civicrm/ajax/rest
Comments.UserDisplayName: Tom B.
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-03-27T14:04:39.963Z
Comments.Text: I checked the reponses and they look identhical to the responses I get on a working website {"is_error":0,"version":3,"count":1,"id":0,"values":[{"id":"79","label":"Test","description":[],"extra":{"is_hidden":"0"}}],"page_num":1} So I guess the problem is in the next step, adding contacts who belong to the selected group.
Comments.UserDisplayName: Marko
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-03-28T15:33:58.623Z
Comments.Text: Thanks for your posts. I could solve the problem only by going back to a previous CiviCrm version via a backup.
Comments.UserDisplayName: user2445
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-03-28T18:08:17.757Z
Comments.Text: Hm, it seems I will have to do that as well. It seems that @TomB. solved the problem by redoing the upgrade, so i guess I will try that if no one has a solution in a couple of days. I posted this [issue on jira](https://issues.civicrm.org/jira/browse/CRM-21856).
Comments.UserDisplayName: Marko
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-03-30T20:47:11.410Z
Comments.Text: This seems to be an issue with multilingual installations.
  
  The issue can be replicated by adding another language and then turning on Multiple Languages Support. After this the problem appears and disappears again when Multiple Languages Support is switched off.
  
  4.7.27 was working, not sure whether the problem first appeared with 4.7.28, 4.7.29 or 4.7.30
  
  Still waiting for the actual solution
Comments.UserDisplayName: Marko
Tags: <wordpress><civimail>
Title: After upgrade to 4.7.31 send mail - recipients - "no recepients"
ThreadText: # After upgrade to 4.7.31 send mail - recipients - "no recepients"
  
  (Asked by: username_0 on 2018-03-21)
  
  After upgrade to 4.7.31 / working with Wordpress 4.9.4
  I face problems with sending mass e-mails (Rundschreiben): I can choose groups (mailing list groups) in the recipients section, but the estimation shows "no recepients"; I can send test emails to a single email address or a group, and it works. I can start the sending process, but no e-mails are being sent. Any hints on how to solve this problem?
  [![enter image description here](https://i.sstatic.net/88hdO.png)](https://i.sstatic.net/88hdO.png)
  [![enter image description here](https://i.sstatic.net/nMHhz.png)](https://i.sstatic.net/nMHhz.png)
  
  **Tags:** wordpress, civimail
  
  > **Comments:**
  > **username_1**: Can you post the AJAX POST request when you add the group to the list, and what response you get?  https://yoursite.de/civicrm/ajax/rest  
  > **username_2**: I checked the reponses and they look identhical to the responses I get on a working website {"is_error":0,"version":3,"count":1,"id":0,"values":[{"id":"79","label":"Test","description":[],"extra":{"is_hidden":"0"}}],"page_num":1} So I guess the problem is in the next step, adding contacts who belong to the selected group.  
  > **username_0**: Thanks for your posts. I could solve the problem only by going back to a previous CiviCrm version via a backup.  
  > **username_2**: Hm, it seems I will have to do that as well. It seems that @TomB. solved the problem by redoing the upgrade, so i guess I will try that if no one has a solution in a couple of days. I posted this [issue on jira](https://issues.civicrm.org/jira/browse/CRM-21856).  
  > **username_2**: This seems to be an issue with multilingual installations.  The issue can be replicated by adding another language and then turning on Multiple Languages Support. After this the problem appears and disappears again when Multiple Languages Support is switched off.  4.7.27 was working, not sure whether the problem first appeared with 4.7.28, 4.7.29 or 4.7.30  Still waiting for the actual solution  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_3 on 2018-03-21. Score: 1
  
  I resolved this by going to Adminstrater > System Settings > Clean up cache and update paths. Click the Clean up cache button.
  
  > **Comments:**
  > **username_0**: Thanks for your reply.  Unfortunately it seemed not to have worked for me.  
  > **username_3**: If your group is a smart group, make sure your rebuild smart group cache scheduled job is enabled. Also make sure your Clean up temporary data and files scheduled job is enabled and maybe manually execute it.   In my case, the system was still pointing to the previous civi version files, when i cleaned up the cache, that resolved it.  
  > **username_0**: Thanks a lot. Could you tell me where I can check the  rebuild smart group cache scheduled job & Clean up temporary data and files scheduled job  
  > **username_0**: Ah I found them. Scheduled jobs. Rebuild smart group cache was disabled.  
  > **username_0**: Unfortunately I still have "no recipients".  
  > **username_0**: (since I enabled "rebuild smart group cache" I get following cron job messages: read timeout at /usr/share/perl5/Net/HTTP/Methods.pm line 268.  
  > **username_4**: I have had that error when the problem was connection to the SMTP provider.   In that case the error message is misleading if not wrong.  Can you send a test message without an error?  
  > **username_5**: I've seen the same thing and will have to look at caches etc. I logged it as an issue in the Mailing project in Gitlab.  
  > **username_5**: I ran Rebuild Smart Group Cache, but it didn't help!  
  > **username_5**: I did some extensive debugging, looking at the various SQL queries and found the following problem that affects those of us not using en_US as the language:  
  
  ---
  
  ### Answer by username_5 on 2018-03-31. Score: 0
  
  I did some extensive debugging, looking at the various SQL queries and found the following problem that affects those of us not using en\_US as the language:
  
  ./CRM/Mailing/BAO/Mailing.php has the getRecipients function, and it has the following line:
  $dao = CRM\_Utils\_SQL\_Select::from('civicrm\_mailing\_group')
  ->select('GROUP\_CONCAT(entity\_id SEPARATOR ",") as group\_ids, group\_type, entity\_table')
  ->where('mailing\_id = #mailing\_id AND entity\_table IN ("civicrm\_group", "civicrm\_mailing")')
  ->groupBy(array('group\_type', 'entity\_table'))
  ->param('#mailing\_id', $mailingID)
  ->execute();
  
  The problem is that for non-en\_US languages, civicrm\_mailing\_group table has the language-specific view as the entity table, so in my case civicrm\_group\_en\_GB, not civicrm\_group, so the recipients are never found. This code snippet solves the problem - I've yet to submit a patch.
  
  ```
  $mailingGroup = new CRM_Mailing_DAO_MailingGroup();
  $mgtable = CRM_Mailing_DAO_MailingGroup::getTableName();
  $group = CRM_Contact_BAO_Group::getTableName();
  $recipientsGroup = $excludeSmartGroupIDs = $includeSmartGroupIDs = $priorMailingIDs = array();
  $dao = CRM_Utils_SQL_Select::from($mgtable)
           ->select('GROUP_CONCAT(entity_id SEPARATOR ",") as group_ids, group_type, entity_table')
           ->where('mailing_id = #mailing_id AND entity_table IN ("' . $group . '", "' . $mailing . '")')
           ->groupBy(array('group_type', 'entity_table'))
           ->param('#mailing_id', $mailingID)
           ->execute();
  
  ```
  
  > **Comments:**
  > **username_2**: There is already [a commit that fixes this issue](https://github.com/civicrm/civicrm-core/pull/11906/files)  
  
  ---
  
  ### Answer by username_6 on 2018-05-17. Score: 0
  
  This bug is marked as being fixed in 5.0 - you should upgrade to the latest release (currently 5.1.2) to get the fix
  
  
  ---
  
  