Answers.Body: <p>After updating civicrm and running db update, this issue is no longer occurring.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-08-13T09:22:56.680Z
Answers.LastActivityDate: 2024-08-13T09:22:56.680Z
Answers.UserDisplayName: Dan
Answers.Body: <p>civi isn't fully sql group-by compliant. You'll need to turn that off in your database's SQL_MODE. See the part about ONLY_FULL_GROUP_BY at <a href="https://docs.civicrm.org/installation/en/latest/general/requirements/#mysql-configuration" rel="nofollow noreferrer">https://docs.civicrm.org/installation/en/latest/general/requirements/#mysql-configuration</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-29T07:24:14.040Z
Answers.Text: I have tried to run this, this morning, but I still recieve the same error. Although ni didnt run it as GLOBAL, due to no permissions on then hosted server, I removed GLOBAL and ran it successfully., yet the error remains
Answers.UserDisplayName: Dan
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-29T12:38:05.380Z
Answers.Text: Ask your hosting provider how to set sql_mode globally on their systems.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-08-13T09:20:31.690Z
Answers.Text: The hosting provider refused to run this sql due to it being unsafe for the rest of the server. However after updating civicrm it is working fine now.
Answers.UserDisplayName: Dan
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-11T18:10:45.023Z
Answers.LastActivityDate: 2024-07-11T18:10:45.023Z
Answers.UserDisplayName: Demerit
Body: <p>I tried installing new extensions, however it timed out on my site.
  Now when I try and go to my backend cvi home with the dashlets, I am receiving a network error: <em>unable to reach server</em>.</p>
  <p>I also receive an error when trying to go into contact records. When I turned debug on, this is what I received:</p>
  <pre><code>SELECT `a`.`id` AS `id`, `a`.`uf_group_id` AS `uf_group_id`, `uf_group_id_1`.`title` AS `uf_group_id.title`, `uf_group_id_1`.`name` AS `uf_group_id.name`, `uf_group_id_1`.`group_type` AS `uf_group_id.group_type`, GROUP_CONCAT(`fields`.`field_name` SEPARATOR &quot;&quot;) AS `field_names`, GROUP_CONCAT(`fields`.`label` ORDER BY `fields`.`weight` SEPARATOR &quot;&quot;) AS `field_labels` FROM civicrm_uf_join a LEFT JOIN `civicrm_uf_group` `uf_group_id_1` ON `a`.`uf_group_id` = `uf_group_id_1`.`id` LEFT JOIN (`civicrm_uf_field` `fields`) ON `a`.`uf_group_id` = `fields`.`uf_group_id` AND `fields`.`is_active` = &quot;1&quot; WHERE (`a`.`module` = &quot;Contact Summary&quot;) AND (`uf_group_id_1`.`is_active` = &quot;1&quot;) GROUP BY `a`.`id` [nativecode=1055 ** 'ajybnmfy_adcid.a.uf_group_id' isn't in GROUP BY]
  
  DebugInfo   SELECT `a`.`id` AS `id`, `a`.`uf_group_id` AS `uf_group_id`, `uf_group_id_1`.`title` AS `uf_group_id.title`, `uf_group_id_1`.`name` AS `uf_group_id.name`, `uf_group_id_1`.`group_type` AS `uf_group_id.group_type`, GROUP_CONCAT(`fields`.`field_name` SEPARATOR &quot;&quot;) AS `field_names`, GROUP_CONCAT(`fields`.`label` ORDER BY `fields`.`weight` SEPARATOR &quot;&quot;) AS `field_labels` FROM civicrm_uf_join a LEFT JOIN `civicrm_uf_group` `uf_group_id_1` ON `a`.`uf_group_id` = `uf_group_id_1`.`id` LEFT JOIN (`civicrm_uf_field` `fields`) ON `a`.`uf_group_id` = `fields`.`uf_group_id` AND `fields`.`is_active` = &quot;1&quot; WHERE (`a`.`module` = &quot;Contact Summary&quot;) AND (`uf_group_id_1`.`is_active` = &quot;1&quot;) GROUP BY `a`.`id` [nativecode=1055 ** 'ajybnmfy_adcid.a.uf_group_id' isn't in GROUP BY]
  </code></pre>
  <p>Can anybody help me with this?</p>
  
Tags: <error><database><backdrop>
Title: Tried installing new extensions but now I get an error
ThreadText: # Tried installing new extensions but now I get an error
  
  (Asked by: username_0 on 2024-07-11)
  
  I tried installing new extensions, however it timed out on my site.
  Now when I try and go to my backend cvi home with the dashlets, I am receiving a network error: *unable to reach server*.
  
  I also receive an error when trying to go into contact records. When I turned debug on, this is what I received:
  
  ```
  SELECT `a`.`id` AS `id`, `a`.`uf_group_id` AS `uf_group_id`, `uf_group_id_1`.`title` AS `uf_group_id.title`, `uf_group_id_1`.`name` AS `uf_group_id.name`, `uf_group_id_1`.`group_type` AS `uf_group_id.group_type`, GROUP_CONCAT(`fields`.`field_name` SEPARATOR "") AS `field_names`, GROUP_CONCAT(`fields`.`label` ORDER BY `fields`.`weight` SEPARATOR "") AS `field_labels` FROM civicrm_uf_join a LEFT JOIN `civicrm_uf_group` `uf_group_id_1` ON `a`.`uf_group_id` = `uf_group_id_1`.`id` LEFT JOIN (`civicrm_uf_field` `fields`) ON `a`.`uf_group_id` = `fields`.`uf_group_id` AND `fields`.`is_active` = "1" WHERE (`a`.`module` = "Contact Summary") AND (`uf_group_id_1`.`is_active` = "1") GROUP BY `a`.`id` [nativecode=1055 ** 'ajybnmfy_adcid.a.uf_group_id' isn't in GROUP BY]
  
  DebugInfo   SELECT `a`.`id` AS `id`, `a`.`uf_group_id` AS `uf_group_id`, `uf_group_id_1`.`title` AS `uf_group_id.title`, `uf_group_id_1`.`name` AS `uf_group_id.name`, `uf_group_id_1`.`group_type` AS `uf_group_id.group_type`, GROUP_CONCAT(`fields`.`field_name` SEPARATOR "") AS `field_names`, GROUP_CONCAT(`fields`.`label` ORDER BY `fields`.`weight` SEPARATOR "") AS `field_labels` FROM civicrm_uf_join a LEFT JOIN `civicrm_uf_group` `uf_group_id_1` ON `a`.`uf_group_id` = `uf_group_id_1`.`id` LEFT JOIN (`civicrm_uf_field` `fields`) ON `a`.`uf_group_id` = `fields`.`uf_group_id` AND `fields`.`is_active` = "1" WHERE (`a`.`module` = "Contact Summary") AND (`uf_group_id_1`.`is_active` = "1") GROUP BY `a`.`id` [nativecode=1055 ** 'ajybnmfy_adcid.a.uf_group_id' isn't in GROUP BY]
  
  ```
  
  Can anybody help me with this?
  
  **Tags:** error, database, backdrop
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_0 on 2024-08-13. Score: 1 | Accepted answer
  
  After updating civicrm and running db update, this issue is no longer occurring.
  
  
  ---
  
  ### Answer by username_1 on 2024-07-11. Score: 2
  
  civi isn't fully sql group-by compliant. You'll need to turn that off in your database's SQL\_MODE. See the part about ONLY\_FULL\_GROUP\_BY at <https://docs.civicrm.org/installation/en/latest/general/requirements/#mysql-configuration>
  
  > **Comments:**
  > **username_0**: I have tried to run this, this morning, but I still recieve the same error. Although ni didnt run it as GLOBAL, due to no permissions on then hosted server, I removed GLOBAL and ran it successfully., yet the error remains  
  > **username_1**: Ask your hosting provider how to set sql_mode globally on their systems.  
  > **username_0**: The hosting provider refused to run this sql due to it being unsafe for the rest of the server. However after updating civicrm it is working fine now.  
  
  ---
  
  