Answers.Body: <p>[SOLVED] Yes found an answer with the help of the CiviCRM team - see <a href="https://lab.civicrm.org/dev/core/issues/963" rel="nofollow noreferrer">https://lab.civicrm.org/dev/core/issues/963</a></p>
  
  <p>The issue is MySQL configuration after upgrading, which adds ONLY_FULL_GROUP_BY to variable sql-mode.  There is a link to a patch but I found it straghtforward to remove this by adding the following line to my.cnf</p>
  
  <p>sql-mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"</p>
  
  <p>Hope that helps.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-06-12T00:42:31.037Z
Answers.LastActivityDate: 2019-06-12T00:42:31.037Z
Answers.UserDisplayName: MickC
Body: <p>To replicate, search all contacts, try to scroll to page 2
  "Network Error
  Unable to reach the server. Please refresh this page in your browser and try again."</p>
  
  <p>Reported by 2 clients, able to replicate.
  Workaround is to use the 'glossary' of first letter of display name.
  Pagination works fine after this.
  Reverting to 'All' also reverts the problem</p>
  
  <p>Replicated on CiviCRM v 5.11.0 and 5.12.0
  Wordpress 5.1.1 and Drupal 7
  Ubuntu 16.04 PHP 7.1.24, Apache</p>
  
  <p><a href="https://i.sstatic.net/qxX9q.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/qxX9q.png" alt="Network Error"></a></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-05-16T17:11:05.140Z
Comments.Text: We are suffering from a similar problem and the common factor seems to be contact search. There is no response to "export contacts" action when all radio button is chosen after a search is done on contacts. It just wouldn't export. I noticed there is something funny about the quick search console. There appears to be an error being raised. See the error log in the screenshot.[![See the error log in the screenshot](https://i.sstatic.net/FqXQU.png)](https://i.sstatic.net/FqXQU.png)
Comments.UserDisplayName: Ulysse Kilim
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-06-10T14:54:39.340Z
Comments.Text: did anyone find an answer to this one as we have it when doing a contact search on a group. Can hit first page and last but not the intermediate pages or change the sort size.
Comments.UserDisplayName: Des Quinn
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-04-12T08:51:49.613Z
Comments.Text: It seems to be ok on https://dmaster.demo.civicrm.org - can you check there and confirm?
Comments.UserDisplayName: Aidan
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-04-13T09:30:54.040Z
Comments.Text: Yes I should have mentioned that I checked the demo too and it is fine.  But not on my clients's sites - replicated on 3 sites now, which have at least several thousand contacts.
Comments.UserDisplayName: MickC
Tags: <contacts><error>
Title: Network Error on Contact Search Results page change
ThreadText: # Network Error on Contact Search Results page change
  
  (Asked by: username_0 on 2019-04-12)
  
  To replicate, search all contacts, try to scroll to page 2
  "Network Error
  Unable to reach the server. Please refresh this page in your browser and try again."
  
  Reported by 2 clients, able to replicate.
  Workaround is to use the 'glossary' of first letter of display name.
  Pagination works fine after this.
  Reverting to 'All' also reverts the problem
  
  Replicated on CiviCRM v 5.11.0 and 5.12.0
  Wordpress 5.1.1 and Drupal 7
  Ubuntu 16.04 PHP 7.1.24, Apache
  
  [![Network Error](https://i.sstatic.net/qxX9q.png)](https://i.sstatic.net/qxX9q.png)
  
  **Tags:** contacts, error
  
  > **Comments:**
  > **username_3**: It seems to be ok on https://dmaster.demo.civicrm.org - can you check there and confirm?  
  > **username_0**: Yes I should have mentioned that I checked the demo too and it is fine.  But not on my clients's sites - replicated on 3 sites now, which have at least several thousand contacts.  
  > **username_1**: We are suffering from a similar problem and the common factor seems to be contact search. There is no response to "export contacts" action when all radio button is chosen after a search is done on contacts. It just wouldn't export. I noticed there is something funny about the quick search console. There appears to be an error being raised. See the error log in the screenshot.[![See the error log in the screenshot](https://i.sstatic.net/FqXQU.png)](https://i.sstatic.net/FqXQU.png)  
  > **username_2**: did anyone find an answer to this one as we have it when doing a contact search on a group. Can hit first page and last but not the intermediate pages or change the sort size.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2019-06-12. Score: 2
  
  [SOLVED] Yes found an answer with the help of the CiviCRM team - see <https://lab.civicrm.org/dev/core/issues/963>
  
  The issue is MySQL configuration after upgrading, which adds ONLY\_FULL\_GROUP\_BY to variable sql-mode. There is a link to a patch but I found it straghtforward to remove this by adding the following line to my.cnf
  
  sql-mode="STRICT\_TRANS\_TABLES,NO\_ZERO\_IN\_DATE,NO\_ZERO\_DATE,ERROR\_FOR\_DIVISION\_BY\_ZERO,NO\_AUTO\_CREATE\_USER,NO\_ENGINE\_SUBSTITUTION"
  
  Hope that helps.
  
  
  ---
  
  