Hey everybody,

I've set up a survey without any problems. I did not use any conditions or something like that.
I've activated the new survey, clicked through it and after that opened the link "Show results of this survey".
Then I got this SQL error:

CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column '524461X64X2219A1_A1' in 'where clause'

The error message seems logical to me. It could not find the column. But I don't know why?
I did not change anything, just created this freshly new survey. And I got this error after fist try.

BTW: It does not matter if I test this in Version 2.05+ or 2.50+. Same problem.

Server runs on PHP Version 5.6.19 using phpMyAdmin and MySQL.

Thank you.

Try finding the question with ID 2219 and remove/rebuild it.

Thank you very much for your answer.
The question is, why is the database created wrong everytime I activate the survey?
I changed the default question codes but the system does not recognize at all for creating the result database. Is that possible?

Hello
I am having the same problem. I get this sql error only with a multiple choice question.
How can I fix this problem?
Thank you!