Welcome to the LimeSurvey Community Forum

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

Upgrade from 3.21 to 4.1 - upgrade Database error

  • adelphisurveys
  • adelphisurveys's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
4 years 1 month ago #193319 by adelphisurveys
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
The topic has been locked.
  • adelphisurveys
  • adelphisurveys's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
4 years 1 month ago #193322 by adelphisurveys
Replied by adelphisurveys on topic Upgrade from 3.21 to 4.1 - upgrade Database error
This is the first error message I received.
Code:
Ein Fehler trat während des Datenbankupdates auf. Fehlerinformation:
CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='


What should be in the database now?


utf8mb4_unicode_ci or utf8mb4_general_ci ???


Grtz B
The topic has been locked.
More
4 years 1 month ago #193345 by Flups22
I have this problem, too, and would be grateful for a solution.
The topic has been locked.
  • ollehar
  • ollehar's Avatar
  • Offline
  • LimeSurvey GmbH Employee
  • LimeSurvey GmbH Employee
More
4 years 1 month ago #193346 by ollehar
Feel free to report it on our bug tracker.

Which database are you using? Which version of that database?
The topic has been locked.
More
4 years 1 month ago #193347 by Flups22
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.
The topic has been locked.
More
4 years 1 month ago #193348 by Flups22
... it actually seems to make no difference whether "ENGINE=InnoDB" is present in the options line or not.
The topic has been locked.
  • ollehar
  • ollehar's Avatar
  • Offline
  • LimeSurvey GmbH Employee
  • LimeSurvey GmbH Employee
More
4 years 1 month ago #193349 by ollehar
The following user(s) said Thank You: Flups22
The topic has been locked.
  • adelphisurveys
  • adelphisurveys's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
4 years 1 month ago #193350 by adelphisurveys
Replied by adelphisurveys on topic Upgrade from 3.21 to 4.1 - upgrade Database error
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
The topic has been locked.
  • ollehar
  • ollehar's Avatar
  • Offline
  • LimeSurvey GmbH Employee
  • LimeSurvey GmbH Employee
More
4 years 1 month ago #193351 by ollehar
Which exact version did you upgrade from? 3.21.0?
The topic has been locked.
  • adelphisurveys
  • adelphisurveys's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
4 years 1 month ago #193352 by adelphisurveys
Replied by adelphisurveys on topic Upgrade from 3.21 to 4.1 - upgrade Database error
yes
The topic has been locked.
  • ollehar
  • ollehar's Avatar
  • Offline
  • LimeSurvey GmbH Employee
  • LimeSurvey GmbH Employee
More
4 years 1 month ago #193353 by ollehar
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
The topic has been locked.
  • adelphisurveys
  • adelphisurveys's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
4 years 1 month ago #193354 by adelphisurveys
Replied by adelphisurveys on topic Upgrade from 3.21 to 4.1 - upgrade Database error
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



The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose