View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
17337Bug reportsQuestion editorpublic2021-07-12 11:53
Reporterbbraeuer Assigned Togabrieljenik  
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Product Version5.x 
Summary17337: Setting mandatory state on multiple questions leads to exception
DescriptionHi,

setting mandatory state on multiple questions leads to an exception.

Kind regards
Benny
Steps To Reproduce1. Go to question list
2. select multiple questions
3. choose set "mandatory" state
4. choose soft or yes
5. exception
Additional Information{"success":false,"message":"Property \"CDbCriteria.0\" is not defined.","error":{"code":500,"type":"CException","errorCode":0,"message":"Property \"CDbCriteria.0\" is not defined.","file":"\/var\/www\/apps3\/limesurvey2\/framework\/db\/schema\/CDbCriteria.php","line":160,"trace":"#0 \/var\/www\/apps3\/limesurvey2\/framework\/db\/schema\/CDbCriteria.php(160): CComponent->__set('0', 'sid=:sid')\n#1 \/var\/www\/apps3\/limesurvey2\/framework\/db\/schema\/CDbCommandBuilder.php(588): CDbCriteria->__construct(Array)\n#2 \/var\/www\/apps3\/limesurvey2\/framework\/db\/schema\/CDbCommandBuilder.php(617): CDbCommandBuilder->createCriteria(Array, Array)\n#3 \/var\/www\/apps3\/limesurvey2\/framework\/db\/ar\/CActiveRecord.php(1493): CDbCommandBuilder->createPkCriteria(Object(CMysqlTableSchema), Array, Array, Array, '`t`.')\n#4 \/var\/www\/apps3\/limesurvey2\/application\/controllers\/QuestionAdministrationController.php(1929): CActiveRecord->findByPk(Array, Array, Array)\n#5 \/var\/www\/apps3\/limesurvey2\/application\/controllers\/QuestionAdministrationController.php(1413): QuestionAdministrationController::setMultipleQuestionMandatoryState(Array, 'Y', 979671)\n#6 \/var\/www\/apps3\/limesurvey2\/framework\/web\/actions\/CInlineAction.php(49): QuestionAdministrationController->actionChangeMultipleQuestionMandatoryState()\n#7 \/var\/www\/apps3\/limesurvey2\/framework\/web\/CController.php(308): CInlineAction->runWithParams(Array)\n#8 \/var\/www\/apps3\/limesurvey2\/framework\/web\/CController.php(286): CController->runAction(Object(CInlineAction))\n#9 \/var\/www\/apps3\/limesurvey2\/framework\/web\/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)\n#10 \/var\/www\/apps3\/limesurvey2\/application\/controllers\/LSBaseController.php(160): CController->run('changeMultipleQ...')\n#11 \/var\/www\/apps3\/limesurvey2\/framework\/web\/CWebApplication.php(282): LSBaseController->run('changeMultipleQ...')\n#12 \/var\/www\/apps3\/limesurvey2\/framework\/web\/CWebApplication.php(141): CWebApplication->runController('questionAdminis...')\n#13 \/var\/www\/apps3\/limesurvey2\/framework\/base\/CApplication.php(185): CWebApplication->processRequest()\n#14 \/var\/www\/apps3\/limesurvey2\/index.php(182): CApplication->run()\n#15 {main}","traces":[{"file":"\/var\/www\/apps3\/limesurvey2\/framework\/db\/schema\/CDbCriteria.php","line":160,"function":"__set","class":"CComponent","type":"->","args":["0","sid=:sid"]},{"file":"\/var\/www\/apps3\/limesurvey2\/framework\/db\/schema\/CDbCommandBuilder.php","line":588,"function":"__construct","class":"CDbCriteria","type":"->","args":[["sid=:sid"]]},{"file":"\/var\/www\/apps3\/limesurvey2\/framework\/db\/schema\/CDbCommandBuilder.php","line":617,"function":"createCriteria","class":"CDbCommandBuilder","type":"->","args":[["sid=:sid"],{":sid":979671}]},{"file":"\/var\/www\/apps3\/limesurvey2\/framework\/db\/ar\/CActiveRecord.php","line":1493,"function":"createPkCriteria","class":"CDbCommandBuilder","type":"->","args":[{"schemaName":null,"name":"lime4_questions","rawName":"`lime4_questions`","primaryKey":"qid","sequenceName":"","foreignKeys":[],"columns":{"qid":{"name":"qid","rawName":"`qid`","allowNull":false,"dbType":"int(11)","type":"integer","defaultValue":null,"size":11,"precision":11,"scale":null,"isPrimaryKey":true,"isForeignKey":false,"autoIncrement":true,"comment":""},"parent_qid":{"name":"parent_qid","rawName":"`parent_qid`","allowNull":false,"dbType":"int(11)","type":"integer","defaultValue":0,"size":11,"precision":11,"scale":null,"isPrimaryKey":false,"isForeignKey":false,"autoIncrement":false,"comment":""},"sid":{"name":"sid","rawName":"`sid`","allowNull":false,"dbType":"int(11)","type":"integer","defaultValue":0,"size":11,"precision":11,"scale":null,"isPrimaryKey":false,"isForeignKey":false,"autoIncrement":false,"comment":""},"gid":{"name":"gid","rawName":"`gid`","allowNull":false,"dbType":"int(11)","type":"integer","defaultValue":0,"size":11,"precision":11,"scale":null,"isPrimaryKey":false,"isForeignKey":false,"autoIncrement":false,"comment":""},"type":{"name":"type","rawName":"`type`","allowNull":false,"dbType":"varchar(30)","type":"string","defaultValue":"T","size":30,"precision":30,"scale":null,"isPrimaryKey":false,"isForeignKey":false,"autoIncrement":false,"comment":""},"title":{"name":"title","rawName":"`title`","allowNull":false,"dbType":"varchar(20)","type":"string","defaultValue":"","size":20,"precision":20,"scale":null,"isPrimaryKey":false,"isForeignKey":false,"autoIncrement":false,"comment":""},"preg":{"name":"preg","rawName":"`preg`","allowNull":true,"dbType":"text","type":"string","defaultValue":null,"size":null,"precision":null,"scale":null,"isPrimaryKey":false,"isForeignKey":false,"autoIncrement":false,"comment":""},"other":{"name":"other","rawName":"`other`","allowNull":false,"dbType":"varchar(1)","type":"string","defaultValue":"N","size":1,"precision":1,"scale":null,"isPrimaryKey":false,"isForeignKey":false,"autoIncrement":false,"comment":""},"mandatory":{"name":"mandatory","rawName":"`mandatory`","allowNull":true,"dbType":"varchar(1)","type":"string","defaultValue":null,"size":1,"precision":1,"scale":null,"isPrimaryKey":false,"isForeignKey":false,"autoIncrement":false,"comment":""},"encrypted":{"name":"encrypted","rawName":"`encrypted`","allowNull":true,"dbType":"varchar(1)","type":"string","defaultValue":"N","size":1,"precision":1,"scale":null,"isPrimaryKey":false,"isForeignKey":false,"autoIncrement":false,"comment":""},"question_order":{"name":"question_order","rawName":"`question_order`","allowNull":false,"dbType":"int(11)","type":"integer","defaultValue":null,"size":11,"precision":11,"scale":null,"isPrimaryKey":false,"isForeignKey":false,"autoIncrement":false,"comment":""},"scale_id":{"name":"scale_id","rawName":"`scale_id`","allowNull":false,"dbType":"int(11)","type":"integer","defaultValue":0,"size":11,"precision":11,"scale":null,"isPrimaryKey":false,"isForeignKey":false,"autoIncrement":false,"comment":""},"same_default":{"name":"same_default","rawName":"`same_default`","allowNull":false,"dbType":"int(11)","type":"integer","defaultValue":0,"size":11,"precision":11,"scale":null,"isPrimaryKey":false,"isForeignKey":false,"autoIncrement":false,"comment":""},"relevance":{"name":"relevance","rawName":"`relevance`","allowNull":true,"dbType":"text","type":"string","defaultValue":null,"size":null,"precision":null,"scale":null,"isPrimaryKey":false,"isForeignKey":false,"autoIncrement":false,"comment":""},"modulename":{"name":"modulename","rawName":"`modulename`","allowNull":true,"dbType":"varchar(255)","type":"string","defaultValue":null,"size":255,"precision":255,"scale":null,"isPrimaryKey":false,"isForeignKey":false,"autoIncrement":false,"comment":""}}},{"qid":2793},["sid=:sid"],{":sid":979671},"`t`."]},{"file":"\/var\/www\/apps3\/limesurvey2\/application\/controllers\/QuestionAdministrationController.php","line":1929,"function":"findByPk","class":"CActiveRecord","type":"->","args":[{"qid":2793},["sid=:sid"],{":sid":979671}]},{"file":"\/var\/www\/apps3\/limesurvey2\/application\/controllers\/QuestionAdministrationController.php","line":1413,"function":"setMultipleQuestionMandatoryState","class":"QuestionAdministrationController","type":"::","args":[["2793","2794","2795","2796","2797"],"Y",979671]},{"file":"\/var\/www\/apps3\/limesurvey2\/framework\/web\/actions\/CInlineAction.php","line":49,"function":"actionChangeMultipleQuestionMandatoryState","class":"QuestionAdministrationController","type":"->","args":[]},{"file":"\/var\/www\/apps3\/limesurvey2\/framework\/web\/CController.php","line":308,"function":"runWithParams","class":"CInlineAction","type":"->","args":[[]]},{"file":"\/var\/www\/apps3\/limesurvey2\/framework\/web\/CController.php","line":286,"function":"runAction","class":"CController","type":"->","args":[{}]},{"file":"\/var\/www\/apps3\/limesurvey2\/framework\/web\/CController.php","line":265,"function":"runActionWithFilters","class":"CController","type":"->","args":[{},[]]},{"file":"\/var\/www\/apps3\/limesurvey2\/application\/controllers\/LSBaseController.php","line":160,"function":"run","class":"CController","type":"->","args":["changeMultipleQuestionMandatoryState"]},{"file":"\/var\/www\/apps3\/limesurvey2\/framework\/web\/CWebApplication.php","line":282,"function":"run","class":"LSBaseController","type":"->","args":["changeMultipleQuestionMandatoryState"]},{"file":"\/var\/www\/apps3\/limesurvey2\/framework\/web\/CWebApplication.php","line":141,"function":"runController","class":"CWebApplication","type":"->","args":["questionAdministration\/changeMultipleQuestionMandatoryState"]},{"file":"\/var\/www\/apps3\/limesurvey2\/framework\/base\/CApplication.php","line":185,"function":"processRequest","class":"CWebApplication","type":"->","args":[]},{"file":"\/var\/www\/apps3\/limesurvey2\/index.php","line":182,"function":"run","class":"CApplication","type":"->","args":[]}]}}
TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)5.0.0+210526
I will donate to the project if issue is resolvedNo
Browser
Database & DB-VersionMySQL 5.6.51-log
Server OS (if known)Ubuntu 18.04
Webserver software & version (if known)
PHP Version7.2.24-0ubuntu0.18.04.7

Users monitoring this issue

User List There are no users monitoring this issue.

Activities

bbraeuer

bbraeuer

2021-05-28 14:11

reporter  

DenisChenu

DenisChenu

2021-05-28 14:44

developer   ~64640

Same for Other state :) (and surely other part)
gabrieljenik

gabrieljenik

2021-06-01 16:32

manager   ~64691

PR: https://github.com/LimeSurvey/LimeSurvey/pull/1904
gabrieljenik

gabrieljenik

2021-06-02 14:20

manager   ~64713

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

c_schmitz

2021-07-12 11:53

administrator   ~65339

Release done.

Related Changesets

LimeSurvey: master 400d3fdb

2021-06-02 14:20:05

gabrieljenik


Committer: GitHub Details Diff
Fixed issue 17337: Setting mandatory state on multiple questions leads to exception (#1904)

Co-authored-by: encuestabizdevgit <devgit@encuesta.biz>
Affected Issues
17337
mod - application/controllers/QuestionAdministrationController.php Diff File

Issue History

Date Modified Username Field Change
2021-05-28 14:11 bbraeuer New Issue
2021-05-28 14:11 bbraeuer File Added: Bildschirmfoto 2021-05-28 um 14.05.03.png
2021-05-28 14:11 bbraeuer File Added: Bildschirmfoto 2021-05-28 um 14.04.56.png
2021-05-28 14:11 bbraeuer File Added: Bildschirmfoto 2021-05-28 um 14.04.50.png
2021-05-28 14:44 DenisChenu Note Added: 64640
2021-05-28 15:37 gabrieljenik Assigned To => gabrieljenik
2021-05-28 15:37 gabrieljenik Status new => assigned
2021-06-01 16:32 gabrieljenik Note Added: 64691
2021-06-01 16:33 gabrieljenik Status assigned => resolved
2021-06-01 16:33 gabrieljenik Resolution open => fixed
2021-06-02 14:20 gabrieljenik Changeset attached => LimeSurvey master 400d3fdb
2021-06-02 14:20 gabrieljenik Note Added: 64713
2021-07-12 11:53 c_schmitz Note Added: 65339
2021-07-12 11:53 c_schmitz Status resolved => closed