Answers.Body: <p>Eileen McNaughton wrote:</p>
  
  <blockquote>
    <p>It's possible you have FULL_GROUP_BY mode enabled in mysql &amp; that is
    causing problems - the log file should be
    /var/www/vietfeir.com/public_html/wp-content/uploads/civicrm/ConfigAndLog/CiviCRM.4a976861044aadd15e2c85b9.log
    (or similar) and have more error details – eileen 16 hours ago</p>
  </blockquote>
  
  <p>I removed the ONLY_FULL_GROUP_BY mode and the problem was solved. Thanks, Eileen.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-07-10T04:10:06.267Z
Answers.LastActivityDate: 2019-07-10T04:10:06.267Z
Answers.UserDisplayName: Vietyank
Body: <p>After executing a search that returns more than one page of data, I get an error when I click on "next". "Unable to reach the server. Please refresh this page in your browser and try again." </p>
  
  <p>The Apache2 error log shows:</p>
  
  <pre><code>apache2/error.log shows [Mon Jul 08 12:58:29.922448 2019] [php7:warn] [pid 4022] [client 96.9.90.28:57008] PHP Warning:  fopen(/var/www/vietfeir.com/public_html/wp-content/uploads/civicrm/ConfigAndLog/CiviCRM.4a976861044aadd15e2c85b9.log): failed to open stream: Permission denied in /var/www/vietfeir.com/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/log/Log/file.php on line 216, referer: https://ccrmdemo.vietfeir.com/wp-admin/admin.php?page=CiviCRM&amp;q=civicrm%2Fcontact%2Fsearch&amp;_qf_Basic_display=true&amp;qfKey=082061e63d30f54afa566bb
  </code></pre>
  
  <p>All of my files have permissions set to 644 and the directories are 755. </p>
  
  <p>All files are owned by www-data:www-data</p>
  
  <p>This is intermittent. I sometimes do not get the error.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-08T14:03:10.773Z
Comments.Text: I would check the file owner specifically on `/var/www/vietfeir.com/public_html/wp-content/uploads/civicrm/ConfigAndLog/CiviCRM.4a976861044aadd15e2c85b9.log`.  If you're working on the command line, it's very likely that file was created with a user other than www-data.
Comments.UserDisplayName: Jon G - Megaphone Tech
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-08T17:12:55.913Z
Comments.Text: All files are owned by www-data:www-data
Comments.UserDisplayName: Vietyank
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-09T01:03:06.360Z
Comments.Text: I did chown -R www-data: www-data on the site directory. The error message has gone away so that file  had the wrong ownership..The network error is still therr
Comments.UserDisplayName: Vietyank
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-09T04:48:24.237Z
Comments.Text: now that the permissions issue is resolved, does that log file, or other more recent log files, have any recent entries that might help diagnose the issue?
Comments.UserDisplayName: ericG
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-09T07:30:57.483Z
Comments.Text: Not the Apache log. Does CiviCRM have a log I should be looking in?
Comments.UserDisplayName: Vietyank
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-09T10:02:45.807Z
Comments.Text: I've reviewed how logging works. Is there a CiviCRM log I should be looking at?
Comments.UserDisplayName: Vietyank
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-09T12:04:19.670Z
Comments.Text: It's possible you have FULL_GROUP_BY mode enabled in mysql & that is causing problems - the log file should be /var/www/vietfeir.com/public_html/wp-content/uploads/civicrm/ConfigAndLog/CiviCRM.4a976861044aadd15e2c85b9.log (or similar) and have more error details
Comments.UserDisplayName: eileen
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-09T12:43:43.737Z
Comments.Text: Are you recommend that I disable full_group_by?
Comments.UserDisplayName: Vietyank
Tags: <search-results>
Title: "Unable to reach the server" error
ThreadText: # "Unable to reach the server" error
  
  (Asked by: username_0 on 2019-07-08)
  
  After executing a search that returns more than one page of data, I get an error when I click on "next". "Unable to reach the server. Please refresh this page in your browser and try again." 
  The Apache2 error log shows:
  apache2/error.log shows [Mon Jul 08 12:58:29.922448 2019] [php7:warn] [pid 4022] [client 96.9.90.28:57008] PHP Warning:  fopen(/var/www/vietfeir.com/public_html/wp-content/uploads/civicrm/ConfigAndLog/CiviCRM.4a976861044aadd15e2c85b9.log): failed to open stream: Permission denied in /var/www/vietfeir.com/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/log/Log/file.php on line 216, referer: https://ccrmdemo.vietfeir.com/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcontact%2Fsearch&_qf_Basic_display=true&qfKey=082061e63d30f54afa566bb
  
  All of my files have permissions set to 644 and the directories are 755. 
  All files are owned by www-data:www-data
  This is intermittent. I sometimes do not get the error.
  
  **Tags:** search-results
  
  > **Comments:**
  > **username_1**: I would check the file owner specifically on `/var/www/vietfeir.com/public_html/wp-content/uploads/civicrm/ConfigAndLog/CiviCRM.4a976861044aadd15e2c85b9.log`.  If you're working on the command line, it's very likely that file was created with a user other than www-data.  
  > **username_0**: All files are owned by www-data:www-data  
  > **username_0**: I did chown -R www-data: www-data on the site directory. The error message has gone away so that file  had the wrong ownership..The network error is still therr  
  > **username_2**: now that the permissions issue is resolved, does that log file, or other more recent log files, have any recent entries that might help diagnose the issue?  
  > **username_0**: Not the Apache log. Does CiviCRM have a log I should be looking in?  
  > **username_0**: I've reviewed how logging works. Is there a CiviCRM log I should be looking at?  
  > **username_3**: It's possible you have FULL_GROUP_BY mode enabled in mysql & that is causing problems - the log file should be /var/www/vietfeir.com/public_html/wp-content/uploads/civicrm/ConfigAndLog/CiviCRM.4a976861044aadd15e2c85b9.log (or similar) and have more error details  
  > **username_0**: Are you recommend that I disable full_group_by?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2019-07-10. Score: 1 | Accepted answer
  
  Eileen McNaughton wrote:
  
  > It's possible you have FULL\_GROUP\_BY mode enabled in mysql & that is
  > causing problems - the log file should be
  > /var/www/vietfeir.com/public\_html/wp-content/uploads/civicrm/ConfigAndLog/CiviCRM.4a976861044aadd15e2c85b9.log
  > (or similar) and have more error details – username_3 16 hours ago
  
  I removed the ONLY\_FULL\_GROUP\_BY mode and the problem was solved. Thanks, Eileen.
  
  
  ---
  
  