Enable Data Storage error

Joomla 1.5.11
Chronoforms V3.1 RC 5.1

Clean install - no changes made to core files

Form works fine. Mail is send to user.

If I set "Enable Data Storage" to YES, I get a 500 Internal Server error. Disable this function and everything works fine again...

Checked the SQL table : it contains all the columns which are needed

This is the Autogenerated code

<?php
		$MyForm =& CFChronoForm::getInstance();
		if($MyForm->formparams("dbconnection") == "Yes"){
			$user = JFactory::getUser();			
			$row =& JTable::getInstance("chronoforms_registreren", "Table");
			srand((double)microtime()*10000);
			$inum	=	"I" . substr(base64_encode(md5(rand())), 0, 16).md5(uniqid(mt_rand(), true));
			JRequest::setVar( "recordtime", JRequest::getVar( "recordtime", date("Y-m-d")." - ".date("H:i:s"), "post", "string", "" ));
			JRequest::setVar( "ipaddress", JRequest::getVar( "ipaddress", $_SERVER["REMOTE_ADDR"], "post", "string", "" ));
			JRequest::setVar( "uid", JRequest::getVar( "uid", $inum, "post", "string", "" ));
			JRequest::setVar( "cf_user_id", JRequest::getVar( "cf_user_id", $user->id, "post", "int", "" ));
			$post = JRequest::get( "post" , JREQUEST_ALLOWRAW );			
			if (!$row->bind( $post )) {
				JError::raiseWarning(100, $row->getError());
			}				
			if (!$row->store()) {
				JError::raiseWarning(100, $row->getError());
			}
			$MyForm->tablerow["jos_chronoforms_register"] = $row;
		}
		?>
		

Hi Quevi2008,

Please show me the SQL for the table, any columns names start with numbers or have special characters ?

Max

thx man! This did the job!

One of my columns had a number in the id 😶