Answers.Body: <pre><code>[debug_info] =&gt; SELECT id, component_type
                  FROM    civicrm_mailing_component
                  WHERE   is_active = 1
                  AND     is_default = 1
                  GROUP BY component_type [nativecode=1055 ** Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'civicrm.civicrm_mailing_component.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
  </code></pre>
  
  <p>After deactivating 'ONLY_FULL_GROUP_BY' in mysql with</p>
  
  <pre><code>msql &gt; SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
  </code></pre>
  
  <p>it works...</p>
  
  <p><a href="https://issues.civicrm.org/jira/browse/CRM-18439" rel="nofollow">https://issues.civicrm.org/jira/browse/CRM-18439</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-11-17T13:21:16.677Z
Answers.Text: Helped my problem too. Accepting your own answer is possible and will give you some more points ;-)
Answers.UserDisplayName: thoni56
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-06-27T09:10:54.573Z
Answers.LastActivityDate: 2016-06-27T09:10:54.573Z
Answers.UserDisplayName: Christian
Body: <p>I'm using a new installed CiviCRM 4.7.8. with Drupal 7.5  ( Database system version 5.7.12-0ubuntu1 - PHP   5.6.22-4+deb.sury.org~xenial+1  )</p>
  
  <p>The installation was done without errors but now I get:</p>
  
  <pre><code>Notice: Undefined index: values in _civicrm_api3_api_resolve_alias() (line 2310 of /var/www/html/sites/all/modules/civicrm/api/v3/utils.php).
  Warning: Invalid argument supplied for foreach() in _civicrm_api3_api_resolve_alias() (line 2317 of /var/www/html/sites/all/modules/civicrm/api/v3/utils.php).
  Notice: Undefined index: values in _civicrm_api3_api_resolve_alias() (line 2310 of /var/www/html/sites/all/modules/civicrm/api/v3/utils.php).
  Warning: Invalid argument supplied for foreach() in _civicrm_api3_api_resolve_alias() (line 2317 of /var/www/html/sites/all/modules/civicrm/api/v3/utils.php).
  </code></pre>
  
  <p>on clicking "New Mailing".</p>
  
  <p>Any idea what's wrong or how to solve this error?</p>
  
  <p>Thank you</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-11-17T13:20:27.847Z
Comments.Text: I had this when sending test mailings. An error popup showed "DBError: Unknown error". Digging in to the debug and log info showed "[nativecode=1055 ** ...
Comments.UserDisplayName: thoni56
Tags: <civimail><drupal><mailing>
Title: Undefined index: values in _civicrm_api3_api_resolve_alias()
ThreadText: # Undefined index: values in _civicrm_api3_api_resolve_alias()
  
  (Asked by: username_0 on 2016-06-14)
  
  I'm using a new installed CiviCRM 4.7.8. with Drupal 7.5  ( Database system version 5.7.12-0ubuntu1 - PHP   5.6.22-4+deb.sury.org~xenial+1  )
  The installation was done without errors but now I get:
  Notice: Undefined index: values in _civicrm_api3_api_resolve_alias() (line 2310 of /var/www/html/sites/all/modules/civicrm/api/v3/utils.php).
  Warning: Invalid argument supplied for foreach() in _civicrm_api3_api_resolve_alias() (line 2317 of /var/www/html/sites/all/modules/civicrm/api/v3/utils.php).
  Notice: Undefined index: values in _civicrm_api3_api_resolve_alias() (line 2310 of /var/www/html/sites/all/modules/civicrm/api/v3/utils.php).
  Warning: Invalid argument supplied for foreach() in _civicrm_api3_api_resolve_alias() (line 2317 of /var/www/html/sites/all/modules/civicrm/api/v3/utils.php).
  
  on clicking "New Mailing".
  Any idea what's wrong or how to solve this error?
  Thank you
  
  **Tags:** civimail, drupal, mailing
  
  > **Comments:**
  > **username_1**: I had this when sending test mailings. An error popup showed "DBError: Unknown error". Digging in to the debug and log info showed "[nativecode=1055 ** ...  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2016-06-27. Score: 1
  
  [debug_info] => SELECT id, component_type
                  FROM    civicrm_mailing_component
                  WHERE   is_active = 1
                  AND     is_default = 1
                  GROUP BY component_type [nativecode=1055 ** Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'civicrm.civicrm_mailing_component.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
  
  After deactivating 'ONLY_FULL_GROUP_BY' in mysql with
  msql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
  
  it works...
  https://issues.civicrm.org/jira/browse/CRM-18439
  
  > **Comments:**
  > **username_1**: Helped my problem too. Accepting your own answer is possible and will give you some more points ;-)  
  
  ---
  
  