CiviCRM Community Forums (archive)

The street_unit field in the table civicrm_address is only VARCHAR(16), whilst the street_name field is VARCHAR(64).  Surely this is inconsistent?  I tried a data import that failed because of this error.



Sorry. A non-recoverable error has occurred.

--------------------------------------------------------------------------------

DB Error: unknown error



 Error Details

Database Error Code: Data too long for column 'street_unit' at row 1, 1406

Additional Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => UPDATE  civicrm_address  SET contact_id = 1740 , location_type_id = 1 , is_primary = 1 , is_billing = 0 , street_address = '4 rue Pierre et Marie Curie' , street_number = 4 , street_number_suffix = NULL , street_name = 'rue' , street_unit = 'Pierre et Marie Curie' , city = '49480 St Sylvain d’Anjou' , country_id = 1076 , geo_code_1 = 47.5158484 , geo_code_2 = -0.4724194   WHERE (  civicrm_address.id = 1739 )   [nativecode=1406 ** Data too long for column 'street_unit' at row 1]
    [type] => DB_Error
    [user_info] => UPDATE  civicrm_address  SET contact_id = 1740 , location_type_id = 1 , is_primary = 1 , is_billing = 0 , street_address = '4 rue Pierre et Marie Curie' , street_number = 4 , street_number_suffix = NULL , street_name = 'rue' , street_unit = 'Pierre et Marie Curie' , city = '49480 St Sylvain d’Anjou' , country_id = 1076 , geo_code_1 = 47.5158484 , geo_code_2 = -0.4724194   WHERE (  civicrm_address.id = 1739 )   [nativecode=1406 ** Data too long for column 'street_unit' at row 1]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE  civicrm_address  SET contact_id = 1740 , location_type_id = 1 , is_primary = 1 , is_billing = 0 , street_address = '4 rue Pierre et Marie Curie' , street_number = 4 , street_number_suffix = NULL , street_name = 'rue' , street_unit = 'Pierre et Marie Curie' , city = '49480 St Sylvain d’Anjou' , country_id = 1076 , geo_code_1 = 47.5158484 , geo_code_2 = -0.4724194   WHERE (  civicrm_address.id = 1739 )   [nativecode=1406 ** Data too long for column 'street_unit' at row 1]"]
)