No Data being saved

Hi Guys, gotta say...ove your product. Recently however I have had a little grief and hoping you can point me in the right direction.

Have set up a whole bunch of forms last year. they all worked great..right up until 30/01/08 where all of a sudden they all stopped recording data. No errors however are being reported.

Since then I have upgraded my Joomla (now latest 1.0.x) and also chronoforms to the latest version..but still no fix.

You can see the forms at
http://www.riverview.nsw.edu.au/index.php?option=com_content&task=view&id=58&Itemid=218

http://www.riverview.nsw.edu.au/index.php?option=com_content&task=view&id=60&Itemid=220

Both are also meant to be redirecting to a thankyou page..but that no longer happens either.

I am open to any pointers or ideas you might have as this is slowly driving me insane.

Julian<br><br>Post edited by: jsridden, at: 2008/03/19 03:41

Hi Julian,

How did you upgrade ChronoForms ? is it version 2.3.8.1 now ? does everyform have the code in the autogenerated tab ?

Let me know

Cheers

Max

Thanks for the quick response.

Yes, I am currently running version 2.3.8 and the code has been generated for each.

i.e. the first form has the following:

<?php 
	global $database;
	
$database->setQuery( "INSERT INTO #__chronoforms_1 VALUES  (
'' , '". date('Y-m-d')." - ".date("H:i:«»s"«»)."', '".$_SERVER['REMOTE_ADDR']."' , '".mosGetParam($_POST,'Full_Name','')."' , '".mosGetParam($_POST,'Street','')."' , '".mosGetParam($_POST,'Suburb','')."' , '".mosGetParam($_POST,'Postcode','')."' , '".mosGetParam($_POST,'State','')."' , '".mosGetParam($_POST,'Country','')."' , '".mosGetParam($_POST,'Home_Phone','')."' , '".mosGetParam($_POST,'Work_Phone','')."' , '".mosGetParam($_POST,'Mobile_Phone','')."' , '".mosGetParam($_POST,'email','')."' , '".mosGetParam($_POST,'Child_1_age','')."' , '".mosGetParam($_POST,'Child_2_age','')."' , '".mosGetParam($_POST,'Child_3_age','')."' , '".mosGetParam($_POST,'Child_1_DOB','')."' , '".mosGetParam($_POST,'Child_2_DOB','')."' , '".mosGetParam($_POST,'Child_3_DOB','')."' , '".mosGetParam($_POST,'Child_1_religion','')."' , '".mosGetParam($_POST,'Child_2_religion','')."' , '".mosGetParam($_POST,'Child_3_religion','')."' , '".mosGetParam($_POST,'Child_1_Type','')."' , '".mosGetParam($_POST,'Child_2_Type','')."' , '".mosGetParam($_POST,'Child_3_Type','')."' , '".mosGetParam($_POST,'Child_1_Year_Starting','')."' , '".mosGetParam($_POST,'Child_2_Year_Starting','')."' , '".mosGetParam($_POST,'Child_3_Year_Starting','')."' , '".mosGetParam($_POST,'submit','')."');" );
if (!$database->query()) {
echo "<script> alert('".$database->getErrorMsg()."'); window.history.go(-1); </script>
";
}
?>

Hi Julian,

That code looks OK to me.

If you take a Form Backup of one of the forms I can restore it on my test site and take a look (email to the address in my sig please).

If there's nothing there than I'm happy to take a look at the back-end of your site and see if I can see what's happening.

Bob

Hi Julian,

Are you sure that the database still has the forms tables like jos_chronoforms_1 ...etc ?

and on form submit, is there any errors or popups shown ? do you have any code on the onsubmit boxes ?

Cheers

Max

Sorry for the delay in replay.

yes the database tables are still there (1 thru 5) and there is no on submit code running. This was working fine then stopped of its own accord with no changes made by myself.😟
I am happy for you guys to look at the backend. Do you have an email addy I can send the details to?

JR<br><br>Post edited by: jsridden, at: 2008/03/24 23:55

Hi Julian,

Address in my sig.

Bob

lol, ask a stupid question😛

Email has been sent. Thanks again for looking into this.

Julian