DB Issue while upgrading from 1.92+

More
2 months 3 weeks ago - 2 months 3 weeks ago #157158 by cbertea_
cbertea_ created the topic: DB Issue while upgrading from 1.92+
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"
Last Edit: 2 months 3 weeks ago by cbertea_.

Please Log in to join the conversation.

More
2 months 3 weeks ago - 2 months 3 weeks ago #157170 by Ben_V
Ben_V replied the topic: DB Issue while upgrading from 1.92+

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

Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
Last Edit: 2 months 3 weeks ago by Ben_V.
The following user(s) said Thank You: DenisChenu

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now