Forums

hello every body
i have some problem with chronform... whenever i create new form and click on save button the error message shown here like this as follow... please somebody help me.. this is very urgent

thnx in advance

TableChronoContact::store failed - Unknown column 'theme' in 'field list' SQL=INSERT INTO `jos_chrono_contact` ( `name`,`html`,`redirecturl`,`fieldsnames`,`fieldstypes`,`onsubmitcode`,`paramsall`,`theme`,`chronocode` ) VALUES ( 'CV2','\r\n
\r\n
\r\n Click Me to Edit\r\n \r\n \r\n
\r\n

\r\n
\r\n\r\n
\r\n
\r\n Click Me to Edit\r\n \r\n \r\n
\r\n

\r\n
\r\n\r\n
\r\n
\r\n Click Me to Edit\r\n \r\n \r\n
\r\n

\r\n
\r\n\r\n
\r\n
\r\n \r\n
\r\n

\r\n
\r\n\r\n
\r\n
\r\n Click Me to Edit\r\n \r\n Choose Option\r\n option 1\noption 2\noption 3\n\r\n\r\n \r\n
\r\n

\r\n
\r\n','','text_0,text_1,text_2,select_4','text,text,text,select','','formmethod=post\n omittedfields=\n LoadFiles=Yes\n submissions_limit=\n tablenames=\n savedataorder=\n handlepostedarrays=\n debug=0\n mysql_type=1\n enmambots=No\n uploads=No\n uploadfields=\n uploadmax=\n uploadmin=\n uploadpath=\n dvfields=\n dvrecord=Record #n\n imagever=No\n imtype=0\n captcha_dataload=0\n imgver_error_msg=\n validate=No\n servervalidate=\n validatetype=mootools\n val_required=\n val_validate_number=\n val_validate_digits=\n val_validate_alpha=\n val_validate_alphanum=\n val_validate_date=\n val_validate_email=\n val_validate_url=\n val_validate_date_au=\n val_validate_currency_dollar=\n val_validate_selection=\n val_validate_one_required=\n val_validate_confirmation=\n plugins=\n plugins_order=1\n onsubmitcode_order=2\n autogenerated_order=3\n mplugins_order=\n dbconnection=\n datefieldformat=d/m/Y\n datefieldsnames=','default','[type=\"cf_textbox\"CHRONO_CONSTANT_EOL{CHRONO_CONSTANT_EOLid = text_0CHRONO_CONSTANT_EOLname = text_0CHRONO_CONSTANT_EOLclass = cf_inputboxCHRONO_CONSTANT_EOLtype = textCHRONO_CONSTANT_EOLsize = 30CHRONO_CONSTANT_EOLmaxlength = 150CHRONO_CONSTANT_EOLtitle = CHRONO_CONSTANT_EOLhidelabel = 0CHRONO_CONSTANT_EOLlabelwidth = 0pxCHRONO_CONSTANT_EOLlabeltext = Click Me to EditCHRONO_CONSTANT_EOLtooltiptext = CHRONO_CONSTANT_EOLslabel = CHRONO_CONSTANT_EOL}]CHRONO_CONSTANT_EOL[type=\"cf_textbox\"CHRONO_CONSTANT_EOL{CHRONO_CONSTANT_EOLid = text_1CHRONO_CONSTANT_EOLname = text_1CHRONO_CONSTANT_EOLclass = cf_inputboxCHRONO_CONSTANT_EOLtype = textCHRONO_CONSTANT_EOLsize = 30CHRONO_CONSTANT_EOLmaxlength = 150CHRONO_CONSTANT_EOLtitle = CHRONO_CONSTANT_EOLhidelabel = 0CHRONO_CONSTANT_EOLlabelwidth = 0pxCHRONO_CONSTANT_EOLlabeltext = Click Me to EditCHRONO_CONSTANT_EOLtooltiptext = CHRONO_CONSTANT_EOLslabel = CHRONO_CONSTANT_EOL}]CHRONO_CONSTANT_EOL[type=\"cf_textbox\"CHRONO_CONSTANT_EOL{CHRONO_CONSTANT_EOLid = text_2CHRONO_CONSTANT_EOLname = text_2CHRONO_CONSTANT_EOLclass = cf_inputboxCHRONO_CONSTANT_EOLtype = textCHRONO_CONSTANT_EOLsize = 30CHRONO_CONSTANT_EOLmaxlength = 150CHRONO_CONSTANT_EOLtitle = CHRONO_CONSTANT_EOLhidelabel = 0CHRONO_CONSTANT_EOLlabelwidth = 0pxCHRONO_CONSTANT_EOLlabeltext = Click Me to EditCHRONO_CONSTANT_EOLtooltiptext = CHRONO_CONSTANT_EOLslabel = CHRONO_CONSTANT_EOL}]CHRONO_CONSTANT_EOL[type=\"cf_button\"CHRONO_CONSTANT_EOL{CHRONO_CONSTANT_EOLvalue = SubmitCHRONO_CONSTANT_EOLname = button_5CHRONO_CONSTANT_EOLtooltiptext = CHRONO_CONSTANT_EOLreset = 0CHRONO_CONSTANT_EOLhidelabel = 0CHRONO_CONSTANT_EOLlabelwidth = 0CHRONO_CONSTANT_EOLslabel = CHRONO_CONSTANT_EOL}]CHRONO_CONSTANT_EOL[type=\"cf_dropdown\"CHRONO_CONSTANT_EOL{CHRONO_CONSTANT_EOLid = select_4CHRONO_CONSTANT_EOLname = select_4CHRONO_CONSTANT_EOLclass = cf_inputboxCHRONO_CONSTANT_EOLsize = 1CHRONO_CONSTANT_EOLtitle = CHRONO_CONSTANT_EOLtheoptions = option 1*,*option 2*,*option 3*,*CHRONO_CONSTANT_EOLhidelabel = 0CHRONO_CONSTANT_EOLlabelwidth = 0pxCHRONO_CONSTANT_EOLlabeltext = Click Me to EditCHRONO_CONSTANT_EOLtooltiptext = CHRONO_CONSTANT_EOLslabel = CHRONO_CONSTANT_EOL}]CHRONO_CONSTANT_EOL' )

Hi shail,

It sounds as though you have upgraded an old version of ChronoForms without unistalling and re-installing. Do you have many forms or any critical form data stored? If not then backup the forms, uninstall ChronoForms and reinstall the latest version again and this should update your database table. Then restore the forms.

If you can't do this then you'll need to edit the tble manually to add the new columns. The SQL for the current table is

CREATE TABLE IF NOT EXISTS `#__chrono_contact` (
                   `id` INT NOT NULL AUTO_INCREMENT,
                   `name` TEXT NOT NULL,
		   `html` LONGTEXT NOT NULL,
		   `scriptcode` LONGTEXT NOT NULL,
		   `redirecturl` TEXT NOT NULL,
		   `emailresults` TINYINT(1) NOT NULL,
		   `fieldsnames` TEXT NOT NULL,
		   `fieldstypes` TEXT NOT NULL,
		   `onsubmitcode` LONGTEXT NOT NULL,
		   `onsubmitcodeb4` LONGTEXT NOT NULL,
		   `server_validation` LONGTEXT NOT NULL,
		   `attformtag` LONGTEXT NOT NULL,
		   `submiturl` TEXT NOT NULL,	 
		   `emailtemplate` LONGTEXT NOT NULL,	
		   `useremailtemplate` LONGTEXT NOT NULL,  
		   `paramsall` LONGTEXT NOT NULL,
		   `titlesall` LONGTEXT NOT NULL,
		   `dbclasses` LONGTEXT NOT NULL,
		   `autogenerated` LONGTEXT NOT NULL,
		   `chronocode` LONGTEXT NOT NULL,
		   `theme` TEXT NOT NULL,
                   `published` TINYINT(1) NOT NULL,
		   `extra1` LONGTEXT NOT NULL,
		   `extra2` LONGTEXT NOT NULL,
		   `extra3` LONGTEXT NOT NULL,
		   `extra4` LONGTEXT NOT NULL,
		   `extra5` LONGTEXT NOT NULL,
            PRIMARY KEY (`id`) ) CHARACTER SET `utf8`

Bob

Thanks Bob for quick reply now its working...

but i cant receive email on my admin site after posting form...

do you tell me whats the wrong ?

thnx n regards

Hi shail,

Hard to tell with email as there are several things that can go wrong. Please check the Email tutorial (from the tutorial link above) if you haven't already done so.

If you have then please turn on DeBug in the Form General Tab and post the results that you see after you submit the form.

Bob