Answers.Body: <p>Verify that your CiviCRM settings file <code>web/sites/default/civicrm.settings.php</code>
  is correct. If you are using a separate CiviCRM database (i.e., not using the same database as drupal), this may need to be adjusted and / or deleted and reinstalled.</p>
  <p>Also verify the MySQL user has super priveledges.  You should NOT be using root in MySQL, but instead should have a separate user account.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-07T18:15:21.213Z
Answers.LastActivityDate: 2022-04-07T18:15:21.213Z
Answers.UserDisplayName: Greyson
Body: <p>I drupal version 9.3.5 I have installed CiviCRM 5.47.3 plugin using composer in the centos 8 servers.</p>
  <p>After installing CiviCRM on the server CiviCRM plugin is enabled automatically in the admin extension section</p>
  <p>But after configuring CiviCRM no page is loading and facing the below error,</p>
  <pre><code>Initialization Error
  
  Array
  (
      [callback] =&gt; Array
          (
              [0] =&gt; CRM_Core_Error
              [1] =&gt; simpleHandler
          )
  
      [code] =&gt; -18
      [message] =&gt; DB Error: no such table
      [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=1146 ** Table 'civicrm_cidd.civicrm_setting' doesn't exist]
      [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=1146 ** Table 'civicrm_cidd.civicrm_setting' doesn't exist]
      [to_string] =&gt; [db_error: message=&quot;DB Error: no such table&quot; code=-18 mode=callback callback=CRM_Core_Error::simpleHandler prefix=&quot;&quot; info=&quot;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=1146 ** Table 'civicrm_cidd.civicrm_setting' doesn't exist]&quot;]
  )
  </code></pre>
  <p>I installed CiviCRM by referring to the below link <a href="https://docs.civicrm.org/installation/en/latest/drupal8/" rel="nofollow noreferrer">https://docs.civicrm.org/installation/en/latest/drupal8/</a></p>
  <p>PHP version is v8.0.27</p>
  <p>any guide is appreciated if need any more details please comment</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-04-07T00:24:54.317Z
Comments.Text: are your civi tables in same db as drupal or not. if not, did you do the additional steps required for that scenario?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-04-07T06:54:01.153Z
Comments.Text: No, I am using the separate DB for CiviCRM and drupal configuration and notables were available in the CiviCRM database. When I navigate to the CiviCRM installation page I am getting the above error. Can you please guide us on how we can install the CiviCRM configuration?
Comments.UserDisplayName: Rajesh Baskaran
Tags: <installation>
Title: "[message] => DB Error: no such table" error after installing civicrm
ThreadText: # "[message] => DB Error: no such table" error after installing civicrm
  
  (Asked by: username_0 on 2022-04-06)
  
  I drupal version 9.3.5 I have installed CiviCRM 5.47.3 plugin using composer in the centos 8 servers.
  After installing CiviCRM on the server CiviCRM plugin is enabled automatically in the admin extension section
  But after configuring CiviCRM no page is loading and facing the below error,
  Initialization Error
  
  Array
  (
      [callback] => Array
          (
              [0] => CRM_Core_Error
              [1] => simpleHandler
          )
  
      [code] => -18
      [message] => DB Error: no such table
      [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=1146 ** Table 'civicrm_cidd.civicrm_setting' doesn't exist]
      [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=1146 ** Table 'civicrm_cidd.civicrm_setting' doesn't exist]
      [to_string] => [db_error: message="DB Error: no such table" code=-18 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=1146 ** Table 'civicrm_cidd.civicrm_setting' doesn't exist]"]
  )
  
  I installed CiviCRM by referring to the below link https://docs.civicrm.org/installation/en/latest/drupal8/
  PHP version is v8.0.27
  any guide is appreciated if need any more details please comment
  
  **Tags:** installation
  
  > **Comments:**
  > **username_1**: are your civi tables in same db as drupal or not. if not, did you do the additional steps required for that scenario?  
  > **username_0**: No, I am using the separate DB for CiviCRM and drupal configuration and notables were available in the CiviCRM database. When I navigate to the CiviCRM installation page I am getting the above error. Can you please guide us on how we can install the CiviCRM configuration?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2022-04-07. Score: 0
  
  Verify that your CiviCRM settings file `web/sites/default/civicrm.settings.php`
  is correct. If you are using a separate CiviCRM database (i.e., not using the same database as drupal), this may need to be adjusted and / or deleted and reinstalled.
  
  Also verify the MySQL user has super priveledges. You should NOT be using root in MySQL, but instead should have a separate user account.
  
  
  ---
  
  