View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
05165Bug reportsImport/Exportpublic2011-05-12 10:332011-05-25 12:21
Reportersp00ky Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.91 
Fixed in Version1.91+ 
Summary05165: Export to excel exports no results but query
Description

While exporting to Excel file contains query structure instead of results:

eg.:SELECT lime_survey_38842.id, submitdate, lastpage, startlanguage, datestamp, startdate, ipaddr, 38842X297X3184 FROM lime_survey_38842 LEFT OUTER JOIN lime_tokens_38842 ON lime_survey_38842.token = lime_tokens_38842.token WHERE lime_survey_38842.submitdate is not null WHERE lime_survey_38842.submitdate is not null ORDER BY lime_survey_38842.id

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)10060
I will donate to the project if issue is resolvedNo
Browser
Database type & versionmysql 5.0
Server OS (if known)Windows 2003 Server
Webserver software & version (if known)Apache 2.2
PHP Versionphp 5.2

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2011-05-15 12:15

administrator   ~15006

I can't reproduce that. Can you please attach a small sample survvey and tell us which settings do you choose when exporting to Excel.
sp00ky

sp00ky

2011-05-16 09:09

reporter   ~15019

Try "Completed responses only" or "Inompleted responses only". For "All responses" everything is just fine.
c_schmitz

c_schmitz

2011-05-16 09:46

administrator   ~15021

Fixed in rev 10077
sp00ky

sp00ky

2011-05-16 09:48

reporter   ~15022

Thanks!
c_schmitz

c_schmitz

2011-05-25 12:21

administrator   ~15105

Released new 1.91+ version.

Issue History

Date Modified Username Field Change
2011-05-12 10:33 sp00ky New Issue
2011-05-12 10:36 sp00ky Issue Monitored: sp00ky
2011-05-12 17:17 c_schmitz Assigned To => c_schmitz
2011-05-12 17:17 c_schmitz Status new => assigned
2011-05-15 12:15 c_schmitz Note Added: 15006
2011-05-15 12:15 c_schmitz Status assigned => feedback
2011-05-16 09:09 sp00ky Note Added: 15019
2011-05-16 09:09 sp00ky Status feedback => assigned
2011-05-16 09:46 c_schmitz Note Added: 15021
2011-05-16 09:46 c_schmitz Status assigned => resolved
2011-05-16 09:46 c_schmitz Fixed in Version => 1.91+
2011-05-16 09:46 c_schmitz Resolution open => fixed
2011-05-16 09:48 sp00ky Note Added: 15022
2011-05-16 10:45 sp00ky Issue End Monitor: sp00ky
2011-05-25 12:21 c_schmitz Note Added: 15105
2011-05-25 12:21 c_schmitz Status resolved => closed