View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 10
IDProjectCategoryView StatusDate SubmittedLast Update
11366Bug reportsResponse browsingpublic2016-06-10 15:032016-06-13 12:26
Reportergantier Assigned Toc_schmitz  
PrioritynoneSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.06+ 
Fixed in Version2.50.x 
Summary11366: Freeze when survey is big
Description

When I try to browse answers for a big survey (more than 500 columns) I get the error.
It can easily happen when we use the 'upload file 'question type with a high max. number of file.

Steps To Reproduce
  • Create a survey with 1 question 'Upload File'
  • For this question, set the maximum file number to 5000 (over some point, there is a PHP Error)
  • Activate the survey
  • Send 1 answer (with only 1 file)
  • Try to visualize responses
TagsNo tags attached.
Attached Files
capture.png (48,262 bytes)   
capture.png (48,262 bytes)   
Bug heat10
Complete LimeSurvey version number (& build)Build Git 160524
I will donate to the project if issue is resolvedNo
BrowserFirefox/Chrome
Database type & versionMySQL 5.5.49
Server OS (if known)Ubuntu 14.04.04 LTS
Webserver software & version (if known)Apache 2.4.7
PHP Version5.5

Users monitoring this issue

gantier, duvemyster

Activities

gantier

gantier

2016-06-10 15:15

reporter   ~39414

Last edited: 2016-06-10 15:19

I forgot to write that I commented the following lines (in file /srv/www/limesurvey/scripts/admin/listresponse.js) in order to help.
(Thank you Denis!)

    beforeRequest: function(){
        /* activate tooltip on header */
        for (i = 0; i < colModels.length; i++) {
            var col=i+1;
            $("tr.ui-jqgrid-labels th:eq("+col+") .questiontext").attr('title',colModels[i]['title']);
        }
        $(".ui-jqgrid-labels").tooltip();
    },

While browsing the responses, it could be a good idea to display only 2 columns (Files names and File count) instead of 1 column per files.
DenisChenu

DenisChenu

2016-06-10 16:09

developer   ~39429

The issue is too in HTML produced : 5000 columns for a page .... : break.

gantier have then issue in real with ~40 upload questions with 99 for max number of files.
c_schmitz

c_schmitz

2016-06-11 10:27

administrator   ~39430

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

gantier

2016-06-13 12:00

reporter   ~39467

Hello, I pacthed my application/controllers/admin/responses.php with thoses modifications but it seems nothing changed.

There are still 4 columns per file-upload question : so if maxfile = 50, there are 200 columns displayed.

As I am not sure to understand how you wanted to fix the bug I prefer to tell you :)
c_schmitz

c_schmitz

2016-06-13 12:26

administrator   ~39469

Version 2.50 Build 160613 released

Related Changesets

LimeSurvey: master bea28e95

2016-06-11 08:26:08

c_schmitz

Details Diff 		Fixed issue 11366: Survey response table is slow when maximmum number if files in a file upload question is set to a high number Affected Issues
11366
mod - application/controllers/admin/responses.php Diff File

Issue History

Date Modified Username Field Change
2016-06-10 15:03 gantier New Issue
2016-06-10 15:03 gantier File Added: capture.png
2016-06-10 15:03 gantier Issue Monitored: gantier
2016-06-10 15:15 gantier Note Added: 39414
2016-06-10 15:15 gantier Note Edited: 39414
2016-06-10 15:19 gantier Note Edited: 39414
2016-06-10 16:09 DenisChenu Note Added: 39429
2016-06-10 23:53 duvemyster Issue Monitored: duvemyster
2016-06-11 10:25 c_schmitz Assigned To => c_schmitz
2016-06-11 10:25 c_schmitz Status new => assigned
2016-06-11 10:26 c_schmitz Status assigned => resolved
2016-06-11 10:26 c_schmitz Fixed in Version => 2.5
2016-06-11 10:26 c_schmitz Resolution open => fixed
2016-06-11 10:27 c_schmitz Changeset attached => LimeSurvey master bea28e95
2016-06-11 10:27 c_schmitz Note Added: 39430
2016-06-13 12:00 gantier Note Added: 39467
2016-06-13 12:26 c_schmitz Note Added: 39469
2016-06-13 12:26 c_schmitz Status resolved => closed
2021-08-04 09:47 guest Bug heat 6 => 10