Forums

Hello

i'm using joomla 3.7.2 and chronoform, php version 7.0.15 and chronoform 6.0.5.
My form in not a multi page.
I receive data in email, it's ok.
I created a table to save data and export in csv.
All is working fine ..... but some data are missing in database .
Fields exist but are empty in phpmyadmin.
I don't understand that random error.

Thanks.

Hi monfil29 ,

Please drag a Debugger action into the On Submit event, then submit the form and post the debug results here. That should show the MySQL query that is being created.

Bob

Hi Bob

here results

Array
(
    [chronoform] => inscription-forum-des-associations-2017
    [event] => submit
    [nomassoc] => trhr
    [siegesocial] => trh
    [email] => rhh@ffl.com
    [telephone] => 0296020305
    [datedeclarationprefecture] => erf
    [objetsocial] => erf
    [textarea53] => fef
    [thematique] => Action sociale
    [radio16] => non
    [president] => efer
    [adesspresident] => erf
    [telpresident] => 02312ef
    [mailpresident] => 
    [responsablestandpresident] => oui
    [nomresponsstand] => 
    [text25] => 
    [text26] => 
    [text27] => 
    [text28] => 
    [inscriptionsauforum] => oui
    [communicationinscriptions] => oui
    [radio29] => oui
    [responsableanimation] => oui
    [nomresponsablanimations] => efer
    [text33] => efe
    [text34] => ef
    [emailresponsanima] => 
    [text36] => 
    [radio37] => 
    [typesanimations] => Musique
    [autreanimation] => 
    [dureeprestation] => 
    [radio43] => 
    [micro] => 
    [radio45] => 
    [branchementelec] => oui
    [radio49] => oui
    [radio56] => 
    [radio57] => 
    [button7] => submit
    [f5a950283b0bc43609afd1fedd294161] => 6eec4436e58b33e120a178e53772ab3a
    [9344845b3af87c806d44097de5dd60f7] => 8fe1d047b1ae8fac8f608703bc33de5e
    [_gat] => 1
    [_ga] => GA1.2.1337898611.1494486340
    [_gid] => GA1.2.1441058926.1497862971
    [Itemid] => 197
    [option] => com_chronoforms6
    [view] => form
)
Array
(
    [email2] => Array
        (
            [recipients] => Array
                (
                    [0] => philippe@--------.fr
                    [1] => second@---------.fr
                )

            [subject] => Forum des assos / inscriptions
            [body] => <wrapper><h2>Nouvelle insciption au forum des associations!</h2></wrapper>
<container>
<row>
<column first last>
<table width="100%" cellpadding="3" cellspacing="3" border="0" class="ui table">
<tr><td width="30%" valign="top" align="right"><strong>Nom association : </strong></td><td width="70%" valign="top" align="left">trhr</td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Siège social</strong></td><td width="70%" valign="top" align="left">trh</td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Email</strong></td><td width="70%" valign="top" align="left">rhh@ffl.com</td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Téléphone</strong></td><td width="70%" valign="top" align="left">0296020305</td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Date déclaration en sous-préfecture</strong></td><td width="70%" valign="top" align="left">erf</td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Objet social</strong></td><td width="70%" valign="top" align="left">erf</td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Présentation de votre association et de ses activités (5 lignes). Ces informations ont vocation à être mises à disposition du public le jour du forum</strong></td><td width="70%" valign="top" align="left">fef</td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Thématique</strong></td><td width="70%" valign="top" align="left">Action sociale</td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Avez-vous reçu une subvention de la ville de Lannion pour l'année 2017? </strong></td><td width="70%" valign="top" align="left">non</td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Nom président</strong></td><td width="70%" valign="top" align="left">efer</td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Adresse président</strong></td><td width="70%" valign="top" align="left">erf</td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Téléphone président </strong></td><td width="70%" valign="top" align="left">02312ef</td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Email président</strong></td><td width="70%" valign="top" align="left"></td></tr>
<tr><td width="30%" valign="top" align="right"><strong>La personne responsable du stand est-elle le président? </strong></td><td width="70%" valign="top" align="left">oui</td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Nom responsable stand</strong></td><td width="70%" valign="top" align="left"></td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Prénom responsable stand</strong></td><td width="70%" valign="top" align="left"></td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Adresse responsable stand</strong></td><td width="70%" valign="top" align="left"></td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Email responsable stand</strong></td><td width="70%" valign="top" align="left"></td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Téléphone responsable stand</strong></td><td width="70%" valign="top" align="left"></td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Proposerez-vous des inscriptions à vos activités durant le forum?</strong></td><td width="70%" valign="top" align="left">oui</td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Nous autorisez-vous à communiquer cette information sur nos supports de communication?</strong></td><td width="70%" valign="top" align="left">oui</td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Souhaitez vous proposer des animations?</strong></td><td width="70%" valign="top" align="left">oui</td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Si oui, la personne responsable des animations est elle différente du président</strong></td><td width="70%" valign="top" align="left">oui</td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Nom responsable des animations</strong></td><td width="70%" valign="top" align="left">efer</td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Prénom responsable des animations</strong></td><td width="70%" valign="top" align="left">efe</td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Adresse responsable des animations</strong></td><td width="70%" valign="top" align="left">ef</td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Email responsable des animations</strong></td><td width="70%" valign="top" align="left"></td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Téléphone responsable des animations</strong></td><td width="70%" valign="top" align="left"></td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Ou proposez-vous une animation?</strong></td><td width="70%" valign="top" align="left"></td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Quel type d'animation, proposerez-vous?</strong></td><td width="70%" valign="top" align="left">Musique</td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Autre animation proposée :</strong></td><td width="70%" valign="top" align="left"></td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Durée de la prestation (ne peut pas dépasser 15 minutes)</strong></td><td width="70%" valign="top" align="left"></td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Nombre de prestations proposées :</strong></td><td width="70%" valign="top" align="left"></td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Matériel nécessaire: Micro</strong></td><td width="70%" valign="top" align="left"></td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Diffusion de musique d'accompagnement :</strong></td><td width="70%" valign="top" align="left"></td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Souhaitez-vous un branchement électrique?</strong></td><td width="70%" valign="top" align="left">oui</td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Souhaitez-vous obtenir des informations sur le service de restauration ?</strong></td><td width="70%" valign="top" align="left">oui</td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Candidatez-vous pour un stand à la maison des sports?</strong></td><td width="70%" valign="top" align="left"></td></tr>
<tr><td width="30%" valign="top" align="right"><strong>Voulez-vous assurer le service de restauration à la maison des sports?</strong></td><td width="70%" valign="top" align="left"></td></tr>
</table>
</column>
</row>
</container>
            [from_name] => Associations Lannion
            [from_email] => philippe.salou@ville-lannion.fr
            [reply_name] => Ville de Lannion
            [reply_email] => philippe.salou@ville-lannion.fr
            [result] => the Mail sent successfully.
            [var] => 1
        )

    [save_data4] => Array
        (
            [data] => Array
                (
                    [created] => 2017-06-19 13:05:47
                    [user_id] => 0
                    [nomassoc] => trhr
                    [siegesocial] => trh
                    [email] => rhh@ffl.com
                    [telephone] => 0296020305
                    [datedeclarationprefecture] => erf
                    [objetsocial] => erf
                    [textarea53] => fef
                    [thematique] => Action sociale
                    [radio16] => non
                    [president] => efer
                    [adesspresident] => erf
                    [telpresident] => 02312ef
                    [mailpresident] => 
                    [responsablestandpresident] => oui
                    [nomresponsstand] => 
                    [text25] => 
                    [text26] => 
                    [text27] => 
                    [text28] => 
                    [inscriptionsauforum] => oui
                    [communicationinscriptions] => oui
                    [radio29] => oui
                    [responsableanimation] => oui
                    [nomresponsablanimations] => efer
                    [text33] => efe
                    [text34] => ef
                    [emailresponsanima] => 
                    [text36] => 
                    [radio37] => 
                    [typesanimations] => Musique
                    [autreanimation] => 
                    [dureeprestation] => 
                    [radio43] => 
                    [micro] => 
                    [radio45] => 
                    [branchementelec] => oui
                    [radio49] => oui
                    [radio56] => 
                    [radio57] => 
                )

            [_success] => Data saved successfully
            [log] => Array
                (
                    [0] => INSERT INTO `y9m16_chronoform_data_forum-assocs-2017` (`created`, `user_id`, `nomassoc`, `siegesocial`, `email`, `telephone`, `datedeclarationprefecture`, `objetsocial`, `textarea53`, `thematique`, `radio16`, `president`, `adesspresident`, `telpresident`, `mailpresident`, `responsablestandpresident`, `nomresponsstand`, `text25`, `text26`, `text27`, `text28`, `inscriptionsauforum`, `communicationinscriptions`, `radio29`, `responsableanimation`, `nomresponsablanimations`, `text33`, `text34`, `emailresponsanima`, `text36`, `radio37`, `typesanimations`, `autreanimation`, `dureeprestation`, `radio43`, `micro`, `radio45`, `branchementelec`, `radio49`, `radio56`, `radio57`)  values  ('2017-06-19 13:05:47', '0', 'trhr', 'trh', 'rhh@ffl.com', '0296020305', 'erf', 'erf', 'fef', 'Action sociale', 'non', 'efer', 'erf', '02312ef', '', 'oui', '', '', '', '', '', 'oui', 'oui', 'oui', 'oui', 'efer', 'efe', 'ef', '', '', '', 'Musique', '', '', '', '', '', 'oui', 'oui', '', '');
                )

            [var] => Array
                (
                    [created] => 2017-06-19 13:05:47
                    [user_id] => 0
                    [nomassoc] => trhr
                    [siegesocial] => trh
                    [email] => rhh@ffl.com
                    [telephone] => 0296020305
                    [datedeclarationprefecture] => erf
                    [objetsocial] => erf
                    [textarea53] => fef
                    [thematique] => Action sociale
                    [radio16] => non
                    [president] => efer
                    [adesspresident] => erf
                    [telpresident] => 02312ef
                    [mailpresident] => 
                    [responsablestandpresident] => oui
                    [nomresponsstand] => 
                    [text25] => 
                    [text26] => 
                    [text27] => 
                    [text28] => 
                    [inscriptionsauforum] => oui
                    [communicationinscriptions] => oui
                    [radio29] => oui
                    [responsableanimation] => oui
                    [nomresponsablanimations] => efer
                    [text33] => efe
                    [text34] => ef
                    [emailresponsanima] => 
                    [text36] => 
                    [radio37] => 
                    [typesanimations] => Musique
                    [autreanimation] => 
                    [dureeprestation] => 
                    [radio43] => 
                    [micro] => 
                    [radio45] => 
                    [branchementelec] => oui
                    [radio49] => oui
                    [radio56] => 
                    [radio57] => 
                    [aid] => 167
                )

        )

)

It works that time.
Thanks.

Hi monfil29,

OK - please let us know if you see the problem again.

Bob

Hello

the 3 last submissions are empty in the database ... but data are ok in the mail.

Philippe

Hi Philippe,

Hard to know why that would happen. If the data is in one place it should be in both. Can you replicate this with the Debugger on?

Bob