Relationship Graph View Issue Dependency Graph
related to child of duplicate of

View Issue Details

IDProjectCategoryView StatusLast Update
15684Bug reports[All Projects] Survey takingpublic2020-01-15 11:59
ReporterDenisChenu Assigned ToDenisChenu  
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Product Version3.21.3 
Target VersionFixed in Version3.21.3 
Summary15684: When reloading decimal value with 0 with MSSQL : 0 disappear
Description

When relmoading (from DB) with 0 as integer value : it brke when doing survey :
0 : .0000000000
0.1 : .1000000000

Maybe due to specific mssql config.

Reload by DB can be done with token + token answer persistance

Steps To Reproduce

Find a mssql server with IIS
Import include survey
Luabch the 1st token

Additional Information

Global fic for decimal in qanda seems the best solution

There are issue to in browse response and export : but less important.

TagsNo tags attached.
Complete LimeSurvey version number (& build)3.21.1
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database & DB-Versionsqlsrv SQLserver 12
Server OS (if known)windowserver 2016
Webserver software & version (if known)IIS
PHP Versionphp7.2

Activities

DenisChenu

DenisChenu

2019-12-20 16:50

developer  

survey_archive_0onMssql.lsa (4,637 bytes)
survey_archive_0onMssqlExportedMSSQL.lsa (4,468 bytes)
DenisChenu

DenisChenu

2019-12-20 16:51

developer   ~55107

survey_archive_0onMssql.lsa is the exporeted data via mariadb
survey_archive_0onMssqlExportedMSSQL.lsa is from MSSQL server : show clealy data is saved as .XXX if start by 0

DenisChenu

DenisChenu

2019-12-20 17:43

developer   ~55108

https://github.com/LimeSurvey/LimeSurvey/pull/1354

DenisChenu

DenisChenu

2020-01-08 14:45

developer   ~55154

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

DenisChenu

DenisChenu

2020-01-09 11:54

developer   ~55168

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

lime_release_bot

lime_release_bot

2020-01-15 11:59

administrator   ~55272

Fixed in Release 3.21.5+200115

Related Changesets

LimeSurvey: master 2eb78e6c

2020-01-08 14:45:51

DenisChenu


Committer: ollehar Details Diff
[WIP] Dev: Issue with MSSQL and 0 or 0.1 or 0.001 (#1354)

Fixed issue 15684: MSSQL issue reloading decimal value
Fixed issue 15685: Issue when exporting decimal value in MSSQL
Affected Issues
15684, 15685
mod - application/controllers/admin/dataentry.php Diff File
mod - application/helpers/admin/export/SurveyObj.php Diff File
mod - application/helpers/common_helper.php Diff File
mod - application/helpers/expressions/em_core_helper.php Diff File
mod - application/helpers/qanda_helper.php Diff File
mod - application/models/SurveyDynamic.php Diff File

LimeSurvey: master a4e89005

2020-01-09 11:53:57

DenisChenu


Committer: ollehar Details Diff
Fixed issue 15684: When reloading decimal value with 0 with MSSQL : 0 disappear (#1360)

Fixed issue 15685: Issue when exporting decimal value in MSSQL
Affected Issues
15684, 15685
mod - application/controllers/admin/dataentry.php Diff File
mod - application/helpers/admin/export/SurveyObj.php Diff File
mod - application/helpers/common_helper.php Diff File
mod - application/helpers/qanda_helper.php Diff File

Issue History

Date Modified Username Field Change
2019-12-20 16:50 DenisChenu New Issue
2019-12-20 16:50 DenisChenu Status new => assigned
2019-12-20 16:50 DenisChenu Assigned To => DenisChenu
2019-12-20 16:50 DenisChenu File Added: Capture d’écran du 2019-12-20 16-45-15.png
2019-12-20 16:50 DenisChenu File Added: survey_archive_0onMssql.lsa
2019-12-20 16:50 DenisChenu File Added: survey_archive_0onMssqlExportedMSSQL.lsa
2019-12-20 16:50 DenisChenu File Added: Capture d’écran du 2019-12-20 16-49-58.png
2019-12-20 16:51 DenisChenu Note Added: 55107
2019-12-20 17:13 DenisChenu Relationship added related to 15685
2019-12-20 17:43 DenisChenu Note Added: 55108
2020-01-08 14:45 ollehar Changeset attached => LimeSurvey master 2eb78e6c
2020-01-08 14:45 DenisChenu Note Added: 55154
2020-01-08 14:45 DenisChenu Resolution open => fixed
2020-01-09 11:54 ollehar Changeset attached => LimeSurvey master a4e89005
2020-01-09 11:54 DenisChenu Note Added: 55168
2020-01-10 16:19 DenisChenu Status assigned => resolved
2020-01-10 16:19 DenisChenu Fixed in Version => 3.21.3
2020-01-15 11:59 lime_release_bot Note Added: 55272
2020-01-15 11:59 lime_release_bot Status resolved => closed