Forums

Unknown column 'Array' in 'field list'

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 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.
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
alexatr 31 Jul, 2024

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

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 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:

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
You need to login to be able to post a reply.