View Issue Details

This bug affects 1 person(s).
 8
IDProjectCategoryView StatusLast Update
13113Bug reportsRemoteControlpublic2018-01-10 17:16
Reportercairomckenzie Assigned ToLouisGac 
PrioritynoneSeverityblock 
Status closedResolutionfixed 
Product Version3.0.0-rc.x 
Summary13113: export_responses returns page error as response - 'Call to a member function getColumnNames() on null'
Description

When sending a request through remote control to export responses, the response text is markup with a php error.

Steps To Reproduce

Activate survey, activate token, take survey. Use remote control api function "export_responses" to download one record
(my example JSON {"method":"export_responses","params":{"sSessionKey":"xt8bnhinzcaah6d7da88m8x344x6kn63","iSurveyID":126941,"sDocumentType":"json","sLanguageCode":"en","sCompletionStatus":"all","sHeadingType":"code","sResponseType":"short","iFromResponsesID":1,"iToResponseID":2,"aFields":null},"id":1})

Response text from server:
<!DOCTYPE html PUBLIC
"-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd&quot;>
<html xmlns="http://www.w3.org/1999/xhtml&quot; xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title>Internal Server Error</title>

<style type="text/css">
/<![CDATA[/
body {font-family:"Verdana";font-weight:normal;color:black;background-color:white;}
h1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
h2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
h3 {font-family:"Verdana";font-weight:bold;font-size:11pt}
p {font-family:"Verdana";font-weight:normal;color:black;font-size:9pt;margin-top: -5px}
.version {color: gray;font-size:8pt;border-top:1px solid #aaaaaa;}
/]]>/
</style>
</head>

<body>
<h1>Internal Server Error</h1>
<h2>Call to a member function getColumnNames() on null</h2>
<p>
An internal error occurred while the Web server was processing your request.
Please contact the webmaster to report this problem.
</p>
<p>
Thank you.
</p>
<div class="version">
2018-01-02 13:33:47 </div>
</body>
</html>

TagsNo tags attached.
Bug heat8
Complete LimeSurvey version number (& build)Version 3.0.1+171228
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMariaDB
Server OS (if known)Ubuntu 16.04
Webserver software & version (if known)Apache 2.4.18
PHP Version7.0

Relationships

related to 13126 closedLouisGac rx 3.0.0.rc - can't export responses 

Users monitoring this issue

There are no users monitoring this issue.

Activities

cairomckenzie

cairomckenzie

2018-01-02 20:35

reporter   ~45415

This error also comes up while using the survey admin page as well. It appears that this only affects surveys that have a participant token table. If the survey is not tokenized - the export works fine.

TonisOrmisson

TonisOrmisson

2018-01-02 21:34

developer   ~45416

https://github.com/LimeSurvey/LimeSurvey/pull/910

abc99

abc99

2018-01-06 02:48

reporter   ~45429

Same as issue 13126.

LouisGac

LouisGac

2018-01-08 11:31

developer   ~45454

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=25843

Related Changesets

LimeSurvey: master 21020a16

2018-01-08 11:31:51

TonisOrmisson


Committer: LouisGac Details Diff
Fixed issue 13113: export_responses returns page error as response -… (#910) Affected Issues
13113
mod - application/controllers/admin/NotificationController.php Diff File
mod - application/helpers/admin/export/FormattingOptions.php Diff File
mod - application/helpers/admin/export/SurveyDao.php Diff File

Issue History

Date Modified Username Field Change
2018-01-02 20:19 cairomckenzie New Issue
2018-01-02 20:35 cairomckenzie Note Added: 45415
2018-01-02 21:34 TonisOrmisson Note Added: 45416
2018-01-06 02:48 abc99 Note Added: 45429
2018-01-08 11:31 LouisGac Changeset attached => LimeSurvey master 21020a16
2018-01-08 11:31 LouisGac Note Added: 45454
2018-01-08 11:31 LouisGac Assigned To => LouisGac
2018-01-08 11:31 LouisGac Resolution open => fixed
2018-01-08 11:32 LouisGac Relationship added related to 13126
2018-01-08 11:32 LouisGac Status new => resolved
2018-01-10 17:16 ollehar Status resolved => closed
2018-01-10 17:16 ollehar Fixed in Version => 3.0.2