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 Profiles (Moderator: Dave Greenberg) »
  • Getting duplicates on member directory
Pages: 1 [2]

Author Topic: Getting duplicates on member directory  (Read 4068 times)

CiviTeacher.com

  • I live on this forum
  • *****
  • Posts: 1282
  • Karma: 118
    • CiviTeacher
  • CiviCRM version: 3.4 - 4.5
  • CMS version: Drupal 6&7, Wordpress
  • MySQL version: 5.1 - 5.5
  • PHP version: 5.2 - 5.4
Re: Getting duplicates on member directory
April 10, 2010, 10:38:53 pm
Greenberg, believe it or not I ran into another bug relating to this issue pre-populating address fields on a Contribution/membership renewal page.  If a Contact has Email Primary: Home and Phone Primary: Billing, then the Billing address will populate, but any included Profiles containing address fields in a contribution page membership renewal will not populate.

This is, as you say, likely due to some deep deep deep ways Civi is handling this data, and it doesn't know how to interpret two different locations for two different primaries.

RootyHollow Jim and I are working on a project together and this bug is kinda critical, could you shoot us some clues as to where we should be looking for this stuff?  I'm actually not bad at MySQL queries, and joins and stuff.  I might be able to figure it out if you don't have time atm.
« Last Edit: April 11, 2010, 11:04:43 am by Stoob »
Try CiviTeacher: the online video tutorial CiviCRM learning library.

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Getting duplicates on member directory
April 10, 2010, 11:53:47 pm
yeah - I hit this too - I think I asked about it on the IRC & Lobo suggested I investigate & patch but  the customer didn't have time or budget for it (& there's limits to how much I can do in my 'free' time) so we found a work around. But the problem we had was that phone numbers were being entered but not saved. I can't remember if it was the primary location or the home location that wasn't working but whichever it was we swapped
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Getting duplicates on member directory
April 13, 2010, 09:53:15 pm
If you can replicate reliably, doing a backtrace and then adding debug statements (probably in the setDefaults method) is your best bet for nailing this down. Jim should be able to help with this - or if not IRC is best.
Protect your investment in CiviCRM by  becoming a Member!

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Getting duplicates on member directory
May 03, 2010, 08:57:23 pm
Just a note to confirm the behaviour is 'one-per-type-that-is-primary' e.g

phone location primary type is home
email location primary type is home
address location primary type is home

1 record returned

phone location primary type is billing
email location primary type is home
address location primary type is 'main

3 records returned
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

davej

  • Ask me questions
  • ****
  • Posts: 404
  • Karma: 21
Re: Getting duplicates on profile search
October 27, 2010, 10:40:05 am
Encountered the profile search duplicates issue in 3.2.3. Attached a file to CRM-6082 that captures the relevant SQL queries with backtraces.

Dave J
Pages: 1 [2]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Profiles (Moderator: Dave Greenberg) »
  • Getting duplicates on member directory

This forum was archived on 2017-11-26.