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

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