Answers.Body: <p>I wonder whether log tables are being created in the wrong order by the config change that switches on Logging? If the error you see always refers to this same table, maybe creation of another log table triggers expects <strong>dcmadmin_civicrm.entity_log_civireport</strong> to exist already. Chicken and egg?
  David</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-02-21T10:35:12.853Z
Answers.LastActivityDate: 2018-02-21T10:35:12.853Z
Answers.UserDisplayName: David Hepper
Answers.Body: <p>Andy, what version of MySQL are you running?  If it's 5.7 check whether SQL Mode has ONLY_FULL_GROUP_BY set in it.  If so try deleting this out and restarting MySQL.  Removing this has fixed this error for me and also another one where I couldn't run the Detailed Contributions report.  It seems the MySQL 5.7 has changed the default behaviour for the SQL Mode and some of the CiviCRM queries don't seem to like the more strict handling.</p>
  
  <p>You can check if this is the likely casue by checking the backtrace to see if it contains and error such as:</p>
  
  <pre><code>Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'civicrm.contribution_soft_civireport.amount' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]"]
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-02-25T22:31:48.217Z
Answers.Text: It's MySQL 5.7.20 but that error is not in the backtrace. And I can run the Detailed Contributions report, no problem.  Typical, eh?!
Answers.UserDisplayName: Andy Clark
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-02-25T19:27:08.177Z
Answers.LastActivityDate: 2018-02-25T19:27:08.177Z
Answers.UserDisplayName: SimonB
Answers.Body: <p>I was facing same issue, and on removing sql mode - ONLY_FULL_GROUP_BY, worked for me.
  SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-15T11:40:09.900Z
Answers.Text: I checked with Civihosting & this option is already disabled.  So that's not the solution. But thanks for the suggestion.
Answers.UserDisplayName: Andy Clark
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-14T11:05:16.803Z
Answers.LastActivityDate: 2018-03-14T11:05:16.803Z
Answers.UserDisplayName: chitra jajoria
Body: <p>After switching logging on, clicking the tab 'Change Log' hangs for ever and the following error occurs (full traceback availabe).  This is, I guess, a temporary table that for some reason Civi has failed to create.  Does anyone have any clues on fixing this problem.  Civi is 4.7.27 / Drupal and is otherwise functioning well (hosted at CiviHosting)</p>
  
  <p><strong>#9 /home/dcmadmin/www/www/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-18, NULL, NULL, NULL, "1146 ** Table 'dcmadmin_civicrm.entity_log_civireport' doesn't exist")</strong></p>
  
  <p>(previously I raised this as a question about 'Unable to reach the server' but that's only a symptom of the above problem.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-02-20T13:36:43.620Z
Comments.Text: Andy do you mean you have just turned logging on and it produces the error - or that logging has been on for a while and you are now seeing the error?  Turning logging off and back on fixes some conditions.
Comments.UserDisplayName: Aidan
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-02-20T13:54:34.307Z
Comments.Text: No just turned it on & checked log_ tables all created.  Have switched it back & forth with same problem.
Comments.UserDisplayName: Andy Clark
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-02-20T14:19:38.153Z
Comments.Text: Does the rest of the stacktrace show what it was doing to trigger that message?
Comments.UserDisplayName: Aidan
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-02-20T14:24:48.157Z
Comments.Text: Yes - it was building 'CRM_Report_Form_Contact_LoggingSummary' - I emailed you the backtrace
Comments.UserDisplayName: Andy Clark
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-02-21T23:05:49.867Z
Comments.Text: I'm relatively new to CiviCRM and am having the same issue as Andy in both 4.7.29 and 4.7.30 although with a different table:
  #6 /var/www/html/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-1, NULL, NULL, "INSERT IGNORE INTO civicrm_temp_civireport_logsummary SELECT entity_log_civir...", "1055 ** Expression #3 of SELECT list is not in GROUP BY clause and contains n...")
  The symptoms are the same - switch logging on, go to Change Log tab and get the "Network Error" message with a spinning circle and no response. I have switched logging off, deleted all log_ tables
Comments.UserDisplayName: SimonB
Tags: <drupal><4.7><logging>
Title: Change log crashes - table entity_log_civireport doesn't exist - how to fix?
ThreadText: # Change log crashes - table entity_log_civireport doesn't exist - how to fix?
  
  (Asked by: username_0 on 2018-02-20)
  
  After switching logging on, clicking the tab 'Change Log' hangs for ever and the following error occurs (full traceback availabe). This is, I guess, a temporary table that for some reason Civi has failed to create. Does anyone have any clues on fixing this problem. Civi is 4.7.27 / Drupal and is otherwise functioning well (hosted at CiviHosting)
  
  **#9 /home/dcmadmin/www/www/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB\_common->raiseError(-18, NULL, NULL, NULL, "1146 \*\* Table 'dcmadmin\_civicrm.entity\_log\_civireport' doesn't exist")**
  
  (previously I raised this as a question about 'Unable to reach the server' but that's only a symptom of the above problem.
  
  **Tags:** drupal, 4.7, logging
  
  > **Comments:**
  > **username_1**: Andy do you mean you have just turned logging on and it produces the error - or that logging has been on for a while and you are now seeing the error?  Turning logging off and back on fixes some conditions.  
  > **username_0**: No just turned it on & checked log_ tables all created.  Have switched it back & forth with same problem.  
  > **username_1**: Does the rest of the stacktrace show what it was doing to trigger that message?  
  > **username_0**: Yes - it was building 'CRM_Report_Form_Contact_LoggingSummary' - I emailed you the backtrace  
  > **username_2**: I'm relatively new to CiviCRM and am having the same issue as Andy in both 4.7.29 and 4.7.30 although with a different table: #6 /var/www/html/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-1, NULL, NULL, "INSERT IGNORE INTO civicrm_temp_civireport_logsummary SELECT entity_log_civir...", "1055 ** Expression #3 of SELECT list is not in GROUP BY clause and contains n...") The symptoms are the same - switch logging on, go to Change Log tab and get the "Network Error" message with a spinning circle and no response. I have switched logging off, deleted all log_ tables  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_3 on 2018-02-21. Score: 0
  
  I wonder whether log tables are being created in the wrong order by the config change that switches on Logging? If the error you see always refers to this same table, maybe creation of another log table triggers expects **dcmadmin\_civicrm.entity\_log\_civireport** to exist already. Chicken and egg?
  David
  
  
  ---
  
  ### Answer by username_2 on 2018-02-25. Score: 0
  
  Andy, what version of MySQL are you running?  If it's 5.7 check whether SQL Mode has ONLY_FULL_GROUP_BY set in it.  If so try deleting this out and restarting MySQL.  Removing this has fixed this error for me and also another one where I couldn't run the Detailed Contributions report.  It seems the MySQL 5.7 has changed the default behaviour for the SQL Mode and some of the CiviCRM queries don't seem to like the more strict handling.
  You can check if this is the likely casue by checking the backtrace to see if it contains and error such as:
  Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'civicrm.contribution_soft_civireport.amount' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]"]
  
  > **Comments:**
  > **username_0**: It's MySQL 5.7.20 but that error is not in the backtrace. And I can run the Detailed Contributions report, no problem.  Typical, eh?!  
  
  ---
  
  ### Answer by username_4 on 2018-03-14. Score: 0
  
  I was facing same issue, and on removing sql mode - ONLY\_FULL\_GROUP\_BY, worked for me.
  SET GLOBAL sql\_mode=(SELECT REPLACE(@@sql\_mode,'ONLY\_FULL\_GROUP\_BY',''));
  
  > **Comments:**
  > **username_0**: I checked with Civihosting & this option is already disabled.  So that's not the solution. But thanks for the suggestion.  
  
  ---
  
  