View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 12
IDProjectCategoryView StatusDate SubmittedLast Update
05628Bug reportsStatisticspublic2011-12-15 22:042012-03-14 21:08
Reporterpitou31 Assigned Toc_schmitz  
PriorityhighSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.91+ 
Fixed in Version1.91+ 
Summary05628: After having filter on fast satistic we cannot any more search on statistic
Description

If we filter on some field (like first name for example)we cannot any more use the statistic.
The sql search instructions are no more valid, we have the following error:
Couldn't get results
SELECT count(*) FROM lime_survey_81627 WHERE 627X2X2SQ002LIKE 'Michel') You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' LIKE 'Michel')' at line 1
It seems that the application keep the previous sql instructions and doesn't generate again the right search according to the new statistic demand.

Steps To Reproduce
  1. Make a statistic response without filtering, it works,
  2. Make a statistic response using filtering, it works,
  3. Make a statistic response without filtering, it fail, it seems that the system generate a wrong SQL instruction.
TagsNo tags attached.
Attached Files
limesurvey_survey_81627.lss (64,802 bytes)
Bug heat12
Complete LimeSurvey version number (& build)11524
I will donate to the project if issue is resolvedNo
BrowserMozilla Firegox
Database type & versionMySql 5.5.8
Server OS (if known)Windows 7
Webserver software & version (if known)Wamp server in local
PHP VersionPHP 5.3.5

Users monitoring this issue

There are no users monitoring this issue.

Activities

pitou31

pitou31

2011-12-30 10:22

reporter   ~16767

In order to help I have just attached the survey document (it is in French I hope it won't be a problem for understanding).
c_schmitz

c_schmitz

2012-01-22 18:36

administrator   ~16899

Good catch, thank you.
pitou31

pitou31

2012-01-22 21:49

reporter   ~16900

Thank you very much. I will test it on the new version 1.91+
pitou31

pitou31

2012-01-22 22:34

reporter   ~16901

I just test it but it still doesn't work.
Sorry.
c_schmitz

c_schmitz

2012-01-24 21:20

administrator   ~16955

New 1.91+ version released.

Related Changesets

LimeSurvey: Yii feb08943

2012-01-22 09:33:52

c_schmitz

Details Diff 		Fixed issue 05628: SQL error after setting a filter in statistics and removing it again
Some minor fixes

git-svn-id: file:///Users/Shitiz/Downloads/lssvn/source/limesurvey_yii@12157 b72ed6b6-b9f8-46b5-92b4-906544132732		 Affected Issues
05628
mod - application/controllers/AdminController.php Diff File
mod - application/controllers/admin/questiongroup.php Diff File
mod - application/controllers/admin/quotas.php Diff File
mod - application/helpers/admin/statistics_helper.php Diff File
mod - application/helpers/database_helper.php Diff File
mod - application/helpers/frontend_helper.php Diff File
mod - application/views/admin/quotas/newquota_view.php Diff File
mod - application/views/admin/survey/QuestionGroups/addGroup_view.php Diff File
mod - application/views/admin/survey/subview/tabGeneralEditSurvey_view.php Diff File
mod - application/views/admin/survey/surveybar_view.php Diff File
mod - images/conditions.png Diff File
mod - images/expressionmanager_30.png Diff File

Issue History

Date Modified Username Field Change
2011-12-15 22:04 pitou31 New Issue
2011-12-29 19:23 c_schmitz Assigned To => c_schmitz
2011-12-29 19:23 c_schmitz Status new => assigned
2011-12-30 10:19 pitou31 File Added: limesurvey_survey_81627.lss
2011-12-30 10:22 pitou31 Note Added: 16767
2012-01-22 17:28 c_schmitz Status assigned => resolved
2012-01-22 17:28 c_schmitz Fixed in Version => 1.91+
2012-01-22 17:28 c_schmitz Resolution open => fixed
2012-01-22 18:36 c_schmitz Note Added: 16899
2012-01-22 21:49 pitou31 Note Added: 16900
2012-01-22 22:34 pitou31 Note Added: 16901
2012-01-24 21:20 c_schmitz Note Added: 16955
2012-01-24 21:20 c_schmitz Status resolved => closed
2012-03-14 21:08 c_schmitz Changeset attached => Import 2012-03-09 13:30:34 Yii feb08943