Upgrade From 1.90 to 2.05

More
3 years 3 months ago #112251 by Mike1985_2
Mike1985_2 created the topic: Upgrade From 1.90 to 2.05
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;
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..

Please Log in to join the conversation.

More
3 years 3 months ago #112257 by c_schmitz
c_schmitz replied the 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

Please Log in to join the conversation.

More
3 years 3 months ago #112272 by Mike1985_2
Mike1985_2 replied the 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?

Please Log in to join the conversation.

More
3 years 3 months ago #112273 by c_schmitz
c_schmitz replied the 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

Please Log in to join the conversation.

More
3 years 3 months ago #112275 by Mike1985_2
Mike1985_2 replied the 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...

Please Log in to join the conversation.

More
3 years 3 months ago #112277 by c_schmitz
c_schmitz replied the 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

Please Log in to join the conversation.

More
3 years 2 months ago #113109 by Mike1985_2
Mike1985_2 replied the 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.

Please Log in to join the conversation.

More
3 years 2 months ago #113198 by Mike1985_2
Mike1985_2 replied the 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
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?

Please Log in to join the conversation.

More
3 years 2 months ago #113248 by DenisChenu
DenisChenu replied the 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 (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!