- Posts: 70
- Thank you received: 1
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
- Topic Author
- Offline
- Senior Member
Less
More
4 years 2 months ago #193319
by adelphisurveys
Upgrade from 3.21 to 4.1 - upgrade Database error was created 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
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
- Topic Author
- Offline
- Senior Member
Less
More
- Posts: 70
- Thank you received: 1
4 years 2 months 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.
What should be in the database now?
utf8mb4_unicode_ci or utf8mb4_general_ci ???
Grtz B
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.
- Flups22
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 0
4 years 2 months ago #193345
by Flups22
Replied by Flups22 on topic Upgrade from 3.21 to 4.1 - upgrade Database error
I have this problem, too, and would be grateful for a solution.
The topic has been locked.
- ollehar
- Offline
- LimeSurvey GmbH Employee
Less
More
- Posts: 522
- Thank you received: 108
4 years 2 months ago #193346
by ollehar
Replied by ollehar on topic Upgrade from 3.21 to 4.1 - upgrade Database error
Feel free to report it on our bug tracker.
Which database are you using? Which version of that database?
Which database are you using? Which version of that database?
The topic has been locked.
- Flups22
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 0
4 years 2 months ago #193347
by Flups22
Replied by Flups22 on topic Upgrade from 3.21 to 4.1 - upgrade Database error
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.
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.
- Flups22
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 0
4 years 2 months ago #193348
by Flups22
Replied by Flups22 on topic Upgrade from 3.21 to 4.1 - upgrade Database error
... it actually seems to make no difference whether "ENGINE=InnoDB" is present in the options line or not.
The topic has been locked.
- ollehar
- Offline
- LimeSurvey GmbH Employee
Less
More
- Posts: 522
- Thank you received: 108
4 years 2 months ago #193349
by ollehar
Replied by ollehar on topic Upgrade from 3.21 to 4.1 - upgrade Database error
Your database version might be too old:
manual.limesurvey.org/Installation_-_Lim...rvey_on_your_website
The following user(s) said Thank You: Flups22
The topic has been locked.
- adelphisurveys
- Topic Author
- Offline
- Senior Member
Less
More
- Posts: 70
- Thank you received: 1
4 years 2 months 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
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
- Offline
- LimeSurvey GmbH Employee
Less
More
- Posts: 522
- Thank you received: 108
4 years 2 months ago #193351
by ollehar
Replied by ollehar on topic Upgrade from 3.21 to 4.1 - upgrade Database error
Which exact version did you upgrade from? 3.21.0?
The topic has been locked.
- adelphisurveys
- Topic Author
- Offline
- Senior Member
Less
More
- Posts: 70
- Thank you received: 1
4 years 2 months 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
- Offline
- LimeSurvey GmbH Employee
Less
More
- Posts: 522
- Thank you received: 108
4 years 2 months ago #193353
by ollehar
Replied by ollehar on topic Upgrade from 3.21 to 4.1 - upgrade Database error
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
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
- Topic Author
- Offline
- Senior Member
Less
More
- Posts: 70
- Thank you received: 1
4 years 2 months 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
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
Attachments:
The topic has been locked.