View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
18329Bug reportsInstallationpublic2022-08-31 10:132022-09-01 13:37
Reporterandreafesta Assigned Toollehar  
PrioritynoneSeverityblock 
Status closedResolutionunable to reproduce 
Product Version5.3.x 
Summary18329: Errore during upgrade from 3 to 5
Description

Hello.
I'm updating from a old 3 version to last 5 version but I find a lot of issue during Database Update

Last is:
Errore non recuperabile durante l'aggiornamento. Dettaglio dell'errore:
CDbCommand ha riportato un errore nell'esecuzione della query SQL: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'tokenencryptionoptions'

File Update_406.php, linea 13.

Could someone help me?
Thank you
Andrea

TagsNo tags attached.
Attached Files
errore.jpg (33,109 bytes)   
errore.jpg (33,109 bytes)   
Bug heat4
Complete LimeSurvey version number (& build)5.3.32+220817
I will donate to the project if issue is resolvedNo
BrowserChrome
Database type & versionlibmysql - mysqlnd 5.0.12-dev - 20150407
Server OS (if known)10.3.34-MariaDB-0+deb10u1 - Debian 10
Webserver software & version (if known)
PHP Version7.3.31-1~deb10u1

Users monitoring this issue

There are no users monitoring this issue.

Activities

ollehar

ollehar

2022-08-31 10:49

administrator   ~71557

Strange. From which LS3 version did you update?

You could try to manually drop that column in the database, and then try to upgrade again.
andreafesta

andreafesta

2022-08-31 12:38

reporter   ~71562

Thank you, I solve It.
Now I have another problem... Old surveys don't save results. The newers yes...

Another ideas?

Thank you
Andrea

errore2.jpg (83,943 bytes)   
errore2.jpg (83,943 bytes)   
ollehar

ollehar

2022-08-31 17:10

administrator   ~71566

Very good question... You probably want to look for further feedback on the forum. Are you a paying customer, with ComfortUpdate?
andreafesta

andreafesta

2022-09-01 10:09

reporter   ~71570

I solve... I don't no why a lot of mysql table don't have primary key because a lot of rows was duplicated.
I remove them and choose primay key and solve the problem.

Thank you
Andrea

Issue History

Date Modified Username Field Change
2022-08-31 10:13 andreafesta New Issue
2022-08-31 10:13 andreafesta File Added: errore.jpg
2022-08-31 10:49 ollehar Note Added: 71557
2022-08-31 10:49 ollehar Bug heat 0 => 2
2022-08-31 10:49 ollehar Assigned To => ollehar
2022-08-31 10:49 ollehar Status new => feedback
2022-08-31 12:38 andreafesta Note Added: 71562
2022-08-31 12:38 andreafesta File Added: errore2.jpg
2022-08-31 12:38 andreafesta Bug heat 2 => 4
2022-08-31 12:38 andreafesta Status feedback => assigned
2022-08-31 17:10 ollehar Note Added: 71566
2022-09-01 10:09 andreafesta Note Added: 71570
2022-09-01 13:37 c_schmitz Status assigned => closed
2022-09-01 13:37 c_schmitz Resolution open => unable to reproduce