Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 1.1
-
Fix Version/s: 1.2
-
Component/s: Technical infrastructure
-
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]"]
)