Forums

Store failed

jjtao 15 Feb, 2010
Been getting this error on my site.
I create the form with the wizzard,
I create the email setup,
I create the after form submission.

But when I save it and name the form I get this error.
TableChronoContact::store failed - Unknown column 'stylecode' in 'field list' SQL=UPDATE `jos_chrono_contact` SET `name`='submitcontent',`html`='
Got a story ? Submit it!
 
With ChronoForms V3.0 out, new possibilities are achievable, using this form, users can submit their content to the chronoengine.com website! =)
 
Please submit something meaningful or it will be deleted, no \"blah blah\" text or so!
 
Title:
Title: :: Your story title please!
 
Story body:\r\ndisplay( \'fulltext\', \'\' , \'80%\', \'350\', \'55\', \'20\', false ) ;\r\n\r\n?>\r\n\r\n
 
Your name:
Your name: :: Your nickname as you like it to appear with the story!
 
Enter code as shown{imageverification}
 
 
',`scriptcode`='',`stylecode`='',`redirecturl`='',`emailresults`='2',`fieldsnames`='title,created_by_alias,fulltext',`fieldstypes`='text,text,textarea',`onsubmitcode`='

Thank you for submitting your story, we will review it shortly and if approved it will be published!
\r\n

Cheers
\r\n

ChronoEngine.com team!
\r\n',`onsubmitcodeb4`='',`server_validation`='',`attformtag`='',`submiturl`='',`dbclasses`='\n',`paramsall`='formmethod=post\nLoadFiles=Yes\nsubmissions_limit=\nsubmissions_limit_error=Sorry but you can not submit the form again very soon like this!\nhandlepostedarrays=Yes\ndebug=0\ncheckToken=1\nmysql_type=1\nenmambots=No\ncaptcha_dataload=1\ncaptcha_dataload_skip=\nuseCurrent=\ndatefieldformat=d/m/Y\ndatefieldsnames=\ndatefieldextras=classes: [\'dashboard\']\ndbconnection=Yes\nsavedataorder=after_email\ndvfields=\ndvrecord=Record #n\nuploads=No\nuploadfields=\nuploadpath=/usr/www/users/stealtf/components/com_chronocontact/uploads/submitcontent/\nfilename_format=$filename = date(\'YmdHis\').\'_\'.$chronofile[\'name\'];\nupload_exceedslimit=Sorry, Your uploaded file size exceeds the allowed limit.\nupload_lesslimit=Sorry, Your uploaded file size is less than the allowed limit\nupload_notallowed=Sorry, Your uploaded file type is not allowed\nimagever=Yes\nimtype=1\nimgver_error_msg=PCs are good but sometimes they are pain, you have entered a wrong code, please re-enter it!\nvalidate=No\nvalidatetype=mootools\nvalidate_onlyOnBlur=1\nvalidate_wait=\nvalidate_onlyOnSubmit=0\nvalidation_type=default\nval_required=\nval_validate_number=\nval_validate_digits=\nval_validate_alpha=\nval_validate_alphanum=\nval_validate_date=\nval_validate_email=\nval_validate_url=\nval_validate_date_au=\nval_validate_currency_dollar=\nval_validate_selection=\nval_validate_one_required=\nval_validate_confirmation=\nservervalidate=Yes\nautogenerated_order=3\nonsubmitcode_order=2\nplugins_order=1\nplugins=\nmplugins_order=\ntablenames=jos_content',`autogenerated`='formparams(\"dbconnection\") == \"Yes\"){\n $user = JFactory::getUser(); \n $row =& JTable::getInstance(\"content\", \"Table\");\n srand((double)microtime()*10000);\n $inum = \"I\" . substr(base64_encode(md5(rand())), 0, 16).md5(uniqid(mt_rand(), true));\n JRequest::setVar( \"recordtime\", JRequest::getVar( \"recordtime\", date(\"Y-m-d\").\" - \".date(\"H:i:s\"), \"post\", \"string\", \"\" ));\n JRequest::setVar( \"ipaddress\", JRequest::getVar( \"ipaddress\", $_SERVER[\"REMOTE_ADDR\"], \"post\", \"string\", \"\" ));\n JRequest::setVar( \"uid\", JRequest::getVar( \"uid\", $inum, \"post\", \"string\", \"\" ));\n JRequest::setVar( \"cf_user_id\", JRequest::getVar( \"cf_user_id\", $user->id, \"post\", \"int\", \"\" ));\n $post = JRequest::get( \"post\" , JREQUEST_ALLOWRAW ); \n if (!$row->bind( $post )) {\n JError::raiseWarning(100, $row->getError());\n } \n if (!$row->store()) {\n JError::raiseWarning(100, $row->getError());\n }\n $MyForm->tablerow[\"jos_content\"] = $row;\n }\n ?>\n ',`theme`='default',`extra1`='',`extra2`='',`extra3`='',`extra4`='',`extra5`='' WHERE id='10'


You can see this on my attached picture. what am I doing wrong. I am on Mysql 5
GreyHead 15 Feb, 2010
Hi jjtao,

Please click the "Upgrade SQL and Load Demo Form" link in the ChronoForms Forms Manager. This should bring the CF database tables up to the latest version.

Caution Backup your database first.

Bob
jjtao 18 Feb, 2010
Sorry Only managed to log on now and see my responses. But ALAS!! thank you both of you for your help! IT WORKED! upgrading did the trick! All is good! forms work!
This topic is locked and no more replies can be posted.