Check out the LimeSurvey source code on GitHub!

Upgrade 1.91 to 2.0 - SQL error

More
4 years 4 months ago #85821 by dinko
I am trying to upgrade limesurvey system ver 1.91 to 2.0 and I get stuck on DB (mysql) upgrade. Message I get, first pass, is:

Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
`attribute_type` varchar(4) NOT NULL,
`visible` varchar(5) NOT NULL,
PRIMARY' at line 2

After continuing, I get repeated error as:

CDbCommand failed to execute the SQL statement: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'participant_panel'

I am using LAMMP (XAMPP) version 1.7.7 (tried with upgrading to 1.8.0, as well - same problem) as environment. Mysql is version 5.5.16 (as in lampp 1.7.7).

Help?

Thank you, Dinko

Please Log in to join the conversation.

More
4 years 4 months ago #85827 by dinko
Problem solved: Limesurvey upgraded from 1.9.1 to 1.9.2 and then to 2.0; installation and upgrade of existing database went smoothly. Ergo, make sure to bring your Limesurvey server to 1.92 before attempting to upgrade to 2.0.

Dinko

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form