Answers.Body: <p>ok, finally got it working by adding the following lines to the config file located at
  <em>/etc/mysql/my.cnf</em></p>
  
  <pre><code>[mysqld]
  sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
  </code></pre>
  
  <p>But looks like a bug anyway..?!</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-03-30T10:49:27.713Z
Answers.LastActivityDate: 2017-04-07T14:30:35.377Z
Answers.LastEditDate: 2017-04-07T14:30:35.377Z
Answers.UserDisplayName: tlvz
Body: <p>I'm new to CiviCRM and just installed it (v. 4.7.17) on Wordpress 4.7.3</p>
  
  <p>When I access the tag management page (wp-admin/admin.php?page=CiviCRM&amp;q=civicrm%2Ftag&amp;reset=1), I get a DB Error + a display bug.</p>
  
  <p>Error is </p>
  
  <pre><code>Expression #12 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'civicrm.child.id' which is not functionnally dependent on columns in GROUP BY clause ; this is incompatible with sql_mode=only_full_group_by, 1055
  </code></pre>
  
  <p>And debug info is in the image attached.</p>
  
  <p><a href="https://i.sstatic.net/27cBa.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/27cBa.png" alt="enter image description here"></a>
  Does anybody know how to sort this out?</p>
  
  <p>thanks</p>
  
  <p>Thomas</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-03-30T11:09:27.950Z
Comments.Text: What database software & version are you using?
Comments.UserDisplayName: Aidan
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-03-31T12:54:48.567Z
Comments.Text: i am with MySQL 5.7.17
Comments.UserDisplayName: tlvz
Tags: <error><database><tags>
Title: DB error on tag page after installation
ThreadText: # DB error on tag page after installation
  
  (Asked by: username_0 on 2017-03-30)
  
  I'm new to CiviCRM and just installed it (v. 4.7.17) on Wordpress 4.7.3
  When I access the tag management page (wp-admin/admin.php?page=CiviCRM&q=civicrm%2Ftag&reset=1), I get a DB Error + a display bug.
  Error is 
  Expression #12 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'civicrm.child.id' which is not functionnally dependent on columns in GROUP BY clause ; this is incompatible with sql_mode=only_full_group_by, 1055
  
  And debug info is in the image attached.
  
  Does anybody know how to sort this out?
  thanks
  Thomas
  
  **Tags:** error, database, tags
  
  > **Comments:**
  > **username_1**: What database software & version are you using?  
  > **username_0**: i am with MySQL 5.7.17  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2017-03-30. Score: 1
  
  ok, finally got it working by adding the following lines to the config file located at
  /etc/mysql/my.cnf
  [mysqld]
  sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
  
  But looks like a bug anyway..?!
  
  
  ---
  
  