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 CiviContribute (Moderator: Donald Lobo) »
  • Civicontribute shows multiple contributions for single donation
Pages: [1]

Author Topic: Civicontribute shows multiple contributions for single donation  (Read 2111 times)

jeff porter

  • I post occasionally
  • **
  • Posts: 72
  • Karma: 2
Civicontribute shows multiple contributions for single donation
August 27, 2007, 07:10:12 pm
Strange problem with Civicontribute.  I have not been able to reproduce it on the sandbox, but not sure how I would. 

Here is the deal. We see multiple contributions in the reports and dashboard for a single contributor. We even see it in the user's profile if you select the "contributions" tab. It is not calculating multiple contributions, but Civicontribute is certainly showing them on our system. We thought this could be a bug with 1.5/1.6 (first cropped up in 1.5), but it is doing the same in 1.8

If you export contributions, it will show you the duplicates as well.  However, when it calcs them in the db, or if you look in the db, they are only in there once.

Any thoughts?  See the attached screen shot

Jeff


Jeff Porter
Foundation for Prader-Willi Research (www.fpwr.org)

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: Civicontribute shows multiple contributions for single donation
August 27, 2007, 07:29:58 pm

Jeff:

Can u check if one of the contributions that occurs multiple times, has more than one note attached to it in the civicrm_note table. Most likely the below error is because of a LEFT JOIN with a table which has 2 instances for the same contribution (and i'm pretty sure it will be the notes table)

I think the older versions had a bug which created multiple notes for a contribution. This bug has been fixed in 1.8

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

jeff porter

  • I post occasionally
  • **
  • Posts: 72
  • Karma: 2
Re: Civicontribute shows multiple contributions for single donation
August 27, 2007, 08:19:31 pm
There are no notes on the latest contribution that shows this.  However, all of the contributions appear this way.  In fact, when I was going in to edit the "accepted credit cards" under the Civicontribute settings - it did the same thing (see attached).

It consistently shows 40 copies of the same entry - some issue with the query for sure.

BTW - We are running 1.8.10954


Jeff Porter
Foundation for Prader-Willi Research (www.fpwr.org)

jeff porter

  • I post occasionally
  • **
  • Posts: 72
  • Karma: 2
Re: Civicontribute shows multiple contributions for single donation
August 27, 2007, 08:25:36 pm
I take that back on the credit cards... Those are all in the civicrm_option_value table 40 times each ?? Is that right?

Jeff Porter
Foundation for Prader-Willi Research (www.fpwr.org)

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: Civicontribute shows multiple contributions for single donation
August 27, 2007, 08:30:47 pm

For some reasons your option_value table with regard to it is messed up. This might mess up other queries also, since we also LEFT JOIN on the option_value table. You might want to clean that up and see if there are other groups with multiple values. This might be the reason for the multiple contributions

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

jeff porter

  • I post occasionally
  • **
  • Posts: 72
  • Karma: 2
Re: Civicontribute shows multiple contributions for single donation
August 28, 2007, 04:56:17 am
Ok, just so I make sure - everything in this table should only have 1 entry?
Jeff Porter
Foundation for Prader-Willi Research (www.fpwr.org)

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: Civicontribute shows multiple contributions for single donation
August 28, 2007, 11:37:48 am

Yes, basically there will be one entry / domain. If you are running multiple domains, there will be multiple copies of each, one per domain

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

jeff porter

  • I post occasionally
  • **
  • Posts: 72
  • Karma: 2
Re: Civicontribute shows multiple contributions for single donation
September 02, 2007, 10:16:10 pm
Cleaned up that table and all is good now.  Strange that it got that way, but happy that it is fixed!


Jeff Porter
Foundation for Prader-Willi Research (www.fpwr.org)
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • Civicontribute shows multiple contributions for single donation

This forum was archived on 2017-11-26.