View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
11505Bug reportsStatisticspublic2016-08-01 14:15
Reporterthiagosmartins Assigned Toc_schmitz  
PriorityimmediateSeveritycrash 
Status closedResolutionfixed 
Product Version2.50.x 
Fixed in Version2.50.x 
Summary11505: When browsing survey responses, search fields gives a 404 error.
Description

I have a somehow big survey, with 11 groups and 56 questions.

When browsing survey responses, trying to use any search field gives a 404 error popup (see attached file).

Even with an empty response table the error shows up, but in my live survey I have around 400 responses.

Steps To Reproduce

Import the provided LSS file
Activate the survey
Initialize Participant DB
Go to Survey responses and Display All responses
Type anything in the search fields and change to another field
The error will popup.

Additional Information

Google Chrome Developer Tools give this error:

GET https://ADDRESS/tmp/assets/b198ed5/img/loader.gif 404 (Not Found)
jquery-2.2.4.min.js:4 GET https://ADDRESS/index.php?SurveyDynamic%5Bid%5D=3&…Fsurveyid%2F883598&YII_CSRF_TOKEN=28b4cf7ec632c0c20b81b477f689f7d55e5f806b 404 (Not Found)send @ jquery-2.2.4.min.js:4ajax @ jquery-2.2.4.min.js:4(anonymous function) @ jquery.yiigridview.js:355each @ jquery-2.2.4.min.js:2each @ jquery-2.2.4.min.js:2update @ jquery.yiigridview.js:260$.fn.yiiGridView @ jquery.yiigridview.js:418(anonymous function) @ jquery.yiigridview.js:142dispatch @ jquery-2.2.4.min.js:3r.handle @ jquery-2.2.4.min.js:3

TagsNo tags attached.
Attached Files
2016_07_27_10_04_55.png (68,922 bytes)   
2016_07_27_10_04_55.png (68,922 bytes)   
survey_883598.lss (85,213 bytes)
Bug heat6
Complete LimeSurvey version number (& build)2.50+ Build 160728
I will donate to the project if issue is resolvedNo
BrowserAll
Database type & versionSQLServer
Server OS (if known)Windows NT RD00155D001AF5 6.2 build 9200 (Windows Server 2012 Datacenter Edition) i586
Webserver software & version (if known)IIS 8.0
PHP Version5.6.20

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2016-07-28 09:11

developer   ~40087

Can not confirm the issue with last GIT version. What is your config abiut urlManager ?

Maybe its' get ?

I only can confirm issue for loader.gif only :)

c_schmitz

c_schmitz

2016-07-28 11:42

administrator   ~40088

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

c_schmitz

c_schmitz

2016-07-28 11:43

administrator   ~40089

Dev note:
MSSQL does not properly identify a field name starting with numbers and
Cgridview does not seem to properly quote the fieldname for the query.

Probably an error in Yii CBCriteria - field names in criterias should always be quoted.

DenisChenu

DenisChenu

2016-07-28 11:56

developer   ~40090

@c_schmitz : ytou're right : compare don't quote : https://github.com/LimeSurvey/LimeSurvey/blob/master/application/helpers/common_helper.php#L5650

DenisChenu

DenisChenu

2016-07-28 11:58

developer   ~40091

PS : bad SQL => 404 error ???????

c_schmitz

c_schmitz

2016-07-28 12:11

administrator   ~40092

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

c_schmitz

c_schmitz

2016-07-28 12:11

administrator   ~40093

I cannot see any other errors. So lets first fix what's obvious.
It is IIS so it is somewhat unpredictable. :p A 404 instead of some other error would perfectly fit that.

c_schmitz

c_schmitz

2016-07-28 12:19

administrator   ~40094

thiagosmartins, please apply the fix (just replace the file with the one from the second patch) and let us know if the issue is gone.

DenisChenu

DenisChenu

2016-07-28 13:53

developer   ~40095

Its why i think og get in url and not path :)

thiagosmartins

thiagosmartins

2016-07-28 14:50

reporter   ~40098

I don't know if this is related to this issue, but maybe it is. I was about to open a new case but maybe it is related to this one.

In the same survey, more then 400 responses, when I try to "Export to Application" and select Microsoft Excel, I get a huge PHP Warning. See attached PDF file. Sorry if this is not related to this case, I have very basic dev and DB skills. If needed I can open a new case for this one.

thiagosmartins

thiagosmartins

2016-07-28 14:56

reporter   ~40099

Sorry guys, still not working after changing SurveyDynamic.php. Same 404 error and same log using Chrome Dev Tools (error below). I have tried both, the first e last fix.

#breadcrumb-container
https://ADDRESS/tmp/assets/b198ed5/img/loader.gif [^] Failed to load resource: the server responded with a status of 404 (Not Found)
https://ADDRESS/index.php?SurveyDynamic%5Bid%5D=&S [^]…Fsurveyid%2F883598&YII_CSRF_TOKEN=190f3c06a29d87e61eebc466165222d180d7ca3b Failed to load resource: the server responded with a status of 404 (Not Found)
https://ADDRESS/index.php?SurveyDynamic%5Bid%5D=&S [^]…Fsurveyid%2F883598&YII_CSRF_TOKEN=190f3c06a29d87e61eebc466165222d180d7ca3b Failed to load resource: the server responded with a status of 404 (Not Found)
https://ADDRESS/index.php?SurveyDynamic%5Bid%5D=&S [^]…Fsurveyid%2F883598&YII_CSRF_TOKEN=190f3c06a29d87e61eebc466165222d180d7ca3b Failed to load resource: the server responded with a status of 404 (Not Found)

c_schmitz

c_schmitz

2016-07-28 17:23

administrator   ~40102

I set up the IIS with SQL Server and could not reproduce.
Probably it is a server conifguration issue.
Anyway, there have been numerous changes along with mine so a full update might be necessary.

c_schmitz

c_schmitz

2016-08-01 14:15

administrator   ~40137

Version 2.50 Build 160731 released

Related Changesets

LimeSurvey: master d4d15d93

2016-07-28 09:41:47

c_schmitz

Details Diff
Fixed issue 11505: When browsing survey responses, search fields gives a 404 error
Dev Partial fix
Affected Issues
11505
mod - application/models/SurveyDynamic.php Diff File

LimeSurvey: master a14ab634

2016-07-28 10:08:38

c_schmitz

Details Diff
Fixed issue 11505: When browsing survey responses, search fields gives a 404 error
Dev Fully fixed
Affected Issues
11505
mod - application/models/SurveyDynamic.php Diff File

Issue History

Date Modified Username Field Change
2016-07-27 15:36 thiagosmartins New Issue
2016-07-27 15:36 thiagosmartins File Added: 2016_07_27_10_04_55.png
2016-07-27 15:38 thiagosmartins File Added: survey_883598.lss
2016-07-28 09:11 DenisChenu Note Added: 40087
2016-07-28 11:40 c_schmitz Priority none => immediate
2016-07-28 11:41 c_schmitz Assigned To => LouisGac
2016-07-28 11:41 c_schmitz Status new => assigned
2016-07-28 11:42 c_schmitz Changeset attached => LimeSurvey master d4d15d93
2016-07-28 11:42 c_schmitz Note Added: 40088
2016-07-28 11:42 c_schmitz Assigned To LouisGac => c_schmitz
2016-07-28 11:42 c_schmitz Resolution open => fixed
2016-07-28 11:43 c_schmitz Note Added: 40089
2016-07-28 11:56 DenisChenu Note Added: 40090
2016-07-28 11:58 DenisChenu Note Added: 40091
2016-07-28 12:11 c_schmitz Changeset attached => LimeSurvey master a14ab634
2016-07-28 12:11 c_schmitz Note Added: 40092
2016-07-28 12:11 c_schmitz Note Added: 40093
2016-07-28 12:19 c_schmitz Status assigned => resolved
2016-07-28 12:19 c_schmitz Fixed in Version => 2.5
2016-07-28 12:19 c_schmitz Note Added: 40094
2016-07-28 13:53 DenisChenu Note Added: 40095
2016-07-28 14:50 thiagosmartins Note Added: 40098
2016-07-28 14:50 thiagosmartins File Added: PHP warning.pdf
2016-07-28 14:56 thiagosmartins Note Added: 40099
2016-07-28 14:56 thiagosmartins Status resolved => feedback
2016-07-28 14:56 thiagosmartins Resolution fixed => reopened
2016-07-28 17:23 c_schmitz Note Added: 40102
2016-07-28 17:23 c_schmitz Status feedback => resolved
2016-07-28 17:23 c_schmitz Resolution reopened => fixed
2016-07-28 17:24 c_schmitz File Deleted: PHP warning.pdf
2016-08-01 14:15 c_schmitz Note Added: 40137
2016-08-01 14:15 c_schmitz Status resolved => closed