Upgrade 1.91 to 2.0 - SQL error

More
4 years 10 months ago #85821 by dinko
dinko created the topic: Upgrade 1.91 to 2.0 - SQL error
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 10 months ago #85827 by dinko
dinko replied the topic: Upgrade 1.91 to 2.0 - SQL error
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.

Did you already participate in our customer survey?

Don't miss your chance for great prices.

Please click here to participate:

Start now

Start now!

Just create your account and start using Limesurvey today.

Register now