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.
You can see this on my attached picture. what am I doing wrong. I am on Mysql 5
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
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
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
This topic is locked and no more replies can be posted.