View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
13170Bug reportsSurvey editingpublic2018-01-12 15:24
Reporterfvanderstarre Assigned Toollehar  
PrioritynoneSeveritypartial_block 
Status closedResolutionno change required 
Summary13170: 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)].
Insert statement as traced by SQL Server profiler:
INSERT INTO [dbo].[answers] ([qid], [code], [answer], [language], [sortorder], [scale_id]) VALUES (49, 'A1', '', 'nl', 0, 0)
No value specified for assessment_value, which is defined as NOT NULL in the database.

Steps To Reproduce

See above

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)3.0.2+180110
I will donate to the project if issue is resolvedNo
BrowserAny
Database type & versionMS-SQL 2008 R2
Server OS (if known)Linux RHEL 7
Webserver software & version (if known)Apache 2.4.6
PHP Version5.6.33

Relationships

duplicate of 13163 closedollehar cant add answer options to "single choice Questions" 

Users monitoring this issue

There are no users monitoring this issue.

Activities

ollehar

ollehar

2018-01-12 15:24

administrator   ~45589

Already fixed/duplicate.

Issue History

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