View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
09127Bug reportsSurvey editingpublic2014-07-03 16:32
ReporterDenisChenu Assigned ToDenisChenu  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.05+ 
Fixed in Version2.05+ 
Summary09127: Invalid quota broke quota view
Description

If you have an invalid question in quota : this broke the quota view.

Steps To Reproduce

Create a survey
Add a multi choice question with a subquestion named REMOVE
Create a quota on this subquestion
Remove this subquestion
Activate survey
Try to view quota page (count)

CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column '858275X1793X39194REMOVE' in 'where clause'. The SQL statement executed was: SELECT COUNT(*) FROM lime_survey_858275 t WHERE (858275X1793X39194REMOVE=:ycp2) AND (submitdate IS NOT NULL). Bound with :ycp2='Y'

Additional Information

Before 1.92 we have this for 'remove sible choice question'. Do a quick fix for 2.05 to allow viewing quota.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)140702
I will donate to the project if issue is resolvedNo
Browsernot relevant (FF30)
Database type & versionMysql 5
Server OS (if known)debian/linux
Webserver software & version (if known)apache
PHP VersionPHP Version 5.4.4

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2014-07-02 18:35

developer   ~30256

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

c_schmitz

c_schmitz

2014-07-03 16:32

administrator   ~30261

2.05+ Build 140703 released.

Related Changesets

LimeSurvey: master 0bbcb174

2014-07-02 16:34:45

DenisChenu

Details Diff
Fixed issue 09127: Invalid quota broke quota view
Fixed issue : Miscalculation of completed quota for Multi Question type
Dev: see :http://bugs.limesurvey.org/view.php?id=9066#c30080 for miscalculation
Dev: Todo : use getQuotaCompletedCount in checkQuota function
Dev: Todo remove quota members when removing a sub question, but allways need a fix for old survey
Affected Issues
09066, 09127
mod - application/helpers/common_helper.php Diff File

Issue History

Date Modified Username Field Change
2014-07-02 18:04 DenisChenu New Issue
2014-07-02 18:04 DenisChenu Status new => assigned
2014-07-02 18:04 DenisChenu Assigned To => DenisChenu
2014-07-02 18:35 DenisChenu Changeset attached => LimeSurvey master 0bbcb174
2014-07-02 18:35 DenisChenu Note Added: 30256
2014-07-02 18:35 DenisChenu Resolution open => fixed
2014-07-02 18:35 DenisChenu Status assigned => resolved
2014-07-02 18:35 DenisChenu Fixed in Version => 2.05+
2014-07-03 16:32 c_schmitz Note Added: 30261
2014-07-03 16:32 c_schmitz Status resolved => closed
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing