search

formtools / core

The Form Tools Core.
https://formtools.org
207 stars 78 forks source link

Form Tools database error #511

Open EnglishUNM opened 5 years ago

EnglishUNM commented 5 years ago

Uh-oh. The system encountered a serious database error. This should not occur. Please report these details on github.

Class: FormTools\Submissions File: /home/english/public_html/english.unm.edu/formtools/global/code/Submissions.class.php Line: 1100 Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'criterion_1' in 'field list'

nelsondcosta23 commented 5 years ago

hmmm did you edit the DB?

nelsondcosta23 commented 5 years ago

Hi, do you have that field inside a form?

EnglishUNM commented 5 years ago

The fields were edited and updated, and a test submission went through without any issues a couple weeks ago (the database hasn't been edited at all).

nelsondcosta23 commented 5 years ago

Ah wait, this is a clean install of ft3.0.13?

EnglishUNM commented 5 years ago

I just updated to 3.0.13 this morning from 3.0.12, but the 3.0.12 was not a fresh install (just a previous update).

benkeen commented 5 years ago

Hey @EnglishUNM, thanks for reporting this. You're the second person that reported something along these lines recently, which is a concern. Does criterion_1 ring a bell? Did you rename or delete a field with that name on the Edit Form -> Fields tab?

EnglishUNM commented 5 years ago

Sorry for the delayed response! Criterion_1 was a renamed field on an existing form (there were 8 other fields renamed at the same time). I was able to update the form without any errors, and afterward, sent a test submission through as well. It wasn't until several days later that we started to see this error occur.