View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
13122 | Bug reports | Installation | public | 2018-01-04 14:29 | 2018-01-08 11:41 |
Reporter | fifisteph | Assigned To | |||
Priority | none | Severity | crash | ||
Status | closed | Resolution | duplicate | ||
Product Version | 3.0.0-rc.x | ||||
Fixed in Version | 3.0.x | ||||
Summary | 13122: 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() | ||||
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. | ||||
Tags | No tags attached. | ||||
Bug heat | 2 | ||||
Complete LimeSurvey version number (& build) | 3.0.1+171228 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | |||||
Database type & version | MSSQL 2016 | ||||
Server OS (if known) | Windows 2012R2 | ||||
Webserver software & version (if known) | IIS 8.5 | ||||
PHP Version | 7.1 | ||||
duplicate of | 13106 | closed | SQL error when installing 3.0.1 |
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 |
|
Relationship added | related to 13106 |
2018-01-08 11:40 |
|
Relationship replaced | duplicate of 13106 |
2018-01-08 11:41 |
|
Assigned To | => markusfluer |
2018-01-08 11:41 |
|
Status | new => closed |
2018-01-08 11:41 |
|
Resolution | open => duplicate |
2018-01-08 11:41 |
|
Fixed in Version | => 3.0.x |