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