View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
05993Bug reportsSurvey takingpublic2012-04-08 08:552012-04-12 00:42
ReporterTmac Assigned ToTMSWhite  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version1.92+ 
Fixed in Version1.92+ 
Summary05993: When survey is submitted, the link in the confirmation email no longer works. Causes SQL error
Description

After submitting a new survey, the administrator receives an email noting the fact that a survey has been completed. The email contains the following link to be able to view the submission:
http://yoursite.com/survey/admin/admin.php?action=browse&sid=29792&subaction=id&id=5956
If you click on the link the following SQL error occurs
Unknown column 's.id' in 'where clause':SELECT * FROM lime_survey_29792 sLEFT JOIN lime_tokens_29792 t ON s.token = t.token WHERE s.id = 5956
It looks like a space is missing from "sLEFT" - should be "s LEFT"

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)120405
I will donate to the project if issue is resolvedNo
BrowserChrome
Database type & versionMySQL
Server OS (if known)Linux
Webserver software & version (if known)Apache
PHP VersionPHP Version 5.3.3-7+squeeze8

Relationships

Relationship GraphDependency Graph
related to 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

TMSWhite

TMSWhite

2012-04-08 11:23

reporter   ~18276

Please try this with latest GitHub code. Should have been fixed with latest patch for this bug - http://bugs.limesurvey.org/view.php?id=5962
Tmac

Tmac

2012-04-08 11:34

reporter   ~18277

Yup, the patch to browse.php has fixed this
c_schmitz

c_schmitz

2012-04-08 12:59

administrator   ~18279

Thank you, Thomas!
c_schmitz

c_schmitz

2012-04-12 00:42

administrator   ~18327

New 1.91+ version released.

Issue History

Date Modified Username Field Change
2012-04-08 08:55 Tmac New Issue
2012-04-08 11:23 TMSWhite Note Added: 18276
2012-04-08 11:24 TMSWhite Relationship added related to 05962
2012-04-08 11:34 Tmac Note Added: 18277
2012-04-08 12:59 c_schmitz Note Added: 18279
2012-04-08 12:59 c_schmitz Status new => resolved
2012-04-08 12:59 c_schmitz Fixed in Version => 1.92+
2012-04-08 12:59 c_schmitz Resolution open => fixed
2012-04-08 12:59 c_schmitz Assigned To => TMSWhite
2012-04-12 00:42 c_schmitz Note Added: 18327
2012-04-12 00:42 c_schmitz Status resolved => closed