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) »
  • Upgraded from 1.9 to 4.1, CiviReports displays the civi homepage.
Pages: [1]

Author Topic: Upgraded from 1.9 to 4.1, CiviReports displays the civi homepage.  (Read 864 times)

iandev

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
  • CiviCRM version: 4.1
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Upgraded from 1.9 to 4.1, CiviReports displays the civi homepage.
May 31, 2012, 08:36:03 am
Hi everyone, I've recently upgraded an old civicrm 1.9 install to 4.1 and I notice the reports pages do not work.  If I try to view any of the reports pages that are listed under the Reports top menu item, the homepage civicrm dashboard is displayed instead.  No error messages just the civicrm dashboard.  Is there something extra that I need to do to get this component working?  In the meantime I will be stepping through the code to see if I can figure out what is going on but any help from the community would be great.

Thanks

emilyf

  • Ask me questions
  • ****
  • Posts: 696
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Re: Upgraded from 1.9 to 4.1, CiviReports displays the civi homepage.
May 31, 2012, 08:57:08 am
did you verify your permissions at admin/user/permissions -- there are specific ones for civireport. also try clearing the drupal cache and then see if you can go direct to a report link, such as http://yoursite.com/civicrm/report/instance/1?reset=1...does it show up this way?

iandev

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
  • CiviCRM version: 4.1
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Upgraded from 1.9 to 4.1, CiviReports displays the civi homepage.
May 31, 2012, 11:00:54 am
I am using drupal, so do you mean the drupal access control?  If so there is no permission here for civi report.  I have permissions for Civi add/edit/delete profiles/contacts/activities/etc, CiviContribute, CiviMember, CiviEvent, CiviMail, CiviGrant, CiviPledge, CiviCampaign but none for CiviReport.

Then there is the CiviCRM ACL, which I have a few roles here but no acl's setup. 

I don't see anything specifically for CiviReport.

I will try clearing the drupal cache.

Thanks.

Edit: I cleared the drupal cache, and it didn't make a difference.
« Last Edit: May 31, 2012, 11:03:01 am by iandev »

emilyf

  • Ask me questions
  • ****
  • Posts: 696
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Re: Upgraded from 1.9 to 4.1, CiviReports displays the civi homepage.
May 31, 2012, 11:41:13 am
you should definitely have permissions for civireport, including "access reports" "administer reports" etc under the civicrm section at admin/user/permissions.

try disabling the civireport component (civicrm > administer > system settings > enable components) and then reenabling. also try clearing civi caches (civicrm > administer > system settings > cleanup caches...)

also, can you answer the other question: can you go direct to a report link, such as http://yoursite.com/civicrm/report/instance/1?reset=1...does the report show up?


iandev

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
  • CiviCRM version: 4.1
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Upgraded from 1.9 to 4.1, CiviReports displays the civi homepage.
May 31, 2012, 11:52:50 am
I don't have those permissions.  I also don't have the CiviReport component in that list.  Could it be possible the component was not even installed but the menu is there anyway?  If so how could I install this component separately?

These are the components I have enabled:
CiviEvent
CiviContribute
CiviMember
CiviMail
CiviPledge
CiviCampaign
CiviGrant

And one component disabled:
CiviCase

I cleared the civi caches and it didn't do anything.

Clicking on any of the CiviReport links in the menu (/civicrm/report/instance/1, etc) just displays the homepage dashboard.


emilyf

  • Ask me questions
  • ****
  • Posts: 696
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Re: Upgraded from 1.9 to 4.1, CiviReports displays the civi homepage.
May 31, 2012, 12:06:32 pm
you say you upgraded from version 1.9.

did you do a straight upgrade to 4.1? the upgrade instructions here: http://wiki.civicrm.org/confluence/display/CRMDOC41/Upgrade+Drupal+Sites+to+4.1+-+Drupal+6

specify that if you are on a version prior to 2.2 you need to first upgrade to 2.2.

iandev

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
  • CiviCRM version: 4.1
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Upgraded from 1.9 to 4.1, CiviReports displays the civi homepage.
May 31, 2012, 12:30:45 pm
Yes I followed these instructions.  Actually I went like this:
1.9 to 2.0
2.0 to 2.1
2.1 to 2.2.6
2.2.6 to 3.0
3.0 to 3.1
3.1 to 3.3.5
3.3.5 to 3.4.8
3.4.8 to 4.0.8
4.0.8 to 4.1.2

emilyf

  • Ask me questions
  • ****
  • Posts: 696
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Re: Upgraded from 1.9 to 4.1, CiviReports displays the civi homepage.
May 31, 2012, 12:55:30 pm
I think you are having the same issue as another thread I found, start reading here: http://forum.civicrm.org/index.php/topic,8392.msg37740.html#msg37740


iandev

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
  • CiviCRM version: 4.1
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Upgraded from 1.9 to 4.1, CiviReports displays the civi homepage.
May 31, 2012, 01:12:09 pm
Hey, thanks for the help.  While the issues in that thread seem to be exactly what I am experiencing, I didn't find the solution there.  Instead this is what I did:

I noticed in the database, the 'civicrm_component' table contained this:
CiviEvent
CiviContribute
CiviMember
CiviMail
CiviGrant
CiviPledge
CiviCase
CiviCampaign

And did not include 'CiviReport'. 
So I added this row, "INSERT INTO civicrm_component VALUES(NULL, 'CiviReport', 'CRM_Report')"

Then this component showed up on the list of components within civicrm, but as disabled.
I then enabled it.
I went to the drupal acl and found the 3 new permissions for reports and enabled those.
I cleared the drupal cache and the civicrm cache, and it works!




Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • Upgraded from 1.9 to 4.1, CiviReports displays the civi homepage.

This forum was archived on 2017-11-26.