Hi LS-Team,

we are trying to update our LS version from 3.14.8+180829 to LS Version 5.2.3.

We've created a new server (RHEL) and installed a new LS Version. After that we create a dump-file from the database (old LS) and try to migrate them to the new database. After importing all the database file and open the page in browser, LS redirect us to the following page : xxxxx/index.php/admin/databaseupdate/sa/db
It says the actual database version is 358 and the target database version is 447. After we click the data base upgrade button it shows us the following error:
We've tried to change the column type for surveyls_email_invite from mediumtext to longtext but the error still exist.

Can you please help us, maybe show us the way to update the database ? Should we update them to earlier LS version first ?

I appreciate any kind of help. Thank you in advance.

Best Regards,
Anderson Elias

I recommend to install LS3 on the new server with the database from the LS3 installation. Then Upgrade to LS5 on the new server which will convert the database too.

This may result in the same issue in the end. I recommend to check the integrity of the database in the running LS3 installation on the old server first.

Just like Jelo, I would try to update LS 3 to the latest version first, then upgrade to LS 5.

3.14.8+180829 to LS Version 5.2.3.

3.14.8 is over 3 years old now, so I think it is save to say that most people will not upgrade to LS5 from such an old version.

As Jelo says, you might run into the same error, but it is worth a shot.

Thank you @jelo & @holch. I've found the release page  community.limesurvey.org/release/180829/ but cannot found the installer. Do you happen to know, where I can get the LS3 files ? Thank you.

I don't think that such an old version is still available. But you can just copy all files from your current server to the new server. There is no real "installer", you just download the files and unpack them.

Perfect. Thank you @holch

Hmmm, you might need to clean the config file though, not sure. check what happens when you open the admin after copying everything. Because you might need to adapt the Database login data, because they have probably changed.

But in my opinion, you should be able to copy your old database and then install the newest LS3 using this old database.

Best seems to report the issue
We set to mediumtext in 429
But we use text in 359

Else : you can update it before update via phpMyAdmin for example.