Error connecting to database

Astrid 08 May, 2009
I get the following error when trying to connect to the database:

tablechronocontact::store failed - Unknown column 'fieldsnames' in 'field list' SQL=UPDATE `jos_chrono_contact` SET `name`='dauw',`html`='
Inschrijfformulier Dauwtrapwedstrijd
\r\n

Je kunt je hier inschrijven voor de Dauwtrapwedstrijd van 21 mei.
\r\n\r\n
Je gegevens (behalve je handicap) zijn al ingevuld. Als je partner zich ook \r\n wil inschrijven moet hij/zij zelf even inloggen!
\r\n id) {\r\n$out=\" SELECTED\";\r\n$readonl=\" readonly=\'readonly\'\";\r\n} else {\r\n$in=\" SELECTED\";\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 \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Naam \r\n name?>\" /> \r\n Lidnummer: \r\n /> Hcp \r\n
E-mailadres \r\n email?>\" />
Buffet \r\n

\r\n \r\n \r\n \r\n
\r\n
Opmerkingen \r\n
* Verplichte velden \r\n
\r\n \r\n \r\n \r\n
\r\n ',`scriptcode`='',`redirecturl`='',`emailresults`='2',`fieldsnames`='naam,lidnummer,Hcp,email,buffet,Opmerkingen',`fieldstypes`='text,text,text,text,select,textarea',`onsubmitcode`='\';\r\n$mainframe->addCustomHeadTag($custom_tag);\r\n?> \r\n\r\n \r\n \r\n \r\n

We hebben je aanmelding ontvangen
\r\n

Je krijgt zelf ook nog een bevestiging
\r\n


',`onsubmitcodeb4`='',`server_validation`='',`attformtag`='',`submiturl`='',`dbclasses`='',`paramsall`='formmethod=post\nsubmissions_limit=\ndatefieldformat=\nLoadFiles=No\ndebug=0\nmysql_type=1\nenmambots=No\ndbconnection=No\nsavedataorder=after_email\ndatefieldsnames=\nhandlepostedarrays=Yes\nuploads=No\nuploadfields=\nuploadpath=/home/sites/site353/web/components/com_chronocontact/uploads/dauw/\ndvfields=\ndvrecord=Record #n\nimagever=No\nimtype=0\ncaptcha_dataload=0\nimgver_error_msg=\nvalidate=Yes\nvalidatetype=mootools\nval_required=naam,lidnummer,Hcp,email,buffet\nval_validate_number=\nval_validate_digits=\nval_validate_alpha=\nval_validate_alphanum=\nval_validate_date=\nval_validate_email=email\nval_validate_url=\nval_validate_date_au=\nval_validate_currency_dollar=\nval_validate_selection=buffet\nval_validate_one_required=\nval_validate_confirmation=\nservervalidate=No\nautogenerated_order=3\nonsubmitcode_order=2\nplugins_order=1\nplugins=cf_profile\nmplugins_order=\ntablenames=',`autogenerated`='',`theme`='default',`extra1`='',`extra2`='',`extra3`='',`extra4`='',`extra5`='' WHERE id='31'



Tables included as well.
This form is from V3.0 V1.5 beta_1 were everything was working OK.
Hope somebody knows what's going wrong here..............
GreyHead 08 May, 2009
Hi Astid,

Have you upgraded your ChronoForms from the 1.5 beta to RC5.0?

Bob
Astrid 08 May, 2009
Hi Bob,
Yes, that's what I did. Think I solved the problem now bij adding the missing fields manually to the database.
Didn't read the upgrade instructions well enough I think.
Data now are saved to table and e-mails are being sent.
LoriMo 27 Jun, 2009
I have the same error but I don't understand how you fixed it.
Astrid 27 Jun, 2009
Installed new version on live server, exported table jos_chrono_contact, uninstalled old version of chronoforms on local host and made fresh install of new version on local host.
Exported table jos_chrono_contact from localhost. Compared tables en made neccesary changes in table on live server.
Max_admin 28 Jun, 2009
@LoriMo, are you sure its the "same" error ? you may have a similar error but with small differences which may be fixed easily, try to access the "upgrade SQL" option from Chronoforms menu

Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.