View Issue Details

This issue affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
04767Bug reportsOtherpublic2010-11-28 13:45
Reporteruser372Assigned Toc_schmitz  
PriorityhighSeveritycrash 
Status closedResolutionno change required 
Product Version1.90+ 
Summary04767: Problems Upgrading from v1.87+ to 1.90+
Description

After upgrading from v1.87+ to v1.90+ I noticed that nearly every of my existing survey was messed up ==> I think there are problem at upgrading certain question types, eg. Matrix.

A)
Most of my problems are caused by the upgrade script, which didn't run through successfully, because of a low value for max_execution_time of my hosting provider.
The problem was, that I could only raise the value step by step and every try resulted in new answer values ==> see "EveryBadTryOneLine.png".

B)
At question type matrix the values of an labelset are inserted as answer options.
I want to show the problem with this example:
http://www.gisdat-umfragen.at/LQ/index.php?sid=5&lang=de
On the 3rd screen at "Bitte denken Sie an die Nahversorgungsqualität" the first 5 questions should be just two rows with "ZUFRIEDENHEIT" and "WICHTIGKEIT" and the columns should be 1 to 5 and "keine Angabe".
But the upgrade script added 1 to 5 and "keine Angabe" as answer option in a row.

TagsNo tags attached.
Attached Files
EveryBadTryOneLine.png (20,567 bytes)   
EveryBadTryOneLine.png (20,567 bytes)   
Bug heat4
Complete LimeSurvey version number (& build)9539
I will donate to the project if issue is resolvedNo
BrowserFF 3.6
Database type & versionMySQL 5.0.77
Server OS (if known)Linux
Webserver software & version (if known)Apache
PHP Version5.2.14
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

user372

2010-11-27 17:55

  ~13630

Feel free to contact me via IRC if you need further details.

c_schmitz

c_schmitz

2010-11-27 19:48

administrator   ~13631

Sadly there is not much we can do about both issues.

A.) results as you said from a max_execution time being too low. Executing the update script just takes its time - there is nothing we can do about that. If it fails you have to restore the DB from the backup you naturally made before starting the update procedure.

b.) Results from faulty data in your database. Most probably your matrix also had answers or a 2nd label set assigned (remains from an earlier question type change which properly didn't wipe the old options) and they were then converted and showed up. To be sure we would need the original database (from before the upgrade).

Issue History

Date Modified Username Field Change
2010-11-27 17:54 user372 New Issue
2010-11-27 17:54 user372 Status new => assigned
2010-11-27 17:54 user372 Assigned To => c_schmitz
2010-11-27 17:54 user372 File Added: EveryBadTryOneLine.png
2010-11-27 17:55 user372 Note Added: 13630
2010-11-27 19:48 c_schmitz Note Added: 13631
2010-11-27 19:48 c_schmitz Status assigned => feedback
2010-11-28 13:45 c_schmitz Status feedback => closed
2010-11-28 13:45 c_schmitz Resolution open => no change required