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) »
  • Email does not show in a profile search list
Pages: [1]

Author Topic: Email does not show in a profile search list  (Read 1995 times)

Cedeira

  • I post occasionally
  • **
  • Posts: 45
  • Karma: 1
    • CompuLogiX Systems, Inc.
Email does not show in a profile search list
November 10, 2008, 06:34:04 pm
Hi all,

before I submit this as a bug or issue on the tracker, I thought I would pass it by the forum. I tested the same steps on the demo sandbox (http://joomla.demo.civicrm.org joomla version) with same results as in my setup.
Summary of task: create a profile to be used for listing individual's name, phone and email data items only for an specific group, to be used on front end of site.

1. Create a profile to be used for "Profile" and "Search results"
2. Add fields from Individual(contact) records, include the email field (in my setup only 1 email is being used under the Home label (I assume since I tried to select all of the types of emails without any luck).
3. On the Profile settings restrict the profile search to be used for one group.
4. Test the profile list by doing an Advance search on contacts(individuals) and make sure you select the profile created in step 1.
OR as a front-end test use something like this link: http://joomla.demo.civicrm.org/index.php?option=com_civicrm&task=civicrm/profile&force=1&gid=2, if you create it on your own setup make sure to substitute the number in the link "gid=2" to correspond with the ID of your created profile. 

Any ideas suggestions, comments?

thank you,
Jose

God grant me the serenity to accept the things I can not change, valor to change the ones I can, and the knowledge to recognize the difference!

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: Email does not show in a profile search list
November 11, 2008, 05:38:50 am

jose:

can you please file an issue. we'll fix for 2.1 or 2.2 (depending on how extensive the fix is)

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

Cedeira

  • I post occasionally
  • **
  • Posts: 45
  • Karma: 1
    • CompuLogiX Systems, Inc.
Re: Email does not show in a profile search list
November 13, 2008, 06:55:50 am
Lobo,

Will do. I will check to see where it is failing to see if I can point the developer in the right direction.

Jose

God grant me the serenity to accept the things I can not change, valor to change the ones I can, and the knowledge to recognize the difference!

Cedeira

  • I post occasionally
  • **
  • Posts: 45
  • Karma: 1
    • CompuLogiX Systems, Inc.
Re: Email does not show in a profile search list
November 13, 2008, 09:03:15 am
getting an error on the profile view now that seems to point to the issue:

Code: [Select]
Database Error Code: Unknown column 'Home-email-1.email' in 'where clause', 1054

Error Details:

[db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT count(DISTINCT contact_a.id) FROM civicrm_contact contact_a LEFT JOIN civicrm_email `Home-email` ON contact_a.id = `Home-email`.contact_id AND `Home-email`.location_type_id = 1 LEFT JOIN civicrm_location_type `Home-location_type` ON ( ( `Home-phone-Mobile`.location_type_id = `Home-location_type`.id )OR ( `Home-phone-Phone`.location_type_id = `Home-location_type`.id )OR ( `Home-address`.location_type_id = `Home-location_type`.id ) OR ( `Home-email`.location_type_id = `Home-location_type`.id ) ) LEFT JOIN civicrm_group_contact `civicrm_group_contact-4` ON contact_a.id = `civicrm_group_contact-4`.contact_id WHERE ( LOWER(`Home-email-1`.email) LIKE '%xyxcvas@asfsafsew.net%' AND `civicrm_group_contact-4`.group_id IN ( 4 ) AND `civicrm_group_contact-4`.status IN ("Added") ) AND ( 1 ) [nativecode=1054 ** Unknown column 'Home-email-1.email' in 'where clause']"]
I masked the email address in the select statement for privacy reasons.
God grant me the serenity to accept the things I can not change, valor to change the ones I can, and the knowledge to recognize the difference!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Profiles (Moderator: Dave Greenberg) »
  • Email does not show in a profile search list

This forum was archived on 2017-11-26.