Unknown column 'Array' in 'field list'

Save checkbox array data to a database.

Overview

The issue occurs when trying to save multiple checkbox selections as an array without proper configuration.
Add the checkbox field name to the JSON fields setting in the CF Save Data action to correctly process the array.

Answered
ChronoForms v8
lo lollymaster 25 Aug, 2024

Hi all,

im trying to save a checkboxes into db.

Checkboxes permit to save mutli choices(so an array of choices). I create a db field as verchar 255.

when i try to save data with submit( then i use save data) i have the problem in subject.

I tried to rename the db field with "array" and the error disappears, but nathing saved.

Can someone help me please?

thanks a lot,

Lorenzo.

lo lollymaster 27 Aug, 2024

sorry, but none can help me?

my problem is simple(i think): just save a checkboxes on db with savedata.

None saves checkboxes field on db?

Max_admin Max_admin 10 Sep, 2024
Answer

Hi lollymaster

Apologies for the late reply, I was out of town

You need to add the checkboxes field name to the JSON fields behavior setting in the "Save data" action

Unknown column 'Array' in 'field list' image 1

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Post a Reply