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

I've just downloaded the new Participants.php file and I get the same issue (CDbException (Error 500) Could not process your query.) on my installation ... don't know if I should or not ... appologies if you would expect this.

I checked again and it works just fine. Make sure that you download the right file, replace it correctly and clean your browser cache.

Just tested again and still no joy ... steps to reproduce:

• Downloaded file from here: https://raw.github.com/LimeSurvey/LimeSurvey/1b431ec5357d5ad4d389aca1173163c0b389f42d/application/models/Participants.php

• Deleted existing /application/models/Participants.php file and recreated from above URL

• Opened new browser window with InPrivate filtering

• Logged in to Limesurvey

• Opened Survey

• Clicked on Token Management

• Clicked on Display Tokens

• Ticked select all tick box to select both participants listed

• Clicked on 'View Participants of this survey in the central participant database panel' button at the bottom of the list of tokens (second icon from left)

• URL Loaded: .../index.php/admin/participants/displayParticipants/searchurl/survey%7C%7Cequal%7C%7C489924

• Error Displayed: CDbException (Error 500)Could not process your query.

• Clicked OK to close pop-up error

• Empty Participant list displayed.

Maybe you can trace again and check if the issue moved somewhere else?

OK just done a simple check (print text and exit) and the code seems to be failing at line 634 $arr = Participants::model()->findAll($command);

I'm afraid I've only got primitive dev tools on this laptop but if you have something specific you'd like me to try I'd be more than happy to.

ok, can you check what the contents of

$command->toArray()

is ?

do a

var_dump($command->toArray()); die()

array(15) { ["select"]=> string(1) "*" ["condition"]=> string(359) "participant_id IN (SELECT distinct {{survey_links}}.participant_id FROM {{survey_links}}, {{surveys_languagesettings}} WHERE {{survey_links}}.survey_id = {{surveys_languagesettings}}.surveyls_survey_id AND {{surveys_languagesettings}}.surveyls_language=:lang AND ({{surveys_languagesettings}}.surveyls_title = :param1 OR {{survey_links}}.survey_id = :param2))" ["params"]=> array(3) { [":lang"]=> string(2) "en" [":param1"]=> int(489924) [":param2"]=> int(489924) } ["limit"]=> string(2) "25" ["offset"]=> int(0) ["order"]=> string(0) "" ["group"]=> string(0) "" ["join"]=> string(0) "" ["having"]=> string(0) "" ["distinct"]=> bool(false) ["scopes"]=> NULL ["with"]=> NULL ["alias"]=> NULL ["index"]=> NULL ["together"]=> NULL }

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

Should there be a new version of the file from the 18th?? I've just grabbed the latest one from here: http://github.com/LimeSurvey/LimeSurvey/tree/8fca43738201e737c3688b269d048aec7b31ca5a/application/models/Participants.php and the issue still exists. The contents of $command->toArray() are below if this helps:

array(15) { ["select"]=> string(1) "*" ["condition"]=> string(359) "participant_id IN (SELECT distinct {{survey_links}}.participant_id FROM {{survey_links}}, {{surveys_languagesettings}} WHERE {{survey_links}}.survey_id = {{surveys_languagesettings}}.surveyls_survey_id AND {{surveys_languagesettings}}.surveyls_language=:lang AND ({{surveys_languagesettings}}.surveyls_title = :param1 OR {{survey_links}}.survey_id = :param2))" ["params"]=> array(3) { [":lang"]=> string(2) "en" [":param1"]=> int(378628) [":param2"]=> int(378628) } ["limit"]=> string(2) "25" ["offset"]=> int(0) ["order"]=> string(0) "" ["group"]=> string(0) "" ["join"]=> string(0) "" ["having"]=> string(0) "" ["distinct"]=> bool(false) ["scopes"]=> NULL ["with"]=> NULL ["alias"]=> NULL ["index"]=> NULL ["together"]=> NULL }

I am sorry but I cannot reproduce the issue. The parameter array looks fine to me, too. Can you try to manually cobble a statement together from that contents and see if there are any problems executing that statement?

Rather than my trying to guess is there a place where I can intercept the formed SQL statement before it's executed?

Do you have Firefix and Firebug installed? If yes you can activate the new parameter in the latest version in config.php and it would appear in the Firebug console.

Got it! Here's the SQL it's trying to execute.

CDbCommand failed to execute the SQL statement: SQLSTATE[22018]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Conversion failed when converting the varchar value 'Test Large Survey' to data type int.. The SQL statement executed was: SELECT TOP 25 * FROM [dbo].[participants] [t] WHERE participant_id IN (SELECT distinct survey_links.participant_id FROM survey_links, surveys_languagesettings WHERE survey_links.survey_id = surveys_languagesettings.surveyls_survey_id AND surveys_languagesettings.surveyls_language=:lang AND (surveys_languagesettings.surveyls_title = :param1 OR survey_links.survey_id = :param2)) (C:\limesurvey\framework\db\CDbCommand.php:528)

and here's the full error text:

<h1>CDbException</h1>

CDbCommand failed to execute the SQL statement: SQLSTATE[22018]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Conversion failed when converting the varchar value 'Test Large Survey' to data type int.. The SQL statement executed was: SELECT TOP 25 * FROM [dbo].[participants] [t] WHERE participant_id IN (SELECT distinct survey_links.participant_id FROM survey_links, surveys_languagesettings WHERE survey_links.survey_id = surveys_languagesettings.surveyls_survey_id AND surveys_languagesettings.surveyls_language=:lang AND (surveys_languagesettings.surveyls_title = :param1 OR survey_links.survey_id = :param2)) (C:\limesurvey\framework\db\CDbCommand.php:528)

#0 C:\limesurvey\framework\db\CDbCommand.php(390): CDbCommand->queryInternal('fetchAll', Array, Array)

#1 C:\limesurvey\framework\db\ar\CActiveRecord.php(1287): CDbCommand->queryAll()

#2 C:\limesurvey\framework\db\ar\CActiveRecord.php(1406): CActiveRecord->query(Object(CDbCriteria), true)

#3 C:\limesurvey\application\models\Participants.php(631): CActiveRecord->findAll(Object(CDbCriteria))

#4 C:\limesurvey\application\controllers\admin\participantsaction.php(881): Participants->getParticipantsSearchMultiple(Array, '1', '25')

#5 [internal function]: participantsaction->getParticipantsResults_json()

#6 C:\limesurvey\framework\web\actions\CAction.php(107): ReflectionMethod->invokeArgs(Object(participantsaction), Array)

#7 C:\limesurvey\application\core\Survey_Common_Action.php(82): CAction->runWithParamsInternal(Object(participantsaction), Object(ReflectionMethod), Array)

#8 C:\limesurvey\framework\web\CController.php(309): Survey_Common_Action->runWithParams(Array)

#9 C:\limesurvey\framework\web\CController.php(287): CController->runAction(Object(participantsaction))

#10 C:\limesurvey\framework\web\CController.php(266): CController->runActionWithFilters(Object(participantsaction), Array)

#11 C:\limesurvey\application\controllers\AdminController.php(159): CController->run('participants')

#12 C:\limesurvey\framework\web\CWebApplication.php(276): AdminController->run('participants')

#13 C:\limesurvey\framework\web\CWebApplication.php(135): CWebApplication->runController('admin/participa...')

#14 C:\limesurvey\framework\base\CApplication.php(162): CWebApplication->processRequest()

#15 C:\limesurvey\index.php(178): CApplication->run()

#16 {main}

Thank you - that helped. Hope this fix does the trick.

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

This seems to have resolved the issue, many thanks.

New 2.00+ build released.