View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
06377Bug reportsSurvey takingpublic2012-07-23 19:582014-03-19 09:18
Reporterlolo Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.00RC7 
Fixed in Version2.00RC8 
Summary06377: Integer values corrupted in survey answers
Description

When designing a survey with numerical values (integers), integer values are not correctly saved. They seem to be truncated due to wrong data type used in database (float column data type).

The float datatype is not suitable to store integer values, since the float datatype is of limited precision.

Steps To Reproduce

step 1: create survey

  • Click "+" icon to add survey
  • enter title "My survey"
  • click "Save"
  • Click "+" icon to add question group
  • Title: enter "group 1"
  • click "Save question group"
  • click "+" icon to add question
  • enter: Code->"FORTUNE", Question->"Bank account balance?", "Question type"->"Numerical Input"
  • click "Show advanced settings"
  • in "Input" box, enter: "Integer Only" -> Yes, "Maximum characters" -> 10
  • click "Add question"

step 2: activate survey

  • select "Activate survey" icon
  • click "Save / activate survey", then "No, thanks" (no tokens)

step 3: take survey

  • go to survey (public URL)
  • enter "123456789"
  • submit survey

step 4: check survey answers

  • go back to admin screen
  • select survey
  • select "Responses" -> "Responses and statistics"
  • select "Display responses" icon (white sheet)
  • check value of "Bank account balance" : value is 123457000 instead of 123456789
TagsNo tags attached.
Attached Files
limesurvey_survey_489511.lss (12,288 bytes)
Bug heat4
Complete LimeSurvey version number (& build)120721
I will donate to the project if issue is resolvedNo
BrowserMozilla 13.0.1 (Mac)
Database type & versionMysql 5.5.24
Server OS (if known)Linux 2.6.27.52
Webserver software & version (if known)Apache 2
PHP Version5.3.14

Relationships

Relationship GraphDependency Graph
related to 08814 closedc_schmitz Multiple numeric input limit 

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-07-23 21:34

administrator   ~19940

Can you attach the survey as .lss file, please?
lolo

lolo

2012-07-23 22:28

reporter   ~19941

Update: Survey has been uploaded. Thanks.
c_schmitz

c_schmitz

2012-07-24 13:06

administrator   ~19945

Fix committed to Yii branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9111
c_schmitz

c_schmitz

2012-07-24 13:07

administrator   ~19946

Thank you!
c_schmitz

c_schmitz

2012-08-03 13:44

administrator   ~20145

2.00RC8 released

Related Changesets

LimeSurvey: Yii b1947782

2012-07-24 04:07:08

c_schmitz

Details Diff 		Fixed issue 06377: Large integer values corrupted in survey responses Affected Issues
06377
mod - application/helpers/admin/activate_helper.php Diff File
mod - application/views/admin/survey/Question/questionbar_view.php Diff File

Issue History

Date Modified Username Field Change
2012-07-23 19:58 lolo New Issue
2012-07-23 21:08 c_schmitz Assigned To => c_schmitz
2012-07-23 21:08 c_schmitz Status new => assigned
2012-07-23 21:34 c_schmitz Note Added: 19940
2012-07-23 21:34 c_schmitz Status assigned => feedback
2012-07-23 22:28 lolo File Added: limesurvey_survey_489511.lss
2012-07-23 22:28 lolo Note Added: 19941
2012-07-23 22:28 lolo Status feedback => assigned
2012-07-24 13:06 c_schmitz Changeset attached => LimeSurvey Yii b1947782
2012-07-24 13:06 c_schmitz Note Added: 19945
2012-07-24 13:06 c_schmitz Resolution open => fixed
2012-07-24 13:07 c_schmitz Note Added: 19946
2012-07-24 13:07 c_schmitz Status assigned => resolved
2012-07-24 13:07 c_schmitz Fixed in Version => 2.00+
2012-08-03 13:44 c_schmitz Fixed in Version 2.00+ => 2.00RC8
2012-08-03 13:44 c_schmitz Note Added: 20145
2012-08-03 13:44 c_schmitz Status resolved => closed
2014-03-19 09:18 c_schmitz Relationship added related to 08814