CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 4.4 Release Testing »
  • Activity report fails
Pages: [1]

Author Topic: Activity report fails  (Read 1377 times)

clarkac

  • Administrator
  • Ask me questions
  • *****
  • Posts: 399
  • Karma: 11
  • CiviCRM version: 4.4.11 & 4.5.5
  • CMS version: Drupal 7
  • MySQL version: 5.1.61-cll
  • PHP version: 5.3.27
Activity report fails
August 23, 2013, 10:17:57 am
After upgrade from 4.3.5 a report that works in 4.3.5 fails in 4.4 with 'DB Error: no such field'.  This report uses a custom field that has been converted OK (as far as I can tell).  There are > 50 activities with this custom field completed so I should get hits. When I try to recreate the report by building it from scratch I get the same error. 

Backtrace is attached.

« Last Edit: August 23, 2013, 10:29:32 am by clarkac »
Andy Clark

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Activity report fails
August 23, 2013, 10:58:20 am

is this a custom report?

note that in 4.4, the activity schema has changed (to make things a lot more efficient). U'll need to rewrite your sql to conform to the new schema

there is now a civicrm_activity_contact table where all contacts that are related to the activity are stored

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

clarkac

  • Administrator
  • Ask me questions
  • *****
  • Posts: 399
  • Karma: 11
  • CiviCRM version: 4.4.11 & 4.5.5
  • CMS version: Drupal 7
  • MySQL version: 5.1.61-cll
  • PHP version: 5.3.27
Re: Activity report fails
August 23, 2013, 11:23:15 am
This is just using a regular activity report template, so not a custom report.  Depending on what you mean by custom report... ;)
Andy Clark

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Activity report fails
August 24, 2013, 04:47:33 am

can u try and reproduce this issue on our sandbox server please

thx

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

clarkac

  • Administrator
  • Ask me questions
  • *****
  • Posts: 399
  • Karma: 11
  • CiviCRM version: 4.4.11 & 4.5.5
  • CMS version: Drupal 7
  • MySQL version: 5.1.61-cll
  • PHP version: 5.3.27
Re: Activity report fails
August 24, 2013, 05:28:47 am
Just tried the 4.4 sandbox at sandbox.drupal.civicrm.org ...  doesn't seem to be doing anything after you login.
Andy Clark

clarkac

  • Administrator
  • Ask me questions
  • *****
  • Posts: 399
  • Karma: 11
  • CiviCRM version: 4.4.11 & 4.5.5
  • CMS version: Drupal 7
  • MySQL version: 5.1.61-cll
  • PHP version: 5.3.27
Re: Activity report fails
August 26, 2013, 01:30:49 pm
I was able to reproduce this problem exactly, now the 4.4 sandbox is working.  I added a custom field of 'Offence details' to the 'Interview' activity type.   I then selected one of the offence options in an activity report.  The result when previewing the report was the same crash; the backtrace is attached.
Andy Clark

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: Activity report fails
August 27, 2013, 12:25:01 am
clarkac :

We 'll file an issue and fix this.

Thanks
-Yashodha
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: Activity report fails
August 27, 2013, 03:36:02 am
Here's the patch:
https://github.com/civicrm/civicrm-core/issues/1518

HTH
-Yashodha
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

clarkac

  • Administrator
  • Ask me questions
  • *****
  • Posts: 399
  • Karma: 11
  • CiviCRM version: 4.4.11 & 4.5.5
  • CMS version: Drupal 7
  • MySQL version: 5.1.61-cll
  • PHP version: 5.3.27
Re: Activity report fails
August 29, 2013, 05:17:21 am
This problem is now fixed in Alpha3 - thanks!
Andy Clark

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: Activity report fails
August 29, 2013, 07:05:40 am
clarkac :

You 'll be able to find all the issues filed and fixed for 4.4 here :

http://issues.civicrm.org/jira/browse/CRM/fixforversion/10990

Thanks for helping out with testing
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 4.4 Release Testing »
  • Activity report fails

This forum was archived on 2017-11-26.