Unknown column 'Array' in 'field list'

How to fix the 'Unknown column 'Array' in 'field list'' error when saving a checkbox group in ChronoForms.

Overview

The error occurs because the form submits the checkbox group as an array, which the standard database save action cannot process directly.
Enable the JSON fields behavior in the Save Data action settings and specify the name of the checkbox field to have its array data properly encoded and stored.

Answered
ChronoForms v8
al alexatr 23 Jul, 2024

Hello Bob, Chronoforms-TeamThe moment I use a checkbox group and then select at least 1 option there, I get this error message when I save to the database. The field Option is created as VarChar(256) in the SQL database. What am I doing wrong?

Many thanks for your help in advance.

DebugData

Array
(
    [option] => com_chronoforms8
    [action] => view
    [id] => 3
    [chronoform] => test
    [Text] => sd
    [Option] => Array
        (
            [0] => ck1
        )

    [button_4] => 
    [chronopage] => 0
    [sectoken] => 669fbe1b260de0.38424481
)

Files

Array
(
)

Vars

Array
(
    [app_active_page] => 0
    [Option] => Array
        (
            [selection] => Array
                (
                    [0] => Choice #1
                )

        )

    [save_data5] => false
)

Info

Array
(
    [save_data5] => Array
        (
            [returned] => false
        )

)
Bildschirmfoto 2024-07-23 um 16.34.25.png
Max_admin Max_admin 25 Jul, 2024

How did you setup the "Save data" action ?

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
al alexatr 25 Jul, 2024

Somewhere I have found that here {Data:} here. Without an array this also works only with the checkbox fields or other fields with several values inside you get the error message.

Bildschirmfoto 2024-07-25 um 07.26.18.png
al alexatr 31 Jul, 2024

No tips for my problem?And then you want a positive rating when the support is so bad?

pr prashanth.sp.rao956 03 Aug, 2024
1 Likes

I am facing the same issue.. Is there a place for documentation or help videos that I can watch.

Chronoforms looks like a powerful tool but without knowing how to use, I am not able to take advantage of this tool.

Max_admin Max_admin 11 Sep, 2024
Answer

Apologies for the late reply, the solution is to enable the JSON fields behavior in Sava data and enter your array field name, screenshot:

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