When updating LimeSurvey from version 1.92 to 2.0+, I ran into the following error message:
CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'limesurvey.lime_survey_links' doesn't exist
There are some posts concerning the issue, that suggest starting from a fresh installation. As I don’t liked this idea, I suggest adding the missing table by the following SQL:
CREATE TABLE lime_survey_links ( participant_id character varying ( 50 ) NOT NULL, token_id integer NOT NULL, survey_id integer NOT NULL, date_created date NOT NULL, PRIMARY KEY (participant_id,token_id,survey_id) );
Afterwards, the upgrade process has been completed successfully.