How to do a Update?

[porschberg]

Hi,
we use your docker-image for a long time now with success. Thank you.
However: Did you have an upgrade-guide? What is when I want to upgrade to a new version of Limesurvey? Currently we use Version 2.72.3+171020.
I fear that a simple docker-compose build will not work with my current version of Limesurvey and I want not lose my old surveys.

Thomas

[crramirez]

Hello,

Good to know :)

First, make a backup of your database and the config and update directory. I understand that you are using docker-compose. In this case, just do a docker-compose pull && docker-compose up -d. Limesurvey 3 is backward compatible with 2 so, once you upgrade the image and recreate the container it will upgrade your database.

Another option (and recommended) is to use comfort update. I think they offer a few for free. Inside LimeSurvey in the administration go to Confort Update, it will update your LimeSurvey and your database.

In each case please backup everything before.

Regards,
Carlos

[porschberg]

I pulled the new docker-image. Now i get a "LimeSurvey installer" dialogue. Does it recognize the old database?

[crramirez]

Yes, put the same parameters it will say that there is an existing database

[porschberg]

Good point. When I login into the docker-container I see:

root@7303394b11c0:/var/lib/mysql# ls
ib_logfile0  ib_logfile1  ibdata1  limesurvey  mysql  performance_schema

So my database is called limesurvey probably. Yes?
Can I read the USER/PASSWORD somewhere from the environment?

I wrote down my password and user, but I'm not sure if it's true.

[crramirez]

You can test. If your database name is right it will try to connect. It won't overwrite your database. But your doubts make me think that you didn't make a backup first and it is very dangerous to do the update without a backup. Anyway in the Readme of the project you have the default values. El lun., 23 de septiembre de 2019 16:34, Thomas Porschberg < [email protected]> escribió:

…

Good point. When I login into the docker-container I see: ***@***.***:/var/lib/mysql# ls ib_logfile0 ib_logfile1 ibdata1 limesurvey mysql performance_schema So my database is called limesurvey probably. Yes? Can I read the USER/PASSWORD somewhere from the environment? I wrote down my password and user, but I'm not sure if it's true. — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#35?email_source=notifications&email_token=ACACEQ6VVT44H7RUGUTUSYTQLDHWRA5CNFSM4IZGW272YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD7LCA6Y#issuecomment-534126715>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ACACEQ7TQUFMDPBTAV65VU3QLDHWRANCNFSM4IZGW27Q> .

[porschberg]

I did a backup via the UI and I have now a file LimeSurvey_limesurvey_dump_2019-09-23.sql .
In this file I see a INSERT into table lime_users with name=admin.

After my first installation of limesurvey I wrote down two user/password pairs:
user: root password:
user: admin password:
However when I login into my container and try to connect via mysql I get
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
The same for user root.

This should work at command line?!

[porschberg]

Ok, could connect now with user root. The installation process recognizes the old databases but gives an error:
CDbException Die Tabelle "{{template_configuration}}" für die ActiveRecord-Klasse "TemplateConfiguration" kann nicht in der Datenbank gefunden werden.

English:
CDbException The {{template_configuration}} table for the TemplateConfiguration ActiveRecord class can not be found in the database

[crramirez]

OK, It allows you to continue? you can go back modifying your docker-compose.yml to

image:
  crramirez/limesurvey:2

But probably you will need to restore the backup. And export your surveys and begin from scratch then import the surveys

[porschberg]

Okay. I'm back now. I updated in my docker-compose to crramirez/limesurvey:2.
I see my old surveys. I had not to restore my backup. "ComfortUpdate" is not available for me.
How should I proceed?

When I login into the container and do a
mysql> SELECT * FROM template_configuration; ERROR 1146 (42S02): Table 'limesurvey.template_configuration' doesn't exist
This problematic table does still not exist. Is it possible to upgrade to limesurvey3?

[crramirez]

Hello,

You should be in 2.73.1 now, the latest 2.x. You can try the upgrade process again. If it doesn't work, the only way is to export your surveys, start from scratch and import them again.

Regards

[porschberg]

Seems to be the way. It is not possible to upgrade from 2 to 3. Same error as before.