View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 12
IDProjectCategoryView StatusDate SubmittedLast Update
06000Bug reportsResponse browsingpublic2012-04-10 18:512012-04-10 20:38
Reporteruser19287Assigned Toc_schmitz  
PriorityhighSeveritypartial_block 
Status closedResolutionduplicate 
Product Version1.92+ 
Summary06000: A SQL Error is thrown when attempting to browse individual responses
Description

A SQL Error is thrown when attempting to browse individual responses from the token management page.

Steps To Reproduce
  1. Receive survey response(s)
  2. Navigate to token management page
  3. Click "View/Update last response" action icon
TagsNo tags attached.
Bug heat12
Complete LimeSurvey version number (& build)1.92
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMySQL
Server OS (if known)Linux
Webserver software & version (if known)Apache 2.2.15
PHP Version5.3.3

Relationships

Relationship GraphDependency Graph
has duplicate 05962 closedc_schmitz View Response Details does not work correctly if responses are filtered (Statistics) 

Users monitoring this issue

There are no users monitoring this issue.

Activities

user19287

2012-04-10 18:55

  ~18307

This can be fixed by adding a space at the end of the SQL string on line 190 of browse.php:
before: $idquery = "SELECT FROM {$surveytable} s";
after: $idquery = "SELECT FROM {$surveytable} s ";
TMSWhite

TMSWhite

2012-04-10 19:13

reporter   ~18308

Thanks, but this has already been fixed. The next 1.92+ release will contain the fix.

Issue History

Date Modified Username Field Change
2012-04-10 18:51 user19287 New Issue
2012-04-10 18:55 user19287 Note Added: 18307
2012-04-10 19:13 TMSWhite Note Added: 18308
2012-04-10 19:13 TMSWhite Relationship added has duplicate 05962
2012-04-10 20:38 c_schmitz Status new => closed
2012-04-10 20:38 c_schmitz Assigned To => c_schmitz
2012-04-10 20:38 c_schmitz Resolution open => duplicate