Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 1.1
-
Fix Version/s: 1.1
-
Component/s: None
-
Labels:None
Description
1. Create new profile "Profile 1".
2. Add a profile field "Note".
3. Goto my account -> edit.
enter the note and submit.
Database Error Code: Unknown table 'civicrm_note' in where clause, 1109
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_email ON (civicrm_location.id = civicrm_email.location_id AND civicrm_email.is_primary = 1) LEFT JOIN civicrm_location ON (civicrm_location.entity_table = 'civicrm_contact' AND
civicrm_contact.id = civicrm_location.entity_id AND
civicrm_location.is_primary = 1) WHERE LOWER(civicrm_email.email) = "kurund@webaccess.co.in" AND LOWER(civicrm_note.note) = "dsdsdsdsds" AND civicrm_contact.id != 101 [nativecode=1109 ** Unknown table 'civicrm_note' in where clause]
[type] => DB_Error
[user_info] => SELECT DISTINCT civicrm_contact.id as id FROM civicrm_contact LEFT JOIN civicrm_email ON (civicrm_location.id = civicrm_email.location_id AND civicrm_email.is_primary = 1) LEFT JOIN civicrm_location ON (civicrm_location.entity_table = 'civicrm_contact' AND
civicrm_contact.id = civicrm_location.entity_id AND
civicrm_location.is_primary = 1) WHERE LOWER(civicrm_email.email) = "kurund@webaccess.co.in" AND LOWER(civicrm_note.note) = "dsdsdsdsds" AND civicrm_contact.id != 101 [nativecode=1109 ** Unknown table 'civicrm_note' 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_email ON (civicrm_location.id = civicrm_email.location_id AND civicrm_email.is_primary = 1) LEFT JOIN civicrm_location ON (civicrm_location.entity_table = 'civicrm_contact' AND
civicrm_contact.id = civicrm_location.entity_id AND
civicrm_location.is_primary = 1) WHERE LOWER(civicrm_email.email) = "kurund@webaccess.co.in" AND LOWER(civicrm_note.note) = "dsdsdsdsds" AND civicrm_contact.id != 101 [nativecode=1109 ** Unknown table 'civicrm_note' in where clause]"]
)