13170: Database error when attempting to enter answer option for radio question (mssql)

This bug affects 1 person(s).

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)]. 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
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

ollehar 2018-01-12 15:24 administrator ~45589	Already fixed/duplicate.