Forums

email adress doesn't save with DB save action

ideescom 24 Jul, 2014
Hi,
i activate the DB save action, i can save all the fields i need, but just one can't be saved : my email field.
Is this a bug ?
Look at the attachment.

[attachment=0]php.png[/attachment][attachment=1]sql.png[/attachment]
GreyHead 24 Jul, 2014
Hi ideescom,

It's not a bug. Nor is there enough information to get any clue :-(

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

Bob
ideescom 24 Jul, 2014
Thanks for fast anwser.
Here is the full debug :

Data Array

Array
(
    [chronoform] => Contact
    [event] => submit
    [Itemid] => 106
    [option] => com_content
    [view] => article
    [id] => 27
    [nom] => sss
    [prenom] => 
    [date] => 
    [adresse] => 
    [cp] => 
    [ville] => 
    [tel] => 
    [tel2] => 
    [tel3] => 
    [email] => blabla@gmail.com
    [text] => 
    [captcha] => 
    [save] => Envoyer
    [ip_address] => 86.209.221.187
    [] => 0
)

Array
(
)

Errors

Array
(
)

Debug Info

Array
(
    [0] => Array
        (
            [Email] => Array
                (
                    [0] => An email with the details below was sent successfully:
                    [1] => To:pugnat.florian@gmail.com
                    [2] => Subject:formulaire web move and danse
                    [3] => From name:
                    [4] => From email:blabla@gmail.com
                    [5] => CC:
                    [6] => BCC:
                    [7] => Reply name:
                    [8] => Reply email:email
                    [9] => Attachments:
                    [10] => Body:
<table>
<tbody>
<tr>
<td>Nom :</td>
<td>sss</td>
</tr>
<tr>
<td>Prénom :</td>
<td></td>
</tr>
<tr>
<td>Date de naissance :</td>
<td></td>
</tr>
<tr>
<td>Adresse :</td>
<td></td>
</tr>
<tr>
<td>Code Postal :</td>
<td></td>
</tr>
<tr>
<td>Ville :</td>
<td></td>
</tr>
<tr>
<td>Tél Domicile :</td>
<td></td>
</tr>
<tr>
<td>Tél Portable :</td>
<td></td>
</tr>
<tr>
<td>Tél Travail :</td>
<td></td>
</tr>
<tr>
<td>E-Mail :</td>
<td>blabla@gmail.com</td>
</tr>
<tr>
<td>Demande :</td>
<td></td>
</tr>
<tr>
<td>Dossier Envoyer :</td>
<td></td>
</tr>
</tbody>
</table>
                )

        )

    [15] => Array
        (
            [DB Save] => Array
                (
                    [Queries] => Array
                        (
                            [0] => INSERT INTO `dbsave` (`nom`, `prenom`, `date`, `adresse`, `cp`, `ville`, `tel`, `tel2`, `tel3`, `text`) values ('sss', '', '', '', '', '', '', '', '', '');
                        )

                )

        )

)
GreyHead 24 Jul, 2014
Hi ideescom,

That all looks OK. Did you add the email field later than the others? If so I think you need to click the Delete Cache icon in the Forms Manager Toolbar to update the DB columns that ChronoForms uses.

Bob
ideescom 24 Jul, 2014
Thank you very much Bob, it works !!
What a fast support 😀 :mrgreen:
This topic is locked and no more replies can be posted.