Answers.Body: <p>There are a few questions combined here I think. From what you describe there may be other problems afoot, but hopefully these two suggestions may help you make some progress.</p>
  
  <p><strong>Why do I see the error <code>DB Error: no such field</code> with <code>Unknown column 'civicrm_uf_group.description' in 'field list'</code>?</strong></p>
  
  <p>It sounds like your source and destination CiviCRM may be different versions. Check the codebase of your source and destination CiviCRM and if the destination is newer, make them match.</p>
  
  <p>Up to you whether to run the upgrader on the source before migration or on the destination afterwards. <em>It may be as simple as visiting the CiviCRM upgrade URL on the destination server.</em></p>
  
  <p><strong>Why doesn't the DB migrate when I exclude those tables?</strong></p>
  
  <p>The docs actually say <em>If copying an existing install don't skip the cache tables they will not be created automatically</em>, so you should NOT exclude those tables if you are migrating CiviCRM to a new server.</p>
  
  <p>(It looks like the docs could be improved there, they give different-yet-kinda-identical advice for dumping Drupal and Joomla and don't mention how to deal with WordPress?)</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-11T01:25:12.437Z
Answers.LastActivityDate: 2015-06-11T03:18:40.637Z
Answers.LastEditDate: 2015-06-11T03:18:40.637Z
Answers.UserDisplayName: Chris Burgess
Body: <p>What's the best way to migrate CiviCRM to a new a server? I haven't been able to get it to work. I've been following this <a href="http://wiki.civicrm.org/confluence/display/CRMDOC/Moving+an+Existing+Installation+to+a+New+Server+or+Location" rel="nofollow">guide</a>. Here are the steps I've been taking to for the migration.</p>
  
  <p>1.) SQLDump and exclude the flowing tables in old database.</p>
  
  <p>db_name.civicrm_domain</p>
  
  <p>db_name.civicrm_acl_cache</p>
  
  <p>db_name.civicrm_acl_contact_cache</p>
  
  <p>db_name.civicrm_cache
  db_name.civicrm_group_contact_cache</p>
  
  <p>2.) Setup new CMS (WordPress, Joomla or Drupal) I have tried all three platforms</p>
  
  <p>3.) SQLDump old database into new</p>
  
  <p>2.) Clear cache and rebuild menus</p>
  
  <p>I know that I must be missing steps. Here are some of the problems I'm running into:</p>
  
  <p>1.) There is a problem when trying to run custom reports that repopulate after rebuilding the menu. The message I get is (error: You have tried to access a report that does not exist.) Where do you find custom reports made on the old system? Whats the best way to transfer them, copy paste?</p>
  
  <p>2.) When clicking a a link on the menu or running search I get this (error: DB:no such field).</p>
  
  <p>I'm guessing that when I transfer the custom templates/reports (not sure the proper nomenclature) the database error will resolve itself?</p>
  
  <p>Here is the database error from the CiviCRM error log:</p>
  
  <pre><code>[code] =&gt; -19
  [message] =&gt; DB Error: no such field
  [mode] =&gt; 16
  [debug_info] =&gt; SELECT civicrm_uf_group.id, civicrm_uf_group.title, civicrm_uf_group.created_id, civicrm_uf_group.is_active, civicrm_uf_group.is_reserved, civicrm_uf_group.group_type, civicrm_uf_group.description
                      FROM civicrm_uf_group
                      LEFT JOIN civicrm_uf_join ON (civicrm_uf_group.id = uf_group_id) AND civicrm_uf_group.is_active = 1
                            WHERE civicrm_uf_join.module = 'Search Profile' ORDER BY civicrm_uf_join.weight, civicrm_uf_group.title [nativecode=1054 ** Unknown column 'civicrm_uf_group.description' in 'field list']
  </code></pre>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-06-10T22:54:27.020Z
Comments.Text: Are you using the same exact versions of civi on the old server and the new?  Can you look on the old server and see if the column "description" exists in the civicrm_uf_group table?  The error message says it doesn't exist on the new server or it is having issues reading it.
Comments.UserDisplayName: Paul-Tahoe
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-06-11T01:29:04.760Z
Comments.Text: You may improve your answers by giving more detail in your question - eg rather than _SQLDump old database into new_, give the exact command you executed to load the DB on the destination server, and report any errors if shown.
Comments.UserDisplayName: Chris Burgess
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-06-11T01:40:33.460Z
Comments.Text: To compare your versions on each: What version of CiviCRM is installed on the destination server? What does this SQL query show on the source DB? `SELECT version FROM civicrm_domain`
Comments.UserDisplayName: Chris Burgess
Tags: <civireport><database>
Title: Missing fields and reports in database after migrating to a new server
ThreadText: # Missing fields and reports in database after migrating to a new server
  
  (Asked by: username_0 on 2015-06-10)
  
  What's the best way to migrate CiviCRM to a new a server? I haven't been able to get it to work. I've been following this [guide](http://wiki.civicrm.org/confluence/display/CRMDOC/Moving+an+Existing+Installation+to+a+New+Server+or+Location). Here are the steps I've been taking to for the migration.
  
  1.) SQLDump and exclude the flowing tables in old database.
  
  db\_name.civicrm\_domain
  
  db\_name.civicrm\_acl\_cache
  
  db\_name.civicrm\_acl\_contact\_cache
  
  db\_name.civicrm\_cache
  db\_name.civicrm\_group\_contact\_cache
  
  2.) Setup new CMS (WordPress, Joomla or Drupal) I have tried all three platforms
  
  3.) SQLDump old database into new
  
  2.) Clear cache and rebuild menus
  
  I know that I must be missing steps. Here are some of the problems I'm running into:
  
  1.) There is a problem when trying to run custom reports that repopulate after rebuilding the menu. The message I get is (error: You have tried to access a report that does not exist.) Where do you find custom reports made on the old system? Whats the best way to transfer them, copy paste?
  
  2.) When clicking a a link on the menu or running search I get this (error: DB:no such field).
  
  I'm guessing that when I transfer the custom templates/reports (not sure the proper nomenclature) the database error will resolve itself?
  
  Here is the database error from the CiviCRM error log:
  
  ```
  [code] => -19
  [message] => DB Error: no such field
  [mode] => 16
  [debug_info] => SELECT civicrm_uf_group.id, civicrm_uf_group.title, civicrm_uf_group.created_id, civicrm_uf_group.is_active, civicrm_uf_group.is_reserved, civicrm_uf_group.group_type, civicrm_uf_group.description
                      FROM civicrm_uf_group
                      LEFT JOIN civicrm_uf_join ON (civicrm_uf_group.id = uf_group_id) AND civicrm_uf_group.is_active = 1
                            WHERE civicrm_uf_join.module = 'Search Profile' ORDER BY civicrm_uf_join.weight, civicrm_uf_group.title [nativecode=1054 ** Unknown column 'civicrm_uf_group.description' in 'field list']
  
  ```
  
  **Tags:** civireport, database
  
  > **Comments:**
  > **username_1**: Are you using the same exact versions of civi on the old server and the new?  Can you look on the old server and see if the column "description" exists in the civicrm_uf_group table?  The error message says it doesn't exist on the new server or it is having issues reading it.  
  > **username_2**: You may improve your answers by giving more detail in your question - eg rather than _SQLDump old database into new_, give the exact command you executed to load the DB on the destination server, and report any errors if shown.  
  > **username_2**: To compare your versions on each: What version of CiviCRM is installed on the destination server? What does this SQL query show on the source DB? `SELECT version FROM civicrm_domain`  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2015-06-11. Score: 3 | Accepted answer
  
  There are a few questions combined here I think. From what you describe there may be other problems afoot, but hopefully these two suggestions may help you make some progress.
  
  **Why do I see the error `DB Error: no such field` with `Unknown column 'civicrm_uf_group.description' in 'field list'`?**
  
  It sounds like your source and destination CiviCRM may be different versions. Check the codebase of your source and destination CiviCRM and if the destination is newer, make them match.
  
  Up to you whether to run the upgrader on the source before migration or on the destination afterwards. *It may be as simple as visiting the CiviCRM upgrade URL on the destination server.*
  
  **Why doesn't the DB migrate when I exclude those tables?**
  
  The docs actually say *If copying an existing install don't skip the cache tables they will not be created automatically*, so you should NOT exclude those tables if you are migrating CiviCRM to a new server.
  
  (It looks like the docs could be improved there, they give different-yet-kinda-identical advice for dumping Drupal and Joomla and don't mention how to deal with WordPress?)
  
  
  ---
  
  