Connection to DB: Error

Hello everybody

I am really in trouble: I want to connect a new form to a new database (was created by chronoforms)... but when I do this and open the form, I see the following error:
Parse error: syntax error, unexpected '$', expecting T_VARIABLE in /home/jugendta/www/jugendtag-sg.ch/components/com_chronocontact/chronocontact.php(52) : eval()'d code on line 23

When I disconnect the form to the database: everything is fine.... I have really no idea, why there is a problem with the database, that chronoforms creates...

oh, please, can anybody help me`?? I am working on this form already since 8.00 this morning :-(

THANKS SO MUCH in advance

Charlotte


PS: I don't know, if it helps, but I post the content of the file that is mentionned in the error message:
<?php
/**
* CHRONOFORMS version 3.1
* Copyright (c) 2006 Chrono_Man, ChronoEngine.com. All rights reserved.
* Author: Chrono_Man (ChronoEngine.com)
* See readme.html.
* Visit http://www.ChronoEngine.com for regular update and information.
**/

/* ensure that this file is called by another file */
defined('_JEXEC') or die('Restricted access');

/**
* Load the HTML class
*/
require_once( JApplicationHelper::getPath( 'front_html' ) );
require_once( JApplicationHelper::getPath( 'class' ) );

require_once ( JPATH_BASE .DS.'includes'.DS.'defines.php' );
require_once ( JPATH_BASE .DS.'includes'.DS.'framework.php' );
$mainframe =& JFactory::getApplication('site');
$mainframe->initialise();
//load chronoforms classes
require_once( JPATH_COMPONENT.DS.'libraries'.DS.'chronoform.php');
require_once( JPATH_COMPONENT.DS.'libraries'.DS.'mails.php');
require_once( JPATH_COMPONENT.DS.'libraries'.DS.'customcode.php');
require_once( JPATH_COMPONENT.DS.'libraries'.DS.'chronoformuploads.php');
require_once( JPATH_COMPONENT.DS.'libraries'.DS.'plugins.php');




jimport( 'joomla.application.component.controller' );
global $mainframe;
if(JRequest::getVar('chronoformname')){
JRequest::setVar('chronoformname', preg_replace('/[^A-Za-z0-9_]/', '', JRequest::getVar('chronoformname')));
}
$formname = JRequest::getVar('chronoformname');
if ( !$formname ) {
$params =& $mainframe->getPageParameters('com_chronocontact');
$formname = $params->get('formname');
}

$MyForm =& CFChronoForm::getInstance($formname);

if(!$MyForm->formrow->id){
echo "There is no form with this name or may be the form is unpublished, Please check the form and the url and the form management";
return;
}

if($MyForm->formparams('dbconnection') == "Yes"){
eval ("?>".$MyForm->formrow->dbclasses);
}

$posted = JRequest::get( 'post' , JREQUEST_ALLOWRAW );
/**
* Main switch statement
*/
switch( $task ) {
case 'send':
uploadandmail($formname);
break;
case 'extra':
doextratask($formname);
break;
default:
showform($formname, $posted);
break;
}
/**
* End of main page
*
*/

/**
* Display the form for entry
*
*/
function showform($formname, $posted)
{
global $mainframe;
$database =& JFactory::getDBO();

$MyForm =& CFChronoForm::getInstance($formname);
$MyForm->showForm($formname, $posted);
//HTML_ChronoContact::showform( $MyForm->formrow, $posted);
}

/**
* Respond to a submitted form
*
*/
function uploadandmail($formname)
{
global $mainframe;
$database =& JFactory::getDBO();
$posted = JRequest::get( 'post' , JREQUEST_ALLOWRAW );

//Load Chronoforms Classes
$MyForm =& CFChronoForm::getInstance($formname);
$MyFormData = $MyForm->getForm(JRequest::getVar( 'chronoformname'));
if($MyFormData){
//fine
}else{
$mainframe->enqueueMessage('Error processing this form, form was not loaded!');
return;
}

// Block SPAM through the submit URL
if((!JRequest::checkToken()) && $MyForm->formparams('checkToken', 1)){
echo "You are not allowed to access this URL";
return;
}
if ( empty($posted) ) {
echo "You are not allowed to access this URL directly, POST array is empty";
return;
}

if(JRequest::getVar('action') == 'extra'){
$extraid = JRequest::getVar( 'extraid');
$MyForm->doExtra($MyForm->formrow->name, $extraid, $posted);
}

$MyForm->submitForm($MyForm->formrow->name, $posted, $MyForm->formparams('useCurrent', false));
}

function doextratask($formname){
global $mainframe;
$database =& JFactory::getDBO();
$posted = JRequest::get( 'post' , JREQUEST_ALLOWRAW );

$MyForm =& CFChronoForm::getInstance($formname);
$extraid = JRequest::getVar( 'extraid');
$MyForm->doExtra($formname, $extraid, $posted);
}
?>

Hi Charlotte,

You probably have a dash '-' in one of your input names. Dashes give ChronoForms and MySQL problems. Please rename the input using only [a-z], [A-Z], [0-9] or underscore '_'. No dashes, spaces or other special characters.

You'll also need to rename the corresponding database column and refresh the DB Connection after any changes to database column names. In the Form Editor click the DB Connection tab and set the Connection to 'No'. Click the 'Apply icon in the toolbar to save the form, open the DB Connection tab, set the Connection back to 'Yes' and re-save the form. This will refresh the copy of the table information that ChronoForms uses.

Bob

Hi Bob

Thank you sooooo much for your reply! I did exactly this mistake and used "-" in some names... I tried the way you explained, but I had to start all over again and now it works! HALLELUJA!

I am so happy now! :-)

Have a great Christmas Time!

Charlotte