Welcome to the LimeSurvey Community Forum

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

Comfort update from Version 2.00+ Build 130611

  • sostberg
  • sostberg's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 1 week ago #200144 by sostberg
Replied by sostberg on topic Comfort update from Version 2.00+ Build 130611
I understand. So, what would be the best way? Manually update to 2.06 and then using CU to 3.xx? Or manually update to 3.xx directly? If last, is there a way to cancel the CU key in order to not have expire without using it?
The topic has been locked.
  • sostberg
  • sostberg's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 1 week ago #200149 by sostberg
Replied by sostberg on topic Comfort update from Version 2.00+ Build 130611
I did the manual update to 2.06+ Build 160129, and the front end seems to work. However, when I try to log into the admin area, I get a 500 error message.

The error I get is =>
Internal Server error
The table "{{plugins}}" for the ActiveRecord-class "Plugin" can not be found in the database.

<=
What shall I do? Just add this table in the database?

Thanks!
The topic has been locked.
  • sostberg
  • sostberg's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 1 week ago #200152 by sostberg
Replied by sostberg on topic Comfort update from Version 2.00+ Build 130611
In the meantime I enabled the debug mode and found the following details:



Both tables which are mentioned in the message are already in the database.
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 1 week ago #200156 by holch
I would probably manually update to 2.06+ and then see if Comfort Update works.

In any way, for manual update, I probably would update in steps and I wouldn't skip any major release. Just in case.

Also, with such an old installation, I recon it isn't used that much? Maybe a solution would be to set up a totally new and clean install of the latest 3.x LTS release (if you don't have many surveys that you still need or if you don't have a ton of users, which you would have to create new one by one).

I did the manual update to 2.06+ Build 160129, and the front end seems to work. However, when I try to log into the admin area, I get a 500 error message.


Weird, but a 500 error is usually do to some problems with the server itself. What version of PHP/MySQL are you running? With such an old version that hasn't been updated in about 7 years there is a good chance that the server it is running on is old "slightly" outdated. ;-)

Maybe the fresh install is your best solution for the moment. Your "mumie" is almost 7 years old now. I doubt anyone here has such an old version running (I honestly hope so!) to check things.

I don't know your setup, but I would probably "cut" my losses and just install LS 3.x LTS on a fresh server with an up to date setup, to be prepared for the future. LS has come a long way since 2.00 and there have been a lot of improvements and changes since 2013.

If last, is there a way to cancel the CU key in order to not have expire without using it?

I instantly hope that you will actually use it, once you have a more modern version running. There are always minor updates and bug fixes, so the CU key will not expire without using it, as long as you don't wait another 7 years, to do the next update. ;-) (sorry, it was just too tempting...).

But honestly, I don't think it makes sense to put the CU key on hold even if it would be possible (I don't know, you need to clarify this with the Limesurvey GmbH), if you solve this issue within the next couple of days. Because from then on you can use the comfort update for any new update that is applying to 3.x LTS or 4.x (which I would currently only install for testing, because I don't feel it is ready for "productive" use yet - we probably have to give it another couple of weeks/months for that).

Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
The following user(s) said Thank You: cdorin
The topic has been locked.
  • sostberg
  • sostberg's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 1 week ago #200161 by sostberg
Replied by sostberg on topic Comfort update from Version 2.00+ Build 130611

holch wrote: What version of PHP/MySQL are you running?


If I knew that... The old version was installed by 1&1 automatically, so I can't change the version, and I can't even see the version.

I also already thought about making a complete new installation. We don't have any users, and no open surveys. It's just the work setting up the surveys. Until now we only had to copy the old survey.
The topic has been locked.
More
5 years 1 week ago #200162 by cdorin
About Error 500: we saw that error as well. We edited the parameter and tested it but again... without any success (deeper changes/edits are needed to make CU work in LS2.00)

Manual: manual.limesurvey.org/LimeSurvey_Manual
Bugs tracker: bugs.limesurvey.org/my_view_page.php
If you self-host and need help, contact one of our partners: limesurvey.com
Please do not contact me via PM - thank you.
The topic has been locked.
  • sostberg
  • sostberg's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 1 week ago #200164 by sostberg
Replied by sostberg on topic Comfort update from Version 2.00+ Build 130611
So, you don't have an idea about this table error message?
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 1 week ago - 5 years 1 week ago #200165 by holch

It's just the work setting up the surveys. Until now we only had to copy the old survey.


Set up the latest 3.x LTS in parallel, it doesn't cost you anything, at least not more than maybe 5-10 minutes to set the new installation up (mabye 15min if we include the upload).

Then you export one of your surveys as LSS and import it into the new installation. This should work without problems. Test it. if everything else is fine, export and import all of your surveys to the new system.

So no need to create the surveys from scratch. If you use some workarounds, they might not work with the newer version, but the same problem you would have with any upgrade either. And if you have custom templates/designs, they will need to be adapted to the new templating system. But here also the same when upgrading.

So if you don't have many users and only few base surveys that you would like to use again, then the setup of a new installation including copying the surveys might take you between 30-60min. I think it is the cleanest approach.

And from then on you just keep up with the updates and CU should work like a charm.

Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
Last edit: 5 years 1 week ago by holch.
The topic has been locked.
  • sostberg
  • sostberg's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 1 week ago #200169 by sostberg
Replied by sostberg on topic Comfort update from Version 2.00+ Build 130611
Ok, I will try this. First I have to reset everything to the older version 2.00.

Thanks!
The topic has been locked.
  • sostberg
  • sostberg's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 1 week ago #200173 by sostberg
Replied by sostberg on topic Comfort update from Version 2.00+ Build 130611
We can close this topic. Reinstalling V2.00 didn't work, and I will set up a completely new installation. Luckily I found a survey export of the old survey, so that I at least know the questions...

Thanks again for the help! :)
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 1 week ago #200175 by holch
When you say that you found an export of the old survey, is it an LSS?

Because then you should be able to import without a problem.

What happened to the reinstall? Why did it not work?

What you could try is making the new install of LS 3.0 and use a dump of the old database to see what happens. More than loosing the data can't really happen. If it works, great, basically an "update", if it doesn't, you'll just need to start over with the installation.

Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
The topic has been locked.
  • sostberg
  • sostberg's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 1 week ago #200178 by sostberg
Replied by sostberg on topic Comfort update from Version 2.00+ Build 130611
No, it's an Excel file. And there was a ton of error messages. The question for us is, if we really need LimeSurvey (or another survey platform), as we usually run one or two surveys per year... Plus, you can't easily embed it into another website (at least not V2.0)...
The topic has been locked.
Moderators: holchtpartner

Lime-years ahead

Online-surveys for every purse and purpose