Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Upgrade From 1.90 to 2.05

  • Mike1985_2
  • Mike1985_2's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 6 months ago #112251 by Mike1985_2
Upgrade From 1.90 to 2.05 was created by Mike1985_2
I'm trying to upgrade from 1.90 to 2.05. I have followed the documentation correctly. I found this post which sort of describes my problem in that I am getting the same error message;
Code:
CDbCommand failed to execute the SQL statement: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'savetimings'

The column in the table in this instances is not a "duplicate". It is only in there once. So does that mean I have to delete every single column that already exists? In which case, that's not an "update" is it, that's a brand new installation.

Or am I supposed to start with a blank database and then, after, import copies of my tables back in to the database? If that's the case, the documentation should make that really clear..
The topic has been locked.
  • c_schmitz
  • c_schmitz's Avatar
  • Offline
  • LimeSurvey GmbH Employee
  • LimeSurvey GmbH Employee
More
9 years 6 months ago #112257 by c_schmitz
Replied by c_schmitz on topic Upgrade From 1.90 to 2.05
If your database upgrade fails for whatever reason then you will need to restore the original database and try again. (the error from that first try is important)

Trying again on a failed database makes no sense and will get you in more and more trouble.

Best regards

Carsten Schmitz
LimeSurvey project leader
The topic has been locked.
  • Mike1985_2
  • Mike1985_2's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 6 months ago #112272 by Mike1985_2
Replied by Mike1985_2 on topic Upgrade From 1.90 to 2.05
By "restore the original database" do you mean a fresh install of the limesurvey 1.90 database? Or a restore of my database as it was prior to my attempted upgrade?

If you mean the first then I will lose all my survey data. If you mean the second then surely I'll just have exactly the same problem, and exactly the same error, when I try again?
The topic has been locked.
  • c_schmitz
  • c_schmitz's Avatar
  • Offline
  • LimeSurvey GmbH Employee
  • LimeSurvey GmbH Employee
More
9 years 6 months ago #112273 by c_schmitz
Replied by c_schmitz on topic Upgrade From 1.90 to 2.05
I meant the 2nd. Are you 100% sure you had the same problem when you tried the first time? Because from my experience usually you don't. Also activate debug mode in config.php before you try again.

Best regards

Carsten Schmitz
LimeSurvey project leader
The topic has been locked.
  • Mike1985_2
  • Mike1985_2's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 6 months ago #112275 by Mike1985_2
Replied by Mike1985_2 on topic Upgrade From 1.90 to 2.05
Do you mean applications/config/config-sample-mysql.php? There is no config.php file from what I can see...
The topic has been locked.
  • c_schmitz
  • c_schmitz's Avatar
  • Offline
  • LimeSurvey GmbH Employee
  • LimeSurvey GmbH Employee
More
9 years 6 months ago #112277 by c_schmitz
Replied by c_schmitz on topic Upgrade From 1.90 to 2.05
There is one right on time before when you get to the db update part ( it is create during the installation)

Best regards

Carsten Schmitz
LimeSurvey project leader
The topic has been locked.
  • Mike1985_2
  • Mike1985_2's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 5 months ago #113109 by Mike1985_2
Replied by Mike1985_2 on topic Upgrade From 1.90 to 2.05
No. There really isn't. There is no config.php file anywhere in a 2.05 that I can see.
The topic has been locked.
  • Mike1985_2
  • Mike1985_2's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 5 months ago #113198 by Mike1985_2
Replied by Mike1985_2 on topic Upgrade From 1.90 to 2.05
I have managed to upgrade :)

I am not 100% sure what the issue was but I had to delete a particular survey in order for my upgrade to work.

c_schmitz - you were right about needing to restore back to a post-upgrade database state. However, just curious... is there an upgrade planned to avoid needing to do this? The reason my upgrade was failing the second time was because
Code:
Column already exists: 1060 Duplicate column name 'participant_id'.
. Can't there be a check done first to see if it alreadys exists? And if it does, skip?
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 5 months ago #113248 by DenisChenu
Replied by DenisChenu on topic Upgrade From 1.90 to 2.05

Mike1985_2 wrote: Can't there be a check done first to see if it alreadys exists? And if it does, skip?

I think we have a bug report in devoppement part for all upgrade system.

But it's hard to rework on a very old system and don't break anything ....

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose