Answers.Body: <p>Just a directory filling up.  Deleted some unused files and the error went away.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-11-10T20:23:23.517Z
Answers.LastActivityDate: 2021-11-10T20:23:23.517Z
Answers.UserDisplayName: Andrew G
Body: <p>Drupal 7.41
  CiviCRM 4.6.6</p>
  <p>We are using an older version of CiviCRM and are randomly starting to get &quot;Sorry but we are not able to provide this at the moment.&quot; when running certain reports.</p>
  <p>I enabled backtrace and debugging.  Below are the results.</p>
  <p>Any help would be appreciated.  This happens randomly but is happening more and more often now.</p>
  <p>backTrace</p>
  <p>#0 /var/www/html/Dash/modules/civicrm/CRM/Core/Error.php(182): CRM_Core_Error::backtrace()
  #1 internal function: CRM_Core_Error::handle(Object(DB_Error))
  #2 /var/www/html/Dash/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
  #3 /var/www/html/Dash/modules/civicrm/packages/DB.php(976): PEAR_Error-&gt;PEAR_Error(&quot;DB Error: unknown error&quot;, -1, 16, (Array:2), &quot;SELECT SQL_CALC_FOUND_ROWS GROUP_CONCAT(civicrm_contact_contact_target SEPARA...&quot;)
  #4 /var/www/html/Dash/modules/civicrm/packages/PEAR.php(564): DB_Error-&gt;DB_Error(-1, 16, (Array:2), &quot;SELECT SQL_CALC_FOUND_ROWS GROUP_CONCAT(civicrm_contact_contact_target SEPARA...&quot;)
  #5 /var/www/html/Dash/modules/civicrm/packages/DB/common.php(1905): PEAR-&gt;raiseError(NULL, -1, NULL, NULL, &quot;SELECT SQL_CALC_FOUND_ROWS GROUP_CONCAT(civicrm_contact_contact_target SEPARA...&quot;, &quot;DB_Error&quot;, TRUE)
  #6 /var/www/html/Dash/modules/civicrm/packages/DB/mysql.php(899): DB_common-&gt;raiseError(-1, NULL, NULL, NULL, &quot;126 ** Incorrect key file for table '/tmp/#sql_705_0.MYI'; try to repair it&quot;)
  #7 /var/www/html/Dash/modules/civicrm/packages/DB/mysql.php(328): DB_mysql-&gt;mysqlRaiseError()
  #8 /var/www/html/Dash/modules/civicrm/packages/DB/common.php(1216): DB_mysql-&gt;simpleQuery(&quot;SELECT SQL_CALC_FOUND_ROWS GROUP_CONCAT(civicrm_contact_contact_target SEPARA...&quot;)
  #9 /var/www/html/Dash/modules/civicrm/packages/DB/DataObject.php(2442): DB_common-&gt;query(&quot;SELECT SQL_CALC_FOUND_ROWS GROUP_CONCAT(civicrm_contact_contact_target SEPARA...&quot;)
  #10 /var/www/html/Dash/modules/civicrm/packages/DB/DataObject.php(1634): DB_DataObject-&gt;_query(&quot;SELECT SQL_CALC_FOUND_ROWS GROUP_CONCAT(civicrm_contact_contact_target SEPARA...&quot;)
  #11 /var/www/html/Dash/modules/civicrm/CRM/Core/DAO.php(325): DB_DataObject-&gt;query(&quot;SELECT SQL_CALC_FOUND_ROWS GROUP_CONCAT(civicrm_contact_contact_target SEPARA...&quot;)
  #12 /var/www/html/Dash/modules/civicrm/CRM/Core/DAO.php(1179): CRM_Core_DAO-&gt;query(&quot;SELECT SQL_CALC_FOUND_ROWS GROUP_CONCAT(civicrm_contact_contact_target SEPARA...&quot;, TRUE)
  #13 /var/www/html/Dash/modules/civicrm/CRM/Report/Form.php(2776): CRM_Core_DAO::executeQuery(&quot;SELECT SQL_CALC_FOUND_ROWS GROUP_CONCAT(civicrm_contact_contact_target SEPARA...&quot;)
  #14 /var/www/html/Dash/modules/civicrm/CRM/Report/Form/Activity.php(763): CRM_Report_Form-&gt;buildRows(&quot;SELECT SQL_CALC_FOUND_ROWS GROUP_CONCAT(civicrm_contact_contact_target SEPARA...&quot;, (Array:0))
  #15 /var/www/html/Dash/modules/civicrm/CRM/Report/Form.php(753): CRM_Report_Form_Activity-&gt;postProcess()
  #16 /var/www/html/Dash/modules/civicrm/CRM/Core/Form.php(455): CRM_Report_Form-&gt;preProcess()
  #17 /var/www/html/Dash/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(94): CRM_Core_Form-&gt;buildForm()
  #18 /var/www/html/Dash/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display-&gt;perform(Object(CRM_Report_Form_Activity), &quot;display&quot;)
  #19 /var/www/html/Dash/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller-&gt;handle(Object(CRM_Report_Form_Activity), &quot;display&quot;)
  #20 /var/www/html/Dash/modules/civicrm/CRM/Core/Controller.php(353): HTML_QuickForm_Page-&gt;handle(&quot;display&quot;)
  #21 /var/www/html/Dash/modules/civicrm/CRM/Utils/Wrapper.php(115): CRM_Core_Controller-&gt;run()
  #22 /var/www/html/Dash/modules/civicrm/CRM/Report/Page/Instance.php(101): CRM_Utils_Wrapper-&gt;run(&quot;CRM_Report_Form_Activity&quot;, NULL, NULL)
  #23 /var/www/html/Dash/modules/civicrm/CRM/Core/Invoke.php(312): CRM_Report_Page_Instance-&gt;run((Array:4), NULL)
  #24 /var/www/html/Dash/modules/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:14))
  #25 /var/www/html/Dash/modules/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:4))
  #26 /var/www/html/Dash/modules/civicrm/drupal/civicrm.module(489): CRM_Core_Invoke::invoke((Array:4))
  #27 internal function: civicrm_invoke(&quot;report&quot;, &quot;instance&quot;, &quot;42&quot;)
  #28 /var/www/html/Dash/includes/menu.inc(527): call_user_func_array(&quot;civicrm_invoke&quot;, (Array:3))
  #29 /var/www/html/Dash/index.php(21): menu_execute_active_handler()
  #30 {main}
  Sorry but we are not able to provide this at the moment.
  DB Error: unknown error
  Error Details
  Database Error Code: Incorrect key file for table '/tmp/#sql_705_0.MYI'; try to repair it, 126
  Additional Details:
  Array
  (
  [callback] =&gt; Array
  (
  [0] =&gt; CRM_Core_Error
  [1] =&gt; handle
  )</p>
  <pre><code>[code] =&gt; -1
  [message] =&gt; DB Error: unknown error
  [mode] =&gt; 16
  [debug_info] =&gt; SELECT SQL_CALC_FOUND_ROWS GROUP_CONCAT(civicrm_contact_contact_target SEPARATOR ';') as civicrm_contact_contact_target, GROUP_CONCAT(civicrm_contact_contact_source_id SEPARATOR ';') as civicrm_contact_contact_source_id, GROUP_CONCAT(civicrm_contact_contact_assignee_id SEPARATOR ';') as civicrm_contact_contact_assignee_id, GROUP_CONCAT(civicrm_contact_contact_target_id SEPARATOR ';') as civicrm_contact_contact_target_id, civicrm_activity_id, civicrm_activity_source_record_id, civicrm_activity_activity_type_id, civicrm_activity_activity_subject, civicrm_activity_activity_date_time, civicrm_activity_status_id, civicrm_address_state_province_id, civicrm_value_practice_profile_4_custom_22, civicrm_value_activity_wrap_up_1_custom_3, civicrm_value_activity_wrap_up_1_custom_5, civicrm_value_activity_wrap_up_1_custom_7 
  </code></pre>
  <p>FROM civireport_activity_temp_target tar
  GROUP BY civicrm_activity_id  ORDER BY civicrm_activity_activity_date_time ASC, option_value_civireport ASC  LIMIT 0, 50 [nativecode=126 ** Incorrect key file for table '/tmp/#sql_705_0.MYI'; try to repair it]
  [type] =&gt; DB_Error
  [user_info] =&gt; SELECT SQL_CALC_FOUND_ROWS GROUP_CONCAT(civicrm_contact_contact_target SEPARATOR ';') as civicrm_contact_contact_target, GROUP_CONCAT(civicrm_contact_contact_source_id SEPARATOR ';') as civicrm_contact_contact_source_id, GROUP_CONCAT(civicrm_contact_contact_assignee_id SEPARATOR ';') as civicrm_contact_contact_assignee_id, GROUP_CONCAT(civicrm_contact_contact_target_id SEPARATOR ';') as civicrm_contact_contact_target_id, civicrm_activity_id, civicrm_activity_source_record_id, civicrm_activity_activity_type_id, civicrm_activity_activity_subject, civicrm_activity_activity_date_time, civicrm_activity_status_id, civicrm_address_state_province_id, civicrm_value_practice_profile_4_custom_22, civicrm_value_activity_wrap_up_1_custom_3, civicrm_value_activity_wrap_up_1_custom_5, civicrm_value_activity_wrap_up_1_custom_7
  FROM civireport_activity_temp_target tar
  GROUP BY civicrm_activity_id  ORDER BY civicrm_activity_activity_date_time ASC, option_value_civireport ASC  LIMIT 0, 50 [nativecode=126 ** Incorrect key file for table '/tmp/#sql_705_0.MYI'; try to repair it]
  [to_string] =&gt; [db_error: message=&quot;DB Error: unknown error&quot; code=-1 mode=callback callback=CRM_Core_Error::handle prefix=&quot;&quot; info=&quot;SELECT SQL_CALC_FOUND_ROWS GROUP_CONCAT(civicrm_contact_contact_target SEPARATOR ';') as civicrm_contact_contact_target, GROUP_CONCAT(civicrm_contact_contact_source_id SEPARATOR ';') as civicrm_contact_contact_source_id, GROUP_CONCAT(civicrm_contact_contact_assignee_id SEPARATOR ';') as civicrm_contact_contact_assignee_id, GROUP_CONCAT(civicrm_contact_contact_target_id SEPARATOR ';') as civicrm_contact_contact_target_id, civicrm_activity_id, civicrm_activity_source_record_id, civicrm_activity_activity_type_id, civicrm_activity_activity_subject, civicrm_activity_activity_date_time, civicrm_activity_status_id, civicrm_address_state_province_id, civicrm_value_practice_profile_4_custom_22, civicrm_value_activity_wrap_up_1_custom_3, civicrm_value_activity_wrap_up_1_custom_5, civicrm_value_activity_wrap_up_1_custom_7
  FROM civireport_activity_temp_target tar
  GROUP BY civicrm_activity_id  ORDER BY civicrm_activity_activity_date_time ASC, option_value_civireport ASC  LIMIT 0, 50 [nativecode=126 ** Incorrect key file for table '/tmp/#sql_705_0.MYI'; try to repair it]&quot;]
  )
  Return to home page.</p>
  
Tags: <civireport><civicrm-home>
Title: Receiving errors when running reports. "Sorry but we are not able to provide this at the moment."
ThreadText: # Receiving errors when running reports. "Sorry but we are not able to provide this at the moment."
  
  (Asked by: username_0 on 2021-11-10)
  
  Drupal 7.41
  CiviCRM 4.6.6
  
  We are using an older version of CiviCRM and are randomly starting to get "Sorry but we are not able to provide this at the moment." when running certain reports.
  
  I enabled backtrace and debugging. Below are the results.
  
  Any help would be appreciated. This happens randomly but is happening more and more often now.
  
  backTrace
  
  #0 /var/www/html/Dash/modules/civicrm/CRM/Core/Error.php(182): CRM\_Core\_Error::backtrace()
  #1 internal function: CRM\_Core\_Error::handle(Object(DB\_Error))
  #2 /var/www/html/Dash/modules/civicrm/packages/PEAR.php(931): call\_user\_func((Array:2), Object(DB\_Error))
  #3 /var/www/html/Dash/modules/civicrm/packages/DB.php(976): PEAR\_Error->PEAR\_Error("DB Error: unknown error", -1, 16, (Array:2), "SELECT SQL\_CALC\_FOUND\_ROWS GROUP\_CONCAT(civicrm\_contact\_contact\_target SEPARA...")
  #4 /var/www/html/Dash/modules/civicrm/packages/PEAR.php(564): DB\_Error->DB\_Error(-1, 16, (Array:2), "SELECT SQL\_CALC\_FOUND\_ROWS GROUP\_CONCAT(civicrm\_contact\_contact\_target SEPARA...")
  #5 /var/www/html/Dash/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -1, NULL, NULL, "SELECT SQL\_CALC\_FOUND\_ROWS GROUP\_CONCAT(civicrm\_contact\_contact\_target SEPARA...", "DB\_Error", TRUE)
  #6 /var/www/html/Dash/modules/civicrm/packages/DB/mysql.php(899): DB\_common->raiseError(-1, NULL, NULL, NULL, "126 \*\* Incorrect key file for table '/tmp/#sql\_705\_0.MYI'; try to repair it")
  #7 /var/www/html/Dash/modules/civicrm/packages/DB/mysql.php(328): DB\_mysql->mysqlRaiseError()
  #8 /var/www/html/Dash/modules/civicrm/packages/DB/common.php(1216): DB\_mysql->simpleQuery("SELECT SQL\_CALC\_FOUND\_ROWS GROUP\_CONCAT(civicrm\_contact\_contact\_target SEPARA...")
  #9 /var/www/html/Dash/modules/civicrm/packages/DB/DataObject.php(2442): DB\_common->query("SELECT SQL\_CALC\_FOUND\_ROWS GROUP\_CONCAT(civicrm\_contact\_contact\_target SEPARA...")
  #10 /var/www/html/Dash/modules/civicrm/packages/DB/DataObject.php(1634): DB\_DataObject->\_query("SELECT SQL\_CALC\_FOUND\_ROWS GROUP\_CONCAT(civicrm\_contact\_contact\_target SEPARA...")
  #11 /var/www/html/Dash/modules/civicrm/CRM/Core/DAO.php(325): DB\_DataObject->query("SELECT SQL\_CALC\_FOUND\_ROWS GROUP\_CONCAT(civicrm\_contact\_contact\_target SEPARA...")
  #12 /var/www/html/Dash/modules/civicrm/CRM/Core/DAO.php(1179): CRM\_Core\_DAO->query("SELECT SQL\_CALC\_FOUND\_ROWS GROUP\_CONCAT(civicrm\_contact\_contact\_target SEPARA...", TRUE)
  #13 /var/www/html/Dash/modules/civicrm/CRM/Report/Form.php(2776): CRM\_Core\_DAO::executeQuery("SELECT SQL\_CALC\_FOUND\_ROWS GROUP\_CONCAT(civicrm\_contact\_contact\_target SEPARA...")
  #14 /var/www/html/Dash/modules/civicrm/CRM/Report/Form/Activity.php(763): CRM\_Report\_Form->buildRows("SELECT SQL\_CALC\_FOUND\_ROWS GROUP\_CONCAT(civicrm\_contact\_contact\_target SEPARA...", (Array:0))
  #15 /var/www/html/Dash/modules/civicrm/CRM/Report/Form.php(753): CRM\_Report\_Form\_Activity->postProcess()
  #16 /var/www/html/Dash/modules/civicrm/CRM/Core/Form.php(455): CRM\_Report\_Form->preProcess()
  #17 /var/www/html/Dash/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(94): CRM\_Core\_Form->buildForm()
  #18 /var/www/html/Dash/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM\_Core\_QuickForm\_Action\_Display->perform(Object(CRM\_Report\_Form\_Activity), "display")
  #19 /var/www/html/Dash/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML\_QuickForm\_Controller->handle(Object(CRM\_Report\_Form\_Activity), "display")
  #20 /var/www/html/Dash/modules/civicrm/CRM/Core/Controller.php(353): HTML\_QuickForm\_Page->handle("display")
  #21 /var/www/html/Dash/modules/civicrm/CRM/Utils/Wrapper.php(115): CRM\_Core\_Controller->run()
  #22 /var/www/html/Dash/modules/civicrm/CRM/Report/Page/Instance.php(101): CRM\_Utils\_Wrapper->run("CRM\_Report\_Form\_Activity", NULL, NULL)
  #23 /var/www/html/Dash/modules/civicrm/CRM/Core/Invoke.php(312): CRM\_Report\_Page\_Instance->run((Array:4), NULL)
  #24 /var/www/html/Dash/modules/civicrm/CRM/Core/Invoke.php(86): CRM\_Core\_Invoke::runItem((Array:14))
  #25 /var/www/html/Dash/modules/civicrm/CRM/Core/Invoke.php(54): CRM\_Core\_Invoke::\_invoke((Array:4))
  #26 /var/www/html/Dash/modules/civicrm/drupal/civicrm.module(489): CRM\_Core\_Invoke::invoke((Array:4))
  #27 internal function: civicrm\_invoke("report", "instance", "42")
  #28 /var/www/html/Dash/includes/menu.inc(527): call\_user\_func\_array("civicrm\_invoke", (Array:3))
  #29 /var/www/html/Dash/index.php(21): menu\_execute\_active\_handler()
  #30 {main}
  Sorry but we are not able to provide this at the moment.
  DB Error: unknown error
  Error Details
  Database Error Code: Incorrect key file for table '/tmp/#sql\_705\_0.MYI'; try to repair it, 126
  Additional Details:
  Array
  (
  [callback] => Array
  (
  [0] => CRM\_Core\_Error
  [1] => handle
  )
  
  ```
  [code] => -1
  [message] => DB Error: unknown error
  [mode] => 16
  [debug_info] => SELECT SQL_CALC_FOUND_ROWS GROUP_CONCAT(civicrm_contact_contact_target SEPARATOR ';') as civicrm_contact_contact_target, GROUP_CONCAT(civicrm_contact_contact_source_id SEPARATOR ';') as civicrm_contact_contact_source_id, GROUP_CONCAT(civicrm_contact_contact_assignee_id SEPARATOR ';') as civicrm_contact_contact_assignee_id, GROUP_CONCAT(civicrm_contact_contact_target_id SEPARATOR ';') as civicrm_contact_contact_target_id, civicrm_activity_id, civicrm_activity_source_record_id, civicrm_activity_activity_type_id, civicrm_activity_activity_subject, civicrm_activity_activity_date_time, civicrm_activity_status_id, civicrm_address_state_province_id, civicrm_value_practice_profile_4_custom_22, civicrm_value_activity_wrap_up_1_custom_3, civicrm_value_activity_wrap_up_1_custom_5, civicrm_value_activity_wrap_up_1_custom_7 
  
  ```
  
  FROM civireport\_activity\_temp\_target tar
  GROUP BY civicrm\_activity\_id ORDER BY civicrm\_activity\_activity\_date\_time ASC, option\_value\_civireport ASC LIMIT 0, 50 [nativecode=126 \*\* Incorrect key file for table '/tmp/#sql\_705\_0.MYI'; try to repair it]
  [type] => DB\_Error
  [user\_info] => SELECT SQL\_CALC\_FOUND\_ROWS GROUP\_CONCAT(civicrm\_contact\_contact\_target SEPARATOR ';') as civicrm\_contact\_contact\_target, GROUP\_CONCAT(civicrm\_contact\_contact\_source\_id SEPARATOR ';') as civicrm\_contact\_contact\_source\_id, GROUP\_CONCAT(civicrm\_contact\_contact\_assignee\_id SEPARATOR ';') as civicrm\_contact\_contact\_assignee\_id, GROUP\_CONCAT(civicrm\_contact\_contact\_target\_id SEPARATOR ';') as civicrm\_contact\_contact\_target\_id, civicrm\_activity\_id, civicrm\_activity\_source\_record\_id, civicrm\_activity\_activity\_type\_id, civicrm\_activity\_activity\_subject, civicrm\_activity\_activity\_date\_time, civicrm\_activity\_status\_id, civicrm\_address\_state\_province\_id, civicrm\_value\_practice\_profile\_4\_custom\_22, civicrm\_value\_activity\_wrap\_up\_1\_custom\_3, civicrm\_value\_activity\_wrap\_up\_1\_custom\_5, civicrm\_value\_activity\_wrap\_up\_1\_custom\_7
  FROM civireport\_activity\_temp\_target tar
  GROUP BY civicrm\_activity\_id ORDER BY civicrm\_activity\_activity\_date\_time ASC, option\_value\_civireport ASC LIMIT 0, 50 [nativecode=126 \*\* Incorrect key file for table '/tmp/#sql\_705\_0.MYI'; try to repair it]
  [to\_string] => [db\_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM\_Core\_Error::handle prefix="" info="SELECT SQL\_CALC\_FOUND\_ROWS GROUP\_CONCAT(civicrm\_contact\_contact\_target SEPARATOR ';') as civicrm\_contact\_contact\_target, GROUP\_CONCAT(civicrm\_contact\_contact\_source\_id SEPARATOR ';') as civicrm\_contact\_contact\_source\_id, GROUP\_CONCAT(civicrm\_contact\_contact\_assignee\_id SEPARATOR ';') as civicrm\_contact\_contact\_assignee\_id, GROUP\_CONCAT(civicrm\_contact\_contact\_target\_id SEPARATOR ';') as civicrm\_contact\_contact\_target\_id, civicrm\_activity\_id, civicrm\_activity\_source\_record\_id, civicrm\_activity\_activity\_type\_id, civicrm\_activity\_activity\_subject, civicrm\_activity\_activity\_date\_time, civicrm\_activity\_status\_id, civicrm\_address\_state\_province\_id, civicrm\_value\_practice\_profile\_4\_custom\_22, civicrm\_value\_activity\_wrap\_up\_1\_custom\_3, civicrm\_value\_activity\_wrap\_up\_1\_custom\_5, civicrm\_value\_activity\_wrap\_up\_1\_custom\_7
  FROM civireport\_activity\_temp\_target tar
  GROUP BY civicrm\_activity\_id ORDER BY civicrm\_activity\_activity\_date\_time ASC, option\_value\_civireport ASC LIMIT 0, 50 [nativecode=126 \*\* Incorrect key file for table '/tmp/#sql\_705\_0.MYI'; try to repair it]"]
  )
  Return to home page.
  
  **Tags:** civireport, civicrm-home
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2021-11-10. Score: 1
  
  Just a directory filling up. Deleted some unused files and the error went away.
  
  
  ---
  
  