View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
13122Bug reportsInstallationpublic2018-01-08 11:41
Reporterfifisteph Assigned Tomarkusfluer 
PrioritynoneSeveritycrash 
Status closedResolutionduplicate 
Product Version3.0.0-rc.x 
Fixed in Version3.0.x 
Summary13122: Can't populate database (MSSQL)
Description

Trying to install LS 3.0.1 on IIS + MSSQL 2016. All required drivers/libs installed. Setup is ok until the "populate database". Seems like a PK constraint cannot be applied on a column (NULL). This is the error I get at this step in IE webpage :

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Cannot define PRIMARY KEY constraint on nullable column in table 'lime_groups'. #0 C:\inetpub\wwwroot\limesurvey\framework\db\CDbCommand.php(1352): CDbCommand->execute()
#1 C:\inetpub\wwwroot\limesurvey\installer\create-database.php(125): CDbCommand->createTable('{{groups}}', Array)
#2 C:\inetpub\wwwroot\limesurvey\application\controllers\InstallerController.php(904): createDatabase(Object(DbConnection))
#3 C:\inetpub\wwwroot\limesurvey\application\controllers\InstallerController.php(519): InstallerController->_setup_tables('C:\inetpub\wwwr...')
#4 C:\inetpub\wwwroot\limesurvey\application\controllers\InstallerController.php(82): InstallerController->stepPopulateDb()
#5 C:\inetpub\wwwroot\limesurvey\framework\web\CWebApplication.php(282): InstallerController->run('populatedb')
#6 C:\inetpub\wwwroot\limesurvey\framework\web\CWebApplication.php(141): CWebApplication->runController('installer/popul...')
#7 C:\inetpub\wwwroot\limesurvey\framework\base\CApplication.php(185): CWebApplication->processRequest()
#8 C:\inetpub\wwwroot\limesurvey\index.php(195): CApplication->run()
#9 {main}

Steps To Reproduce

Install LS 3.0.1 on IIS, create DB limesurvey + user on MSSQL server. After all the pre requisites installed (drivers/lib/odbc), go through the setup process until the database has to be populated.

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)3.0.1+171228
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMSSQL 2016
Server OS (if known)Windows 2012R2
Webserver software & version (if known)IIS 8.5
PHP Version7.1

Relationships

duplicate of 13106 closedmarkusfluer SQL error when installing 3.0.1 

Users monitoring this issue

There are no users monitoring this issue.

Activities

fvanderstarre

fvanderstarre

2018-01-05 10:37

reporter   ~45423

Same issue as 13106

Issue History

Date Modified Username Field Change
2018-01-04 14:29 fifisteph New Issue
2018-01-05 10:37 fvanderstarre Note Added: 45423
2018-01-08 11:26 LouisGac Relationship added related to 13106
2018-01-08 11:40 markusfluer Relationship replaced duplicate of 13106
2018-01-08 11:41 markusfluer Assigned To => markusfluer
2018-01-08 11:41 markusfluer Status new => closed
2018-01-08 11:41 markusfluer Resolution open => duplicate
2018-01-08 11:41 markusfluer Fixed in Version => 3.0.x