Form Field Types : multi
  • Hello,

    I've created the following in my model:

    $tags = array('bike' => 'bike', 'breakdown' => 'breakdown', 'business' => 'business', 'car' => 'car', 'home' => 'home', 'other'
    => 'other', 'pet' => 'pet', 'travel' => 'travel', 'van' => 'van');
    $fields['tags'] = array( 'type' => 'multi', 'mode' => 'multi', 'options' => $tags);

    In my database I have a 'tags' column name, but firstly I don't know what Data Type the field should be?

    When saving the record I get the following error:

    Message: Array to string conversion

    And further down the culprit:

    Error Number: 1054

    Unknown column 'Array' in 'field list'

    INSERT IGNORE INTO `kbarticles` (`id`, `title`, `tags`, `slug`, `section1_heading`, `section1_content`, `section1_image`, `section2_heading`, `section2_content`, `section2_image`, `section3_heading`, `section3_content`, `section3_image`, `section4_heading`, `section4_content`, `section4_image`, `section5_heading`, `section5_content`, `section5_image`, `published`) VALUES ('3', 'What are the different types of Insurance cover?', Array, '/test', 'Explore the different types of coverage', '
  • Okay, I've serialized the field that seems to provide a working solution; so the chosen options are saved as JSON.
  • However, if tag(s) are saved and then removed fully and resaved it doesn't recognise the user emptied the field. Hmmm.
  • function on_before_save($values) {
    if ( sizeof( $values['tags'] ) == 0 ) {
    $values['tags'] = '';
    return $values;

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!