View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
07137Bug reportsInstallationpublic2013-01-08 22:32
Reportermapoitras Assigned Toc_schmitz  
PriorityhighSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary07137: Problem upgrading from 1.92 to 2+ for SQL Server.
Description

When attempting to upgrade, I get the error:

An non-recoverable error happened during the update. Error details: CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 10.0][SQL Server]The index 'questions_idx4' is dependent on column 'type'.

I believe a fix for this would be to add the following after

if ($oldversion < 145)
{

add line

// MySQL DB corrections
try{ Yii::app()->db->createCommand()->dropIndex('questions_idx4','{{questions}}');} catch(Exception $e) {};

I got the fix idea from looking at what was done in <157 when this fix was applied.

Steps To Reproduce

We were are version 1.92 and database version 142
Use SQL server 2005 backend.
Using iis
Make backups of everything
delete all previous Limesurvey files under the root folder
install new files
copy templates and upload folder
go to limesurvey/admin and follow instructions
Before database upgrade it says "Please verify the following information before continuing with the database upgrade:

Database type: sqlsrv
Database name:
Table prefix: lime_
Site name: CMHC Surveys SCHL
Root URL: /limesurvey/index.php?r=admin/update

Click here to continue

When I click continue I get the error.

Additional Information

After making the change. I get a new error:

CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot find the object "lime_participant_attribute" because it does not exist or you do not have permissions.

Please fix this error in your database and try again

I believe this is another but later in the db upgrade process. Looking into it.

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)130103
I will donate to the project if issue is resolvedNo
BrowserExplorer
Database type & versionSQL server 2005
Server OS (if known)windows server 2003
Webserver software & version (if known)iis 6
PHP Version5.3.19

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2013-01-05 17:33

administrator   ~23477

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

c_schmitz

c_schmitz

2013-01-05 18:24

administrator   ~23489

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

c_schmitz

c_schmitz

2013-01-08 22:32

administrator   ~23558

2.00+ Build 130108 released.

Related Changesets

LimeSurvey: master a35322de

2013-01-05 16:17:20

c_schmitz

Details Diff
Fixed issue 07137: Problem upgrading from 1.92 to 2.00+ using SQL Server Affected Issues
07137
mod - application/helpers/update/updatedb_helper.php Diff File

LimeSurvey: 2.1 50a37e1c

2013-01-05 16:17:20

c_schmitz

Details Diff
Fixed issue 07137: Problem upgrading from 1.92 to 2.00+ using SQL Server Affected Issues
07137
mod - application/helpers/update/updatedb_helper.php Diff File

Issue History

Date Modified Username Field Change
2013-01-03 21:31 mapoitras New Issue
2013-01-05 17:16 c_schmitz Status new => resolved
2013-01-05 17:16 c_schmitz Fixed in Version => 2.00+
2013-01-05 17:16 c_schmitz Resolution open => fixed
2013-01-05 17:16 c_schmitz Assigned To => c_schmitz
2013-01-05 17:33 c_schmitz Changeset attached => LimeSurvey master a35322de
2013-01-05 17:33 c_schmitz Note Added: 23477
2013-01-05 18:24 c_schmitz Changeset attached => LimeSurvey 2.1 50a37e1c
2013-01-05 18:24 c_schmitz Note Added: 23489
2013-01-08 22:32 c_schmitz Note Added: 23558
2013-01-08 22:32 c_schmitz Status resolved => closed