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 |
|
Same issue as 13106 |
|
| 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 |