Data not saved

Hi,
Any reason why my form no longer saves the data since upgrading to RC3 version of ChronoForms? This site is running Joomla 1.5.1

It is the same form used on another Joomla site running J1.5 RC3 (not upgraded to stable yet), and older version of ChronoForms (not sure which version, but installed December 2007). That install works fine.

Maybe there are changes need to my form to work with latest version(s) of Joomla or ChronoForms?

Any help appreciated.

best wishes,

- Vince

Hi Vince,

Sorry, no idea. I didn't think that Max had changed anything in this area. Hopefully I'll have time to take a look over the weekend.

Bob

Thanks Bob.
Shall I email you the form bkp file?

Best wishes,

- Vince

Hi Vince,

Yes, please do. And let me know which versions of Joomla and CF you are using. Thanks

Bob

Hi Bob, you are a diamond :cheer:
Email sent.

By the way, the server environment is:
Apache/1.3.34
PHP Version 4.4.8
MySQL
Database Version: 4.0.27-standard
Database Collation: N/A (mySQL < 4.1.2)
Client API version: 5.0.32

Safe Mode: Off
Register Globals: Off

The above is the same for the other domain running older versions of J! and CF (same server).

Thanks again, and best wishes,

- Vince

no matter what i do, no data is saved.

Joomla! version 1.5.2
Apache version 2.2.8 (Unix)
PHP version 5.2.5
MySQL version 4.1.22-standard


i've tried deleting the db table, element tags, dataview field and autogenerated code, then redoing it all again but nothing works. nothing ever gets saved into the database.

however, the emailing system is fine.

hi Hadakajime,

Please take a Form Backup from the Form Manager and email it to me at the address in my sig so that I can take a closer look.

Bob

Hi Bob,
Any luck with my form?
Many thanks,

- Vince

I'm also having the same problems with saving data to the database. I'm able to provide a backup if required. Running 2.5 J1.5 RC2 with Joomla 1.5.2.

Hi Vince,

Thanks for the nudge. Sorry, I'll go take a look now . . .

I think I was waiting till I installed the latest CF, I'll do that too.

Bob

hi
i have the same problem - no data saved.
i have a new install from chronoform (rc3) an joomla 1.5.2.
thank's for your message, if you have a solution.
matrix

Hi Vince,

The bad news is that it runs OK for me . . .

Joomla 1.5.2; Apache 2.2.4 (Win32), PHP 5.2.3, MySQL 5.0.45
ChronoForms 2.5 RC3.1

Small differences in set up but nothing that should affect this.

I restored the form, deleted the AutoGenerated code, recreated the table with all VARCHAR except the comments which I left as default, deleted the Redirect URL as it blocks the DeBug code. Saved and submitted the form and the record saved.

I'd suggest that you add some code to echo the sql in the AutoGenerated box and then try manually submitting the SQL in PHPMyAdmin. Sometimes this shows up small errors.

Bob

hmm I'd not spotted the auto generate code was missing on mine. Had some trouble installing the tables so had to do it manually. Now put the code in and it's working.

Hi peterson,

Good catch :-)

Bob

hi
no chance - i have resotred the form, deleted the tables, new generated the tables - nothing is saved.

news: i had a URL (in the field "redirect url) after the submit the form. when i delete this URL, the dates ares safed....
this is not amused - i can't make a message, that the formular is correct submitted.

Post edited by: matrix, at: 2008/04/22 15:05<br><br>Post edited by: matrix, at: 2008/04/22 15:12

Hi Matrix,

That looks like the bug that Ronan reported here Please try the attached copy of chronocontact.php and see if that fixes the problem (I've made the change that Ronan suggested and zipped the file so it will upload here).

Bob

PS Caution: for ChronoForms 1.5RC3.1 only [file name=chronocontact-2cd0d2491a2cb4c20c5b30a57662d800.zip size=5635]http://www.chronoengine.com/components/com_fireboard/uploaded/files/chronocontact-2cd0d2491a2cb4c20c5b30a57662d800.zip[/file]<br><br>Post edited by: GreyHead, at: 2008/04/22 15:50

hi bob
that's it - thank you!
matrix

Hi Matrix,

Thank you. I've updated the 2.5Rc3.1 download and upgrade packages.

Bob

Hi Bob,
I can also confirm that by taking out our thank-you URL the data is saved.

Now using the new chronocontact.php file the data is also saved even with our thank-you page.

Not sure how my form backup worked for you though.:huh:

Best wishes,

- Vincent

Hi Vincent,

Nor do I - weird. I think that maybe I hadn't upgraded properly. The default.ttf file won't copy and that may have caused some other files to be skipped . . . but I don't think so.

Bob

I followed the instructions for upgrading, but still no data is saved. Can I safely remove the component and then install it again?

Hi flodo,

It's unlikely that reinstalling will fix this problem. More likely that there is a problem with your form code.

You can uninstall and reinstall but you will loose all saved forms and form data. Save theses first - take Form Backups of the forms and backup all the jos_chronoforms_xxx database tables. Then reinstall, replace the table and Restore the forms.

Bob

I'd have done that by now, but theres a problem with the server now and it seems to have died...

I'd have done that by now, but theres a problem with the server now and it seems to have died...

EDIT:

sorry bout double post.. cant seem to be able to delete it..

anyway, this was in relation to submitting my form backup so u could check it<br><br>Post edited by: Hadakajime, at: 2008/04/26 19:41

I tried, but with the same results.

I shall include my formcode:

<style>
label
{
  width:300px;
  text-align:left;
  float:left;
}
.row1 label
{
  width:20px;
  text-align:left;
  float:left;
}
.row, .row1
{
  padding:5pt;
}
.row input, .row1 input 
  { 
  background-color:#dcdcdc;
  }
 .row input:focus 
 {
 background-color:#CCCCCC;
 }
 .locatie
 {
 padding-left: 45px;
 padding-right:16px;
 }
 .downloadLabel {
 width: 300px;
 display:inline;
 }
 input#interesseKavelLocatie
 {
 position:relative;
 left:8px;
 }
#titel
{
	font-family:Arial, Helvetica, sans-serif;
	font-size:14px;
	font-weight:bold;
	line-height: 25px;
        text-align: center;
	width:385px;
	background-color:#dcdcdc;
	color:#666666;
	padding-left:5pt;
	position:relative;
	top:12px;
	left:160px;
        border: 1px #ffffff solid;
 }
 #box 
 {
  border:ridge;
  border-width:1px;
  border-color:#ffffff;
  padding-top:30px;
  padding-left:20px;
  }
 .row textarea#bericht
 {
 background-color:#dcdcdc;
 }
 #toelichting
 {
 font-size: 10px;
 padding-left:5px;
 padding-right:40px;
 line-height:15px;
 margin-top:20px;
 margin-bottom:15px;
 text-align:justify;
 }
</style>
<div id="titel">Ja, ik wil graag meer informatie over TOP chalets.</div>
<div id="box">
     <div class="row">
         <label for="naam">Naam :</label>
         <input type="text" id="naam" name="naam" size="25" />
  </div>
        <div class="row">
         <label for="straat">Straat :</label>
         <input type="text" id="straat" name="straat" size="25" />
        </div>
        <div class="row">
         <label for="postcode">Postcode :</label>
         <input type="text" id="postcode" name="postcode" size="25" />
        </div>
        <div class="row">
         <label for="woonplaats">Woonplaats :</label>
         <input type="text" id="woonplaats" name="woonplaats" size="25" />
        </div>
  <div class="row">
    <label for="telnr">Telefoon :</label>
    <input type="text" id="telnr" name="telnr" size="25" />
  </div>
        <div class="row">
         <label for="email">Emailadres :</label>
         <input type="text" id="email" name="email" size="25" />
        </div>
  <div class="row">
         <label for="perpost">Documentatie per post:</label>
         <select name="post" size="1" id="post">
           <option>* maak een keuze</option>
           <option value="ja">ja</option>
           <option value="nee">nee</option>
                        </select> 
	    </div>
  		  <div class="row">
         <label for="download">Documentatie downloaden:</label>
         <select name="download" size="1" id="download">
           <option>* maak een keuze</option>
           <option value="ja">ja</option>
           <option value="nee">nee</option>
            </select> 
 		 </div>
        
        <div class="row">
         <label for="nieuwsbrief">Meld mij aan voor de TOP nieuwsbrief: (*)</label>
        <input name="nieuwsbrief" type="checkbox" id="nieuwsbrief" value="ja" checked />
        </div>
        
          <div class="row">
         <label for="bezitKavel">Bent u in het bezit van een kavel?:</label>
         <input name="bezitKavel" type="checkbox" id="bezitKavel" value="ja" unchecked /> <span class="locatie">op het park :</span>
         <input type="text" id="bezitKavelLocatie" name="bezitKavelLocatie" size="25" />
         </div>
          <div class="row">
         <label for="interesseKavel">Hebt u interesse in een kavel?:</label>
         <input name="interesseKavel" type="checkbox" id="interesseKavel" value="ja" unchecked /> <span class="locatie">omgeving :</span>
         <input type="text" id="interesseKavelLocatie" name="interesseKavelLocatie" size="25" />
         </div>
         
        <div class="row">
         <label for="bericht">Bericht:</label>
         <textarea id="bericht" name="bericht" cols="40" rows="10"></textarea>
        </div>

  <div class="row">
    <input name="verzenden" type="submit" value="Verzenden" />
  </div>
     <div id="toelichting">* De TOP nieuwsbrief zal u periodiek toegezonden worden. U kunt zich ten alle tijde afmelden voor deze nieuwsbrief. Door middel van deze nieuwsbrief wordt u op de hoogte gehouden van de laatste ontwikkelingen, beschikbaarheid van kavels en tips.</div>
 </div>

Any Idea???

Hi flodo,

That code looks OK - but is complicated for a test. If you try a simple form with just one text input and a submit button, does that save to your database?

Bob

This is what I've noticed regarding data not saving to the database. If I've got a redirect, (ie. "index.php?option=com_content&view=article&id=72") than the data never gets put into the database. However, if I remove this redirect and use the default blank page, then the data WILL end up in the database.

Please review this experience and see if it has merit.

Hi pscarnegie,

There was a bug in the most recent release of ChronoForms for Joomla 1.5 that could have this effect. I thought it had been fixed in the most recent version of the download though.

See this thread for a fixed version of one file that you can download and post to your site.

Bob

Hi flodo,

Yes but backup all the chronoforms database tables first or you will lose your forms and your data.

Bob