View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
06735Bug reportsStatisticspublic2012-10-18 20:502012-10-19 16:21
Reporterklaster Assigned ToDenisChenu  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary06735: Median time statistics incorrect
Description

Median survey statistics time calculated incrorrectly - already deleted answers are included in calculation.

Steps To Reproduce

Create & activate survey, fill in 2 responses, delete one response so you have only one response in the responses table.

Average interview time is calculated correctly (it is equal to the value of the one response you have), median is calculated incorrectly - it includes the value of the deleted response.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)121017
I will donate to the project if issue is resolvedNo
Browser
Database type & versionmysql 5.5.25-cll
Server OS (if known)centos 6.3
Webserver software & version (if known) Apache/2.2.22 (Unix)
PHP Version5.3.16

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2012-10-19 10:53

developer   ~21447

Median calculation is good, but remove a response line doesn't remove timings ...
DenisChenu

DenisChenu

2012-10-19 14:06

developer   ~21459

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

DenisChenu

2012-10-19 14:17

developer   ~21460

Hello,

Can you verify if it's work. New relations do the job (allways have an responses to calculate).
BUT, the line stay in DB.
c_schmitz

c_schmitz

2012-10-19 16:21

administrator   ~21480

New version 2.00+ Build 121019 released. Please update.

Related Changesets

LimeSurvey: master f3489266

2012-10-19 06:56

DenisChenu


Details Diff		 Fixed issue 06735: remove a response line doesn't remove timings
Fixed issue : Download files in zip in browse response broken
Dev: Add a function in responses to delete files
Dev: correct the primaryKey for Survey_dynamics and add one for Survey_timings to use deleteByPk
DEV: todo create a new Survey_dynamic to do all the job (delete responses line, delete files, delete timing lines)		 Affected Issues
06735
mod - application/controllers/admin/responses.php Diff File
mod - application/models/Survey_dynamic.php Diff File
mod - application/models/Survey_timings.php Diff File

Issue History

Date Modified Username Field Change
2012-10-18 20:50 klaster New Issue
2012-10-19 10:53 DenisChenu Note Added: 21447
2012-10-19 10:53 DenisChenu Assigned To => DenisChenu
2012-10-19 10:53 DenisChenu Status new => assigned
2012-10-19 14:06 DenisChenu Changeset attached => LimeSurvey master f3489266
2012-10-19 14:06 DenisChenu Note Added: 21459
2012-10-19 14:06 DenisChenu Resolution open => fixed
2012-10-19 14:17 DenisChenu Note Added: 21460
2012-10-19 14:18 DenisChenu Status assigned => resolved
2012-10-19 14:18 DenisChenu Fixed in Version => 2.00+
2012-10-19 16:21 c_schmitz Note Added: 21480
2012-10-19 16:21 c_schmitz Status resolved => closed