View Issue Details

This issue affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
06144Bug reportsInstallationpublic2012-05-28 23:50
Reporteruser20124Assigned Toc_schmitz  
PriorityimmediateSeveritypartial_block 
Status closedResolutionunable to reproduce 
Product Version1.92+ 
Summary06144: 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'"

The problem remains after deleting the 'grelevance' column.

  • There are no errors in Apache error log. Its access log shows:
    "GET / HTTP/1.0" 200 7970
    "GET /admin HTTP/1.0" 301 330
    "GET /admin/admin.php HTTP/1.0" 200 3155
    "GET /admin/admin.php HTTP/1.0" 200 3155
    "GET /admin/admin.php?continue=1 HTTP/1.0" 200 16177
Steps To Reproduce
  1. Downloaded LimeSurvey 1.92+ (build number: 120517) from:
    http://download.limesurvey.org/Latest_stable_release/limesurvey192plus-build120517.tar.gz

  2. Extracted the 'limesurvey192plus-build120517.tar.gz'

  3. Backed up the surveys database by using the mysqldump command.

  4. Backed up the 'config.php' file and the 'upload' directory from the current LimeSurvery 1.91+ (build 11804) directory.

  5. Deleted all the old files and directories in the current LimeSurvery 1.91+ (build 11804) directory.

  6. Replaced the current LS 1.91+ directory with all the files from the extracted 1.92+ (build 120517) version.

  7. Restored the 'config.php' file and the 'upload' directory that were backed up in step 3.

  8. Deleted the surveys database from MySQL.

  9. Created the surveys database but did not populate it with any data.

  10. Deleted the LimeSurvey install directory.

  11. Restored the surveys database, which I backed up in step 3.

  12. Restarted the MySQL service.

  13. Logged into MySQL to check the surveys database and confirmed that it has all the tables.

  • NOTE: * Symptoms are the same for both ComfortUpdate (CU) and manual update except that during CU,
    the error about the 'grelevance' appear immediately after the update while during manual update there was
    an additional error with 8 SQL command failed errors, with the same text, except for different table names:

SQL command failed: CREATE TABLE <table_name> Reason: Table '<table_name>' already exists.

Table names in question were:

lime_participants
lime_participant_attribute
lime_participant_attribute_names
lime_participant_attribute_names_lang
lime_participant_attribute_values
lime_participant_shares
lime_survey_links
lime_expression_errors

Since all of the eight tables were empty, I deleted them and re-started the manual upgrade process but
the same error as with CU repeated, that is:

"SQL command failed: ALTER TABLE lime_groups ADD grelevance text DEFAULT NULL Reason: Duplicate column name 'grelevance'"

Same as with CU, the problem remained after deleting the 'grelevance' column.

Additional Information

I'm not too familiar with the surveys themselves because they belong to one of our research labs.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)120530
I will donate to the project if issue is resolvedNo
BrowserSafari 5.1.7 for Mac, Mozilla Firefox 12.0 for Mac, Internet Explorer 9
Database type & versionmysql Ver 14.12 Distrib 5.0.95, for redhat-linux-gnu (x86_64) using readline 5.1
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
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

user20124

2012-05-28 22:32

  ~18979

This error affected both 1.92+ build 120517 and 1.92+ build 120530.

c_schmitz

c_schmitz

2012-05-28 23:50

administrator   ~18980

This is not a bug.

Instead somehow you managed to screw up your database. If your update fails for any reasons you will need to restart from the database backup again. If you did not backup your database properly before backup you will need manual repair of the database (in that case you might want to contact one of our LimeSurvey partners http://www.limesurvey.com )

IF you restore a previous database backup make sure the database is empty before you restore do it.

If you need further help please use the forums.

Issue History

Date Modified Username Field Change
2012-05-28 22:30 user20124 New Issue
2012-05-28 22:32 user20124 Note Added: 18979
2012-05-28 23:50 c_schmitz Note Added: 18980
2012-05-28 23:50 c_schmitz Status new => closed
2012-05-28 23:50 c_schmitz Assigned To => c_schmitz
2012-05-28 23:50 c_schmitz Resolution open => unable to reproduce