View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 06144 | Bug reports | Installation | public | 2012-05-28 22:30 | 2012-05-28 23:50 |
| Reporter | Assigned To | c_schmitz | |||
| Priority | immediate | Severity | partial_block | ||
| Status | closed | Resolution | unable to reproduce | ||
| Product Version | 1.92+ | ||||
| Summary | 06144: 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:
The problem remains after deleting the 'grelevance' column.
| ||||
| Steps To Reproduce |
SQL command failed: CREATE TABLE Table names in question were: lime_participants Since all of the eight tables were empty, I deleted them and re-started the manual upgrade process but "SQL command failed: ALTER TABLE 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. | ||||
| Tags | No tags attached. | ||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 120530 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Safari 5.1.7 for Mac, Mozilla Firefox 12.0 for Mac, Internet Explorer 9 | ||||
| Database type & version | mysql 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 Version | PHP 5.3.3 | ||||
| Git branch / Pull Request URL | |||||
|
This error affected both 1.92+ build 120517 and 1.92+ build 120530. |
|
|
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. |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-05-28 22:30 |
|
New Issue | |
| 2012-05-28 22:32 |
|
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 |