Author Topic: Why is CiviReport not showing up as an installed module? (Read 13012 times)

Dave Greenberg · August 04, 2009, 09:59:53 am

Ack!
Jeff - I assume you tried clearing the template cache (templates_c folder).... If you did / do and still no joy - then I think we'll need to see what's up with your DB :-( Please go ahead and send a dump of the DB to deepak @ webaccess dot co dot in.

jalama · August 04, 2009, 06:28:08 pm

did you guys figure anything out here. I'm getting the same errors referring to having updated to the v2.2 database after running the install script. I also have a NULL value in the version field in civicrm_domain. The component show up in the list under Enable Components and the CiviReport fieldset shows up empty on the Admin page.

I managed to wrestle a 2.2.7 update into getting reports working a week ago but didn't take notes ( I know, I know) but can;t on a 2.2.5->2.2.8 update

I have run all the to following scripts form the civicrm and civicrm_data.mysql files

Code: [Select]


INSERT INTO 
   `civicrm_option_group` (`name`, `description`, `is_reserved`, `is_active`) 
VALUES ('report_template'               , 'Report Template'                    , 0, 1);

SELECT @option_group_id_report         := MAX(id) FROM civicrm_option_group WHERE NAME = 'report_template';
INSERT INTO    `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `visibility_id`) 
VALUES
  (@option_group_id_report , 'Constituent Report (Summary)',            'contact/summary',                'CRM_Report_Form_Contact_Summary',                NULL, 0, NULL, 1,  'Provides a list of address and telephone information for constituent records in your system.', 0, 0, 1, NULL, NULL),
  (@option_group_id_report , 'Constituent Report (Detail)',             'contact/detail',                 'CRM_Report_Form_Contact_Detail',                 NULL, 0, NULL, 2,  'Provides contact-related information on contributions, memberships, events and activities.',   0, 0, 1, NULL, NULL),
  (@option_group_id_report , 'Activity Report',                         'activity',                       'CRM_Report_Form_Activity',                       NULL, 0, NULL, 3,  'Provides a list of constituent activity including activity statistics for one/all contacts during a given date range(required)', 0, 0, 0, NULL, NULL),
  (@option_group_id_report , 'Walk / Phone List Report',                'walklist',                       'CRM_Report_Form_Walklist',                       NULL, 0, NULL, 4,  'Provides a detailed report for your walk/phonelist for targetted contacts', 0, 0, 0, NULL, NULL),
  (@option_group_id_report , 'Current Employer Report',                 'contact/currentEmployer',        'CRM_Report_Form_Contact_CurrentEmployer',        NULL, 0, NULL, 5,  'Provides detail list of employer employee relationships along with employment details Ex Join Date', 0, 0, 0, NULL, NULL),
  (@option_group_id_report , 'Donor Report (Summary)',                  'contribute/summary',             'CRM_Report_Form_Contribute_Summary',             NULL, 0, NULL, 6,  'Shows contribution statistics by month / week / year .. country / state .. type.', 0, 0, 1, @contributeCompId, NULL),
  (@option_group_id_report , 'Donor Report (Detail)',                   'contribute/detail',              'CRM_Report_Form_Contribute_Detail',              NULL, 0, NULL, 7,  'Lists detailed contribution(s) for one / all contacts. Contribution summary report points to this report for specific details.', 0, 0, 1, @contributeCompId, NULL),
  (@option_group_id_report , 'Donation Summary Report (Repeat)',        'contribute/repeat',              'CRM_Report_Form_Contribute_Repeat',              NULL, 0, NULL, 8,  'Given two date ranges, shows contacts (and their contributions) who contributed in both the date ranges with percentage increase / decrease.', 0, 0, 1, @contributeCompId, NULL),
  (@option_group_id_report , 'Donation Summary Report (Organization)',  'contribute/organizationSummary', 'CRM_Report_Form_Contribute_OrganizationSummary', NULL, 0, NULL, 9,  'Displays a detailed contribution report for Organization relationships with contributors, as to if contribution done was  from an employee of some organization or from that Organization itself.', 0, 0, 0, @contributeCompId, NULL),
  (@option_group_id_report , 'Donation Summary Report (Household)',     'contribute/householdSummary',    'CRM_Report_Form_Contribute_HouseholdSummary',    NULL, 0, NULL, 10, 'Provides a detailed report for Contributions made by contributors(Or Household itself) who are having a relationship with household (For ex a Contributor is Head of Household for some household or is a member of.)', 0, 0, 0, @contributeCompId, NULL),
  (@option_group_id_report , 'Top Donors Report',                       'contribute/topDonor',            'CRM_Report_Form_Contribute_TopDonor',            NULL, 0, NULL, 11, 'Provides a list of the top donors during a time period you define. You can include as many donors as you want (for example, top 100 of your donors).', 0, 0, 0, @contributeCompId, NULL),
  (@option_group_id_report , 'SYBUNT Report',                           'contribute/sybunt',              'CRM_Report_Form_Contribute_Sybunt',              NULL, 0, NULL, 12, 'Some year(s) but not this year. Provides a list of constituents who donated at some time in the history of your organization but did not donate during the time period you specify.', 0, 0, 1, @contributeCompId, NULL),
  (@option_group_id_report , 'LYBUNT Report',                           'contribute/lybunt',              'CRM_Report_Form_Contribute_Lybunt',              NULL, 0, NULL, 13, 'Last year but not this year. Provides a list of constituents who donated last year but did not donate during the time period you specify as the current year.', 0, 0, 1, @contributeCompId, NULL),	
  (@option_group_id_report , 'Soft Credit Report',                      'contribute/softcredit',          'CRM_Report_Form_Contribute_SoftCredit',          NULL, 0, NULL, 14, 'Soft Credit details.', 0, 0, 1,@contributeCompId, NULL),
  (@option_group_id_report , 'Membership Report (Summary)',             'member/summary',                 'CRM_Report_Form_Member_Summary',                 NULL, 0, NULL, 15, 'Provides a summary of memberships by type and join date.', 0, 0, 1, @memberCompId, NULL),
  (@option_group_id_report , 'Membership Report (Detail)',              'member/detail',                  'CRM_Report_Form_Member_Detail',                  NULL, 0, NULL, 16, 'Provides a list of members along with their membership status and membership details (Join Date, Start Date, End Date).', 0, 0, 1, @memberCompId, NULL),
  (@option_group_id_report , 'Membership Report (Lapsed)',              'member/lapse',                   'CRM_Report_Form_Member_Lapse',                   NULL, 0, NULL, 17, 'Provides a list of memberships that lapsed or will lapse before the date you specify.', 0, 0, 1, @memberCompId, NULL),
  (@option_group_id_report , 'Event Participant Report (List)',         'event/participantListing',       'CRM_Report_Form_Event_ParticipantListing',       NULL, 0, NULL, 18, 'Provides lists of participants for an event.', 0, 0, 1, @eventCompId, NULL),
  (@option_group_id_report , 'Event Income Report (Summary)',           'event/summary',                  'CRM_Report_Form_Event_Summary',                  NULL, 0, NULL, 19, 'Provides an overview of event income. You can include key information such as event ID, registration, attendance, and income generated to help you determine the success of an event.', 0, 0, 1, @eventCompId, NULL),			
  (@option_group_id_report , 'Event Income Report (Detail)',            'event/income',                   'CRM_Report_Form_Event_Income',                   NULL, 0, NULL, 20, 'Helps you to analyze the income generated by an event. The report can include details by participant type, status and payment method.', 0, 0, 1, @eventCompId, NULL),
  (@option_group_id_report , 'Pledge Report',                           'pledge/summary',                 'CRM_Report_Form_Pledge_Summary',                 NULL, 0, NULL, 21, 'Pledge Report', 0, 0, 0, @pledgeCompId, NULL),			
  (@option_group_id_report , 'Pledged But not Paid Report',             'pledge/pbnp',                    'CRM_Report_Form_Pledge_Pbnp',                    NULL, 0, NULL, 22, 'Pledged but not Paid Report', 0, 0, 0, @pledgeCompId, NULL);

INSERT INTO civicrm_component (name, namespace) VALUES ('CiviReport'    , 'CRM_Report' );

CREATE TABLE civicrm_report_instance (


     id INT UNSIGNED NOT NULL AUTO_INCREMENT  COMMENT 'Report Instance ID',
     title VARCHAR(255)    COMMENT 'Report Instance Title.',
     report_id VARCHAR(64) NOT NULL   COMMENT 'FK to civicrm_option_value for the report template',
     description VARCHAR(255)    COMMENT 'Report Instance description.',
     permission VARCHAR(255)    COMMENT 'permission required to be able to run this instance',
     form_values TEXT    COMMENT 'Submitted form values for this report',
     is_active TINYINT    COMMENT 'Is this entry active?',
     email_subject VARCHAR(255)    COMMENT 'Subject of email',
     email_to TEXT    COMMENT 'comma-separated list of email addresses to send the report to',
     email_cc TEXT    COMMENT 'comma-separated list of email addresses to send the report to',
     header TEXT    COMMENT 'comma-separated list of email addresses to send the report to',
     footer TEXT    COMMENT 'comma-separated list of email addresses to send the report to' 
,
    PRIMARY KEY ( id )
 
 
 
)  ENGINE=INNODB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci  ;

INSERT INTO civicrm_component (NAME, namespace) VALUES ('CiviReport'    , 'CRM_Report' );

jeff porter · August 05, 2009, 04:51:59 am

I did clear out the templates_c folder - and do so again - no luck. I will send over the dump

Thanks

Jeff

Dwiding · August 05, 2009, 11:06:49 am

Quote from: Dave Greenberg on August 03, 2009, 11:31:09 am

Did you definitely do this step in the Joomla Upgrade instructions:

Quote
* You should see "CiviCRM successfully installed" message and a link to upgrade the database to the current version. Click the link and initiate the database upgrade script on the following screen.

If you ran the DB upgrade step and you still don't see CiviReport - then something failed in the upgrade. If you can send a dump of your DB to deepak at webaccess dot co dot in - we can take a look.

Yes, I ran the script. I'll have to have my PHP developer do the dump if that is still needed. I see a reference to 2.2.8,should I download that and upgrade before doing a db dump?

D

Dave Greenberg · August 05, 2009, 05:09:11 pm

You could do the 2.2.8 upgrade and see if that fixes things. Else we'll need the dump to see what's up.

jinjur · August 23, 2009, 07:38:58 pm

we have found ourselves in a very similar state following an upgrade to 2.2.8, and have tried all the same things to get civireport accessible and working, with no luck - has any solution been found for this?

we're continuing to work on it, and i will chime in if we find anything.

arrow · August 23, 2009, 10:05:03 pm

I'm working with jinjur on this issue. We did find that, in spite of having added the proper roles and privileges, we had to manually add the following to the civicrm_acl table (it wasn't added automatically with the rights):

| 49 | Core ACL | 0 | civicrm_acl_role | 1 | All | access CiviReport | NULL | NULL | NULL | 1 |
| 50 | Core ACL | 0 | civicrm_acl_role | 1 | All | access Report Criteria | NULL | NULL | NULL | 1 |
| 51 | Core ACL | 0 | civicrm_acl_role | 1 | All | administer Reports | NULL | NULL | NULL | 1 |

however, reports are still not listed here:
https://secure.transformativeworks.org/civicrm/report/list?reset=1

even though CiviReport appears to be enabled in global settings.

any help would be appreciated.

Deepak Srivastava · August 23, 2009, 10:58:12 pm

Arrow / Jinjur,

I suspect your db hasn't yet upgraded. Few checks -
1. Whats the value for version column of civicrm_domain table ?

2. Can you run the following query and see if you get any results -

Code: [Select]

SELECT * FROM `civicrm_option_value` WHERE `option_group_id`=(SELECT og.id FROM civicrm_option_group og WHERE og.name='report_template')

3. Whats the message you see when you go to upgrade url

jalama · August 24, 2009, 06:25:08 am

Deepak,

I'm having the same issues upgrading from 2.2.6 to 2.2.8. I ran the db updates I detailed above and arrows civicrm_acl updates to no avail.

the version read 2.2 in the domain table (which I put in there by hand)

I do get results from the query, as I inserted those values in the sql script above.

the update script failed saying I already had the 2.2 updates.

Jim

Deepak Srivastava · August 24, 2009, 07:46:08 am

Jim,

Quote

the version read 2.2 in the domain table (which I put in there by hand)

Any idea what version you were at, when you did that ? (Not sure why it wasn't present). If possible can you verify this from you previous backups.
So for example if you were at v2.2.5 set it to 2.2.5 and try the upgrade again (after you have reverted your sql changes).

(Note: Never forget to take backups.)

jalama · August 24, 2009, 08:23:44 am

I did this on the 2.2.8 version, it was blank before that (after the 2.2.6 upgrade)

jinjur · August 24, 2009, 07:23:17 pm

we managed to get civireport to show up, and everything now appears to be working - in case it helps anyone, here's what we did:

I did a clean install and dumped the database. Then I split the original backup into its 115 separate tables. I imported each one (changing INSERT to REPLACE where necessary, and adding SET FOREIGN_KEY_CHECKS=0; where necessary) After each import I checked to see if reports were still working. In the three cases where something had broken after the import, i recovered that table from the clean install.

CiviCRM Community Forums (archive)

News:

Author Topic: Why is CiviReport not showing up as an installed module? (Read 13012 times)

Dave Greenberg

Re: Why is CiviReport not showing up as an installed module?

jalama

Re: Why is CiviReport not showing up as an installed module?

jeff porter

Re: Why is CiviReport not showing up as an installed module?

Dwiding

Re: Why is CiviReport not showing up as an installed module?

Dave Greenberg

Re: Why is CiviReport not showing up as an installed module?

jinjur

Re: Why is CiviReport not showing up as an installed module?

arrow

Re: Why is CiviReport not showing up as an installed module?

Deepak Srivastava

Re: Why is CiviReport not showing up as an installed module?

jalama

Re: Why is CiviReport not showing up as an installed module?

Deepak Srivastava

Re: Why is CiviReport not showing up as an installed module?

jalama

Re: Why is CiviReport not showing up as an installed module?

jinjur

Re: Why is CiviReport not showing up as an installed module?