Forums

Duplicate Record Submission [ SOLVED ! ]

rjpilla 25 Jun, 2009
Made a simple database for testing record submission to the database following the tutorial. The data gets entered fine but I have 2 records of everything i submit. Can't seem to find the problem, plz help. Is this a connectivity problem or a form problem? Does it have anything to do with the submit button? Or is this a autgenerated code problem?
Max_admin 25 Jun, 2009
hi rjpilla,

Please create a simple form and try again, if it has the same issue then please backup the test form and attach it here to check it! make sure you have the latest release too!

Regards
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
rjpilla 25 Jun, 2009
I noticed that if i enter the data using a menu link just to the chronoform it enters a single record. It enters a double record when i use a menu link to chronoconnectivity using the example like your forum post (chronoconnectivity from start to finish) using the new record link. Hope this may help
rjpilla 25 Jun, 2009
Here is the copy of my header,body and foot code

The Physician Database.
<br />
{new_record}<br />
<table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="0">
<tbody>
<tr>
<td style="font-weight: bold; width: 20%;"> </td>
<td style="font-weight: bold; width: 20%;">Last Name</td>
<td style="font-weight: bold; width: 20%;">First Name</td>
<td style="font-weight: bold; width: 20%;">NPI</td>
<td style="font-weight: bold; width: 20%;">Cell Phone</td>
</tr>
</tbody>
</table>
<div class="clr" style="border-bottom: 3px solid #222; padding: 3px; margin-bottom: 10px;"></div>


<table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="0">
<tbody>
<tr<?php if ($i % 2) echo ' style="background-color: #EBEBEB;"';?>>
<td style="width: 20%;">{edit_record} {cf_id} </td>
<td style="width: 20%;">{text_1}</td>
<td style="width: 20%;">{text_2}</td>
<td style="width: 20%;">{text_10}</td>
<td style="width: 20%;">{text_17}</td>
</tr>
</tbody>
</table>
<?php $i++ ?>


<div class="clr" style="border-bottom: 3px solid #222; padding: 3px; margin-bottom: 10px;"></div>
<script type="text/javascript">
window.addEvent('domready', function() {
var limit_select = $('limit').options;
if ( !limit_select ) return;
for ( var i = 0; i < limit_select.length; i++ ) {
if ( limit_select[i].value == 0 ) {
limit_select[i].value = 250;
limit_select[i].innerHTML = '250';
}
}
});
</script>
<div align="center">{pagination}</div>
<br />
rjpilla 25 Jun, 2009
If I post a record using the link provided in the chronoforms form manager i get a single record. If I post a record using {new_record} link it enters 2 duplicate records. Please can use any help.
Max_admin 25 Jun, 2009
mmm, do you have DB connection enabled in the form you use for editing ? which ChronoConnectivity version do you have ?

Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
rjpilla 26 Jun, 2009
Oh Man Thank you. That was the problem. I had DB enabled in the edit form. Again I thank you.
gugely36 27 Jun, 2009
Hi

I have the same problem with the duplicate records...... where do I find this DB Enabled setting in CC or IN CF?

Michael
Max_admin 28 Jun, 2009
Hi Michael,

CC will save a record by default, so disable DB connection in your form used for editing or it will save its own as well!

Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
GMiranda 28 Sep, 2009
I have the same problem of Duplicating the Record from CC.

I would like that the user can fill and send a form, and that the Admin cand add records from the CC list.

If I disable de DB Connection in the CF I suppose it will not work by itself.

So, must I creat 2 CFs, one for the public, as CF and the second for the Admin with the CC ??

Thnak you,
Gonzalo
This topic is locked and no more replies can be posted.