Forums

I just updated Chronoforms to RC5.3. When installing the update there was a strange error message but it also stated the install was successful. One form did not work, I copied it and used the wizard edit button, didn't change anything, just hit save, switched to using the copied form and now its working. Not sure what is going on, but does this error message mean anything when I installed the latest version. Here it is: http://problemsolved

thanks for your time.

Hi gregs,

Somewhere in the recent updated Max added a box for CSS code to the Form Code tab, this needs a new database column 'stylecode' to store it and it looks as though your database table doesn't have one but one of your forms was trying to save some data to it when you restored.

The 'Upgrade SQL' link in the Forms Manager will upgrade your tables if you click it (just once, after an upgrade before you restore any forms is best). I've posted the code from the Upgrade SQL link below- you can copy any of the SQL commands you need and run them from PHPMyAdmin if you prefer.

Bob

function doupgrade($option){
	global $mainframe;
	$database =& JFactory::getDBO();
	$sql = "ALTER TABLE #__chrono_contact ADD `extravalrules` LONGTEXT NOT NULL AFTER `titlesall`";
	$database->setQuery($sql);
	if (!$database->query()) {
		echo $database->getErrorMsg();
	}
	$sql = "ALTER TABLE #__chrono_contact ADD `stylecode` LONGTEXT NOT NULL AFTER `scriptcode`";
	$database->setQuery($sql);
	if (!$database->query()) {
		echo $database->getErrorMsg();
	}
	$sql = "ALTER TABLE #__chrono_contact ADD `chronocode` LONGTEXT NOT NULL AFTER `autogenerated`";
	$database->setQuery($sql);
	if (!$database->query()) {
		echo $database->getErrorMsg();
	}
	$sql = "ALTER TABLE #__chrono_contact ADD `theme` TEXT NOT NULL AFTER `chronocode`";
	$database->setQuery($sql);
	if (!$database->query()) {
		echo $database->getErrorMsg();
	}
	$sql = "ALTER TABLE #__chrono_contact_emails
ADD COLUMN `replytoname` TEXT AFTER `dfromemail`,
ADD COLUMN `dreplytoname` TEXT AFTER `replytoname`,
ADD COLUMN `replytoemail` TEXT AFTER `dreplytoname`,
ADD COLUMN `dreplytoemail` TEXT AFTER `replytoemail`;";
	$database->setQuery($sql);
	if (!$database->query()) {
		echo $database->getErrorMsg();
	}
	$sql = "ALTER TABLE #__chrono_contact_elements
ADD COLUMN `title` VARCHAR(255) AFTER `id`,
ADD COLUMN `params` LONGTEXT AFTER `code`;";
	$database->setQuery($sql);
	if (!$database->query()) {
		echo $database->getErrorMsg();
	}
	$mainframe->redirect( "index2.php?option=$option", 'Upgrade went successfully' );
}

Thanks for your support!

I had the exact same error when I upgraded from 5 to 5.3. I pressed the Upgrade SQL link. Should that do it for me?

Restoring the whole form failed Failed, error : Unknown column 'stylecode' in 'field list' SQL=INSERT INTO jos_chrono_contact (id,name,html,scriptcode,stylecode,redirecturl,emailresults,fieldsnames,fieldstypes,onsubmitcode,onsubmitcodeb4,
server_validation,attformtag,submiturl,emailtemplate,useremailtemplate,paramsall,titlesall,extravalrules,dbclasses,
autogenerated,chronocode,theme,published,extra1,extra2,extra3,extra4,extra5) VALUES ('','basicDemo','
Name
Email address:
Subject
Message

','','','','2','name,email,subject,message','text,text,text,textarea','
Thank you for contacting us at Mywebsite.com, we have received your message and we will get back to you ASAP!
Hey admin, you need to configure the emaisl addresses in the admin area for the real form to be sent to YOU
','','','','','','','formmethod=post LoadFiles=Yes submissions_limit= submissions_limit_error=Sorry but you can not submit the form again very soon like this! handlepostedarrays=Yes debug=0 checkToken=1 mysql_type=1 enmambots=No captcha_dataload=0 captcha_dataload_skip= useCurrent= datefieldformat=d/m/Y datefieldsnames= datefieldextras=classes: [\'dashboard\'] dbconnection=No savedataorder=after_email dvfields= dvrecord=Record #n uploads=No uploadfields= uploadpath=C:\\xampp\\htdocs\\xampp\\chronosim2\\components\\com_chronocontact\\uploads\\basicDemo\\ filename_format=$filename = date(\'YmdHis\').\'_\'.$chronofile[\'name\']; upload_exceedslimit=Sorry, Your uploaded file size exceeds the allowed limit. upload_lesslimit=Sorry, Your uploaded file size is less than the allowed limit upload_notallowed=Sorry, Your uploaded file type is not allowed imagever=No imtype=0 imgver_error_msg=You have entered an incorrect verification code at the bottom of the form. validate=No validatetype=mootools validate_onlyOnBlur=1 validate_wait= validate_onlyOnSubmit=0 validation_type=default val_required= val_validate_number= val_validate_digits= val_validate_alpha= val_validate_alphanum= val_validate_date= val_validate_email= val_validate_url= val_validate_date_au= val_validate_currency_dollar= val_validate_selection= val_validate_one_required= val_validate_confirmation= servervalidate=No autogenerated_order=3 onsubmitcode_order=2 plugins_order=1 plugins= mplugins_order= tablenames=','','','','','[type=\"cf_textbox\"CHRONO_CONSTANT_EOL{CHRONO_CONSTANT_EOLid = text_1CHRONO_CONSTANT_EOLname = nameCHRONO_CONSTANT_EOLclass = cf_inputbox requiredCHRONO_CONSTANT_EOLtype = textCHRONO_CONSTANT_EOLsize = 30CHRONO_CONSTANT_EOLmaxlength = 150CHRONO_CONSTANT_EOLtitle = Please enter your nameCHRONO_CONSTANT_EOLhidelabel = 0CHRONO_CONSTANT_EOLlabelwidth = 150pxCHRONO_CONSTANT_EOLlabeltext = NameCHRONO_CONSTANT_EOLtooltiptext = CHRONO_CONSTANT_EOLslabel = CHRONO_CONSTANT_EOL}]CHRONO_CONSTANT_EOL[type=\"cf_textbox\"CHRONO_CONSTANT_EOL{CHRONO_CONSTANT_EOLid = text_2CHRONO_CONSTANT_EOLname = emailCHRONO_CONSTANT_EOLclass = cf_inputbox required validate-emailCHRONO_CONSTANT_EOLtype = textCHRONO_CONSTANT_EOLsize = 30CHRONO_CONSTANT_EOLmaxlength = 150CHRONO_CONSTANT_EOLtitle = Please enter your email addressCHRONO_CONSTANT_EOLhidelabel = 0CHRONO_CONSTANT_EOLlabelwidth = 150pxCHRONO_CONSTANT_EOLlabeltext = Email address:CHRONO_CONSTANT_EOLtooltiptext = CHRONO_CONSTANT_EOLslabel = CHRONO_CONSTANT_EOL}]CHRONO_CONSTANT_EOL[type=\"cf_textbox\"CHRONO_CONSTANT_EOL{CHRONO_CONSTANT_EOLid = text_3CHRONO_CONSTANT_EOLname = subjectCHRONO_CONSTANT_EOLclass = cf_inputbox requiredCHRONO_CONSTANT_EOLtype = textCHRONO_CONSTANT_EOLsize = 30CHRONO_CONSTANT_EOLmaxlength = 150CHRONO_CONSTANT_EOLtitle = Please enter a subject for your messageCHRONO_CONSTANT_EOLhidelabel = 0CHRONO_CONSTANT_EOLlabelwidth = 150pxCHRONO_CONSTANT_EOLlabeltext = SubjectCHRONO_CONSTANT_EOLtooltiptext = CHRONO_CONSTANT_EOLslabel = CHRONO_CONSTANT_EOL}]CHRONO_CONSTANT_EOL[type=\"cf_textarea\"CHRONO_CONSTANT_EOL{CHRONO_CONSTANT_EOLid = text_4CHRONO_CONSTANT_EOLname = messageCHRONO_CONSTANT_EOLclass = cf_inputbox requiredCHRONO_CONSTANT_EOLrows = 5CHRONO_CONSTANT_EOLcols = 40CHRONO_CONSTANT_EOLtitle = Please enter your messageCHRONO_CONSTANT_EOLhidelabel = 0CHRONO_CONSTANT_EOLlabelwidth = 150pxCHRONO_CONSTANT_EOLlabeltext = MessageCHRONO_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','default','1','','','','','')

Hi Jokhar,

Yes it should.

Bob

Thanks for the confirmation. All my testing seemed ok too.

Hi johkar1,

Are you still seeing the errror or is it Ok now?

Bob