Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 1.4
-
Fix Version/s: 1.5
-
Component/s: Technical infrastructure
-
Labels:None
Description
If the Phone Type drop down isn't set when entering a new phone number CiviCRM crashes with following error report. Should be validated and caught.
+++++
Sorry. A non-recoverable error has occurred.
Database Error Code: Data truncated for column 'phone_type' at row 1, 1265
Return to CiviCRM menu.
error
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] => INSERT INTO civicrm_phone (location_id , phone , phone_type , is_primary ) VALUES ( 12499 , '+44 7841 097101' , '' , 1 ) [nativecode=1265 ** Data truncated for column 'phone_type' at row 1]
[type] => DB_Error
[user_info] => INSERT INTO civicrm_phone (location_id , phone , phone_type , is_primary ) VALUES ( 12499 , '+44 7841 097101' , '' , 1 ) [nativecode=1265 ** Data truncated for column 'phone_type' at row 1]
[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_phone (location_id , phone , phone_type , is_primary ) VALUES ( 12499 , '+44 7841 097101' , '' , 1 ) [nativecode=1265 ** Data truncated for column 'phone_type' at row 1]"]
)