View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
06172Bug reportsInstallationpublic2012-06-07 11:02
Reportercougarsyankeesfan Assigned ToTMSWhite  
PriorityhighSeverityblock 
Status closedResolutionfixed 
Product Version1.92+ 
Fixed in Version1.92+ 
Summary06172: Update to Version 1.92+ from 1.91+ Cannot Complete - Reason: Duplicate column name 'grelevance'
Description

It seems that there is an issue with upgrading from version 1.91+ (build 11804) to version 1.92+ (build 120517).

Here are the details:

  • Both ComfortUpdate and manual update cannot complete successfully.

  • Error that the LimeSurvey returns when accessing /admin/admin.php after the upgrade is:
    "SQL command failed: ALTER TABLE lime_groups ADD grelevance text DEFAULT NULL Reason: Duplicate column name 'grelevance'"

Steps To Reproduce

We had the same exact issue with the update that others have reported. Before the update, there had not been any changes to the database. This makes me doubt that our mismanagement of the database led to this error. Everything was fine before we attempted to upgrade. Your help would be appreciated.

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)120517
I will donate to the project if issue is resolvedNo
Browser
Database type & versionysql Ver 14.12 Distrib 5.0.95
Server OS (if known)Red Hat Enterprise Linux Server release 5.8 (Tikanga) 64-bit
Webserver software & version (if known)Apache 2.2.3
PHP VersionPHP 5.3.3

Users monitoring this issue

There are no users monitoring this issue.

Activities

TMSWhite

TMSWhite

2012-06-06 06:24

reporter   ~19080

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=8661

TMSWhite

TMSWhite

2012-06-06 06:25

reporter   ~19081

Problem was that some upgrade attempts added grelevance column, but aborted while running UpgradeConditionsToRelevance() before setting the upgraded DBVersion.

Users who continue to have this problem on upgrade should manually change their DBVersion to 154 in the settings_global table (so that LS knows that grelevance was added), then let the automatic DB upgrade process run again.

cougarsyankeesfan

cougarsyankeesfan

2012-06-07 05:25

reporter   ~19091

Great job Thomas! Thanks for the help! Your solution worked perfectly.

c_schmitz

c_schmitz

2012-06-07 11:02

administrator   ~19092

New 1.91+ build released.

Related Changesets

LimeSurvey: master 82d27f1f

2012-06-05 21:24:09

TMSWhite

Details Diff
Fixed issue 06172: Update to Version 1.92+ from 1.91+ Cannot Complete - Reason: Duplicate column name 'grelevance'
Dev Problem was that some upgrade attempts added grelevance column, but aborted while running UpgradeConditionsToRelevance() before setting the upgraded DBVersion
Dev Users who continue to have this problem on upgrade should manually change their DBVersion to 154 in the settings_global table (so that LS knows that grelevance was added), then let the automatic DB upgrade process run again.
Affected Issues
06172
mod - admin/update/upgrade-mssql.php Diff File
mod - admin/update/upgrade-mssqlnative.php Diff File
mod - admin/update/upgrade-mysql.php Diff File
mod - admin/update/upgrade-postgres.php Diff File

LimeSurvey: Yii 9e486677

2012-06-06 08:57:41

TMSWhite

Details Diff
Fixed issue 06171: variable < X is true even if variable isn't answered
Dev Now automatically upgrades all conditions in database via database version upgrade
Affected Issues
06171, 06172
mod - application/config/version.php Diff File
mod - application/helpers/update/updatedb_helper.php Diff File

Issue History

Date Modified Username Field Change
2012-06-06 02:20 cougarsyankeesfan New Issue
2012-06-06 06:24 TMSWhite Changeset attached => LimeSurvey master 82d27f1f
2012-06-06 06:24 TMSWhite Note Added: 19080
2012-06-06 06:24 TMSWhite Assigned To => TMSWhite
2012-06-06 06:24 TMSWhite Resolution open => fixed
2012-06-06 06:25 TMSWhite Note Added: 19081
2012-06-06 06:25 TMSWhite Status new => resolved
2012-06-06 06:25 TMSWhite Fixed in Version => 1.92+
2012-06-06 18:24 TMSWhite Changeset attached => LimeSurvey Yii 9e486677
2012-06-07 05:25 cougarsyankeesfan Note Added: 19091
2012-06-07 11:02 c_schmitz Note Added: 19092
2012-06-07 11:02 c_schmitz Status resolved => closed