Answers.Body: <p>For some reason, the back up hadn't recorded the updated version of CiviCRM (it may have happened before I reran the update script) so when I checked the domain table in the back-up just now, it was still showing version 4.7.29. I did a manual back-up AFTER double-checking the domain/version was correct in the WordPress site, then I copied over the database tables again and it's working.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-06-25T11:29:04.750Z
Answers.LastActivityDate: 2018-06-25T11:29:04.750Z
Answers.UserDisplayName: Rose Lanigan
Body: <p>I've been moving a CiviCRM from WordPress to Drupal but getting a strange array of errors.</p>
  
  <p>It's on the same hosting so I've set up a new database for the new CiviCRM, moved all the tables except the 4 cache tables and the domain. I've cleared all the cache, rebuild menus, (attempted) to sync the users (only got about 180 out of 280 but that's a good start).</p>
  
  <p>My problem is that a number of the pages in CiviCRM throw up the 'DB table does not exist' error:
  When I edit/create a contact
  Organisation address and contact info
  The page to edit the navigation menu opens but the triangle is just spinning
  Quick search doesn't work (nothing happens) but Find Contacts does work.</p>
  
  <p>I've turned on the advanced logging, and getting errors like the following:</p>
  
  <pre><code>Notice: Undefined index: frontend_title in CRM_UF_Page_Group-&gt;browse() (line 329 of /home/xxx/www/data/sites/all/modules/civicrm/CRM/UF/Page/Group.php).
  </code></pre>
  
  <p>Any ideas?</p>
  
  <p>Thanks</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-06-25T09:58:20.460Z
Comments.Text: Hi Rose, for the 'DB table does not exist' messages - which tables is it complaining about?  Do those tables actually exist in the db?
Comments.UserDisplayName: Aidan
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-06-25T10:12:58.430Z
Comments.Text: Yes - checked all tables and they're exactly the same as the WordPress site. Actually - thinking out loud - it was also having similar problems at one point because I'd updated the files to 5.2.2 and run the update script and then rolled back to a back-up. Once I'd re-run the update script, it was fine. The update script didn't work for the new site (it was installed as 5.2.2 so just said there was no need to run the script) but I might re-do the installation (they were on different versions when I first installed it - that may have caused the issue?)
Comments.UserDisplayName: Rose Lanigan
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-06-25T10:25:45.587Z
Comments.Text: So, these were the steps I just took:
Comments.UserDisplayName: Rose Lanigan
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-06-25T10:32:57.917Z
Comments.Text: So, these were the steps I just took:
  * delete the database
  * delete the civicrm.settings.php file
  * Re-run the install page for CiviCRM
  * Restore from last night's back-up all tables except the 4 cache tables, domain and uf_match
  
  Also, to clarify (my mistake), the error message says "DB error: no such field"
Comments.UserDisplayName: Rose Lanigan
Tags: <wordpress><drupal><installation>
Title: Moving site from WordPress to Drupal
ThreadText: # Moving site from WordPress to Drupal
  
  (Asked by: username_0 on 2018-06-25)
  
  I've been moving a CiviCRM from WordPress to Drupal but getting a strange array of errors.
  It's on the same hosting so I've set up a new database for the new CiviCRM, moved all the tables except the 4 cache tables and the domain. I've cleared all the cache, rebuild menus, (attempted) to sync the users (only got about 180 out of 280 but that's a good start).
  My problem is that a number of the pages in CiviCRM throw up the 'DB table does not exist' error:
  When I edit/create a contact
  Organisation address and contact info
  The page to edit the navigation menu opens but the triangle is just spinning
  Quick search doesn't work (nothing happens) but Find Contacts does work.
  I've turned on the advanced logging, and getting errors like the following:
  Notice: Undefined index: frontend_title in CRM_UF_Page_Group->browse() (line 329 of /home/xxx/www/data/sites/all/modules/civicrm/CRM/UF/Page/Group.php).
  
  Any ideas?
  Thanks
  
  **Tags:** wordpress, drupal, installation
  
  > **Comments:**
  > **username_1**: Hi Rose, for the 'DB table does not exist' messages - which tables is it complaining about?  Do those tables actually exist in the db?  
  > **username_0**: Yes - checked all tables and they're exactly the same as the WordPress site. Actually - thinking out loud - it was also having similar problems at one point because I'd updated the files to 5.2.2 and run the update script and then rolled back to a back-up. Once I'd re-run the update script, it was fine. The update script didn't work for the new site (it was installed as 5.2.2 so just said there was no need to run the script) but I might re-do the installation (they were on different versions when I first installed it - that may have caused the issue?)  
  > **username_0**: So, these were the steps I just took:  
  > **username_0**: So, these were the steps I just took: * delete the database * delete the civicrm.settings.php file * Re-run the install page for CiviCRM * Restore from last night's back-up all tables except the 4 cache tables, domain and uf_match  Also, to clarify (my mistake), the error message says "DB error: no such field"  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2018-06-25. Score: 3
  
  For some reason, the back up hadn't recorded the updated version of CiviCRM (it may have happened before I reran the update script) so when I checked the domain table in the back-up just now, it was still showing version 4.7.29. I did a manual back-up AFTER double-checking the domain/version was correct in the WordPress site, then I copied over the database tables again and it's working.
  
  
  ---
  
  