View Issue Details

IDProjectCategoryView StatusLast Update
13477Development Import/Exportpublic2018-03-14 21:31
ReporterdawidmosAssigned To 
PrioritynoneSeveritycrash 
Status newResolutionopen 
Product Version3.x 
Target VersionFixed in Version 
Summary13477: Cant export responses - too many columns
Description

I cant export responses when survey have more columns (over 1000). First 1000 responses are ok, but rest columns are "N/A".

Steps To Reproduce

Large survey - 4138 columns - PostgreSQL, limesurvey version: lastest

TagsNo tags attached.

Activities

dawidmos

dawidmos

2018-03-14 17:52

reporter   ~47050

/admin/export/SurveyObj.php:
invalid value $answerCode value:PO-Revision-Date: 2017-10-26 10:58:37+0000 MIME-Version: 1.0 Content-.......

dawidmos

dawidmos

2018-03-14 20:24

reporter   ~47059

Probably problem is with creating/writing table for survey - there missing part questions (and answers). On debug output is creating column for question 10313 but on responses missing this question.

dawidmos

dawidmos

2018-03-14 21:06

reporter   ~47060

DEBUG:
system.db.CDbCommand.query(UPDATE lime_survey_462663 SET "lastpage"=74, "datestamp"='2018-03-14 19:49:31', "462663X411X10313"='cghg' WHERE ID=897)

DATABASE after Next button:
lime1=> select 462663X411X10313 from "lime_survey_462663" where id = '897';
x411x10313

 462663
dawidmos

dawidmos

2018-03-14 21:31

reporter   ~47061

Update: database problem - wont save values on this column - PostgreSQL (column has text type)

Issue History

Date Modified Username Field Change
2018-03-14 17:34 dawidmos New Issue
2018-03-14 17:52 dawidmos Note Added: 47050
2018-03-14 20:24 dawidmos Note Added: 47059
2018-03-14 21:06 dawidmos Note Added: 47060
2018-03-14 21:31 dawidmos Note Added: 47061