Buy Now
Sign in

error 4200

phormann , January 16 at 14:32
P
phormann
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
GreyHead
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
P
phormann
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
GreyHead
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
P
phormann
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
P
phormann
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
GreyHead
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
P
phormann

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
)

)

)
GreyHead
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
P
phormann
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
[div]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
(
)
[/div]
[div]Errors
Array
(
)
[/div]
[div]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
)

)

)
[/div]
P
phormann
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];​
​}​
​?>
P
phormann
is there a way i can send the google spreadsheet so you could take a look at it? thanks a lot
GreyHead
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much