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) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • Custom report broken on upgrade from 4.2.7.to 4.4.3
Pages: [1]

Author Topic: Custom report broken on upgrade from 4.2.7.to 4.4.3  (Read 848 times)

lesley

  • I post occasionally
  • **
  • Posts: 64
  • Karma: 1
Custom report broken on upgrade from 4.2.7.to 4.4.3
December 08, 2013, 01:07:13 am
Sorry if I'm in the wrong place.
I paid a developer for a custom report that was written for 4.2.7 and based on bookkkeeping transactions report.
It's broken on upgrade to 4.4.3 because (I think) of the changes to the schema of civicrm_contribute.
I've attached the files in the hope that someone can assist me to make it work again. (i've tried changing all references to contribution_type_id to financial_type_id but didn't help)
Really out of my depth here but prepared to give it a go if some kind soul could point me in the right direction.

Also I've never known why there are 2 files? Paths are respectively   Custom_php/CRM/Core/DAO and Custom_php/CRM/Report/Form/Contribute
Can't afford developer again so all help much appreciated
« Last Edit: December 08, 2013, 04:02:08 pm by lesley »

sushant

  • I post frequently
  • ***
  • Posts: 126
  • Karma: 8
  • CiviCRM version: v3.2.x,v3.3.x v4.0.x, v4.x,trunk
  • CMS version: Drupal 6/7 ,joomla 1.5,1.6
  • MySQL version: 5.1.51
  • PHP version: 5.3.3
Re: Custom report broken on upgrade from 4.2.7.to 4.4.3
December 08, 2013, 04:54:25 am
Hi lesley,

Quote
Also I've never known why there are 2 files? Paths are respectively   Custom_php/CRM/Core/DAO and Custom_php/CRM/Report/Form/Contribute

These two files are the custom changes that developer did to achieve the requirements in previous version.
 
For info on custom directory http://wiki.civicrm.org/confluence/display/CRMDOC/Customize+Built-in,+Profile,+Contribution+and+Event+Registration+Screens

S.
CiviCRM Priority Support
http://support.civigardens.com/
http://osseed.com

lesley

  • I post occasionally
  • **
  • Posts: 64
  • Karma: 1
Re: Custom report broken on upgrade from 4.2.7.to 4.4.3
December 08, 2013, 01:03:09 pm
Thanks S that much I know.
Can anyone help with what else I need to modify (apart from changing contribution_type_id) to allow for the schema changes?

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Custom report broken on upgrade from 4.2.7.to 4.4.3
December 08, 2013, 03:01:45 pm
Hi Lesley,

You probably need to ensure debugging is on & then paste the error message here to get help. Note that not only references to contribution_type_id need to be changed - but potentially also references the civicrm_contribution table. Also the activity_target & assignee tables are now gone.

You probably need to go through a process of fix, run report, paste new error, fix etc. You might speed up the process by going on IRC to get quicker feedback.
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

lesley

  • I post occasionally
  • **
  • Posts: 64
  • Karma: 1
Re: Custom report broken on upgrade from 4.2.7.to 4.4.3
December 08, 2013, 03:12:35 pm
Thanks Eileen
Unfortunately there are no error messages - just a white screen - I've had similar when it couldn't find the template but I'm sure the paths are correct (unchanged from 4.2.7) so I think it must be the code.
Would the apache log help? Although I'd have to ask my host for it.
I'll have another peer at the code *girds loins*  :o

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Custom report broken on upgrade from 4.2.7.to 4.4.3
December 08, 2013, 03:25:07 pm
Apache log will show the cause of any white screen errors. You can also change your php settings so they show on the screen (you aren't supposed to leave this on in production). Depending on various things adding

ini_set('display_errors', 'On');

 to civicrm.settings.php may allow you to see them
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

lesley

  • I post occasionally
  • **
  • Posts: 64
  • Karma: 1
Re: Custom report broken on upgrade from 4.2.7.to 4.4.3
December 08, 2013, 04:01:45 pm
 :) :) :) AWESOME!!

ini_set('display_errors', 'On');   Worked beautifully

I just had to change CRM_Contribute_PseudoConstant::contributionType()    to  CRM_Contribute_PseudoConstant::financialType(),
and all is well

Thank you so much Eileen
cheers
Lesley
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • Custom report broken on upgrade from 4.2.7.to 4.4.3

This forum was archived on 2017-11-26.