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 ?

 
Ekko replied on at Permalink Reply
Ekko
You may want to look here

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."
gwp1971 replied on at Permalink Reply
Thanks, Ill give that a try :)
andrew replied on at Permalink Reply
andrew
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)
gwp1971 replied on at Permalink Reply
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.
andrew replied on at Permalink Reply
andrew
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.
gwp1971 replied on at Permalink Reply
Hi Andrew
It was a download from concete.org.
Ill try another download and see if there is any difference
gwp1971 replied on at Permalink Reply
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
andrew replied on at Permalink Reply
andrew
No problem! Someone else had t his exact same issue.
Danives replied on at Permalink Reply
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.