error adding a form block C5.5.2
Permalink
I have tried to add a form to my site, but when i do, i get this error.
________________________________________________________
An unexpected error occurred. mysql error: [1054: Unknown column 'addFilesToSet' in 'field list'] in EXECUTE("insert into btForm (questionSetId, surveyName, notifyMeOnSubmission, recipientEmail, thankyouMsg, displayCaptcha, redirectCID, addFilesToSet, bID) values
_________________________________________________________
Any clues on how to fix this ?
________________________________________________________
An unexpected error occurred. mysql error: [1054: Unknown column 'addFilesToSet' in 'field list'] in EXECUTE("insert into btForm (questionSetId, surveyName, notifyMeOnSubmission, recipientEmail, thankyouMsg, displayCaptcha, redirectCID, addFilesToSet, bID) values
_________________________________________________________
Any clues on how to fix this ?
Thanks, Ill give that a try :)
How did you upgrade your site? This is a database error that comes about if you upgrade the files to a 5.5.2 site without actually running through the upgrade process (which should add this database column automatically)
Thanks for your reply.
I didnt upgrade. this was a fresh install. Can i look within the zip to see if that field would be added to my db?
I am seeing another couple of errors, but need to replicate them before posting.
I didnt upgrade. this was a fresh install. Can i look within the zip to see if that field would be added to my db?
I am seeing another couple of errors, but need to replicate them before posting.
Hmm. You downloaded this from concrete5.org ? Or did you it come in a one-click installer somewhere? I just tested downloading 5.5.2 from concrete5.org and installing it and the database field is definitely created.
Hi Andrew
It was a download from concete.org.
Ill try another download and see if there is any difference
It was a download from concete.org.
Ill try another download and see if there is any difference
Mmm, seems i have had you guys on a fools errand :(
I was on 5.5.1, (i couldnt check as the enviroment wasnt working)
I clciked on upadte and it came up with "Upgrade from 5.5.1 to 5.5.2"
I did this and then tested the form again.
and it works fine
(also the enviroment also works now)
Thanks for your help
I was on 5.5.1, (i couldnt check as the enviroment wasnt working)
I clciked on upadte and it came up with "Upgrade from 5.5.1 to 5.5.2"
I did this and then tested the form again.
and it works fine
(also the enviroment also works now)
Thanks for your help
No problem! Someone else had t his exact same issue.
I got this problem when I migrated a site backup from 5.1 to 5.2 - it seemingly removed that column.
I don't know if that is going to cause other issues also, but for now looks like I'll have to find a way to change it manually.
I don't know if that is going to cause other issues also, but for now looks like I'll have to find a way to change it manually.
http://www.concrete5.org/developers/bugs/5-5-2/form-file-upload-add...
"by member Pmelon
Fixed by adding a column named 'addFilesToSet' to the btForm table (I used phpMyAdmin). The column was an INT type with 11 length, default value defined as 0 with 'Null' checked.
It may not be completely correct as I just copied the values from a similar on/off value, but I no longer get the error message."