Forums

hi please help, i created a form with cf5, managed to upload it but today i receive a message of error 4200??

Also I receive the email with only one field information while i have several.
I filled the Google spreadsheet but i am not getting any connection.
thanks

Hi phormann,

I don't recognise Error 4200 - what is the full message that you get? At what point in working with your form? What is the page URL when you see it?

Bob

thanks Bob error is no more present, i think i had some misconfiguration.
I have created the table and I receive the mail but only with 2 fields, the same that show in the records view while the form has 7 fields?
thanks again

Hi phormann ,

Please drag a Debugger action into the On Submit event, then submit the form and post the debug - including the 'dummy emails' results here.

Note: if you are using the Easy Wizard you can turn on Debug on the Others tab in CFv4 or the Setup tab in CFv5.

Bob

Array
(
[option] => com_chronoforms5
[chronoform] => Dasech
[event] => submit
[nombre] => patricia
[apellidopaterno] => hormann
[apellidomaterno] => illagran
[club] => Brisas de Chicureo
[correo] => phormann@uc.cl
[indice] => 20
[rut] => 5711228k
[enviar] => Enviar
[id] => 11
[ip_address] => 186.9.134.3
)
Array
(
)
Errors
Array
(
)
Debug Info
Array
(
[2] => Array
(
[DB Save] => Array
(
[Queries] => Array
(
[0] => INSERT INTO `vw1eh_chronoengine_chronoforms_datatable_Dasech` (`nombre`, `apellidopaterno`, `enviar`, `user_id`, `uniq_id`, `created`) values ('patricia', 'hormann', 'Enviar', '0', '337a56a8e555ca5eaaacb68627db86b540bcdbc7', '2018-01-19 15:14:15');
)

)

)

[1] => Array
(
[Email] => Array
(
[0] => An email with the details below was sent successfully:
[1] => To:phormann@uc.cl, dasech2014@gmail.com
[2] => Subject:Inscripción campeonatos
[3] => From name:Dasech
[4] => From email:dasech@gmail.com
[5] => CC:
[6] => BCC:
[7] => Reply name:
[8] => Reply email:
[9] => Attachments:
[10] => Array
(
)

[11] => Body:
<table>
<tbody>
<tr>
<td>Nombre</td>
<td>patricia</td>
</tr>
<tr>
<td>Apellido paterno</td>
<td>hormann</td>
</tr>
</tbody>
</table><br /><br />IP: 186.9.134.3
)

)

[3] => Array
(
[Google Spreadsheet Save] => Array
(
[Authentication] => Failed
)

)

)
© Copyright 201

Hi Bob I sent you the information after the debug

here are the messages I receive in my mail

Nombre patricia
Apellido paterno hormann

IP: 191.126.187.21

Nombre Ana maria
Apellido paterno Urrutia

IP: 190.96.21.171

i only get name and apellido of a form where there are more fields, the same happens when I see the saved table in chronoform
thanks for your help

Hi phormann,

I can only guess that the Email template needs to be updated ???

There is also a validation problem with the Google Sheets link but that should not affect the email.

Bob

Hi Bob, i need help. I cannot connect the information of my Chronoforms table to the Google spreadsheet I created. i run the debugger and this is what I get. thanks

Data Array
Array
(
    [chronoform] => Dasech
    [event] => submit
    [nombre] => patricia
    [apellidopaterno] => hormann
    [apellidomaterno] => n
    [club] => Brisas de Chicureo
    [correo] => phormann@uc.cl
    [indice] => 20
    [rut] => 5711228k
    [enviar] => Enviar
    [id] => 12
    [ip_address] => 186.9.135.177
)
Array
(
)
Errors
Array
(
)
Debug Info
Array
(
    [2] => Array
        (
            [DB Save] => Array
                (
                    [Queries] => Array
                        (
                            [0] => INSERT INTO `vw1eh_chronoengine_chronoforms_datatable_leones` (`nombre`, `apellidopaterno`, `apellidomaterno`, `club`, `correo`, `indice`, `rut`, `enviar`, `user_id`, `uniq_id`, `created`) values ('patricia', 'hormann', 'n', 'Brisas de Chicureo', 'phormann@uc.cl', '20', '5711228k', 'Enviar', '0', '6f3ede850f50acb6377408f3c9a3cbd174c2aef2', '2018-02-05 13:47:15');
                        )

                )

        )

    [3] => Array
        (
            [Google Spreadsheet Save] => Array
                (
                    [Authentication] => Failed
                )

        )

    [1] => Array
        (
            [Email] => Array
                (
                    [0] => An email with the details below was sent successfully:
                    [1] => To:phormann@uc.cl, dasech2014@gmail.com
                    [2] => Subject:Inscripción campeonatos
                    [3] => From name:Dasech
                    [4] => From email:dasech@gmail.com
                    [5] => CC:
                    [6] => BCC:
                    [7] => Reply name:
                    [8] => Reply email:
                    [9] => Attachments:
                    [10] => Array
                        (
                        )

                    [11] => Body:
<table>
<tr><td>Nombre</td><td>patricia</td></tr>
<tr><td>Apellido paterno</td><td>hormann</td></tr>
<tr><td>Apellido materno</td><td>n</td></tr>
<tr><td>Club</td><td>Brisas de Chicureo</td></tr>
<tr><td>Correo electrónico</td><td>phormann@uc.cl</td></tr>
<tr><td>Indice</td><td>20</td></tr>
<tr><td>Rut</td><td>5711228k</td></tr>
</table><br /><br />IP: 186.9.135.177
                )

        )

)

Hi phormann,
​
As you can see the Google Authentication failed. I suggest that you re-check all of those settings including the Google User and the P12 file you are using.
​
Bob

Hi Bob, I do not want to abuse of your help but I still cannot understand what I a doing wrong, my google user and password are correct. What do you mean by the P12 file?
I ran the debugger again and this is what I get
​
​

Data Array

Array
(
    [chronoform] => Dasech
    [event] => submit
    [nombre] => pilar
    [apellidopaterno] => pp
    [apellidomaterno] => hormann
    [club] => Brisas de Chicureo
    [correo] => phormann@uc.cl
    [indice] => 20
    [rut] => 5711228k
    [enviar] => Enviar
    [ip_address] => 186.9.134.101
)

Array
(
)

Errors

Array
(
)

Debug Info

Array
(
    [2] => Array
        (
            [DB Save] => Array
                (
                    [Queries] => Error creating the model class, please try a different model id.
                )

        )

    [3] => Array
        (
            [Google Spreadsheet Save] => Array
                (
                    [Authentication] => Failed
                )

        )

    [1] => Array
        (
            [Email] => Array
                (
                    [0] => An email with the details below was sent successfully:
                    [1] => To:phormann@uc.cl, dasech2014@gmail.com
                    [2] => Subject:Inscripción campeonatos
                    [3] => From name:Dasech
                    [4] => From email:dasech@gmail.com
                    [5] => CC:
                    [6] => BCC:
                    [7] => Reply name:
                    [8] => Reply email:
                    [9] => Attachments:
                    [10] => Array
                        (
                        )

                    [11] => Body:
<table>
<tr><td>Formulario de inscripción</td><td></td></tr>
<tr><td>Nombre</td><td>pilar</td></tr>
<tr><td>Apellido paterno</td><td>pp</td></tr>
<tr><td>Apellido materno</td><td>hormann</td></tr>
<tr><td>Club</td><td>Brisas de Chicureo</td></tr>
<tr><td>Correo electrónico</td><td>phormann@uc.cl</td></tr>
<tr><td>Indice</td><td>20</td></tr>
<tr><td>Rut</td><td>5711228k</td></tr>
</table><br /><br />IP: 186.9.134.101
                )

        )

)

I added this Custom code that I found from you in an old forum
​
<?php
$save = array(
'nombre',
'apellidopaterno',
'apellidomaterno',
'club',
'correo'
'indice'
'rut'
);
foreach ( $save as $s ) {
$form->data['GSheet'][$s] = $form->data[$s];
}
?>

is there a way i can send the google spreadsheet so you could take a look at it? thanks a lot

Hi phormann,
​
I don't think that the spreadsheet is the problem - it is the Google authentication process to allow remote access.
​
Please check the Google Docs here for setting up the API. If I recall correctly you may also now need to use https for the connection.
​
Bob