View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
08815Bug reportsInstallationpublic2014-03-06 11:592014-03-20 14:52
Reporterfvanderstarre Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.05+ 
Summary08815: Some more errors in updatedb_helper.php
Description

Line # 512: "alterColumn('{{questions}}','type',"{$sVarchar}(1)",false , 'T');"
should be preceded by "try{ $oDB->createCommand()->dropIndex('questions_idx4','{{questions}}');} catch(Exception $e){};"
=> Index must be dropped before altering column (mssql)

Line # 647: "'PRIMARY KEY (attribute_id,attribute_type)'" to be removed -
PK to be added in separate statement (just like the other tables):
"addPrimaryKey('participant_attribute_names', array('attribute_id','attribute_type'));"

Steps To Reproduce

Upgrade from db version 143 (1.90) to 177 (2.05+)

Additional Information

Sorry for not reporting earlier - overlooked... :(

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)2.05+ 140302
I will donate to the project if issue is resolvedNo
BrowserFirefox
Database type & versionMS SQL server 2008 10.0.5500.0 (X64)
Server OS (if known)DB server: Windows NT 6.1 <X64> build 7601 SP1. Appl/web server: Linux RHEL 5.8
Webserver software & version (if known)Apache/2.2.3 (Red Hat)
PHP Version5.3.3

Users monitoring this issue

There are no users monitoring this issue.

Activities

Mazi

Mazi

2014-03-06 15:12

updater   ~29118

Assigning this one to Carsten since he has just fixed similar issues.
c_schmitz

c_schmitz

2014-03-18 09:25

administrator   ~29322

fvanderstarre, the first change I found out, too, the 2nd one is IMHO not necessary as it is perfecty valid syntax.
c_schmitz

c_schmitz

2014-03-20 14:52

administrator   ~29463

2.05+ Build 140320 released

Related Changesets

LimeSurvey: master 25426708

2014-03-17 14:09

c_schmitz


Details Diff		 Fixed issue: Problems running DB update when updating from 1.92/1.90 using MSSQL Affected Issues
08815
mod - application/helpers/update/updatedb_helper.php Diff File

Issue History

Date Modified Username Field Change
2014-03-06 11:59 fvanderstarre New Issue
2014-03-06 15:10 Mazi Assigned To => c_schmitz
2014-03-06 15:10 Mazi Status new => assigned
2014-03-06 15:12 Mazi Note Added: 29118
2014-03-18 09:25 c_schmitz Note Added: 29322
2014-03-18 09:25 c_schmitz Status assigned => resolved
2014-03-18 09:25 c_schmitz Resolution open => fixed
2014-03-18 09:25 c_schmitz Changeset attached => LimeSurvey master 25426708
2014-03-20 14:52 c_schmitz Note Added: 29463
2014-03-20 14:52 c_schmitz Status resolved => closed