Upgrade from 3.21 to 4.1 - upgrade Database error

Mehr
2 Monate 1 Woche her #193319 von 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

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

LimeSurvey Partners
Mehr
2 Monate 1 Woche her #193322 von adelphisurveys
This is the first error message I received.
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

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Monate 1 Woche her #193345 von Flups22
I have this problem, too, and would be grateful for a solution.

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Monate 1 Woche her #193346 von ollehar
Feel free to report it on our bug tracker.

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

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Monate 1 Woche her #193347 von 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.

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Monate 1 Woche her #193348 von Flups22
... it actually seems to make no difference whether "ENGINE=InnoDB" is present in the options line or not.

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Monate 1 Woche her #193349 von ollehar
Folgende Benutzer bedankten sich: Flups22

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Monate 1 Woche her #193350 von adelphisurveys
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

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Monate 1 Woche her #193351 von ollehar
Which exact version did you upgrade from? 3.21.0?

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Monate 1 Woche her #193352 von adelphisurveys

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Monate 1 Woche her #193353 von 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

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Monate 1 Woche her #193354 von adelphisurveys
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



Anhänge:

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Monate 1 Woche her #193355 von ollehar
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.

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Monate 1 Woche her #193360 von jelo
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.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Monate 1 Woche her #193361 von adelphisurveys
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
Folgende Benutzer bedankten sich: CarmIT

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Jetzt loslegen!

Melden Sie sich jetzt an, und erstellen Sie in wenigen Minuten Ihre erste Umfrage.

Account einrichten

Abonnieren Sie unseren Newsletter

Abonnieren Sie unseren Newsletter für alle Neuigkeiten rund um LimeSurvey
captcha