View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
07680 | Bug reports | Installation | public | 2013-03-18 21:23 | 2013-03-19 12:06 |
Reporter | eea004 | Assigned To | c_schmitz | ||
Priority | normal | Severity | crash | ||
Status | closed | Resolution | unable to reproduce | ||
Product Version | 2.00+ | ||||
Summary | 07680: LimeSurvey Database Upgrade Failing During Update | ||||
Description | Experiencing an issue when the installation process (http://<yourdomain>/<yourlimesurveydir>/admin) is trying to upgrade the LimeSurvey database. I am currently trying to upgrade from Version 1.87+ Build 8518 to Version 2.00+ Build 130311. I was able to get past the first error "CDbCommand failed to execute the SQL statement: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'lime_defaultvalues' already exists" when I dropped the lime_defaultvalues table, but then encountered the error "CDbCommand failed to execute the SQL statement: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'parent_qid'" and not sure which table this is referring to so I can correct manually. | ||||
Additional Information | Attched screenshot of error. | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 2 | ||||
Complete LimeSurvey version number (& build) | 130311 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | FireFox 10.0.3 | ||||
Database type & version | MySQL 5.0.95 | ||||
Server OS (if known) | Linux | ||||
Webserver software & version (if known) | Apache 2.2.3 | ||||
PHP Version | 5.1.6 | ||||
Date Modified | Username | Field | Change |
---|---|---|---|
2013-03-18 21:23 | eea004 | New Issue | |
2013-03-18 21:23 | eea004 | File Added: LimeSurveyDatabaseUpgradeError2.PNG | |
2013-03-19 12:06 | c_schmitz | Note Added: 24771 | |
2013-03-19 12:06 | c_schmitz | Status | new => closed |
2013-03-19 12:06 | c_schmitz | Assigned To | => c_schmitz |
2013-03-19 12:06 | c_schmitz | Resolution | open => unable to reproduce |