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

Auto-complete enum value for civicrm_custom_field data column not included in any incremental upgrade tpl file

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 3.0
    • Fix Version/s: 3.0
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      The actual error I'm getting when I try to add a custom field of type Auto-complete Select is

      INSERT INTO civicrm_custom_field (custom_group_id , label , data_type , html_type , default_value , is_required , is_searchable , is_search_range , weight , help_pre , help_post , is_active , is_view , options_per_line , text_length , start_date_years , end_date_years , date_parts , note_columns , note_rows , column_name , option_group_id ) VALUES ( 13 , 'testfield' , 'Auto-complete' , 'Select' , NULL , 0 , 0 , 0 , 4 , NULL , NULL , 1 , 0 , NULL , 255 , NULL , NULL , 'MdY' , 60 , 4 , 'testfield', 75 ) [nativecode=1265 ** Data truncated for column 'data_type' at row 1]

      I upgraded an svn install manually from 2.2, but I don't see any of the incremental upgrade files which have this enum added to the data type column.

        Attachments

          Activity

            People

            • Assignee:
              shot Piotr Szotkowski
              Reporter:
              demeritcowboy Dave D
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: