View Issue Details

IDProjectCategoryView StatusLast Update
13241Bug reportsInstallationpublic2018-01-30 14:31
ReporterDanielB Assigned Toc_schmitz  
Status closedResolutionfixed 
Product Version3.0.x 
Fixed in Version3.1.x 
Summary13241: When upgrading from 2.67.3+170728 to 3.0.5+180118 an error occured

Tried upgrading to 3.0.5 following these instructions:

When trying to navigate to https://sd.domain.tld/admin after confirming the update of the database, I receive the following error:

Ein Fehler trat während des Datenbankupdates auf. Fehlerinformation:

CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[23000]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Die CREATE UNIQUE INDEX-Anweisung wurde beendet, weil ein doppelter Schlüssel für den Objektnamen 'dbo.lime_surveymenu' und den Indexnamen 'lime_surveymenu_name' gefunden wurde. Der doppelte Schlüsselwert ist (<NULL>).

Datei D:\limesurvey\application\helpers\update\updatedb_helper.php, line 699.

Steps To Reproduce

Download said Limesurvey-version, follow instructions from here

TagsNo tags attached.
Complete LimeSurvey version number (& build)3.0.5+180118
I will donate to the project if issue is resolvedNo
BrowserFirefox 58.0
Database & DB-VersionMicrosoft SQL Server Standard (64-bit) Version 12.0.5557.0 (SQL Server 2014 SP2 CU8)
Server OS (if known)Windows Server 2012 R2
Webserver software & version (if known)Apache 2.4.25 (32 Bit)
PHP VersionPHP 5.6.30




2018-01-24 16:07

administrator   ~46018

Please first update to the latest version 2.73.0 and then to 3.0.
There will be issued with older versions.



2018-01-24 16:11

administrator   ~46019

Fix committed to master branch:;id=26222

Related Changesets

LimeSurvey: master 3765c451

2018-01-24 16:11:50


Details Diff
Fixed issue 13241: Error when upgrading from 2.x and using MSSQL Affected Issues
mod - application/helpers/update/updatedb_helper.php Diff File
mod - installer/create-database.php Diff File

Issue History

Date Modified Username Field Change
2018-01-24 15:09 DanielB New Issue
2018-01-24 16:07 markusfluer Assigned To => markusfluer
2018-01-24 16:07 markusfluer Status new => closed
2018-01-24 16:07 markusfluer Resolution open => won't fix
2018-01-24 16:07 markusfluer Note Added: 46018
2018-01-24 16:11 c_schmitz Changeset attached => LimeSurvey master 3765c451
2018-01-24 16:11 c_schmitz Note Added: 46019
2018-01-24 16:11 c_schmitz Assigned To markusfluer => c_schmitz
2018-01-24 16:11 c_schmitz Resolution won't fix => fixed
2018-01-24 16:13 c_schmitz Status closed => resolved
2018-01-24 16:13 c_schmitz Fixed in Version => 3.0.x
2018-01-30 14:31 ollehar Status resolved => closed
2018-01-30 14:31 ollehar Fixed in Version 3.0.x => 3.1.x