Hi,

I'm planning to upgrade our LimeSurvey version from 1.92 to the last one but i've got an error everytime i try :

SQL: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sendconfirmation' in 'lime_surveyx'

Following the manual installation guide ( manual.limesurvey.org/Upgrading_from_a_previous_version )
I also tried to do 2.00 and 2.06 before but still the same error.

Does someone know how to fix this problem ? I searched for an existing solution but didn't find it.

EDIT : I'm actually blocked at number 6 of the chapter "Upgrading from version 1.50 or later to any later 2.xx version"

SQL: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sendconfirmation' in 'lime_surveyx'

I think you have first to restore your 1.92 version (files + db) to check what is going wrong and retry the upgrade process in better conditions...

Do you mean for example lime_survey_1234 ?

1. If this error occurs just for 1 survey (1234 in my example), first check if this survey is still needed or not and if not delete it
2. Also check the db integrity using the built-in tool available from the main upper admin toolbar in the admin... this can't harm