View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
05237Bug reportsStatisticspublic2011-06-03 16:262011-06-06 17:26
Reporteruser14164Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionduplicate 
Product Version1.91 
Fixed in Version1.91+ 
Summary05237: Bad MYSQL format request : When browsing statistics, request filter statistic browsing of responses fail
Description

Hello,

One more bug I discover since I upgrade to 1.91 10120.

I was browsing responses to a survey when I decide to browse the statistics filtered by answers to a simple checkbox question :

Question .... : 1 / 2 / 3 / 4

In statistics I ask all stats and select the first two items : 1 and 2

I then get the new stats and all is right, but if I ask to display responses that match with my previous request by clicking browse button under first field of statistics displaying the number of results, LS seem to generate a bad format sql request for mysql as I get this output error :

"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 'IN ('A1', 'A2') ORDER BY limesurvey_survey_19425.id LIMIT 0,50' at line 1:SELECT * FROM limesurvey_survey_19425 19425X1X6 IN ('A1', 'A2') ORDER BY limesurvey_survey_19425.id"

Steps To Reproduce

1 Create a survey with multiple questions of different type
2 Enter some responses
3 Request statistics for all questions but for limited responses to one of the questions (eg : choosee from 1 to 4 and request statistics for 1 and 2 only)
4 When you get the screen that display statistics of your request, try to browse the responses matching your request by clicking browse under the first field that display the number of selected responses.

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)10120
I will donate to the project if issue is resolvedNo
BrowserAll
Database type & versionmysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (x86_64) using readline 5.1
Server OS (if known)CentOS release 5.6 (Final)
Webserver software & version (if known)Apache/2.2.3
PHP VersionPHP 5.2.10

Relationships

Relationship GraphDependency Graph
duplicate of 05238 closedc_schmitz Statistics Filters 

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2011-06-05 22:34

administrator   ~15306

Can you attach a small (1-2 questions) sample survey to reproduce the issue?
Thank you!

Issue History

Date Modified Username Field Change
2011-06-03 16:26 user14164 New Issue
2011-06-05 22:34 c_schmitz Note Added: 15306
2011-06-05 22:34 c_schmitz Assigned To => c_schmitz
2011-06-05 22:34 c_schmitz Status new => feedback
2011-06-06 17:26 c_schmitz Relationship added duplicate of 05238
2011-06-06 17:26 c_schmitz Status feedback => resolved
2011-06-06 17:26 c_schmitz Fixed in Version => 1.91+
2011-06-06 17:26 c_schmitz Resolution open => duplicate
2011-06-06 17:26 c_schmitz Status resolved => closed