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.
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
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
It works that time.
Thanks.
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.
Hello
the 3 last submissions are empty in the database ... but data are ok in the mail.
Philippe
the 3 last submissions are empty in the database ... but data are ok in the mail.
Philippe
This topic is locked and no more replies can be posted.
