Welcome to the LimeSurvey Community Forum

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

Cannot update from 1.92+ to 2.51.3+

  • marius2
  • marius2's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 6 months ago #141378 by marius2
Cannot update from 1.92+ to 2.51.3+ was created by marius2
Hello,

I've downloaded my Limesurvey website to localhost to try make update from 1.92 to 2.51 before trying on production server.

As written in Docs I've deleted all old files and copied new ones. Left only old config.php, /upload, /tmp directories.
Opened http://localhost/lime/admin/, choosen language, all requirements passed, entered db, dbuser, dbpassword (it didn't recognize current database...), then it opened database upgrade window:
Database upgrade
Please verify the following information before continuing with the database upgrade...

I clicked on "Continue.." and after ~1-2mins it just opened url http://localhost/lime/index.php/admin/databaseupdate/sa/db/continue/yes and it was written: All 3 user templates updated.

When I tried go to http://localhost/lime/admin/ or Home page it gave me error:
Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't.allowjumps' in 'field list'
An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.
Thank you.

I have tried to restore backup database and make this db upgrade one more time, but it still gets the same error message...
I have set max_execution_time to 300 just in case, but didn't help.
I have set $debug = 2; but it didn't show me any error on the screen.
Using WAMPSERVER3 Apache 2.4.18 - PHP 5.6.19 - MySQL 5.7.11

Maybe I should try update from 1.92 to 2.05 and then from 2.05 to 2.51 ?

Thanks,
Marius.
The topic has been locked.
  • marius2
  • marius2's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 6 months ago #141383 by marius2
Replied by marius2 on topic Cannot update from 1.92+ to 2.51.3+
UPDATE: I've edited /application/config/config.php file and changed 'debug'=>2 and it started to work.
If I set back to 'debug'=>0, it gives same error:
Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't.allowjumps' in 'field list'
An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.

Strange... Maybe it's wamp and Windows OS problem...
The topic has been locked.
More
7 years 6 months ago #141421 by jelo
Replied by jelo on topic Cannot update from 1.92+ to 2.51.3+
I would recommend to upgrade in smaller steps. From 1.92+ to 2.05/2.06 is already a huge step.
2.5X.X is another beast. I would use the latest from the 2.5X.X. to upgrade from 2.0X. Personally I wouldn't use 2.5.X currently at all.
Too many changes happening. But that is just my opinion.
At least make a copy to be able to use LS 2.0X (LTS) beside LS 2.5.X.X.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The following user(s) said Thank You: DenisChenu
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
7 years 6 months ago - 7 years 6 months ago #141438 by LouisGac
Replied by LouisGac on topic Cannot update from 1.92+ to 2.51.3+

jelo wrote: Personally I wouldn't use 2.5.X currently at all.
Too many changes happening. But that is just my opinion.


That's not true anymore. 2.5 is now very reliable and stable. Only some debug are pushed now. Indeed, today, 2.06 has more bug than 2.5, and not all the fixes have been ported to 2.06lts. We'll do it in the future, but keep in mind that 2.06lts has now more bugs than 2.5.

Big changes on templates HTML is planned, but they will be published in a new major version release.

So you'd rather update to 2.5.
Last edit: 7 years 6 months ago by LouisGac.
The topic has been locked.
More
7 years 6 months ago #141497 by fvanderstarre
Replied by fvanderstarre on topic Cannot update from 1.92+ to 2.51.3+
The template incompatibility between 2.06 and 2.5 is keeping me from updating.
Are there any plans to incorporate a custom template migrating tool/script? That would be very helpful indeed!
The following user(s) said Thank You: DenisChenu
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
7 years 6 months ago #141516 by LouisGac
Replied by LouisGac on topic Cannot update from 1.92+ to 2.51.3+

fvanderstarre wrote: Are there any plans to incorporate a custom template migrating tool/script?

No, nothing like that it planed. You can still contact a LimeSurvey partner to update your custom templates.
The topic has been locked.
More
7 years 6 months ago #141523 by fvanderstarre
Replied by fvanderstarre on topic Cannot update from 1.92+ to 2.51.3+
Hi Louis, I don't want to be nasty but there are just 13 bugs listed in the bugtracker for version 2.06+ where status != 'closed'; for 2.50 and 2,51 combined the number is 51.
The following user(s) said Thank You: DenisChenu
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
7 years 6 months ago #141528 by LouisGac
Replied by LouisGac on topic Cannot update from 1.92+ to 2.51.3+
many 2.06 bugs were closed after being fixed for 2.5 without being fixed for 2.06.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose