Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-390

"Database Error..." when creating new account with IM Screen Name configured in CiviCRM Profile with " Key to Match Contacts?" set to Yes

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 1.1
    • Fix Version/s: 1.2
    • Labels:
      None

      Description

      If you configure "IM Screen Name" as a visible CiviCRM Profile Field in a CiviCRM Profile, set " Key to Match Contacts?" to Yes, log out then try to create a new account, you will receive the following error: "Database Error Code: Unknown table 'civicrm_im' in where clause, 1109" I have not tried the 18 other profile fields to see how they behave, but I know that First Name, Last Name & Job Title do not cause this issue with " Key to Match Contacts?" enabled.

      Steps
      1. Access CiviCRM: http://civicrm.civicspacelabs.com/home/civicrm
      2. Administer CiviCRM: http://civicrm.civicspacelabs.com/home/civicrm/admin
      3. CiviCRM Profile: http://civicrm.civicspacelabs.com/home/civicrm/admin/uf/group?reset=1
      4. Disable all current profiles.
      5. Create a New CiviCRM Profile: http://civicrm.civicspacelabs.com/home/civicrm/admin/uf/group?action=add&reset=1
      6. Save
      7. View and Edit Fields
      8. Click "add one now" next to "There are no CiviCRM Profile Fields for "Your Profile Name", you can".
      9. Under "CiviCRM Field Name" leave the default selection "First name", check mark "Required?", check mark
      "Display in Registration Form?", input 5 for "Weight", check mark "Key to Match Contacts?" and click Save. (Leave all other options as-is)
      10.Click "New CiviCRM Profile Field"
      11.Under "CiviCRM Field Name" select "Last Name", check mark "Required?", check mark "Display in Registration Form?",
      input 6 for "Weight", check mark "Key to Match Contacts?" and click Save. (Leave all other options as-is)
      12.Log out.
      13.Create new account: http://civicrm.civicspacelabs.com/home
      14.Enter a user name, e-mail address. Enter First & Last Names for required CiviCRM profile fields.
      15.Create new account
      16.The user account will be created successfully.
      17.Log back in as an admininstrator.
      18.Go back to CiviCRM Profile: http://civicrm.civicspacelabs.com/home/civicrm/admin/uf/group?reset=1
      19.View and Edit Fields
      20.Click "New CiviCRM Profile Field"
      21.Under "CiviCRM Field Name" select "IM Screen Name", check mark "Required?", check mark "Display in Registration Form?",
      input 7 for "Weight", check mark "Key to Match Contacts?" and click Save. (Leave all other options as-is)
      22.Log out.
      23.Create new account: http://civicrm.civicspacelabs.com/home
      24.Enter a user name & e-mail address. Enter a First Name, Last Name & IM Screen Name for required CiviCRM profile fields.
      25.The following erorr will be displayed on screen:

      Sorry. A non-recoverable error has occurred.
      Database Error Code: Unknown table 'civicrm_im' in where clause, 1109
      Return to CiviCRM menu.

      Notes
      1. Here is the code error dump from the problem

      error

      Array
      (
      [callback] => Array
      (
      [0] => CRM_Core_Error
      [1] => handle
      )

      [code] => -1
      [message] => DB Error: unknown error
      [mode] => 16
      [debug_info] => SELECT DISTINCT civicrm_contact.id as id FROM civicrm_contact LEFT JOIN civicrm_individual ON (civicrm_contact.id = civicrm_individual.contact_id) WHERE LOWER(civicrm_individual.first_name) = "bomb" AND LOWER(civicrm_individual.last_name) = "man" AND LOWER(civicrm_im.name) = "bomby" [nativecode=1109 ** Unknown table 'civicrm_im' in where clause]
      [type] => db_error
      [user_info] => SELECT DISTINCT civicrm_contact.id as id FROM civicrm_contact LEFT JOIN civicrm_individual ON (civicrm_contact.id = civicrm_individual.contact_id) WHERE LOWER(civicrm_individual.first_name) = "bomb" AND LOWER(civicrm_individual.last_name) = "man" AND LOWER(civicrm_im.name) = "bomby" [nativecode=1109 ** Unknown table 'civicrm_im' in where clause]
      [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT DISTINCT civicrm_contact.id as id FROM civicrm_contact LEFT JOIN civicrm_individual ON (civicrm_contact.id = civicrm_individual.contact_id) WHERE LOWER(civicrm_individual.first_name) = "bomb" AND LOWER(civicrm_individual.last_name) = "man" AND LOWER(civicrm_im.name) = "bomby" [nativecode=1109 ** Unknown table 'civicrm_im' in where clause]"]
      )

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              Anonymous
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: