View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
04678Bug reportsOtherpublic2010-10-15 12:252010-10-20 10:10
Reporterludogre Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.90+ 
Summary04678: Can't view the result of a request
Description

Hi!

In the new version of lime survey, when you get statistics from responses, if you want to browse the result of a filter, you've got an error like: "Erreur de syntaxe pr?s de 'IN ('RA11') ORDER BY id LIMIT 0,50' ? la ligne 1:SELECT * FROM lime_survey_12785 12785X169X825 IN ('RA11') ORDER BY id"

The WHERE argument is missing in the SQL instruction.

Steps To Reproduce
  • Goto Statistic view
  • Make a filter and browse the results
TagsNo tags attached.
Attached Files
limesurvey_survey_39641.lss (27,749 bytes)
Bug heat4
Complete LimeSurvey version number (& build)9169
I will donate to the project if issue is resolved
BrowserIceweasel 3.5.13
Database type & versionMysql 5.0.32
Server OS (if known)Debian_7etch8-log
Webserver software & version (if known)Apache/2.2.9
PHP Version5.2.6-1

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2010-10-15 13:59

administrator   ~13201

Please attach a small sample survey to reproduce the issue.
ludogre

ludogre

2010-10-15 16:41

reporter   ~13204

I've just attached it. Thank's for your answer.
c_schmitz

c_schmitz

2010-10-15 17:29

administrator   ~13209

Ludogre, can you really reproduce the problem with the attached survey? Because I can't?

If yes, let me know what exact filter you are setting.
c_schmitz

c_schmitz

2010-10-20 01:34

administrator   ~13285

ludogre?
ludogre

ludogre

2010-10-20 10:00

reporter   ~13286

I've just migrate until 9229 build version.

No more problem of sql syntax now.

???
c_schmitz

c_schmitz

2010-10-20 10:10

administrator   ~13287

That'S great

Issue History

Date Modified Username Field Change
2010-10-15 12:25 ludogre New Issue
2010-10-15 13:59 c_schmitz Assigned To => c_schmitz
2010-10-15 13:59 c_schmitz Status new => assigned
2010-10-15 13:59 c_schmitz Note Added: 13201
2010-10-15 13:59 c_schmitz Status assigned => feedback
2010-10-15 16:41 ludogre File Added: limesurvey_survey_39641.lss
2010-10-15 16:41 ludogre Note Added: 13204
2010-10-15 16:41 ludogre Status feedback => assigned
2010-10-15 17:04 c_schmitz Status assigned => resolved
2010-10-15 17:04 c_schmitz Resolution open => fixed
2010-10-15 17:06 c_schmitz Status resolved => assigned
2010-10-15 17:29 c_schmitz Note Added: 13209
2010-10-15 17:29 c_schmitz Status assigned => feedback
2010-10-20 01:34 c_schmitz Note Added: 13285
2010-10-20 10:00 ludogre Note Added: 13286
2010-10-20 10:00 ludogre Status feedback => assigned
2010-10-20 10:10 c_schmitz Note Added: 13287
2010-10-20 10:10 c_schmitz Status assigned => closed
2010-10-25 00:21 c_schmitz Category Data Access => (No Category)