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) »
  • Profile for Member Directory showing duplicate records
Pages: [1]

Author Topic: Profile for Member Directory showing duplicate records  (Read 1487 times)

ralph.devlin

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
Profile for Member Directory showing duplicate records
January 23, 2011, 11:02:56 pm
I am expericing an issue where I have a profile listing to display members for directory purposes however it appears that deleted contacts are still showing up in the directory. I've checked all of contacts and nothing is showing up, but it does when the profile is pulled up and even searched. I did check other profiles and the same behavior happens

Any ideas on how to fix this? I'm using CiviCRM 3.3.1

mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Re: Profile for Member Directory showing duplicate records
January 24, 2011, 09:57:25 am
Greetings Ralph,

This sounds very similar to something we discovered this weekend:

"Seeing Different Record Sets between Find Contacts and Profile which searches"
http://forum.civicrm.org/index.php/topic,18239.0.html

We have not found the answer to this sort of results.
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Profile for Member Directory showing duplicate records
January 24, 2011, 11:44:04 am
Quote
deleted contacts are still showing up in the directory

Any reason you can't 'permanently delete' these contacts to ensure they don't show?
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

ralph.devlin

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
Re: Profile for Member Directory showing duplicate records
January 24, 2011, 11:55:42 am
Quote from: peterd on January 24, 2011, 11:44:04 am
Quote
deleted contacts are still showing up in the directory

Any reason you can't 'permanently delete' these contacts to ensure they don't show?

The contacts are permanently deleted from what I can tell, I did not disable the contacts, but chose to delete them.

I just looked in the DB and sure enough those contacts are showing there, but have the is_deleted flag set to 1. Why would the profile be seeing those contacts when the contact search doesn't even see them? How can I get them removed permanently deleted.
« Last Edit: January 24, 2011, 12:07:12 pm by ralph.devlin »

mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Re: Profile for Member Directory showing duplicate records
January 24, 2011, 01:00:22 pm
Quote from: ralph.devlin on January 24, 2011, 11:55:42 am
I just looked in the DB and sure enough those contacts are showing there, but have the is_deleted flag set to 1. Why would the profile be seeing those contacts when the contact search doesn't even see them?

Then that seems to be consistent with what we are seeing.

Can you see them via Find Contacts, or only this Profile with Search capabilities? We can not see them via Find Contacts, only the Profile with Search Capabilities... which is what people actually use.

Quote from: ralph.devlin on January 24, 2011, 11:55:42 am
How can I get them removed permanently deleted.

I believe I found that via viewing the actual deleted record, and then it showed up with pink background / strike-through font for the name, and somewhere on that screen was a link to perm delete the record.

I would be interested in a view of all pending deletes... but that is a side topic.
« Last Edit: January 24, 2011, 01:01:55 pm by mdlueck »
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

ralph.devlin

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
Re: Profile for Member Directory showing duplicate records
January 24, 2011, 01:11:44 pm
Find contacts does not produce those results. At one point I got the pink backgroup and a question asking if I wanted it permanently deleted nd said yes, but I believe the DB si still showing that record. The profile is where the deleted item still shows up.

mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Re: Profile for Member Directory showing duplicate records
January 24, 2011, 01:29:38 pm
@ralph: Deja Vu - Same for us.
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Profile for Member Directory showing duplicate records
January 24, 2011, 01:48:15 pm
There is 'delete' and 'permanently delete'

So 'deleted' contacts are still in DB.

If you have permissions to 'permanently delete' then either you can do this as an 'action' after search - or you can search in 'trash' (in Adv Search) and then Permanently Delete.

I am not saying that you aren't experiencing another problem - but if you just need those people to be 'really' deleted so they don't show then the above may give you a quick solution
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Re: Profile for Member Directory showing duplicate records
January 24, 2011, 06:28:40 pm
@peterd: I understand your thought, just how the code is working in reality is a bit odd.

1) To honor the delete within "Find Contacts" and not honor it in a "Search Profile" is certainly a bit odd.
2) Via "Search Profile" we are seeing contacts that might not have ever been associated with the profile, ever. "Then where did that association ever come from?"

Anyway, just taking our site off line for a quick bit to grab some MySQL SQL traces to find out exactly what each query really executes: "Find Contacts" vs "Search Profile". Since my other thread (link above in this thread) already went into SQL depth, I will post the results over on that thread.
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

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: Profile for Member Directory showing duplicate records
January 24, 2011, 07:32:28 pm

Seems like this is a bug :(

Would be great if someone can take a look at the queries and figure out whats happening and why. Do ping us on IRC if you need help getting started/making progress

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

bijama1

  • I’m new here
  • *
  • Posts: 9
  • Karma: 0
Re: Profile for Member Directory showing duplicate records
January 29, 2011, 05:51:09 am
Having the double entries since CiviCrm 2.x

Can be seen at http://ifess.org/civicrm/profile?force=1&gid=12&reset=1&search=0

And there are no double entries neither in the database nor when I display the related Smart Group.

The query is if a custom data field (Multiple Choice Options) = 0
=====
Contact Type - 'Individual' ...AND...
Status = 0
=====

May be this helps?

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Profile for Member Directory showing duplicate records
January 29, 2011, 02:33:47 pm
is this that old problem of those contacts having multiple email etc set to Primary? check on one of those contacts summary screens. - to they have more than one phone or email in BOLD indicating it is Primary?
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Re: Profile for Member Directory showing duplicate records
January 29, 2011, 06:57:17 pm
@peterd: I highly doubt. We only just began importing data into Civi, so have not had it long enough for contacts to end up with multiple phone numbers or email addys.

We observed this just prior to this thread starting, and I reported it on this thread:
http://forum.civicrm.org/index.php/topic,18239.msg75866.html

I performed some clean / logged access and think I discovered an additional SQL INNER JOIN in the query that does NOT have the extra records returned. No one has yet commented on my findings / SQL traces. In my mind, it might be as simple as adding the INNER JOIN to the Profile with Search capabilities, since Find Contacts has the INNER JOIN.
« Last Edit: January 29, 2011, 06:59:30 pm by mdlueck »
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

bijama1

  • I’m new here
  • *
  • Posts: 9
  • Karma: 0
Re: Profile for Member Directory showing duplicate records
January 30, 2011, 03:37:44 am
Hi!

Thanks a lot for the hint!!
I played around for quite a while but could not find a straight forward problem description. What I found out:

* No  Multiple "primary emails" or "primary phone" numbers in any of the cases (seems not possible since it can only be selected by radio buttons).
* Most members with doubled entries had only one Billing-eMail => setting eMail to "Main" solved the problem
* Few double entries remained with only one "Main" eMail and one "Main" Phone" number (both primary flags =1) => the only solution I found in these two cases was manually setting the "is_primary" field of the email in the database to 0.
* Most of the correct displayed members have also one "Main" eMail and one "Main" Phone number (primary flag =1)

* It seems to have an influence if the profiles have been edited (emails and phone numbers added/deleted)

Other ideas more than welcome.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Profiles (Moderator: Dave Greenberg) »
  • Profile for Member Directory showing duplicate records

This forum was archived on 2017-11-26.