Hi,

I have just tried to upgrade LimeSurvey to version 4.1. Unfortunately I cannot upgrade the database. I get the following error:

An error occurred during the database update. Error information:
CDbCommand could not execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'question' in 'field list'

What can I do? Thanks for your help.

Thx Bavra

This is the first error message I received.


What should be in the database now?


utf8mb4_unicode_ci or utf8mb4_general_ci ???


Grtz B

I have this problem, too, and would be grateful for a solution.

Feel free to report it on our bug tracker.

Which database are you using? Which version of that database?

We're using MySQL, as to the version, I get this:

mysqlnd 5.0.12-dev - 20150407 - $Id: 241ae00989d1995ffcbbf63d579943635faf9972 $ (I'm not quite sure whether this is what is asked for; LimeSurvey itself said it wanted to upgrade from database version 359.)

I should mention, perhaps, that we're using InnoDB instead of MyISAM and consequently have "ENGINE=InnoDB " in our options in ../application/core/db/MysqlSchema.php. Maybe this doesn't work anymore in LimeSurvey 4.x? It worked fine in versions 3.x.

... it actually seems to make no difference whether "ENGINE=InnoDB" is present in the options line or not.

Your database version might be too old: www.limesurvey.org/manual/Installation_-...rvey_on_your_website

MySQL Version and PHPVersion

mysql Ver 15.1 Distrib 10.1.41-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
PHP 7.2.27-1+0~20200123.34+debian9~1.gbp63c0bc (cli) (built: Jan 23 2020 14:14:52) ( NTS )
Copyright (c) 1997-2018 The PHP Group

Which exact version did you upgrade from? 3.21.0?

yes

Can you attach a screenshot of the error, please? It's possible the update went through, but the Yii database cache wasn't cleared properly.

I could not reproduce the issue. Steps:

1. Fresh install of 3.21.0 with MySQL and PHP 7.4
2. Import demo survey with multiple languages
3. Update to latest 4.1 git branch
4. Works fine

First I tried it with version 4.1 from here:
www.limesurvey.org/stable-release

Now once again straight from the git from here:
github.com/LimeSurvey/LimeSurvey

Error is the same. Screenshots as attachment.

thx

OK, so what you can do is sending us the entire database dump so that we can test it. This only works if your data is not private/sensitive. You can send it either to me, olle dot haerstedt at limesurvey dot org, or to our support, support at limesurvey dot org.

Since there are two users with the issues, you should submit a bugreport first.

A databasedump without private/sensitive data (in the definition of GDPR/DSGVO) will be hard to find.

Thank you very much for your help. I'll start by filing a bug report. The data in our database is very sensitive, so I can't give out the database.

Thnx