View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 8
IDProjectCategoryView StatusDate SubmittedLast Update
19012Bug reportsInstallationpublic2023-08-04 15:592024-02-20 15:18
Reportertassoman Assigned ToDenisChenu  
PrioritynoneSeverityminor 
Status closedResolutionunable to reproduce 
Product Version6.2.0-dev 
Summary19012: missing db migration upgrade from 6.1.x to 6.2.x
Description

I was apparently able to upgrade from 3.x to 6.1.x branch only by file substitution. (scarifying themes, because of incompatibility)
Then, trying to install "actual" 6.x branch (6.2.0 version) broke the installation.
I got this error

500: Errore interno del server CDbCommand ha riportato un errore nell'esecuzione della query SQL: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't.tokenencryptionoptions' in 'field list'

is 6.2.x branch unstable?

LTS is not guaranteed at 2023/08, also is getting a few of maintenance, either.
Do 3.x upgrade should stop at 5.x branch, is it new stable?

Steps To Reproduce

Steps to reproduce

  1. install a LAMP environment
  2. load a 3.x working SQL Dump
  3. replace limesurvey directory with 6.2.0 release
  4. crank-up the LAMP
  5. visit index.php

Expected result

I expected to see upgrade procedure page

Actual result

Got 500 SQL error:

500: Errore interno del server CDbCommand ha riportato un errore nell'esecuzione della query SQL: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't.tokenencryptionoptions' in 'field list'

TagsNo tags attached.
Bug heat8
Complete LimeSurvey version number (& build)6.2.0
I will donate to the project if issue is resolvedNo
Browserany
Database type & versionmariadb 10
Server OS (if known)redhat ubi9/php-81
Webserver software & version (if known)apache 2.4
PHP Version8.1

Users monitoring this issue

tassoman

Activities

gabrieljenik

gabrieljenik

2023-08-14 19:10

manager   ~76584

How is the config/versions file you load on step 2?

Do you have a bit more of information?
Can you do the same srtting the debug=2 on the config.php file as to know a bit more on the context?

Thanks
tassoman

tassoman

2024-02-16 11:09

reporter   ~79534

We backed off to 5.x branch. I think this issue can be closed for now.
DenisChenu

DenisChenu

2024-02-17 10:54

developer   ~79537

We backed off to 5.x branch. I think this issue can be closed for now.

? if there are an issue, we need to fix it …
@Gabriel : you test an upgrade from 3 to 6.2 ?
gabrieljenik

gabrieljenik

2024-02-19 14:44

manager   ~79541

@Gabriel : you test an upgrade from 3 to 6.2 ?

I will not be able to do this in this week or the next
DenisChenu

DenisChenu

2024-02-19 15:55

developer   ~79542

I will not be able to do this in this week or the next

OK :)
I take it (check if there a
DenisChenu

DenisChenu

2024-02-20 15:18

developer   ~79557

Tested
and https://github.com/LimeSurvey/LimeSurvey/blob/ccf4d07f3e282ea084db9364246e8e90b96ec6b7/application/helpers/update/updates/Update_406.php#L13

Issue History

Date Modified Username Field Change
2023-08-04 15:59 tassoman New Issue
2023-08-04 16:00 tassoman Issue Monitored: tassoman
2023-08-04 16:00 tassoman Bug heat 0 => 2
2023-08-14 19:10 gabrieljenik Note Added: 76584
2023-08-14 19:10 gabrieljenik Bug heat 2 => 4
2023-08-14 19:12 gabrieljenik Status new => acknowledged
2024-02-16 11:09 tassoman Note Added: 79534
2024-02-16 11:09 tassoman Bug heat 4 => 6
2024-02-17 10:54 DenisChenu Note Added: 79537
2024-02-17 10:54 DenisChenu Bug heat 6 => 8
2024-02-19 14:44 gabrieljenik Note Added: 79541
2024-02-19 15:55 DenisChenu Note Added: 79542
2024-02-19 15:55 DenisChenu Assigned To => DenisChenu
2024-02-19 15:55 DenisChenu Status acknowledged => assigned
2024-02-20 15:18 DenisChenu Status assigned => closed
2024-02-20 15:18 DenisChenu Resolution open => unable to reproduce
2024-02-20 15:18 DenisChenu Note Added: 79557