Error when adding a new form
Permalink 1 user found helpful
This is the error message:
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 ('1334078938', 'Home', 0, '', 'Thanks!', 0, 0, 0, 68)") < Back to Home
Any info would be appreciated
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 ('1334078938', 'Home', 0, '', 'Thanks!', 0, 0, 0, 68)") < Back to Home
Any info would be appreciated
Is this an upgrade? Where did you download concrete5 from?
I just upgraded to the latest version via my webhost today. So the latest version as far as i know.
What's your web host? I think something is wrong with their upgrade script.
I use Web Hosting Canada and used softaculous to upgrade to the latest version.
Thanks. We will be in touch with softaculous. In the meantime, if you have the ability to run a direct database query on your concrete5 install, try running these queries:
That should fix these problems.
alter table btForm add column addFilesToSet int unsigned null default 0; alter table btContentImage add column forceImageToMatchDimensions int unsigned null default 0;
That should fix these problems.
I just checked...its version 5.5.1
I have no idea how to add database queries or what they do. I'm not very experienced building sites...just trying to build somthing simple. Have had no problems up until this point after the upgrade. Id there any way to remove the upgrade or reinstall it??
We'll follow up with Softaculous and see if we can't get them to make the changes to the upgrade process to fix this issue for you.
When I go to dashboard and click "update concrete 5" it shows version 5.5.1. But in softaculous it shows 5.5.2.
What do you see if you go tohttp://www.yoursite.com/index.php/tools/required/upgrade... ?
Went to that link and it showed i had 5.5.1 and allowed me to upgrade to 5.5.2. Just tried out the form and it is now working fine.
Thanks so much for your help Andrew! Greatly appreciated!
Thanks so much for your help Andrew! Greatly appreciated!
Awesome! It sounds like the softaculous upgrade puts the new files in place but doesn't run any of the database upgrades that need to happen. Thanks for sticking with it.
