View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 06270 | Bug reports | Other | public | 2012-06-24 04:42 | 2012-08-15 00:11 |
| Reporter | JoyLaneResearch | Assigned To | c_schmitz | ||
| Priority | normal | Severity | crash | ||
| Status | closed | Resolution | fixed | ||
| Fixed in Version | 2.00RC8 | ||||
| Summary | 06270: CDbException during install of 2.0RC4 | ||||
| Description | Domain: mydomain.com/index.php/admin/update/db/continue/yes mydomain.com/application/helpers/update/updatedb_helper.php(596): CDbCommand->dropIndex("user_in_groups_idx1", "{{user_in_groups}}") mydomain.com/application/helpers/update/update_helper.php(34): db_upgrade_all(143) mydomain.com/application/controllers/admin/update.php(539): CheckForDBUpgrades("yes") mydomain.com/index.php(171): CApplication->run() | ||||
| Steps To Reproduce | Not attempted. | ||||
| Additional Information | ALSO: noticed a problem with .git files interfering with Linux - making it impossible to delete folders on my server. | ||||
| Tags | No tags attached. | ||||
| Bug heat | 2 | ||||
| Complete LimeSurvey version number (& build) | |||||
| I will donate to the project if issue is resolved | |||||
| Browser | |||||
| Database type & version | |||||
| Server OS (if known) | |||||
| Webserver software & version (if known) | |||||
| PHP Version | |||||
| Git branch / Pull Request URL | |||||
|
Sorry. I forgot to include the top line of the error message: CDbCommand failed to execute the SQL statement: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'savetimings'. The SQL statement executed was: ALTER TABLE Is it possible that I had the problem because the database already exists? |
|
|
Problem was caused by having a 1.91 existing database by the same name. When the existing database was removed and 2.0RC4 was allowed to create its own databas, the problem was solved. |
|
|
Issue appears to have been resolved in RC8. |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-06-24 04:42 | JoyLaneResearch | New Issue | |
| 2012-06-25 18:56 | JoyLaneResearch | Note Added: 19552 | |
| 2012-06-25 21:05 | JoyLaneResearch | Note Added: 19558 | |
| 2012-08-10 17:12 | JoyLaneResearch | Note Added: 20348 | |
| 2012-08-14 22:45 | c_schmitz | Project | @10@ => Bug reports |
| 2012-08-14 22:45 | c_schmitz | Category | Installation => Other issues |
| 2012-08-15 00:11 | c_schmitz | Status | new => closed |
| 2012-08-15 00:11 | c_schmitz | Assigned To | => c_schmitz |
| 2012-08-15 00:11 | c_schmitz | Resolution | open => fixed |
| 2012-08-15 00:11 | c_schmitz | Fixed in Version | => 2.00RC8 |