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+ |