Can't get tables to work

I'm using Joomla 1.5.1 and created a form by copying and pasting html into Chrono Forms. When testing by submitting by email everything works fine. However, if I create a table and when test I get the following:
Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/techined/public_html/njaet1/components/com_chronocontact/chronocontact.php(525) : eval()'d code on line 5

I even took the test_form from your website and got the same results. Any help would be appreciated.
Thanks.
Alan

Hi Alan,

That says that there is a typo in your AutoGenerated code. Please will you copy & paste it here in [code] tags for me to take a look.

Bob

Here is the autogenerated code:

<?php 
	$database =& JFactory::getDBO();
	
$database->setQuery( "
  INSERT 
    INTO #__chronoforms_3 
    VALUES  (
'' , 
'". date('Y-m-d')." - ".date("H:i:«»s"«»)."',
 '".$_SERVER['REMOTE_ADDR']."' ,
 '".JRequest::getVar('status','' 'post', 'int', 0 )."' ,
 '".JRequest::getVar('title','' 'post', 'int', 0 )."' ,
 '".JRequest::getVar('title2','' 'post', 'int', 0 )."' ,
 '".JRequest::getVar('firstname','' 'post', 'int', 0 )."' ,
 '".JRequest::getVar('mid-initial','' 'post', 'int', 0 )."' ,
 '".JRequest::getVar('lastname','' 'post', 'int', 0 )."' ,
 '".JRequest::getVar('email','' 'post', 'int', 0 )."' ,
 '".JRequest::getVar('schooldistrict','' 'post', 'int', 0 )."' ,
 '".JRequest::getVar('position','' 'post', 'int', 0 )."' ,
 '".JRequest::getVar('org','' 'post', 'int', 0 )."' ,
 '".JRequest::getVar('addressa','' 'post', 'int', 0 )."' ,
 '".JRequest::getVar('addressb','' 'post', 'int', 0 )."' ,
 '".JRequest::getVar('city','' 'post', 'int', 0 )."' ,
 '".JRequest::getVar('state','' 'post', 'int', 0 )."' ,
 '".JRequest::getVar('zip','' 'post', 'int', 0 )."' ,
 '".JRequest::getVar('phone','' 'post', 'int', 0 )."');" );

if (!$database->query()) {
echo "<script> alert('".$database->getErrorMsg()."'); window.history.go(-1); </script>
";
}
?>

<br><br>Post edited by: GreyHead, at: 2008/03/06 00:13

Hi Alan,

I edited your post to make it easier to see - didn't change any text though.

It looks to me as though there's a missing comma after the pairs of quotes '' in each of those getVar calls. So

'".JRequest::getVar('status','' 'post', 'int', 0 )."' ,

should be

 '".JRequest::getVar('status', '', 'post', 'int', 0 )."' ,

Is thsi from the new release today? I'll take a look at the code.

Bob

Hi Alan,

Found the bug. line 488 of admin.chronocontact.php shoudl read

$chrono_posts .= "'\"."."JRequest::getVar('$name', '', 'post', 'int', 0 ).\"'";

with an extra comma between '' and 'post'.

Bob<br><br>Post edited by: GreyHead, at: 2008/03/06 00:24

Bob,
Thanks so much for your quick responses. Should I just go in an change this line or will the a new release be forthcoming that fixes this error? By the way, I did download and installed today.
Alan

Bob,
I went in and changed the line 488. I don't get an error but the tables aren't coming out correctly. Displaying mostly 0 across the fields when backup to Excel. CSV. I've left the fields as default - Biggest number of text. Also, when I look at the table it shows ID, blank box, Record ID (blank),Date & Time. Is there a way to the record directly in Joomla -Chrono?
Thanks.
Alan

Hi Alan,

some fixes have been made, please redownload, overwrite all files, and retest ?

Cheers

Max

Max & Bob,
Bug fix works like a charm! Thanks so much! I'm going right now to get a license for chronoengine! I thinks it's the best forms module out there. It's so easy even a cave... oh that line's already been taken.
Alan