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 -- Francesco
  
  **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**: @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.  
  > **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.  
  
  ---
  
  