View Issue Details

This issue affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
07657Bug reportsInstallationpublic2013-03-12 19:36
Reporteralexschoenmakers Assigned Toc_schmitz  
PriorityhighSeveritycrash 
Status closedResolutionunable to reproduce 
Product Version2.00+ 
Summary07657: Upgrade from Versie 1.87 to 2.0.0
Description

A blocking problem occurs when upgrading a working 1.87 installation to version 2.0.0.

The upgrade-wizard attempts to upgrade the database but the process fails in MySQL because of a "duplicate column parent_qid" in the table questions.

Obviously this is a blocking step in the installation process.

This upgrade is from version "1.87+ Build 8498" to version "2.0.0+ build130305" (taken from the tar.gz found on the website).

Additional Information

In the forums on the Limesurvey-site a registered user pgasper reported this on 18 Dec 2012 09:40 but there was no reply/solution posted.

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)130305
I will donate to the project if issue is resolvedNo
BrowserFirefox 19.0.2
Database type & versionMySQL 5.0.51
Server OS (if known)Debian Lenny
Webserver software & version (if known)apache2 (2.2.9)
PHP Version5.2.6
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2013-03-12 19:36

administrator   ~24675

I installed a clean 1.87+ Build 8498 and updated from it without problems.
I think that the additional columns are a remainder of an update attempt in the past (v 1.9x most probaby). You will need to remove the offending columns manually before you start the update. There might be more stuff you will have to correct before it works.

Issue History

Date Modified Username Field Change
2013-03-12 17:00 alexschoenmakers New Issue
2013-03-12 19:36 c_schmitz Note Added: 24675
2013-03-12 19:36 c_schmitz Status new => closed
2013-03-12 19:36 c_schmitz Assigned To => c_schmitz
2013-03-12 19:36 c_schmitz Resolution open => unable to reproduce