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 CiviMember (Moderator: Deepak Srivastava) »
  • Memberships - phantom memberships show in some reports but not others
Pages: [1]

Author Topic: Memberships - phantom memberships show in some reports but not others  (Read 4194 times)

bhagerty

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 4.3.3
  • CMS version: WordPress 3.6
  • MySQL version: 5.0
  • PHP version: 5.2.17
Memberships - phantom memberships show in some reports but not others
August 04, 2013, 07:33:44 pm
I have a fairly new installation of CiviCRM 4.3.3 on WordPress 3.6 that is giving me weird errors. I'm hoping someone can provide guidance.

I entered some test transactions in April. I also installed all the sample data when I installed CiviCRM. We are about to go live, so I deleted all of the sample contacts today. I kept the contacts that I used for test transactions - or I thought I did.

But there are now some phantom memberships still in my database that show up in some reports but not in others. Specifically:

The CiviReport "Membership Summary"says there are 3 memberships from April. The memberships have Contact ID 5, 132, and 109 - but the only members showing in Contact reports are members 202, 203, 205, and 1 (a group).

The CiviReport "Contribution Summary" says there were contributions of $1400 in March from contact 132, plus a contribution of $50 in March from contact 4. But if I click on the Month in the report to get the "Details" report, it shows zero contributions.

The "Find Contributions" report returns nothing for this year.

Also, the CiviMember "Membership Summary" says that there are zero memberships YTD. And the CiviMember "Find Memberships" report doesn't return any memberships. The CiviReport "Membership Details" report also doesn't return any memberships, even if I set all criteria to find anything.

When I run the "Contribution and Membership Details" report, I get these errors:

Code: [Select]
Warning: implode() [function.implode]: Invalid arguments passed in /home/doctorsuzuki/macphailsa.org/wp-content/plugins/civicrm/civicrm/CRM/Report/Form/Member/ContributionDetail.php on line 688

Warning: implode() [function.implode]: Invalid arguments passed in /home/doctorsuzuki/macphailsa.org/wp-content/plugins/civicrm/civicrm/CRM/Report/Form/Member/ContributionDetail.php on line 694

Those lines are found in the "function statistics(&$rows)" declaration/subroutine (pardon my terminology, I'm not really a programmer). Each line is in an array statement. Line 688 is:
Code: [Select]
'value' => implode(',  ', $totalAmount),Line 694 is:
Code: [Select]
'value' => implode(',  ', $average),
It seems like somehow when I deleted the members, these stray contributions were not deleted entirely, and now they're in the database somehow so that they appear in some reports and not others. I'd really like to get rid of them entirely, but I'm baffled about how to do so.

Thoughts?

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Memberships - phantom memberships show in some reports but not others
August 05, 2013, 04:44:17 pm
Looks like some of the reports are including contributions / memberships belonging to contacts that are "in the trash" (ie. ones you deleted). This would be a bug - so if you're able to investigate and submit a patch that would be great. As a workaround you can try clicking "Search in Trash" in Advanced Search to locate and permanently delete the test / sample contacts. This should 'hard delete' any linked memberships and contributions.
Protect your investment in CiviCRM by  becoming a Member!

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Memberships - phantom memberships show in some reports but not others

This forum was archived on 2017-11-26.