The truth is rarely pure and never simple

LimeSurvey Update: Internal Server Error

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.