View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
06858Bug reportsSurvey takingpublic2012-11-12 16:462012-11-16 10:40
ReporterHolzhauer Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary06858: Large integer inputs get truncated
Description

Large numbers are truncated, e.g. "11289371823480213476" becomes "11289371823480000000.0000000000" although the MySQL data type DECIMAL(30,10) should cover those numbers exactly.

Steps To Reproduce
  1. Import attached survey
  2. Fill out questions (put in a large number for "Input an integer:") and submit
  3. Print answers or inspect your database
TagsNo tags attached.
Attached Files
IntegersTruncated.lss (16,910 bytes)
Bug heat4
Complete LimeSurvey version number (& build)121024
I will donate to the project if issue is resolvedNo
BrowserFirefox 15.0.1
Database type & versionMySQL 5.5.25
Server OS (if known)Windows 7
Webserver software & version (if known)XAMPP USB lite Version 1.8.0
PHP Version5.4.4

Users monitoring this issue

There are no users monitoring this issue.

Activities

Holzhauer

Holzhauer

2012-11-12 17:15

reporter   ~22090

I put in the wrong build number. The correct one is 121106
c_schmitz

c_schmitz

2012-11-13 21:19

administrator   ~22128

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

c_schmitz

2012-11-13 21:21

administrator   ~22129

The reason is that PHP cannot handle numbers that big.
I implemented a patch that if you have the GPM library (http://www.php.net/manual/en/book.gmp.php) installed it will be able to handle the number, otherwise the old handling will be used.
c_schmitz

c_schmitz

2012-11-15 20:41

administrator   ~22204

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

c_schmitz

2012-11-16 10:40

administrator   ~22248

New version 2.00+ Build 121116 released

Related Changesets

LimeSurvey: master 4b7c883d

2012-11-13 20:19:00

c_schmitz

Details Diff 		Fixed issue 06858: Large number inputs get truncated Affected Issues
06858
mod - application/helpers/sanitize_helper.php Diff File

LimeSurvey: 2.1 aa2a250c

2012-11-13 20:19:00

c_schmitz

Details Diff 		Fixed issue 06858: Large number inputs get truncated Affected Issues
06858
mod - application/helpers/sanitize_helper.php Diff File

Issue History

Date Modified Username Field Change
2012-11-12 16:46 Holzhauer New Issue
2012-11-12 16:46 Holzhauer File Added: IntegersTruncated.lss
2012-11-12 17:15 Holzhauer Note Added: 22090
2012-11-13 20:53 c_schmitz Assigned To => c_schmitz
2012-11-13 20:53 c_schmitz Status new => assigned
2012-11-13 21:19 c_schmitz Changeset attached => LimeSurvey master 4b7c883d
2012-11-13 21:19 c_schmitz Note Added: 22128
2012-11-13 21:19 c_schmitz Resolution open => fixed
2012-11-13 21:21 c_schmitz Note Added: 22129
2012-11-13 21:22 c_schmitz Status assigned => resolved
2012-11-13 21:22 c_schmitz Fixed in Version => 2.00+
2012-11-15 20:41 c_schmitz Changeset attached => LimeSurvey 2.1 aa2a250c
2012-11-15 20:41 c_schmitz Note Added: 22204
2012-11-16 10:40 c_schmitz Note Added: 22248
2012-11-16 10:40 c_schmitz Status resolved => closed