Answers.Body: <p>The relevant underlying error is hidden in that long message:</p>
  
  <blockquote>
    <p>** Tablespace is missing for table ieditims.civicrm_setting.</p>
  </blockquote>
  
  <p>I am no expert in database administration but it seems this might be related to a corrupted or missing file of your database system.</p>
  
  <p>If your dev system doesn't have very specific civicrm settings, I would try to delete the table <code>civicrm_setting</code> in an admin tool like phpmyadmin and recreate it afterwards.
  For CiviCRM 4.7.10 the SQL query to create the table would be</p>
  
  <blockquote>
    <p>CREATE TABLE IF NOT EXISTS <code>civicrm_setting</code> (
      <code>id</code> int(10) unsigned NOT NULL AUTO_INCREMENT,
      <code>name</code> varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Unique name for setting',
      <code>value</code> text COLLATE utf8_unicode_ci COMMENT 'data associated with this group / name combo',
      <code>domain_id</code> int(10) unsigned NOT NULL COMMENT 'Which Domain is this menu item for',
      <code>contact_id</code> int(10) unsigned DEFAULT NULL COMMENT 'FK to Contact ID if the setting is localized to a contact',
      <code>is_domain</code> tinyint(4) DEFAULT NULL COMMENT 'Is this setting a contact specific or site wide setting?',
      <code>component_id</code> int(10) unsigned DEFAULT NULL COMMENT 'Component that this menu item belongs to',
      <code>created_date</code> datetime DEFAULT NULL COMMENT 'When was the setting created',
      <code>created_id</code> int(10) unsigned DEFAULT NULL COMMENT 'FK to civicrm_contact, who created this setting',
      PRIMARY KEY (<code>id</code>),
      UNIQUE KEY <code>index_domain_contact_name</code> (<code>domain_id</code>,<code>contact_id</code>,<code>name</code>),
      KEY <code>FK_civicrm_setting_domain_id</code> (<code>domain_id</code>),
      KEY <code>FK_civicrm_setting_contact_id</code> (<code>contact_id</code>),
      KEY <code>FK_civicrm_setting_component_id</code> (<code>component_id</code>),
      KEY <code>FK_civicrm_setting_created_id</code> (<code>created_id</code>)
    ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci</p>
  </blockquote>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-06T11:44:31.627Z
Answers.LastActivityDate: 2016-09-06T11:44:31.627Z
Answers.UserDisplayName: sleidig
Body: <p>i just restarted my PC which has a locally hosted dev version of CiviCRM in WordPress, and now get the following error on initialization...</p>
  
  <pre><code>Initialization Error
  
  Array (
    [callback] =&gt; Array
       (
           [0] =&gt; CRM_Core_Error
           [1] =&gt; simpleHandler
       )
  
    [code] =&gt; -1
    [message] =&gt; DB Error: unknown error
    [mode] =&gt; 16
    [debug_info] =&gt; SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id FROM civicrm_setting
  WHERE (domain_id = 1) AND (is_domain = 1)  [nativecode=1812 **
  Tablespace is missing for table `ieditims`.`civicrm_setting`.]
    [type] =&gt; DB_Error
    [user_info] =&gt; SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id FROM civicrm_setting
  WHERE (domain_id = 1) AND (is_domain = 1)  [nativecode=1812 **
  Tablespace is missing for table `ieditims`.`civicrm_setting`.]
     [to_string] =&gt; [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::simpleHandler prefix=""
   info="SELECT id, name, value, domain_id, contact_id, is_domain,
  component_id, created_date, created_id FROM civicrm_setting WHERE
  (domain_id = 1) AND (is_domain = 1)  [nativecode=1812 ** Tablespace is
  missing for table `ieditims`.`civicrm_setting`.]"]
  </code></pre>
  
  <p>Please help!!!</p>
  
  <p>Joe.</p>
  
Tags: <wordpress><database><error>
Title: DB Error: unknown error (Tablespace is missing for table .civicrm_setting)
ThreadText: # DB Error: unknown error (Tablespace is missing for table .civicrm_setting)
  
  (Asked by: username_0 on 2016-09-06)
  
  i just restarted my PC which has a locally hosted dev version of CiviCRM in WordPress, and now get the following error on initialization...
  Initialization Error
  
  Array (
    [callback] => Array
       (
           [0] => CRM_Core_Error
           [1] => simpleHandler
       )
  
    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id FROM civicrm_setting
  WHERE (domain_id = 1) AND (is_domain = 1)  [nativecode=1812 **
  Tablespace is missing for table `ieditims`.`civicrm_setting`.]
    [type] => DB_Error
    [user_info] => SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id FROM civicrm_setting
  WHERE (domain_id = 1) AND (is_domain = 1)  [nativecode=1812 **
  Tablespace is missing for table `ieditims`.`civicrm_setting`.]
     [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::simpleHandler prefix=""
   info="SELECT id, name, value, domain_id, contact_id, is_domain,
  component_id, created_date, created_id FROM civicrm_setting WHERE
  (domain_id = 1) AND (is_domain = 1)  [nativecode=1812 ** Tablespace is
  missing for table `ieditims`.`civicrm_setting`.]"]
  
  Please help!!!
  Joe.
  
  **Tags:** wordpress, database, error
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-09-06. Score: 1
  
  The relevant underlying error is hidden in that long message:
  
  > \*\* Tablespace is missing for table ieditims.civicrm\_setting.
  
  I am no expert in database administration but it seems this might be related to a corrupted or missing file of your database system.
  
  If your dev system doesn't have very specific civicrm settings, I would try to delete the table `civicrm_setting` in an admin tool like phpmyadmin and recreate it afterwards.
  For CiviCRM 4.7.10 the SQL query to create the table would be
  
  > CREATE TABLE IF NOT EXISTS `civicrm_setting` (
  > `id` int(10) unsigned NOT NULL AUTO\_INCREMENT,
  > `name` varchar(255) COLLATE utf8\_unicode\_ci DEFAULT NULL COMMENT 'Unique name for setting',
  > `value` text COLLATE utf8\_unicode\_ci COMMENT 'data associated with this group / name combo',
  > `domain_id` int(10) unsigned NOT NULL COMMENT 'Which Domain is this menu item for',
  > `contact_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to Contact ID if the setting is localized to a contact',
  > `is_domain` tinyint(4) DEFAULT NULL COMMENT 'Is this setting a contact specific or site wide setting?',
  > `component_id` int(10) unsigned DEFAULT NULL COMMENT 'Component that this menu item belongs to',
  > `created_date` datetime DEFAULT NULL COMMENT 'When was the setting created',
  > `created_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to civicrm\_contact, who created this setting',
  > PRIMARY KEY (`id`),
  > UNIQUE KEY `index_domain_contact_name` (`domain_id`,`contact_id`,`name`),
  > KEY `FK_civicrm_setting_domain_id` (`domain_id`),
  > KEY `FK_civicrm_setting_contact_id` (`contact_id`),
  > KEY `FK_civicrm_setting_component_id` (`component_id`),
  > KEY `FK_civicrm_setting_created_id` (`created_id`)
  > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8\_unicode\_ci
  
  
  ---
  
  