Welcome, Guest
Username: Password: Remember me

TOPIC: Upgrade 1.91 to 2.0 - SQL error

Upgrade 1.91 to 2.0 - SQL error 2 years 2 days ago #85821

  • dinko
  • dinko's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
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
The administrator has disabled public write access.

Re: Upgrade 1.91 to 2.0 - SQL error 2 years 1 day ago #85827

  • dinko
  • dinko's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
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
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.104 seconds
Donation Image