Just an update: the actual error is Unknown column 'col_56' in 'field list' Now, this column actual does exist in the database as well as in formtools. What looks to be the issue is that this error is generated when a user returns to update their submission. col_56 is actual the name field and this is already submitted with the original submission to set up the username and password. So, when a user is trying to update his/her submission and has logged back in, Formtools does not actually show the name text field ( col_56 ) in the page so it seems that the error happens because of this. The first field it encounters in the update routine is col_56 which is not part of the update process because it was submitted in the original insert into the database.
Hope this is not too obtuse..
Dave
So, in trying to track down the unknown column error, I see that when the ability to update submissions is in use, unless a user fills out their submission in total and then submits the form, the partially filled out form does not show up in formtools as an entry or submission. It does, however, show up in the database. This shouldn't be .... should it?
Dave
Hope this is not too obtuse..
Dave
So, in trying to track down the unknown column error, I see that when the ability to update submissions is in use, unless a user fills out their submission in total and then submits the form, the partially filled out form does not show up in formtools as an entry or submission. It does, however, show up in the database. This shouldn't be .... should it?
Dave