View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
06270Bug reportsOtherpublic2012-08-15 00:11
ReporterJoyLaneResearch Assigned Toc_schmitz  
PrioritynormalSeveritycrash 
Status closedResolutionfixed 
Fixed in Version2.00RC8 
Summary06270: CDbException during install of 2.0RC4
Description

Domain: mydomain.com/index.php/admin/update/db/continue/yes
CDbCommand.php(354)
354 throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',

mydomain.com/application/helpers/update/updatedb_helper.php(596): CDbCommand->dropIndex("user_in_groups_idx1", "{{user_in_groups}}")
596 Yii::app()->db->createCommand()->dropIndex('user_in_groups_idx1','{{user_in_groups}}');

mydomain.com/application/helpers/update/update_helper.php(34): db_upgrade_all(143)
34 db_upgrade_all(intval($currentDBVersion));

mydomain.com/application/controllers/admin/update.php(539): CheckForDBUpgrades("yes")
539 $aViewUrls['output'] = CheckForDBUpgrades($continue);

mydomain.com/index.php(171): CApplication->run()
2012-06-23 21:08:51 Apache/2.2.3 (Red Hat) Yii Framework/1.1.10

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.

TagsNo tags attached.
Bug heat2
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

Users monitoring this issue

There are no users monitoring this issue.

Activities

JoyLaneResearch

JoyLaneResearch

2012-06-25 18:56

reporter   ~19552

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 lime_surveys ADD savetimings varchar(1) NULL default 'N'

Is it possible that I had the problem because the database already exists?

JoyLaneResearch

JoyLaneResearch

2012-06-25 21:05

reporter   ~19558

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.

JoyLaneResearch

JoyLaneResearch

2012-08-10 17:12

reporter   ~20348

Issue appears to have been resolved in RC8.

Issue History

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 Development => 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