View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
13477Bug reportsOtherpublic2021-08-04 15:26
Reporterdawidmos Assigned Toc_schmitz  
PrioritynoneSeverityblock 
Status closedResolutionfixed 
Product Version3.x 
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.
Bug heat6
Complete LimeSurvey version number (& build)
I will donate to the project if issue is resolved
Browser
Database type & version
Server OS (if known)
Webserver software & version (if known)
PHP Version

Users monitoring this issue

There are no users monitoring this issue.

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)

c_schmitz

c_schmitz

2021-03-05 16:38

administrator   ~62786

Please provide a sample survey with that many data fields and at least one response as survey archive (*.lsa) . Thank you!

galads

galads

2021-08-04 15:26

reporter   ~65830

Hello dawidmos,

we have asked for feedback on this issue. Because we did not get an answer we assume that the issue is resolved.
However, should you be able to reproduce the issue using the latest version, please feel free to re-open the issue and give us exact details on how to reproduce it.

Thank you and best regards,

galads

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
2021-03-05 16:38 c_schmitz Assigned To => c_schmitz
2021-03-05 16:38 c_schmitz Status new => feedback
2021-03-05 16:38 c_schmitz Note Added: 62786
2021-03-05 16:38 c_schmitz Project Development => Bug reports
2021-03-05 16:38 c_schmitz Category Import/Export => Other issues
2021-08-04 15:26 galads Status feedback => closed
2021-08-04 15:26 galads Resolution open => fixed
2021-08-04 15:26 galads Note Added: 65830
2021-08-04 15:26 galads Bug heat 4 => 6