Answers.Body: <p>As you must be aware CiviVolunteer is not fully tested for 5.5.x version of CiviCRM. The last <a href="https://civicrm.org/extensions/civivolunteer" rel="nofollow noreferrer">extension</a> version was released for 5.0. This error usually occur when sql_mode for mysql is configured for only_full_group_by. I have just submitted a <a href="https://github.com/civicrm/org.civicrm.volunteer/pull/481" rel="nofollow noreferrer">pull request</a> for this fix.</p>
  
  <p>You can either apply the patch from <a href="https://patch-diff.githubusercontent.com/raw/civicrm/org.civicrm.volunteer/pull/481.patch" rel="nofollow noreferrer">here</a> or <a href="https://stackoverflow.com/questions/23921117/disable-only-full-group-by">turn off only_full_group_by sql mode</a></p>
  
  <p>HTH</p>
  
  <p>Pradeep</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-10T01:26:10.533Z
Answers.Text: Thank you! I'll look into those fixes and be more cognizant of the CiviCRM to CiviVolunteer compatibility recommendations. I appreciate your help.
Answers.UserDisplayName: Matt Woodward
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-09T21:45:33.427Z
Answers.LastActivityDate: 2018-10-09T21:45:33.427Z
Answers.UserDisplayName: Pradeep Nayak
Answers.Body: <p>Thanks for the PR pradeep.</p>
  
  <p>I think we will have an official release containing CiviCRM 5.x support bug-fixes this month. There are already some in the master branch on GitHub.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-10T19:26:00.347Z
Answers.LastActivityDate: 2018-10-10T19:26:00.347Z
Answers.UserDisplayName: ginkgoMZD
Body: <p>I'm trying to run a volunteer report on CiviCRM 5.5.2 on WordPress, and if I go to Reports -> Contact Reports -> Volunteer Reports, then click "Refresh Results" (no matter what criteria I seem to choose), I get the following error:</p>
  
  <pre><code>[nativecode=1055 ** Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bitnami_wordpress.civicrm_contact_assignee_civireport.sort_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
  </code></pre>
  
  <p>The full log entry is pretty long but here's the group by clause (through to the end of the query, right before the error above appears in the log):</p>
  
  <pre><code>GROUP BY activity_civireport.id  ORDER BY civicrm_contact_assignee_civireport.sort_name ASC  LIMIT 0, 50
  </code></pre>
  
  <p>In case this sheds any light on things, I'm pretty new to CiviCRM and I set up a project, then starting logging hours, but the people for whom I'm logging hours are NOT on the volunteer roster for the project. Not sure if that matters or not but thought I'd mention it since maybe that's not how you're supposed to do things.</p>
  
  <p>I can provide more details or the full error as needed. Thanks for any ideas anyone has.</p>
  
Tags: <civivolunteer><reports>
Title: Volunteer Report Error: Expression #2 of SELECT list is not in GROUP BY clause
ThreadText: # Volunteer Report Error: Expression #2 of SELECT list is not in GROUP BY clause
  
  (Asked by: username_0 on 2018-10-09)
  
  I'm trying to run a volunteer report on CiviCRM 5.5.2 on WordPress, and if I go to Reports -> Contact Reports -> Volunteer Reports, then click "Refresh Results" (no matter what criteria I seem to choose), I get the following error:
  [nativecode=1055 ** Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bitnami_wordpress.civicrm_contact_assignee_civireport.sort_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
  
  The full log entry is pretty long but here's the group by clause (through to the end of the query, right before the error above appears in the log):
  GROUP BY activity_civireport.id  ORDER BY civicrm_contact_assignee_civireport.sort_name ASC  LIMIT 0, 50
  
  In case this sheds any light on things, I'm pretty new to CiviCRM and I set up a project, then starting logging hours, but the people for whom I'm logging hours are NOT on the volunteer roster for the project. Not sure if that matters or not but thought I'd mention it since maybe that's not how you're supposed to do things.
  I can provide more details or the full error as needed. Thanks for any ideas anyone has.
  
  **Tags:** civivolunteer, reports
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2018-10-09. Score: 1 | Accepted answer
  
  As you must be aware CiviVolunteer is not fully tested for 5.5.x version of CiviCRM. The last [extension](https://civicrm.org/extensions/civivolunteer) version was released for 5.0. This error usually occur when sql\_mode for mysql is configured for only\_full\_group\_by. I have just submitted a [pull request](https://github.com/civicrm/org.civicrm.volunteer/pull/481) for this fix.
  
  You can either apply the patch from [here](https://patch-diff.githubusercontent.com/raw/civicrm/org.civicrm.volunteer/pull/481.patch) or [turn off only\_full\_group\_by sql mode](https://stackoverflow.com/questions/23921117/disable-only-full-group-by)
  
  HTH
  
  Pradeep
  
  > **Comments:**
  > **username_0**: Thank you! I'll look into those fixes and be more cognizant of the CiviCRM to CiviVolunteer compatibility recommendations. I appreciate your help.  
  
  ---
  
  ### Answer by username_2 on 2018-10-10. Score: 1
  
  Thanks for the PR pradeep.
  
  I think we will have an official release containing CiviCRM 5.x support bug-fixes this month. There are already some in the master branch on GitHub.
  
  
  ---
  
  