1

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!

2

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?

  • Thank you, we are coming 4.1 so I believe this to be the problem. What's the best way to correct this issue? – Sean Jun 25 '15 at 13:06
  • 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? – ErikH - CiviCooP Jun 25 '15 at 13:27
  • 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? – Sean Jun 25 '15 at 13:45
  • 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? – ErikH - CiviCooP Jun 25 '15 at 14:01
  • 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. – Sean Jun 25 '15 at 14:10
1

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. If your replacement server differs from your previous one, also review documentation for moving an existing installation to a new server or location.

  • 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 – Sean Jun 25 '15 at 0:44
  • If you can turn on debugging 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. – Chris Burgess Jun 25 '15 at 1:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.