View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 13170 | Bug reports | Survey editing | public | 2018-01-12 14:29 | 2018-01-12 15:24 |
| Reporter | fvanderstarre | Assigned To | ollehar | ||
| Priority | none | Severity | partial_block | ||
| Status | closed | Resolution | no change required | ||
| Summary | 13170: Database error when attempting to enter answer option for radio question (mssql) | ||||
| Description | After creating a new survey and question group and question of type "radio button", I tried to enter the first answer option but got a database error: General error: 20018 Cannot insert the value NULL into column 'assessment_value', table 'LimeSurvey_temp.dbo.answers'; column does not allow nulls. INSERT fails. [20018] (severity 16) [(null)]. | ||||
| Steps To Reproduce | See above | ||||
| Tags | No tags attached. | ||||
| Bug heat | 2 | ||||
| Complete LimeSurvey version number (& build) | 3.0.2+180110 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Any | ||||
| Database type & version | MS-SQL 2008 R2 | ||||
| Server OS (if known) | Linux RHEL 7 | ||||
| Webserver software & version (if known) | Apache 2.4.6 | ||||
| PHP Version | 5.6.33 | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-01-12 14:29 | fvanderstarre | New Issue | |
| 2018-01-12 15:24 | ollehar | Assigned To | => ollehar |
| 2018-01-12 15:24 | ollehar | Status | new => closed |
| 2018-01-12 15:24 | ollehar | Resolution | open => no change required |
| 2018-01-12 15:24 | ollehar | Fixed in Version | => 3.0.3 |
| 2018-01-12 15:24 | ollehar | Note Added: 45589 | |
| 2018-01-12 15:24 | ollehar | Relationship added | duplicate of 13163 |
| 2019-11-01 17:25 | c_schmitz | Category | Survey design => Survey editing |