View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
08786Bug reportsInstallationpublic2014-03-02 12:29
Reporterfvanderstarre Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.05+ 
Fixed in Version2.05+ 
Summary08786: Errors in updatedb_helper.php
Description

When upgrading from 2.00+ build 130929 to 2.05+ build 140226 some database errors are reported (by MS-SQL in our case). Script: updatedb_helper.php.
Line # 1134 : "Yii::app()->getDb()->createCommand()->dropColumn('{{surveys}}', 'allowjumps');" should be replaced by:
"dropColumn('{{surveys}}','allowjumps');"

Line # 1176 : "$oDB->createCommand()->dropIndex('permissions_idx2','{{permissions}}');" should read:
"$oDB->createCommand()->dropIndex('idxPermissions','{{permissions}}');"
Upgrade runs fine after changes.

Steps To Reproduce

Upgrade 2.00+ to 2.05+ (see above)

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)2.05+ 140226
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

fvanderstarre

Activities

c_schmitz

c_schmitz

2014-03-02 11:38

administrator   ~29039

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=13956

c_schmitz

c_schmitz

2014-03-02 11:38

administrator   ~29040

Thank you very much!

c_schmitz

c_schmitz

2014-03-02 12:29

administrator   ~29041

2.0+ Build 140302 released.

Related Changesets

LimeSurvey: master 1f13bdf9

2014-03-02 10:38:05

c_schmitz

Details Diff
Fixed issue 08786: Errors when updating from 2.0 and using MSSQL Affected Issues
08786
mod - application/helpers/update/updatedb_helper.php Diff File

Issue History

Date Modified Username Field Change
2014-02-28 15:28 fvanderstarre New Issue
2014-02-28 15:28 fvanderstarre Issue Monitored: fvanderstarre
2014-02-28 15:38 c_schmitz Assigned To => c_schmitz
2014-02-28 15:38 c_schmitz Status new => assigned
2014-03-02 11:38 c_schmitz Changeset attached => LimeSurvey master 1f13bdf9
2014-03-02 11:38 c_schmitz Note Added: 29039
2014-03-02 11:38 c_schmitz Resolution open => fixed
2014-03-02 11:38 c_schmitz Status assigned => resolved
2014-03-02 11:38 c_schmitz Fixed in Version => 2.05+
2014-03-02 11:38 c_schmitz Note Added: 29040
2014-03-02 12:29 c_schmitz Note Added: 29041
2014-03-02 12:29 c_schmitz Status resolved => closed
2021-08-11 11:41 guest Bug heat 2 => 4