Dear forum members,

I'm encountering the following error message when I try to submit an answer:

Unknown column '87948X1163X17329' in 'field list':UPDATE lime_survey_87948 SET `lastpage`='3', `datestamp`='2015-05-03 18:46:32', `ipaddr`='92.72.144.11', `87948X1163X17329`='' WHERE ID=44714

Interestingly, the error occurs only when the survey is activated. In deactivated mode, everything works just fine.

I am using Version 1.92+ Build 120919

Does anyone know how to solve this?

Thank you very much!

It looks like your responses table is missing a column for a question. It will work while offline since lime doesn't use a responses table while offline. Did you add a question then rename a backup table to be your current table?

No, I did not rename any backup tables. Putting the survey offline and online again also does not work to solve the problem.

I would try to copy the survey and import it and see if you encounter the error message on the copy...

Tammo

BTW: you are working with a LimeSurvey built from 2012! Would it be possible to update? This might also help...

Hey tammo, thanks for your advice, this actually solved the issue. Hope it is stable now.

What solved the issue? Updating or copying?

Just curious...

Tammo

Copying. But you're right, I should consider updating some day..

Yes, the LimeSurvey world did develop since 2012!