Answers.Body: <p>Which version did your database come from? I could imagine your report still tries to retrieve the assignee contact id from the table civicrm_activity_assignment (prior to CiviCRM version 4.4) rather than from civicrm_activity_contact?</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-25T13:06:25.620Z
Answers.Text: Thank you, we are coming 4.1 so I believe this to be the problem. What's the best way to correct this issue?
Answers.UserDisplayName: Sean
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-25T13:27:47.093Z
Answers.Text: Is the report a customized one? If so, you will need to adapt it to retrieve the assignee from the table civicrm_activity_contact with a specific record_type. If it was based on the core activity summary report, I would start by creating a new report from that template?
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-25T13:45:42.663Z
Answers.Text: It's a custom template, in order to retrieve the assignee from the table civicrm_activity_contact, do I need to edit the core or can this be done through the database?
Answers.UserDisplayName: Sean
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-25T14:01:04.927Z
Answers.Text: You should not edit the core in any circumstance :-) If it is a custom template you will have to edit it or get it edited? It should not be a big job, are you able to do that yourself?
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-25T14:10:22.393Z
Answers.Text: I think I can poke around enough to figure it out. It's all about trial and error. Thanks again for your help. I will dig deeper into it.
Answers.UserDisplayName: Sean
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-25T14:44:17.240Z
Answers.Text: The problem will probably be in the query in the $sql variable. It will probably try to access the file civicrm_activity_assignee, and possibly the civicrm_activity_target. Both are now in civicrm_activity_contact with record_type 1 = assignee and record_type 3 = target
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-25T06:27:09.663Z
Answers.LastActivityDate: 2015-06-25T06:27:09.663Z
Answers.UserDisplayName: ErikH - CiviCooP
Answers.Body: <p>Since your codebase has been upgraded, and your question doesn't mention running the upgrader as part of this, make sure you've followed the upgrade instructions (as best as they can apply after a server crash).</p>
  
  <ul>
  <li>For Drupal, visit <code>?q=civicrm/upgrade&amp;reset=1</code> or <code>civicrm/upgrade?reset=1</code></li>
  <li>For WordPress, visit <code>wp-admin/admin.php?page=CiviCRM&amp;q=civicrm/upgrade&amp;reset=1</code></li>
  <li>For Joomla, visit <code>/administrator/index.php?option=com_civicrm&amp;task=civicrm/upgrade&amp;reset=1</code></li>
  </ul>
  
  <p>For upgrade documentation, refer to <a href="http://wiki.civicrm.org/confluence/display/CRMDOC/Installation+and+Upgrades" rel="nofollow">the upgrade documentation page for your CMS</a>. If your replacement server differs from your previous one, also review documentation for <a href="http://wiki.civicrm.org/confluence/display/CRMDOC/Moving+an+Existing+Installation+to+a+New+Server+or+Location" rel="nofollow">moving an existing installation to a new server or location</a>.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-25T00:44:49.017Z
Answers.Text: Thank you for the quick response, I get this error when I try to upgrade and reset: Sorry but we are not able to provide this at the moment.
  Your database has already been upgraded to CiviCRM 4.6.3
Answers.UserDisplayName: Sean
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-25T01:16:33.770Z
Answers.Text: If you can [turn on debugging](http://wiki.civicrm.org/confluence/display/CRMDOC/Debugging+for+developers#Debuggingfordevelopers-EnableDebugging) that will help you see the error. Otherwise there is a CiviCRM log file (see "log files" in linked page) in your installation which records the error message. You'll need to make sense of this error message to identify the unexpected/incorrectly named DB column.
Answers.UserDisplayName: Chris Burgess
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-24T23:47:28.490Z
Answers.LastActivityDate: 2015-06-24T23:47:28.490Z
Answers.UserDisplayName: Chris Burgess
Body: <p>We had to restore a database from server crash to a newer version CiviCRM (4.6.3). We have gotten most of the data moved over but this one has us stumped. We have been getting the error "DB Error: no such field" when we have the "Assignee Contact Email" checked in the Activity Report-Template. </p>
  
  <p>I have gone through and compared the tables: <strong>civicrm_activity</strong> and <strong>civicrm_activity_contact</strong> to a fresh install of CiviCRM 4.6.3. All Columns, Indexes and Foreign Keys seem to be identical.</p>
  
  <p>Is there some other place I should be checking?</p>
  
  <p>Thanks again for everyone's help!</p>
  
Tags: <database>
Title: DB Error: no such field : Assignee Contact Email
ThreadText: # DB Error: no such field : Assignee Contact Email
  
  (Asked by: username_0 on 2015-06-24)
  
  We had to restore a database from server crash to a newer version CiviCRM (4.6.3). We have gotten most of the data moved over but this one has us stumped. We have been getting the error "DB Error: no such field" when we have the "Assignee Contact Email" checked in the Activity Report-Template.
  
  I have gone through and compared the tables: **civicrm\_activity** and **civicrm\_activity\_contact** to a fresh install of CiviCRM 4.6.3. All Columns, Indexes and Foreign Keys seem to be identical.
  
  Is there some other place I should be checking?
  
  Thanks again for everyone's help!
  
  **Tags:** database
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2015-06-25. Score: 2 | Accepted answer
  
  Which version did your database come from? I could imagine your report still tries to retrieve the assignee contact id from the table civicrm\_activity\_assignment (prior to CiviCRM version 4.4) rather than from civicrm\_activity\_contact?
  
  > **Comments:**
  > **username_0**: Thank you, we are coming 4.1 so I believe this to be the problem. What's the best way to correct this issue?  
  > **username_1**: Is the report a customized one? If so, you will need to adapt it to retrieve the assignee from the table civicrm_activity_contact with a specific record_type. If it was based on the core activity summary report, I would start by creating a new report from that template?  
  > **username_0**: It's a custom template, in order to retrieve the assignee from the table civicrm_activity_contact, do I need to edit the core or can this be done through the database?  
  > **username_1**: You should not edit the core in any circumstance :-) If it is a custom template you will have to edit it or get it edited? It should not be a big job, are you able to do that yourself?  
  > **username_0**: I think I can poke around enough to figure it out. It's all about trial and error. Thanks again for your help. I will dig deeper into it.  
  > **username_1**: The problem will probably be in the query in the $sql variable. It will probably try to access the file civicrm_activity_assignee, and possibly the civicrm_activity_target. Both are now in civicrm_activity_contact with record_type 1 = assignee and record_type 3 = target  
  
  ---
  
  ### Answer by username_2 on 2015-06-24. Score: 2
  
  Since your codebase has been upgraded, and your question doesn't mention running the upgrader as part of this, make sure you've followed the upgrade instructions (as best as they can apply after a server crash).
  
  * For Drupal, visit `?q=civicrm/upgrade&reset=1` or `civicrm/upgrade?reset=1`
  * For WordPress, visit `wp-admin/admin.php?page=CiviCRM&q=civicrm/upgrade&reset=1`
  * For Joomla, visit `/administrator/index.php?option=com_civicrm&task=civicrm/upgrade&reset=1`
  
  For upgrade documentation, refer to [the upgrade documentation page for your CMS](http://wiki.civicrm.org/confluence/display/CRMDOC/Installation+and+Upgrades). If your replacement server differs from your previous one, also review documentation for [moving an existing installation to a new server or location](http://wiki.civicrm.org/confluence/display/CRMDOC/Moving+an+Existing+Installation+to+a+New+Server+or+Location).
  
  > **Comments:**
  > **username_0**: Thank you for the quick response, I get this error when I try to upgrade and reset: Sorry but we are not able to provide this at the moment. Your database has already been upgraded to CiviCRM 4.6.3  
  > **username_2**: If you can [turn on debugging](http://wiki.civicrm.org/confluence/display/CRMDOC/Debugging+for+developers#Debuggingfordevelopers-EnableDebugging) that will help you see the error. Otherwise there is a CiviCRM log file (see "log files" in linked page) in your installation which records the error message. You'll need to make sense of this error message to identify the unexpected/incorrectly named DB column.  
  
  ---
  
  