View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
19536 | Bug reports | Question editor | public | 2024-04-24 15:40 | 2024-04-24 17:02 |
Reporter | francois-charles.hebert | Assigned To | |||
Priority | none | Severity | partial_block | ||
Status | new | Resolution | open | ||
Product Version | 5.6.x | ||||
Summary | 19536: Possibility to edit the settings (Maximum Answers, Maximum columns for answers) of a Ranking question on an activated survey | ||||
Description | In a ranking question, it's possible to add answers options and change the logic settings in an activated survey, | ||||
Steps To Reproduce | Steps to reproduceCreate a ranking question. Expected resultSaving the response properly OR indicate that the survey must be deactivate and reactivate in order for database table structure to be updated. Actual resultAn exception is raised (throw new Exception(sprintf("Attribute '%s' not found in the model.", $name)); in application\models\Response.php(289).) and the answer is not saved properly. | ||||
Tags | No tags attached. | ||||
Attached Files | limesurvey_survey_514531.lss (20,523 bytes)
<?xml version="1.0" encoding="UTF-8"?> <document> <LimeSurveyDocType>Survey</LimeSurveyDocType> <DBVersion>499</DBVersion> <languages> <language>en</language> </languages> <answers> <fields> <fieldname>aid</fieldname> <fieldname>qid</fieldname> <fieldname>code</fieldname> <fieldname>sortorder</fieldname> <fieldname>assessment_value</fieldname> <fieldname>scale_id</fieldname> </fields> <rows> <row> <aid><![CDATA[6396]]></aid> <qid><![CDATA[3399]]></qid> <code><![CDATA[AO01]]></code> <sortorder><![CDATA[0]]></sortorder> <assessment_value><![CDATA[0]]></assessment_value> <scale_id><![CDATA[0]]></scale_id> </row> <row> <aid><![CDATA[6397]]></aid> <qid><![CDATA[3399]]></qid> <code><![CDATA[AO03]]></code> <sortorder><![CDATA[1]]></sortorder> <assessment_value><![CDATA[0]]></assessment_value> <scale_id><![CDATA[0]]></scale_id> </row> <row> <aid><![CDATA[6398]]></aid> <qid><![CDATA[3399]]></qid> <code><![CDATA[AO02]]></code> <sortorder><![CDATA[2]]></sortorder> <assessment_value><![CDATA[0]]></assessment_value> <scale_id><![CDATA[0]]></scale_id> </row> <row> <aid><![CDATA[6399]]></aid> <qid><![CDATA[3399]]></qid> <code><![CDATA[AO04]]></code> <sortorder><![CDATA[3]]></sortorder> <assessment_value><![CDATA[0]]></assessment_value> <scale_id><![CDATA[0]]></scale_id> </row> </rows> </answers> <answer_l10ns> <fields> <fieldname>id</fieldname> <fieldname>aid</fieldname> <fieldname>answer</fieldname> <fieldname>language</fieldname> </fields> <rows> <row> <id><![CDATA[12493]]></id> <aid><![CDATA[6396]]></aid> <answer><![CDATA[Answer 1]]></answer> <language><![CDATA[en]]></language> </row> <row> <id><![CDATA[12494]]></id> <aid><![CDATA[6397]]></aid> <answer><![CDATA[answer 3]]></answer> <language><![CDATA[en]]></language> </row> <row> <id><![CDATA[12495]]></id> <aid><![CDATA[6398]]></aid> <answer><![CDATA[answer 2]]></answer> <language><![CDATA[en]]></language> </row> <row> <id><![CDATA[12496]]></id> <aid><![CDATA[6399]]></aid> <answer><![CDATA[answer 4]]></answer> <language><![CDATA[en]]></language> </row> </rows> </answer_l10ns> <groups> <fields> <fieldname>gid</fieldname> <fieldname>sid</fieldname> <fieldname>group_order</fieldname> <fieldname>randomization_group</fieldname> <fieldname>grelevance</fieldname> </fields> <rows> <row> <gid><![CDATA[479]]></gid> <sid><![CDATA[514531]]></sid> <group_order><![CDATA[1]]></group_order> <randomization_group/> <grelevance><![CDATA[1]]></grelevance> </row> </rows> </groups> <group_l10ns> <fields> <fieldname>id</fieldname> <fieldname>gid</fieldname> <fieldname>group_name</fieldname> <fieldname>description</fieldname> <fieldname>language</fieldname> <fieldname>sid</fieldname> <fieldname>group_order</fieldname> <fieldname>randomization_group</fieldname> <fieldname>grelevance</fieldname> </fields> <rows> <row> <id><![CDATA[866]]></id> <gid><![CDATA[479]]></gid> <group_name><![CDATA[Test - ranking question]]></group_name> <description/> <language><![CDATA[en]]></language> <sid><![CDATA[514531]]></sid> <group_order><![CDATA[1]]></group_order> <randomization_group/> <grelevance><![CDATA[1]]></grelevance> </row> </rows> </group_l10ns> <questions> <fields> <fieldname>qid</fieldname> <fieldname>parent_qid</fieldname> <fieldname>sid</fieldname> <fieldname>gid</fieldname> <fieldname>type</fieldname> <fieldname>title</fieldname> <fieldname>preg</fieldname> <fieldname>other</fieldname> <fieldname>mandatory</fieldname> <fieldname>question_order</fieldname> <fieldname>scale_id</fieldname> <fieldname>same_default</fieldname> <fieldname>relevance</fieldname> <fieldname>modulename</fieldname> <fieldname>encrypted</fieldname> <fieldname>question_theme_name</fieldname> <fieldname>same_script</fieldname> </fields> <rows> <row> <qid><![CDATA[3399]]></qid> <parent_qid><![CDATA[0]]></parent_qid> <sid><![CDATA[514531]]></sid> <gid><![CDATA[479]]></gid> <type><![CDATA[R]]></type> <title><![CDATA[Q00]]></title> <other><![CDATA[N]]></other> <mandatory><![CDATA[N]]></mandatory> <question_order><![CDATA[1]]></question_order> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> <encrypted><![CDATA[N]]></encrypted> <question_theme_name><![CDATA[ranking]]></question_theme_name> <same_script><![CDATA[0]]></same_script> </row> </rows> </questions> <question_l10ns> <fields> <fieldname>id</fieldname> <fieldname>qid</fieldname> <fieldname>question</fieldname> <fieldname>help</fieldname> <fieldname>language</fieldname> <fieldname>script</fieldname> </fields> <rows> <row> <id><![CDATA[6362]]></id> <qid><![CDATA[3399]]></qid> <question><![CDATA[Add answer options when the survey is activated results in error 500 because columns are missing in the database table?]]></question> <help><![CDATA[This is a question help text.]]></help> <language><![CDATA[en]]></language> <script/> </row> </rows> </question_l10ns> <question_attributes> <fields> <fieldname>qid</fieldname> <fieldname>attribute</fieldname> <fieldname>value</fieldname> <fieldname>language</fieldname> </fields> <rows> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[min_answers]]></attribute> <value><![CDATA[1]]></value> <language/> </row> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[max_answers]]></attribute> <value><![CDATA[4]]></value> <language/> </row> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[max_subquestions]]></attribute> <value><![CDATA[3]]></value> <language/> </row> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[array_filter]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[array_filter_exclude]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[array_filter_style]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[random_group]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[em_validation_q]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[em_validation_q_tip]]></attribute> <value/> <language><![CDATA[en]]></language> </row> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[hide_tip]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[answer_order]]></attribute> <value><![CDATA[normal]]></value> <language/> </row> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[hidden]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[cssclass]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[showpopups]]></attribute> <value><![CDATA[1]]></value> <language/> </row> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[samechoiceheight]]></attribute> <value><![CDATA[1]]></value> <language/> </row> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[samelistheight]]></attribute> <value><![CDATA[1]]></value> <language/> </row> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[printable_help]]></attribute> <value/> <language><![CDATA[en]]></language> </row> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[page_break]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[choice_title]]></attribute> <value/> <language><![CDATA[en]]></language> </row> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[rank_title]]></attribute> <value/> <language><![CDATA[en]]></language> </row> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[public_statistics]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[statistics_showgraph]]></attribute> <value><![CDATA[1]]></value> <language/> </row> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[statistics_graphtype]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[3399]]></qid> <attribute><![CDATA[save_as_default]]></attribute> <value><![CDATA[N]]></value> <language/> </row> </rows> </question_attributes> <surveys> <fields> <fieldname>sid</fieldname> <fieldname>gsid</fieldname> <fieldname>admin</fieldname> <fieldname>expires</fieldname> <fieldname>startdate</fieldname> <fieldname>adminemail</fieldname> <fieldname>anonymized</fieldname> <fieldname>faxto</fieldname> <fieldname>format</fieldname> <fieldname>savetimings</fieldname> <fieldname>template</fieldname> <fieldname>language</fieldname> <fieldname>additional_languages</fieldname> <fieldname>datestamp</fieldname> <fieldname>usecookie</fieldname> <fieldname>allowregister</fieldname> <fieldname>allowsave</fieldname> <fieldname>autonumber_start</fieldname> <fieldname>autoredirect</fieldname> <fieldname>allowprev</fieldname> <fieldname>printanswers</fieldname> <fieldname>ipaddr</fieldname> <fieldname>refurl</fieldname> <fieldname>showsurveypolicynotice</fieldname> <fieldname>publicstatistics</fieldname> <fieldname>publicgraphs</fieldname> <fieldname>listpublic</fieldname> <fieldname>htmlemail</fieldname> <fieldname>sendconfirmation</fieldname> <fieldname>tokenanswerspersistence</fieldname> <fieldname>assessments</fieldname> <fieldname>usecaptcha</fieldname> <fieldname>usetokens</fieldname> <fieldname>bounce_email</fieldname> <fieldname>attributedescriptions</fieldname> <fieldname>emailresponseto</fieldname> <fieldname>emailnotificationto</fieldname> <fieldname>tokenlength</fieldname> <fieldname>showxquestions</fieldname> <fieldname>showgroupinfo</fieldname> <fieldname>shownoanswer</fieldname> <fieldname>showqnumcode</fieldname> <fieldname>bouncetime</fieldname> <fieldname>bounceprocessing</fieldname> <fieldname>bounceaccounttype</fieldname> <fieldname>bounceaccounthost</fieldname> <fieldname>bounceaccountpass</fieldname> <fieldname>bounceaccountencryption</fieldname> <fieldname>bounceaccountuser</fieldname> <fieldname>showwelcome</fieldname> <fieldname>showprogress</fieldname> <fieldname>questionindex</fieldname> <fieldname>navigationdelay</fieldname> <fieldname>nokeyboard</fieldname> <fieldname>alloweditaftercompletion</fieldname> <fieldname>googleanalyticsstyle</fieldname> <fieldname>googleanalyticsapikey</fieldname> <fieldname>tokenencryptionoptions</fieldname> <fieldname>ipanonymize</fieldname> </fields> <rows> <row> <sid><![CDATA[514531]]></sid> <gsid><![CDATA[1]]></gsid> <admin><![CDATA[inherit]]></admin> <adminemail><![CDATA[inherit]]></adminemail> <anonymized><![CDATA[N]]></anonymized> <format><![CDATA[I]]></format> <savetimings><![CDATA[Y]]></savetimings> <template><![CDATA[inherit]]></template> <language><![CDATA[en]]></language> <additional_languages/> <datestamp><![CDATA[Y]]></datestamp> <usecookie><![CDATA[I]]></usecookie> <allowregister><![CDATA[I]]></allowregister> <allowsave><![CDATA[I]]></allowsave> <autonumber_start><![CDATA[1]]></autonumber_start> <autoredirect><![CDATA[I]]></autoredirect> <allowprev><![CDATA[I]]></allowprev> <printanswers><![CDATA[I]]></printanswers> <ipaddr><![CDATA[N]]></ipaddr> <refurl><![CDATA[Y]]></refurl> <showsurveypolicynotice><![CDATA[0]]></showsurveypolicynotice> <publicstatistics><![CDATA[I]]></publicstatistics> <publicgraphs><![CDATA[I]]></publicgraphs> <listpublic><![CDATA[I]]></listpublic> <htmlemail><![CDATA[I]]></htmlemail> <sendconfirmation><![CDATA[I]]></sendconfirmation> <tokenanswerspersistence><![CDATA[I]]></tokenanswerspersistence> <assessments><![CDATA[I]]></assessments> <usecaptcha><![CDATA[E]]></usecaptcha> <usetokens><![CDATA[N]]></usetokens> <bounce_email><![CDATA[inherit]]></bounce_email> <emailresponseto><![CDATA[inherit]]></emailresponseto> <emailnotificationto><![CDATA[inherit]]></emailnotificationto> <tokenlength><![CDATA[-1]]></tokenlength> <showxquestions><![CDATA[I]]></showxquestions> <showgroupinfo><![CDATA[I]]></showgroupinfo> <shownoanswer><![CDATA[I]]></shownoanswer> <showqnumcode><![CDATA[I]]></showqnumcode> <bounceprocessing><![CDATA[N]]></bounceprocessing> <showwelcome><![CDATA[I]]></showwelcome> <showprogress><![CDATA[I]]></showprogress> <questionindex><![CDATA[-1]]></questionindex> <navigationdelay><![CDATA[-1]]></navigationdelay> <nokeyboard><![CDATA[I]]></nokeyboard> <alloweditaftercompletion><![CDATA[I]]></alloweditaftercompletion> <tokenencryptionoptions/> <ipanonymize><![CDATA[Y]]></ipanonymize> </row> </rows> </surveys> <surveys_languagesettings> <fields> <fieldname>surveyls_survey_id</fieldname> <fieldname>surveyls_language</fieldname> <fieldname>surveyls_title</fieldname> <fieldname>surveyls_description</fieldname> <fieldname>surveyls_welcometext</fieldname> <fieldname>surveyls_endtext</fieldname> <fieldname>surveyls_policy_notice</fieldname> <fieldname>surveyls_policy_error</fieldname> <fieldname>surveyls_policy_notice_label</fieldname> <fieldname>surveyls_url</fieldname> <fieldname>surveyls_urldescription</fieldname> <fieldname>surveyls_email_invite_subj</fieldname> <fieldname>surveyls_email_invite</fieldname> <fieldname>surveyls_email_remind_subj</fieldname> <fieldname>surveyls_email_remind</fieldname> <fieldname>surveyls_email_register_subj</fieldname> <fieldname>surveyls_email_register</fieldname> <fieldname>surveyls_email_confirm_subj</fieldname> <fieldname>surveyls_email_confirm</fieldname> <fieldname>surveyls_dateformat</fieldname> <fieldname>surveyls_attributecaptions</fieldname> <fieldname>email_admin_notification_subj</fieldname> <fieldname>email_admin_notification</fieldname> <fieldname>email_admin_responses_subj</fieldname> <fieldname>email_admin_responses</fieldname> <fieldname>surveyls_numberformat</fieldname> <fieldname>attachments</fieldname> <fieldname>surveyls_alias</fieldname> </fields> <rows> <row> <surveyls_survey_id><![CDATA[514531]]></surveyls_survey_id> <surveyls_language><![CDATA[en]]></surveyls_language> <surveyls_title><![CDATA[Bug - Ranking (add options when survey is activate)]]></surveyls_title> <surveyls_description/> <surveyls_welcometext/> <surveyls_endtext/> <surveyls_policy_notice/> <surveyls_policy_notice_label/> <surveyls_url/> <surveyls_urldescription/> <surveyls_email_invite_subj><![CDATA[Invitation to participate in a survey]]></surveyls_email_invite_subj> <surveyls_email_invite><![CDATA[Dear {FIRSTNAME},<br /> <br /> You have been invited to participate in a survey.<br /> <br /> The survey is titled:<br /> "{SURVEYNAME}"<br /> <br /> "{SURVEYDESCRIPTION}"<br /> <br /> To participate, please click on the link below.<br /> <br /> Sincerely,<br /> <br /> {ADMINNAME} ({ADMINEMAIL})<br /> <br /> ----------------------------------------------<br /> Click here to do the survey:<br /> {SURVEYURL}<br /> <br /> If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:<br /> {OPTOUTURL}<br /> <br /> If you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:<br /> {OPTINURL}]]></surveyls_email_invite> <surveyls_email_remind_subj><![CDATA[Reminder to participate in a survey]]></surveyls_email_remind_subj> <surveyls_email_remind><![CDATA[Dear {FIRSTNAME},<br /> <br /> Recently we invited you to participate in a survey.<br /> <br /> We note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.<br /> <br /> The survey is titled:<br /> "{SURVEYNAME}"<br /> <br /> "{SURVEYDESCRIPTION}"<br /> <br /> To participate, please click on the link below.<br /> <br /> Sincerely,<br /> <br /> {ADMINNAME} ({ADMINEMAIL})<br /> <br /> ----------------------------------------------<br /> Click here to do the survey:<br /> {SURVEYURL}<br /> <br /> If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:<br /> {OPTOUTURL}]]></surveyls_email_remind> <surveyls_email_register_subj><![CDATA[Survey registration confirmation]]></surveyls_email_register_subj> <surveyls_email_register><![CDATA[Dear {FIRSTNAME},<br /> <br /> You, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.<br /> <br /> To complete this survey, click on the following URL:<br /> <br /> {SURVEYURL}<br /> <br /> If you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.]]></surveyls_email_register> <surveyls_email_confirm_subj><![CDATA[Confirmation of your participation in our survey]]></surveyls_email_confirm_subj> <surveyls_email_confirm><![CDATA[Dear {FIRSTNAME},<br /> <br /> This email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.<br /> <br /> If you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.<br /> <br /> Sincerely,<br /> <br /> {ADMINNAME}]]></surveyls_email_confirm> <surveyls_dateformat><![CDATA[9]]></surveyls_dateformat> <email_admin_notification_subj><![CDATA[Response submission for survey {SURVEYNAME}]]></email_admin_notification_subj> <email_admin_notification><![CDATA[Hello,<br /> <br /> A new response was submitted for your survey '{SURVEYNAME}'.<br /> <br /> Click the following link to see the individual response:<br /> {VIEWRESPONSEURL}<br /> <br /> Click the following link to edit the individual response:<br /> {EDITRESPONSEURL}<br /> <br /> View statistics by clicking here:<br /> {STATISTICSURL}]]></email_admin_notification> <email_admin_responses_subj><![CDATA[Response submission for survey {SURVEYNAME} with results]]></email_admin_responses_subj> <email_admin_responses><![CDATA[Hello,<br /> <br /> A new response was submitted for your survey '{SURVEYNAME}'.<br /> <br /> Click the following link to see the individual response:<br /> {VIEWRESPONSEURL}<br /> <br /> Click the following link to edit the individual response:<br /> {EDITRESPONSEURL}<br /> <br /> View statistics by clicking here:<br /> {STATISTICSURL}<br /> <br /> <br /> The following answers were given by the participant:<br /> {ANSWERTABLE}]]></email_admin_responses> <surveyls_numberformat><![CDATA[0]]></surveyls_numberformat> </row> </rows> </surveys_languagesettings> <themes> <theme> <sid>514531</sid> <template_name>default</template_name> <config> <options>inherit</options> </config> </theme> </themes> <themes_inherited> <theme> <sid>514531</sid> <template_name>default</template_name> <config> <options> <ajaxmode>off</ajaxmode> <brandlogo>on</brandlogo> <container>on</container> <hideprivacyinfo>off</hideprivacyinfo> <brandlogofile>image::theme::files/logo.png</brandlogofile> <font>noto</font> </options> </config> </theme> </themes_inherited> </document> | ||||
Bug heat | 2 | ||||
Complete LimeSurvey version number (& build) | 5.6.58 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Opera | ||||
Database type & version | Mariadb 10.11 | ||||
Server OS (if known) | |||||
Webserver software & version (if known) | |||||
PHP Version | 8.0.2 | ||||
Date Modified | Username | Field | Change |
---|---|---|---|
2024-04-24 15:40 | francois-charles.hebert | New Issue | |
2024-04-24 15:40 | francois-charles.hebert | File Added: limesurvey_survey_514531.lss | |
2024-04-24 17:02 | DenisChenu | Note Added: 79996 | |
2024-04-24 17:02 | DenisChenu | Bug heat | 0 => 2 |