ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Problem with multi-select fields not saving

June 20, 2012 5:45pm

Subscribe [1]
  • #1 / Jun 20, 2012 5:45pm

    matrixgroup

    15 posts

    I have a channel with a couple custom fields added to it. One of which is a multi-select field. I can make and save changes to all of the fields but what ever I select in the multi select field doesn’t get saved.

    I’ve turned on SQL debugging and get the following error

    A Database Error Occurred
    Error Number: 1054
    
    Unknown column 'Array' in 'field list'
    
    UPDATE `exp_channel_data` SET `channel_id` = '59', `field_id_1` = '', `field_id_3` = '
    
    \n Who to Contact\n', `field_id_5` = '', `field_ft_5` = 'none', `field_id_41` = Array, `field_ft_41` = 'none', `field_id_42` = '1', `field_id_43` = '', `field_id_2` = '', `field_id_6` = '', `field_id_7` = '', `field_id_8` = '', `field_id_9` = '', `field_id_19` = '', `field_id_20` = '', `field_id_21` = '', `field_id_22` = '', `field_id_23` = '', `field_id_24` = '', `field_id_25` = '', `field_id_26` = '', `field_id_27` = '', `field_id_28` = '', `field_id_29` = '', `field_id_30` = '', `field_id_31` = '', `field_id_33` = '', `field_id_35` = '', `field_id_36` = '', `field_id_37` = '', `field_id_38` = '', `field_id_40` = '', `field_id_44` = '', `field_id_45` = '', `field_id_46` = '', `field_id_47` = '', `field_id_48` = '', `field_id_49` = '' WHERE `entry_id` = '18304'
    Filename: libraries/api/Api_channel_entries.php
    
    Line Number: 2007

    The section which caught my eye was this:

    `field_id_41` = Array, `field_ft_41` = 'none'

    . It looks like EE isn’t properly handling the array being passed by the select box.

    How can I go about fixing this so that I can make changes to this field?

    I’ve encountered this issue on v2.4.0

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases