View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
09847 | Bug reports | Other | public | 2015-08-27 15:04 | 2015-12-08 17:19 |
Reporter | hhug | Assigned To | c_schmitz | ||
Priority | normal | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 2.06+ | ||||
Fixed in Version | 2.06+ | ||||
Summary | 09847: Non integer numerical input is saved as rounded integer to the database | ||||
Description | Real numerical input to a simple numerical question, with setting integer only = no, is written as rounded integer to the database: 1,49 is saved as 1; 3,79 is saved as 4 etc. | ||||
Steps To Reproduce | See attached lss-file. | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 6 | ||||
Complete LimeSurvey version number (& build) | 150825 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Firefox | ||||
Database type & version | MySQL Version 5.5.38-1 | ||||
Server OS (if known) | Linux | ||||
Webserver software & version (if known) | Apache | ||||
PHP Version | 5.3.29 | ||||
child of | 09852 | closed | DenisChenu | DB error when trying to activate survey (only PostgresQL) |
Bug in db It must be return $baseType.$param , no ? |
|
Yes, shnoulle did you fix that? |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=15814 |
|
Fixed for table creation, 3.0 need to be done. What for old table DB update ... ? |
|
@Carsten : give it to you to control if mssql need a fix too. I think yes but unsure. |
|
<s>Just for information : Yii::app()->db->schema->getColumnType("decimal not null"); goes to a memory error</s> <s>Same for Yii::app()->db->schema->getColumnType("string ");</s> I'm a silly idiot .... Call self and not parent .... |
|
Fix committed to develop branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=15856 |
|
@c_schmitz : i can't test with mssql ? Fixed with pg and my. I think same patch can be applied with msSQL but really unsure. |
|
Works fine for me with MSSQL |
|
LimeSurvey: master 334366c3 2015-08-28 09:07 Details Diff |
Fixed issue 09847: Non integer numerical input is saved as rounded integer to the database Dev: decimal(30,10) is found at DECIMAL for Yii, no params Dev: Same for PGsql Dev: @todo : test with MsSQL Dev: Survey table creation is broken since ? |
Affected Issues 09847 |
|
mod - application/core/db/MysqlSchema.php | Diff File | ||
mod - application/core/db/PgsqlSchema.php | Diff File | ||
LimeSurvey: master 77e5aec5 2015-08-28 09:30 Details Diff |
Dev: 334366c38c0bbc711bd8147e7b65264a1b7052cc Child Dev: potential issue with something like DECIMAL (30,10) not null |
Affected Issues 09847 |
|
mod - application/core/db/MysqlSchema.php | Diff File | ||
mod - application/core/db/PgsqlSchema.php | Diff File | ||
LimeSurvey: master 93f50c27 2015-08-29 14:59 Details Diff |
Fixed issue 09852: DB error when trying to activate survey (only PostgresQL) Dev: 334366c38c0bbc711bd8147e7b65264a1b7052cc child ( 09847 fix ) Dev: more test ... word can have space .. (here character varying (255)) |
Affected Issues 09847, 09852 |
|
mod - application/core/db/MysqlSchema.php | Diff File | ||
mod - application/core/db/PgsqlSchema.php | Diff File | ||
LimeSurvey: develop 3b16afca 2015-09-01 16:02 Details Diff |
Fixed issue 09847: Non integer numerical input is saved as rounded integer to the database Dev: decimal(30,10) is found at DECIMAL for Yii, no params Dev: Same for PGsql Dev: @todo : test with MsSQL Dev: fix childrens too Dev: @sammousa : please do some test ;) |
Affected Issues 09847 |
|
mod - application/core/db/PgsqlSchema.php | Diff File | ||
mod - application/core/db/SmartColumnTypeTrait.php | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2015-08-27 15:04 | hhug | New Issue | |
2015-08-27 15:04 | hhug | File Added: limesurvey_survey_186175.lss | |
2015-08-27 15:51 | DenisChenu | Assigned To | => DenisChenu |
2015-08-27 15:51 | DenisChenu | Status | new => confirmed |
2015-08-27 16:11 | DenisChenu | Note Added: 33022 | |
2015-08-27 16:11 | DenisChenu | Assigned To | DenisChenu => sammousa |
2015-08-27 16:11 | DenisChenu | Status | confirmed => assigned |
2015-08-27 16:14 | DenisChenu | Note Edited: 33022 | |
2015-08-27 16:14 | DenisChenu | Note Edited: 33022 | |
2015-08-28 09:04 | sammousa | Assigned To | sammousa => DenisChenu |
2015-08-28 09:04 | sammousa | Note Added: 33024 | |
2015-08-28 09:09 | DenisChenu | Changeset attached | => LimeSurvey master 334366c3 |
2015-08-28 09:09 | DenisChenu | Note Added: 33025 | |
2015-08-28 09:09 | DenisChenu | Resolution | open => fixed |
2015-08-28 09:32 | DenisChenu | Changeset attached | => LimeSurvey master 77e5aec5 |
2015-08-28 09:34 | DenisChenu | Note Added: 33026 | |
2015-08-29 09:40 | DenisChenu | Assigned To | DenisChenu => c_schmitz |
2015-08-29 09:41 | DenisChenu | Note Added: 33031 | |
2015-08-29 11:57 | DenisChenu | Relationship added | child of 09852 |
2015-08-29 14:24 | DenisChenu | Note Added: 33036 | |
2015-08-29 14:26 | DenisChenu | Note Edited: 33036 | |
2015-08-29 14:38 | DenisChenu | Note Edited: 33036 | |
2015-08-29 15:01 | DenisChenu | Changeset attached | => LimeSurvey master 93f50c27 |
2015-09-01 16:02 | DenisChenu | Changeset attached | => LimeSurvey develop 3b16afca |
2015-09-01 16:02 | DenisChenu | Note Added: 33056 | |
2015-09-01 16:02 | DenisChenu | Assigned To | c_schmitz => DenisChenu |
2015-09-03 18:07 | DenisChenu | Assigned To | DenisChenu => c_schmitz |
2015-09-03 18:08 | DenisChenu | Note Added: 33058 | |
2015-12-08 17:19 | c_schmitz | Note Added: 33765 | |
2015-12-08 17:19 | c_schmitz | Status | assigned => closed |
2015-12-08 17:19 | c_schmitz | Fixed in Version | => 2.06+ |