Answers.Body: <p>disabling the <strong>ONLY_FULL_GROUP_BY</strong> SQL mode (which it is by default in MySQL 5.7) with this command</p>
  
  <p><code>mysql &gt; SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));</code></p>
  
  <p>solve the problem about the paging, but it must be considered a workaround. </p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-07-06T20:42:37.050Z
Answers.Text: This is no longer necessary upgrading to CiviCRM 5.15.0.
  The paging problem is solved.
Answers.UserDisplayName: Francesco Garganese
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-06-07T08:19:35.650Z
Answers.LastActivityDate: 2019-06-07T08:19:35.650Z
Answers.UserDisplayName: Francesco Garganese
Body: <p>we have a CiviCRM installation under WordPress 4.9.10 and 2 MySQL db: one for Wordpress and one for CiviCRM.
  Actually we imported and start to manage more than 5000 contacts.</p>
  
  <p>Everything operate as well, excepting the following actions, returning us a</p>
  
  <blockquote>
    <p><strong>Network Error</strong>
    Unable to reach the server. Please refresh this page in your browser and try again.</p>
  </blockquote>
  
  <ul>
  <li>clicking to go on page 2 on a "Search -> Find Contacts" or a "Search
  -> Advanced Search"</li>
  <li>adding a meeting or phone call in the contact summary.</li>
  </ul>
  
  <p>There are <strong>NO ERRORS</strong> adding contributions, registering for events, adding pledges, sending emails.</p>
  
  <p>We see no errors in apache logs too.
  Actual PHP variables are:</p>
  
  <pre><code> php_value memory_limit 256M
   php_value max_input_vars 2500
   php_value upload_max_filesize 16M
   php_value register_globals off
   php_value max_execution_time 600
   php_value output_buffering 0
  </code></pre>
  
  <p>Any ideas about to solve it?
  TIA -- Francesco</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-06-06T11:17:49.000Z
Comments.Text: I think that this has a fix that is merged - but possibly not in this months release but next. It's about your server config - you have something called 'Full Group By' mode enabled in mysql. There is a patch if you feel comfortable backporting
  
  - well that goes for the paging bug - this one "adding a meeting or phone call in the contact summary" - I'm not so sure about - seems different  & unrelated
Comments.UserDisplayName: eileen
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-06-06T12:55:31.677Z
Comments.Text: Trial done! I confirm that disabling the **ONLY_FULL_GROUP_BY** with this command 
  `mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));`
  solve the problem about the paging, 
  but doesn''t solve the problem adding a meeting or phone call in the contact summary.
Comments.UserDisplayName: Francesco Garganese
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-06-06T14:31:30.033Z
Comments.Text: @FrancescoGarganese Could you please repost your comment as an answer below?  Thanks! It might also help to post the problem adding a meeting/phone call as a separate question since it appears to be a separate issue.
Comments.UserDisplayName: Jon G - Megaphone Tech
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-06-07T00:12:17.183Z
Comments.Text: On the other issue - it's going to be necessary to capture some more debugging info - with debugging enabled you might be able to get it in your browser by inspecting the response
Comments.UserDisplayName: eileen
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-06-07T08:13:01.197Z
Comments.Text: Today i try to prepare a small video showing the error, posting to share to you all. Let me know if I can try something to obtain debugging info. About **ONLY_FULL_GROUP_BY** disabling it is a workaround, not a solution; but I put an answer to the question.
Comments.UserDisplayName: Francesco Garganese
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-06-22T08:15:35.567Z
Comments.Text: are there some news about the adding a meeting or phone call in the contact summary??
Comments.UserDisplayName: Francesco Garganese
Tags: <wordpress><contacts><error><search-results><advanced-search>
Title: "Network Error Unable to reach the server" only doing certain actions
ThreadText: # "Network Error Unable to reach the server" only doing certain actions
  
  (Asked by: username_0 on 2019-06-06)
  
  we have a CiviCRM installation under WordPress 4.9.10 and 2 MySQL db: one for Wordpress and one for CiviCRM.
  Actually we imported and start to manage more than 5000 contacts.
  
  Everything operate as well, excepting the following actions, returning us a
  
  > **Network Error**
  > Unable to reach the server. Please refresh this page in your browser and try again.
  
  * clicking to go on page 2 on a "Search -> Find Contacts" or a "Search
    -> Advanced Search"
  * adding a meeting or phone call in the contact summary.
  
  There are **NO ERRORS** adding contributions, registering for events, adding pledges, sending emails.
  
  We see no errors in apache logs too.
  Actual PHP variables are:
  
  ```
   php_value memory_limit 256M
   php_value max_input_vars 2500
   php_value upload_max_filesize 16M
   php_value register_globals off
   php_value max_execution_time 600
   php_value output_buffering 0
  
  ```
  
  Any ideas about to solve it?
  TIA -- username_0
  
  **Tags:** wordpress, contacts, error, search-results, advanced-search
  
  > **Comments:**
  > **username_1**: I think that this has a fix that is merged - but possibly not in this months release but next. It's about your server config - you have something called 'Full Group By' mode enabled in mysql. There is a patch if you feel comfortable backporting  - well that goes for the paging bug - this one "adding a meeting or phone call in the contact summary" - I'm not so sure about - seems different  & unrelated  
  > **username_0**: Trial done! I confirm that disabling the **ONLY_FULL_GROUP_BY** with this command  `mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));` solve the problem about the paging,  but doesn''t solve the problem adding a meeting or phone call in the contact summary.  
  > **username_2**: @username_0 Could you please repost your comment as an answer below?  Thanks! It might also help to post the problem adding a meeting/phone call as a separate question since it appears to be a separate issue.  
  > **username_1**: On the other issue - it's going to be necessary to capture some more debugging info - with debugging enabled you might be able to get it in your browser by inspecting the response  
  > **username_0**: Today i try to prepare a small video showing the error, posting to share to you all. Let me know if I can try something to obtain debugging info. About **ONLY_FULL_GROUP_BY** disabling it is a workaround, not a solution; but I put an answer to the question.  
  > **username_0**: are there some news about the adding a meeting or phone call in the contact summary??  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2019-06-07. Score: 1
  
  disabling the **ONLY\_FULL\_GROUP\_BY** SQL mode (which it is by default in MySQL 5.7) with this command
  
  `mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));`
  
  solve the problem about the paging, but it must be considered a workaround.
  
  > **Comments:**
  > **username_0**: This is no longer necessary upgrading to CiviCRM 5.15.0. The paging problem is solved.  
  
  ---
  
  