Answers.Body: <p>This is down to the fact that you probably have logging turned on in your Drupal environment. So the easiest thing to do would be to turn it off before you migrate and turn it back on in Wordpress (Administer -&gt; Misc -&gt; Logging). If you cant do that (or it still doesn't work) then you have a couple of 'hacks' to make get to the point that you can at least get to the settings, including dropping the database triggers on the settings table, and any subsequent tables, until you get to the home page and to the logging page. But I would turn off at the source, thats the easiest approach.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-09-07T19:12:23.970Z
Answers.Text: Excellent, thanks for offering a couple different routes.  Turning it off at the source did work.
Answers.UserDisplayName: Ken Williams
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-09-06T23:19:35.083Z
Answers.LastActivityDate: 2020-09-06T23:19:35.083Z
Answers.UserDisplayName: Parvez Saleh
Body: <p>I'm following the methodology at <a href="https://docs.civicrm.org/sysadmin/en/latest/misc/switching-cms/drupal-to-wordpress/" rel="nofollow noreferrer">https://docs.civicrm.org/sysadmin/en/latest/misc/switching-cms/drupal-to-wordpress/</a> to migrate from Drupal to WordPress.  After importing the database tables to the WordPress site, I get the error <code>DB Error: no such table</code> in the browser when I try to access the CiviCRM front page.</p>
  <p>In the <code>wp-content/uploads/civicrm/ConfigAndLog/CiviCRM.f00.log</code>, I see the following:</p>
  <pre><code>Sep 06 22:24:15  [error] $Fatal Error Details = Array
  (
      [callback] =&gt; Array
          (
              [0] =&gt; CRM_Core_Error
              [1] =&gt; handle
          )
  
      [code] =&gt; -18
      [message] =&gt; DB Error: no such table
      [mode] =&gt; 16
      [debug_info] =&gt; INSERT INTO civicrm_setting (`component_id`,`contact_id`,`created_date`,`created_id`,`domain_id`,`id`,`is_domain`,`name`,`value`) VALUES
  (NULL,NULL,&quot;20200906222415&quot;,NULL,&quot;1&quot;,NULL,&quot;1&quot;,&quot;wpLoadPhp&quot;,&quot;s:34:\&quot;/home/singersin/www/wp/wp-load.php\&quot;;&quot;)
   [nativecode=1146 ** Table 'singersin_wp1234.log_civicrm_setting' doesn't exist]
      [type] =&gt; DB_Error
      [user_info] =&gt; INSERT INTO civicrm_setting (`component_id`,`contact_id`,`created_date`,`created_id`,`domain_id`,`id`,`is_domain`,`name`,`value`) VALUES
  (NULL,NULL,&quot;20200906222415&quot;,NULL,&quot;1&quot;,NULL,&quot;1&quot;,&quot;wpLoadPhp&quot;,&quot;s:34:\&quot;/home/singersin/www/wp/wp-load.php\&quot;;&quot;)
   [nativecode=1146 ** Table 'singersin_wp1234.log_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::handle prefix=&quot;&quot; info=&quot;INSERT INTO civicrm_setting (`component_id`,`contact_id`,`created_date`,`created_id`,`domain_id`,`id`,`is_domain`,`name`,`value`) VALUES
  (NULL,NULL,&quot;20200906222415&quot;,NULL,&quot;1&quot;,NULL,&quot;1&quot;,&quot;wpLoadPhp&quot;,&quot;s:34:\&quot;/home/singersin/www/wp/wp-load.php\&quot;;&quot;)
   [nativecode=1146 ** Table 'singersin_wp1234.log_civicrm_setting' doesn't exist]&quot;]
  )
  </code></pre>
  <p>What puzzles me: why is it looking for a table called <code>log_civicrm_setting</code> when it's doing <code>INSERT INTO civicrm_setting</code>?  There is a table called <code>civicrm_setting</code>, all CiviCRM tables are prefixed with <code>civicrm_</code> in this installation.</p>
  
Tags: <wordpress><database><migration>
Title: Migrate from Drupal to WordPress - 'DB Error: no such table'
ThreadText: # Migrate from Drupal to WordPress - 'DB Error: no such table'
  
  (Asked by: username_0 on 2020-09-06)
  
  I'm following the methodology at https://docs.civicrm.org/sysadmin/en/latest/misc/switching-cms/drupal-to-wordpress/ to migrate from Drupal to WordPress.  After importing the database tables to the WordPress site, I get the error DB Error: no such table in the browser when I try to access the CiviCRM front page.
  In the wp-content/uploads/civicrm/ConfigAndLog/CiviCRM.f00.log, I see the following:
  Sep 06 22:24:15  [error] $Fatal Error Details = Array
  (
      [callback] => Array
          (
              [0] => CRM_Core_Error
              [1] => handle
          )
  
      [code] => -18
      [message] => DB Error: no such table
      [mode] => 16
      [debug_info] => INSERT INTO civicrm_setting (`component_id`,`contact_id`,`created_date`,`created_id`,`domain_id`,`id`,`is_domain`,`name`,`value`) VALUES
  (NULL,NULL,"20200906222415",NULL,"1",NULL,"1","wpLoadPhp","s:34:\"/home/singersin/www/wp/wp-load.php\";")
   [nativecode=1146 ** Table 'singersin_wp1234.log_civicrm_setting' doesn't exist]
      [type] => DB_Error
      [user_info] => INSERT INTO civicrm_setting (`component_id`,`contact_id`,`created_date`,`created_id`,`domain_id`,`id`,`is_domain`,`name`,`value`) VALUES
  (NULL,NULL,"20200906222415",NULL,"1",NULL,"1","wpLoadPhp","s:34:\"/home/singersin/www/wp/wp-load.php\";")
   [nativecode=1146 ** Table 'singersin_wp1234.log_civicrm_setting' doesn't exist]
      [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_setting (`component_id`,`contact_id`,`created_date`,`created_id`,`domain_id`,`id`,`is_domain`,`name`,`value`) VALUES
  (NULL,NULL,"20200906222415",NULL,"1",NULL,"1","wpLoadPhp","s:34:\"/home/singersin/www/wp/wp-load.php\";")
   [nativecode=1146 ** Table 'singersin_wp1234.log_civicrm_setting' doesn't exist]"]
  )
  
  What puzzles me: why is it looking for a table called log_civicrm_setting when it's doing INSERT INTO civicrm_setting?  There is a table called civicrm_setting, all CiviCRM tables are prefixed with civicrm_ in this installation.
  
  **Tags:** wordpress, database, migration
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2020-09-06. Score: 4 | Accepted answer
  
  This is down to the fact that you probably have logging turned on in your Drupal environment. So the easiest thing to do would be to turn it off before you migrate and turn it back on in Wordpress (Administer -> Misc -> Logging). If you cant do that (or it still doesn't work) then you have a couple of 'hacks' to make get to the point that you can at least get to the settings, including dropping the database triggers on the settings table, and any subsequent tables, until you get to the home page and to the logging page. But I would turn off at the source, thats the easiest approach.
  
  > **Comments:**
  > **username_0**: Excellent, thanks for offering a couple different routes.  Turning it off at the source did work.  
  
  ---
  
  