Skip to content

GitLab

D
Drupal
Closed
Opened by kenahoo@kenahoo

Many duplicates in Drupal view of CiviCRM contributions

I have a Drupal view configured as shown in the attached screenshot:

Screen_Shot_2020-01-05_at_8.53.03_PM

This results in lots of duplicate results in the listing, as you can see:

Screen_Shot_2020-01-05_at_8.54.17_PM

Not every contribution is duplicated, but many are.

Some notes:

  • There are 16 total entries for contribution #1. 16 is suspiciously a power of 2.
  • If I decrease the number of address fields shown, the number of duplicates gets cut in half each time.

So I'm guessing there's some poorly-formed SQL join between contributions and addresses, resulting in the Cartesian product of join fields or something like that. Any way to diagnose?

Thanks.

To upload designs, you'll need to enable LFS and have admin enable hashed storage. More information