Relationship Graph

Relationship Graph
related to related to child of child of duplicate of duplicate of

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 

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