View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
06957Bug reportsCentral participant databasepublic2013-03-02 16:34
ReporterpfpDave Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary06957: Error 400 when using too many parameters in a search
Description

When including too many parameters in a search for participants in the CPD, the following error is returned:

HTTP Error 400. The request URL is invalid.

I found this error when attempting to find 50 participants to add to a real survey from a CPD of 3,000+ users.

Steps To Reproduce
  1. Navigate to CPD
  2. Create a search with 10 parameters and execute
    The following error is returned:

HTTP Error 400. The request URL is invalid.

The url returning the error:

http://pfpconsulttest/index.php/admin/participants/getParticipantsResults_json/search/lastname||equal||jonesa||or||lastname||equal||jonesb||or||lastname||equal||jonesc||or||lastname||equal||jonesd||or||lastname||equal||jonese||or||lastname||equal||jonesf||or||lastname||equal||jonesg||or||lastname||equal||jonesh||or||lastname||equal||jonesi||or||lastname||equal||jonesj?_search=false&nd=1353934783977&page=1&rows=25&sidx=firstname&sord=asc

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)121121
I will donate to the project if issue is resolvedNo
BrowserIE8
Database type & versionSQL Express 2012
Server OS (if known)Server 2008
Webserver software & version (if known)IIS 7
PHP Version5.4.8

Users monitoring this issue

There are no users monitoring this issue.

Activities

mdekker

mdekker

2012-12-12 14:29

reporter   ~23175

Is this issue still present in current build or can this issue be closed?

pfpDave

pfpDave

2012-12-12 15:25

reporter   ~23180

Still exists in Build 121211 on clicking search after entering 10 criteria I get pop-up box appears with 'Bad Request (Error 400)
Could not process your query.'

c_schmitz

c_schmitz

2013-01-31 20:52

administrator   ~23925

Most likely the error is caused by limitation of your webserver not accepting long URLs beyond a certain limit.

The general problem in LimeSurvey is that such a long URL is used at all instead of POSTing the information in the AJAX call - so this parts needs to be refactored.

c_schmitz

c_schmitz

2013-02-23 15:12

administrator   ~24210

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

c_schmitz

c_schmitz

2013-02-26 20:03

administrator   ~24416

New version released.

c_schmitz

c_schmitz

2013-03-02 16:34

administrator   ~24482

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

Related Changesets

LimeSurvey: master d9173d0d

2013-02-23 14:12:43

c_schmitz

Details Diff
Fixed issue 06957: Error when using too many parameters in a search in central participant database Affected Issues
06957
mod - application/controllers/admin/participantsaction.php Diff File
mod - application/views/admin/participants/displayParticipants_view.php Diff File
mod - scripts/admin/displayParticipant.js Diff File

LimeSurvey: 2.1 138242cf

2013-02-23 14:12:43

c_schmitz

Details Diff
Fixed issue 06957: Error when using too many parameters in a search in central participant database Affected Issues
06957
mod - application/controllers/admin/participantsaction.php Diff File
mod - application/views/admin/participants/displayParticipants_view.php Diff File
mod - scripts/admin/displayParticipant.js Diff File

Issue History

Date Modified Username Field Change
2012-11-26 14:03 pfpDave New Issue
2012-11-26 14:03 pfpDave Status new => assigned
2012-11-26 14:03 pfpDave Assigned To => jcleeland
2012-12-12 14:29 mdekker Note Added: 23175
2012-12-12 15:25 pfpDave Note Added: 23180
2013-01-31 20:52 c_schmitz Note Added: 23925
2013-02-23 15:11 c_schmitz Assigned To jcleeland => c_schmitz
2013-02-23 15:12 c_schmitz Changeset attached => LimeSurvey master d9173d0d
2013-02-23 15:12 c_schmitz Note Added: 24210
2013-02-23 15:12 c_schmitz Resolution open => fixed
2013-02-23 15:12 c_schmitz Status assigned => resolved
2013-02-23 15:12 c_schmitz Fixed in Version => 2.00+
2013-02-26 20:03 c_schmitz Note Added: 24416
2013-02-26 20:03 c_schmitz Status resolved => closed
2013-03-02 16:34 c_schmitz Changeset attached => LimeSurvey 2.1 138242cf
2013-03-02 16:34 c_schmitz Note Added: 24482