View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 17818 | Bug reports | Survey editing | public | 2021-12-23 18:27 | 2023-06-01 17:44 |
| Reporter | DenisChenu | Assigned To | adamzammit | ||
| Priority | none | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.25.20 | ||||
| Summary | 17818: Copy a multiple choice question send a DB error (MSSQL) | ||||
| Description | When copy a Multiple choice question on MSSQL : receoive a DB error | ||||
| Steps To Reproduce | Steps to reproduce
Expected resultQuestion is copied with subquestions Actual resultReceive a DB error | ||||
| Tags | No tags attached. | ||||
| Attached Files | 500 Internal Server Error.html (13,418 bytes)
<!DOCTYPE html>
<html dir="ltr" class="en dir-ltr no-js " lang="en"><head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/jquery-ui.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/font-awesome.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/bootstrap.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/yiistrap.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/bootstrap-switch.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/select2.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/select2-bootstrap.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/bootstrap-datetimepicker.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/roboto.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/icomoon.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/lstutorial.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/adminbasics.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/adminsidepanel.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/lime-admin-colors.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/statistics.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/select2ForAdmin.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/noto.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/survey.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/template-core.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/awesome-bootstrap-checkbox.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/ajaxify.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/base.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/errors.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/theme.css">
<link rel="stylesheet" type="text/css" href="500%20Internal%20Server%20Error_fichiers/custom.css">
<script type="text/javascript">window.debugState = {frontend : (0 === 1), backend : (0 === 1)};</script><script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/jquery-3.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/jquery-migrate-3.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/jquery-ui.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/adminbasics.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/adminsidepanel.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/js.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/bootstrap.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/bootstrapconfirm.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/moment-with-locales.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/select2.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/lslog.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/pjax.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/ckeditor.js" class="headScriptTag"></script><style>.cke{visibility:hidden;}</style>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/config.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/ckeditoradditions.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/adapt.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/select2ForAdmin.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/pjax_002.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/survey.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/template-core.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/theme.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/ajaxify.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/custom.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/em_javascript.js" class="headScriptTag"></script>
<script type="text/javascript">
/*<![CDATA[*/
LS.globalUserId = "7";
/*]]>*/
</script>
<title>
500: Internal Server Error
</title>
<meta name="generator" content="LimeSurvey http://www.limesurvey.org">
<link rel="shortcut icon" href="https://survey.oecd.org/tmp/assets/a60e85a9/favicon.ico">
</head>
<body class="oecd vanilla lang-en " marginwidth="0" marginheight="0"><script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/bootstrap-switch.js"></script>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/bootstrap-datetimepicker.js"></script>
<script type="text/javascript">
/*<![CDATA[*/
var LEMmode='survey';
var LEMgseq='';
ExprMgr_process_relevance_and_tailoring = function(evt_type,sgqa,type){
if (typeof LEM_initialized == 'undefined') {
LEM_initialized=true;
LEMsetTabIndexes();
}
if (evt_type == 'onchange' && (typeof last_sgqa !== 'undefined' && sgqa==last_sgqa) && (typeof last_evt_type !== 'undefined' && last_evt_type == 'TAB' && type != 'checkbox')) {
last_evt_type='onchange';
last_sgqa=sgqa;
return;
}
last_evt_type = evt_type;
last_sgqa=sgqa;
relChange491364=false;
relChange491365=false;
relChange491366=false;
relChange491367=false;
relChange491368=false;
relChangeG0=false;
LEMrel491364(sgqa);
LEMrel491364(sgqa);
LEMrel491365(sgqa);
LEMrel491365(sgqa);
LEMrel491366(sgqa);
LEMrel491366(sgqa);
LEMrel491367(sgqa);
LEMrel491367(sgqa);
LEMrel491368(sgqa);
LEMrel491368(sgqa);
}
function LEMrel491364(sgqa){
var UsesVars = ' ';
if(relChangeG0){
;
}
else if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
return;
}
if (1)
{
LEMval491364(sgqa);
relChange491364=true;
$('#relevance491364').val('1');
}
$('#relevance491364').val('1'); // always true
}
function LEMrel491365(sgqa){
var UsesVars = ' ';
if(relChangeG0){
;
}
else if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
return;
}
if (1)
{
LEMval491365(sgqa);
relChange491365=true;
$('#relevance491365').val('1');
}
$('#relevance491365').val('1'); // always true
}
function LEMrel491366(sgqa){
var UsesVars = ' ';
if(relChangeG0){
;
}
else if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
return;
}
if (1)
{
LEMval491366(sgqa);
relChange491366=true;
$('#relevance491366').val('1');
}
$('#relevance491366').val('1'); // always true
}
function LEMrel491367(sgqa){
var UsesVars = ' ';
if(relChangeG0){
;
}
else if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
return;
}
if (1)
{
LEMval491367(sgqa);
relChange491367=true;
$('#relevance491367').val('1');
}
$('#relevance491367').val('1'); // always true
}
function LEMrel491368(sgqa){
var UsesVars = ' ';
if(relChangeG0){
;
}
else if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
return;
}
if (1)
{
LEMval491368(sgqa);
relChange491368=true;
$('#relevance491368').val('1');
}
$('#relevance491368').val('1'); // always true
}
function LEMval491364(sgqa){
isValidSum491364=true;
isValidOther491364=true;
isValidOtherComment491364=true;
if(((1))){
$('#vmsg_491364_default').trigger('classChangeGood');
}
else {
$('#vmsg_491364_default').trigger('classChangeError');
isValidOther491364=false;
}
if(isValidSum491364){
$('#totalvalue_491364').trigger('classChangeGood');
}
else {
$('#totalvalue_491364').trigger('classChangeError');
}
}
function LEMval491365(sgqa){
isValidSum491365=true;
isValidOther491365=true;
isValidOtherComment491365=true;
if(((1))){
$('#vmsg_491365_default').trigger('classChangeGood');
}
else {
$('#vmsg_491365_default').trigger('classChangeError');
isValidOther491365=false;
}
if(isValidSum491365){
$('#totalvalue_491365').trigger('classChangeGood');
}
else {
$('#totalvalue_491365').trigger('classChangeError');
}
}
function LEMval491366(sgqa){
isValidSum491366=true;
isValidOther491366=true;
isValidOtherComment491366=true;
if(((1))){
$('#vmsg_491366_default').trigger('classChangeGood');
}
else {
$('#vmsg_491366_default').trigger('classChangeError');
isValidOther491366=false;
}
if(isValidSum491366){
$('#totalvalue_491366').trigger('classChangeGood');
}
else {
$('#totalvalue_491366').trigger('classChangeError');
}
}
function LEMval491367(sgqa){
isValidSum491367=true;
isValidOther491367=true;
isValidOtherComment491367=true;
if(((1))){
$('#vmsg_491367_default').trigger('classChangeGood');
}
else {
$('#vmsg_491367_default').trigger('classChangeError');
isValidOther491367=false;
}
if(isValidSum491367){
$('#totalvalue_491367').trigger('classChangeGood');
}
else {
$('#totalvalue_491367').trigger('classChangeError');
}
}
function LEMval491368(sgqa){
isValidSum491368=true;
isValidOther491368=true;
isValidOtherComment491368=true;
if(((1))){
$('#vmsg_491368_default').trigger('classChangeGood');
}
else {
$('#vmsg_491368_default').trigger('classChangeError');
isValidOther491368=false;
}
if(isValidSum491368){
$('#totalvalue_491368').trigger('classChangeGood');
}
else {
$('#totalvalue_491368').trigger('classChangeError');
}
}
/*]]>*/
</script>
<article id="block_error">
<div>
<h1>500: Internal Server Error</h1>
<h2>CDbCommand failed to execute the SQL
statement: SQLSTATE[23000]: [Microsoft][ODBC Driver 11 for SQL
Server][SQL Server]Cannot insert explicit value for identity column in
table 'lime_questions' when IDENTITY_INSERT is set to OFF.</h2>
<p>
An internal error occurred while the Web server was processing your request.
</p>
<p>
Please contact OECD Surveys to report this problem.
</p>
</div>
</article>
<footer>
<div class="row">
<div class="copyright col-xs-12">
© Organisation for Economic Co-operation and Development
</div>
</div>
</footer>
<script type="text/javascript" src="500%20Internal%20Server%20Error_fichiers/lstutorial.js"></script>
<script type="text/javascript">
/*<![CDATA[*/
jQuery('body').popover({'selector':'a\x5Brel\x3Dpopover\x5D'});
jQuery('body').tooltip({'selector':'a\x5Brel\x3Dtooltip\x5D'});
try{
triggerEmClassChange();
} catch(e) {
console.ls.warn('triggerEmClassChange could not be run. Is survey.js correctly loaded?');
}
triggerEmRelevance();
jQuery(document).off('pjax:scriptcomplete.mainBottom').on('ready pjax:scriptcomplete.mainBottom', function() {
updateMandatoryErrorClass();
});
/*]]>*/
</script>
<div id="grammalecte_menu_main_button_shadow_host" style="width: 0px; height: 0px;"></div></body><script src="500%20Internal%20Server%20Error_fichiers/api.js"></script></html> CDbException.html (25,448 bytes)
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>CDbException</title>
<style type="text/css">
/*<![CDATA[*/
html,body,div,span,applet,object,iframe,h1,h2,h3,h4,h5,h6,p,blockquote,pre,a,abbr,acronym,address,big,cite,code,del,dfn,em,font,img,ins,kbd,q,s,samp,small,strike,strong,sub,sup,tt,var,b,u,i,center,dl,dt,dd,ol,ul,li,fieldset,form,label,legend,table,caption,tbody,tfoot,thead,tr,th,td{border:0;outline:0;font-size:100%;vertical-align:baseline;background:transparent;margin:0;padding:0;}
body{line-height:1;}
ol,ul{list-style:none;}
blockquote,q{quotes:none;}
blockquote:before,blockquote:after,q:before,q:after{content:none;}
:focus{outline:0;}
ins{text-decoration:none;}
del{text-decoration:line-through;}
table{border-collapse:collapse;border-spacing:0;}
body {
font: normal 9pt "Verdana";
color: #000;
background: #fff;
}
h1 {
font: normal 18pt "Verdana";
color: #f00;
margin-bottom: .5em;
}
h2 {
font: normal 14pt "Verdana";
color: #800000;
margin-bottom: .5em;
}
h3 {
font: bold 11pt "Verdana";
}
pre {
font: normal 11pt Menlo, Consolas, "Lucida Console", Monospace;
}
pre span.error {
display: block;
background: #fce3e3;
}
pre span.ln {
color: #999;
padding-right: 0.5em;
border-right: 1px solid #ccc;
}
pre span.error-ln {
font-weight: bold;
}
.container {
margin: 1em 4em;
}
.version {
color: gray;
font-size: 8pt;
border-top: 1px solid #aaa;
padding-top: 1em;
margin-bottom: 1em;
}
.message {
color: #000;
padding: 1em;
font-size: 11pt;
background: #f3f3f3;
-webkit-border-radius: 10px;
-moz-border-radius: 10px;
border-radius: 10px;
margin-bottom: 1em;
line-height: 160%;
}
.source {
margin-bottom: 1em;
}
.code pre {
background-color: #ffe;
margin: 0.5em 0;
padding: 0.5em;
line-height: 125%;
border: 1px solid #eee;
}
.source .file {
margin-bottom: 1em;
font-weight: bold;
}
.traces {
margin: 2em 0;
}
.trace {
margin: 0.5em 0;
padding: 0.5em;
}
.trace.app {
border: 1px dashed #c00;
}
.trace .number {
text-align: right;
width: 2em;
padding: 0.5em;
}
.trace .content {
padding: 0.5em;
}
.trace .plus,
.trace .minus {
display:inline;
vertical-align:middle;
text-align:center;
border:1px solid #000;
color:#000;
font-size:10px;
line-height:10px;
margin:0;
padding:0 1px;
width:10px;
height:10px;
}
.trace.collapsed .minus,
.trace.expanded .plus,
.trace.collapsed pre {
display: none;
}
.trace-file {
cursor: pointer;
padding: 0.2em;
}
.trace-file:hover {
background: #f0ffff;
}
/*]]>*/
</style>
</head>
<body>
<div class="container">
<h1>CDbException</h1>
<p class="message">
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]:
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot insert
explicit value for identity column in table 'lime_questions' when
IDENTITY_INSERT is set to OFF.. The SQL statement executed was: INSERT
INTO [dbo].[lime_questions] ([parent_qid], [sid], [gid], [type],
[title], [other], [scale_id], [same_default], [qid], [question], [preg],
[help], [mandatory], [question_order], [language], [relevance],
[modulename]) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7,
:yp8, :yp9, :yp10, :yp11, :yp12, :yp13, :yp14, :yp15, :yp16) </p>
<div class="source">
<p class="file">E:\WebSite\limesurvey\framework\db\CDbCommand.php(358)</p>
<div class="code"><pre><span class="ln">346</span> {
<span class="ln">347</span> if($this->_connection->enableProfiling)
<span class="ln">348</span> Yii::endProfile('system.db.CDbCommand.execute('.$this->getText().$par.')','system.db.CDbCommand.execute');
<span class="ln">349</span>
<span class="ln">350</span> $errorInfo=$e instanceof PDOException ? $e->errorInfo : null;
<span class="ln">351</span> $message=$e->getMessage();
<span class="ln">352</span> Yii::log(Yii::t('yii','CDbCommand::execute() failed: {error}. The SQL statement executed was: {sql}.',
<span class="ln">353</span> array('{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
<span class="ln">354</span>
<span class="ln">355</span> if(YII_DEBUG)
<span class="ln">356</span> $message.='. The SQL statement executed was: '.$this->getText().$par;
<span class="ln">357</span>
<span class="error"><span class="ln error-ln">358</span> throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
</span><span class="ln">359</span> array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
<span class="ln">360</span> }
<span class="ln">361</span> }
<span class="ln">362</span>
<span class="ln">363</span> /**
<span class="ln">364</span> * Executes the SQL statement and returns query result.
<span class="ln">365</span> * This method is for executing an SQL query that returns result set.
<span class="ln">366</span> * @param array $params input parameters (name=>value) for the SQL execution. This is an alternative
<span class="ln">367</span> * to {@link bindParam} and {@link bindValue}. If you have multiple input parameters, passing
<span class="ln">368</span> * them in this way can improve the performance. Note that if you pass parameters in this way,
<span class="ln">369</span> * you cannot bind parameters or values using {@link bindParam} or {@link bindValue}, and vice versa.
<span class="ln">370</span> * Please also note that all values are treated as strings in this case, if you need them to be handled as
</pre></div> </div>
<div class="traces">
<h2>Stack Trace</h2>
<table style="width:100%;">
<tbody><tr class="trace core collapsed">
<td class="number">
#0 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\WebSite\limesurvey\framework\db\ar\CActiveRecord.php(1083): <strong>CDbCommand</strong>-><strong>execute</strong>() </div>
<div class="code"><pre><span class="ln">1078</span> {
<span class="ln">1079</span> Yii::trace(get_class($this).'.insert()','system.db.ar.CActiveRecord');
<span class="ln">1080</span> $builder=$this->getCommandBuilder();
<span class="ln">1081</span> $table=$this->getTableSchema();
<span class="ln">1082</span> $command=$builder->createInsertCommand($table,$this->getAttributes($attributes));
<span class="error"><span class="ln error-ln">1083</span> if($command->execute())
</span><span class="ln">1084</span> {
<span class="ln">1085</span> $primaryKey=$table->primaryKey;
<span class="ln">1086</span> if($table->sequenceName!==null)
<span class="ln">1087</span> {
<span class="ln">1088</span> if(is_string($primaryKey) && $this->$primaryKey===null)
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#1 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\WebSite\limesurvey\framework\db\ar\CActiveRecord.php(811): <strong>CActiveRecord</strong>-><strong>insert</strong>(null) </div>
<div class="code"><pre><span class="ln">806</span> * @return boolean whether the saving succeeds
<span class="ln">807</span> */
<span class="ln">808</span> public function save($runValidation=true,$attributes=null)
<span class="ln">809</span> {
<span class="ln">810</span> if(!$runValidation || $this->validate($attributes))
<span class="error"><span class="ln error-ln">811</span> return $this->getIsNewRecord() ? $this->insert($attributes) : $this->update($attributes);
</span><span class="ln">812</span> else
<span class="ln">813</span> return false;
<span class="ln">814</span> }
<span class="ln">815</span>
<span class="ln">816</span> /**
</pre></div> </td>
</tr>
<tr class="trace app expanded">
<td class="number">
#2 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\WebSite\limesurvey\application\models\Question.php(1149): <strong>CActiveRecord</strong>-><strong>save</strong>() </div>
<div class="code"><pre><span class="ln">1144</span> $oRecord = new self;
<span class="ln">1145</span> foreach ($data as $k => $v) {
<span class="ln">1146</span> $oRecord->$k = $v;
<span class="ln">1147</span> }
<span class="ln">1148</span> if ($oRecord->validate()) {
<span class="error"><span class="ln error-ln">1149</span> return $oRecord->save();
</span><span class="ln">1150</span> }
<span class="ln">1151</span> Yii::log(\CVarDumper::dumpAsString($oRecord->getErrors()), 'warning', 'application.models.Question.insertRecords');
<span class="ln">1152</span> }
<span class="ln">1153</span>
<span class="ln">1154</span> }
</pre></div> </td>
</tr>
<tr class="trace app expanded">
<td class="number">
#3 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\WebSite\limesurvey\application\controllers\admin\database.php(1377): <strong>Question</strong>-><strong>insertRecords</strong>(array("qid" => "491363", "parent_qid" => "491362", "sid" => "999245", "type" => "T", ...)) </div>
<div class="code"><pre><span class="ln">1372</span> } else { // additional languages
<span class="ln">1373</span> $aInsertData['qid'] = $aSubquestionIds[$sSubquestionIndex]; // get qid from array
<span class="ln">1374</span> }
<span class="ln">1375</span>
<span class="ln">1376</span> $aInsertData['parent_qid'] = $this->iQuestionID;
<span class="error"><span class="ln error-ln">1377</span> if (Question::model()->insertRecords($aInsertData)){
</span><span class="ln">1378</span> if ($sLanguageIndex == 0){ // main language
<span class="ln">1379</span> $aSubquestionIds[$sSubquestionIndex] = getLastInsertID('{{questions}}'); // save qid into the array
<span class="ln">1380</span> }
<span class="ln">1381</span> }
<span class="ln">1382</span> }
</pre></div> </td>
</tr>
<tr class="trace app expanded">
<td class="number">
#4 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\WebSite\limesurvey\application\controllers\admin\database.php(127): <strong>database</strong>-><strong>actionInsertCopyQuestion</strong>(999245) </div>
<div class="code"><pre><span class="ln">122</span> }
<span class="ln">123</span> if ($sAction == "updatesubquestions" && Permission::model()->hasSurveyPermission($this->iSurveyID, 'surveycontent', 'update')) {
<span class="ln">124</span> $this->actionSubQuestions($this->iSurveyID);
<span class="ln">125</span> }
<span class="ln">126</span> if (in_array($sAction, array('insertquestion', 'copyquestion')) && Permission::model()->hasSurveyPermission($this->iSurveyID, 'surveycontent', 'create')) {
<span class="error"><span class="ln error-ln">127</span> $this->actionInsertCopyQuestion($this->iSurveyID);
</span><span class="ln">128</span> }
<span class="ln">129</span> if ($sAction == "updatequestion" && Permission::model()->hasSurveyPermission($this->iSurveyID, 'surveycontent', 'update')) {
<span class="ln">130</span> $this->actionUpdateQuestion($this->iSurveyID);
<span class="ln">131</span> }
<span class="ln">132</span> if (($sAction == "updatesurveylocalesettings") && (Permission::model()->hasSurveyPermission($this->iSurveyID, 'surveylocale', 'update') || Permission::model()->hasSurveyPermission($iSurveyID, 'surveysettings', 'update'))) {
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#5 </td>
<td class="content">
<div class="trace-file">
unknown(0): <strong>database</strong>-><strong>index</strong>() </div>
</td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#6 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\WebSite\limesurvey\framework\web\actions\CAction.php(115): <strong>ReflectionMethod</strong>-><strong>invokeArgs</strong>(database, array()) </div>
<div class="code"><pre><span class="ln">110</span> elseif($param->isDefaultValueAvailable())
<span class="ln">111</span> $ps[]=$param->getDefaultValue();
<span class="ln">112</span> else
<span class="ln">113</span> return false;
<span class="ln">114</span> }
<span class="error"><span class="ln error-ln">115</span> $method->invokeArgs($object,$ps);
</span><span class="ln">116</span> return true;
<span class="ln">117</span> }
<span class="ln">118</span> }
</pre></div> </td>
</tr>
<tr class="trace app collapsed">
<td class="number">
#7 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\WebSite\limesurvey\application\core\Survey_Common_Action.php(83): <strong>CAction</strong>-><strong>runWithParamsInternal</strong>(database,
ReflectionMethod, array("r" => "admin/database/index", "index" =>
"", "iGroupId" => "18850", "iSurveyId" => "999245", ...)) </div>
<div class="code"><pre><span class="ln">78</span> $oMethod = new ReflectionMethod($this, $sDefault);
<span class="ln">79</span> }
<span class="ln">80</span>
<span class="ln">81</span> // We're all good to go, let's execute it
<span class="ln">82</span> // runWithParamsInternal would automatically get the parameters of the method and populate them as required with the params
<span class="error"><span class="ln error-ln">83</span> return parent::runWithParamsInternal($this, $oMethod, $params);
</span><span class="ln">84</span> }
<span class="ln">85</span>
<span class="ln">86</span> /**
<span class="ln">87</span> * Some functions have different parameters, which are just an alias of the
<span class="ln">88</span> * usual parameters we're getting in the url. This function just populates
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#8 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\WebSite\limesurvey\framework\web\CController.php(308): <strong>Survey_Common_Action</strong>-><strong>runWithParams</strong>(array("r" => "admin/database/index", "index" => "", "iGroupId" => "18850", "iSurveyId" => "999245", ...)) </div>
<div class="code"><pre><span class="ln">303</span> {
<span class="ln">304</span> $priorAction=$this->_action;
<span class="ln">305</span> $this->_action=$action;
<span class="ln">306</span> if($this->beforeAction($action))
<span class="ln">307</span> {
<span class="error"><span class="ln error-ln">308</span> if($action->runWithParams($this->getActionParams())===false)
</span><span class="ln">309</span> $this->invalidActionParams($action);
<span class="ln">310</span> else
<span class="ln">311</span> $this->afterAction($action);
<span class="ln">312</span> }
<span class="ln">313</span> $this->_action=$priorAction;
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#9 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\WebSite\limesurvey\framework\web\CController.php(286): <strong>CController</strong>-><strong>runAction</strong>(database) </div>
<div class="code"><pre><span class="ln">281</span> * @see runAction
<span class="ln">282</span> */
<span class="ln">283</span> public function runActionWithFilters($action,$filters)
<span class="ln">284</span> {
<span class="ln">285</span> if(empty($filters))
<span class="error"><span class="ln error-ln">286</span> $this->runAction($action);
</span><span class="ln">287</span> else
<span class="ln">288</span> {
<span class="ln">289</span> $priorAction=$this->_action;
<span class="ln">290</span> $this->_action=$action;
<span class="ln">291</span> CFilterChain::create($this,$action,$filters)->run();
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#10 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\WebSite\limesurvey\framework\web\CController.php(265): <strong>CController</strong>-><strong>runActionWithFilters</strong>(database, array()) </div>
<div class="code"><pre><span class="ln">260</span> {
<span class="ln">261</span> if(($parent=$this->getModule())===null)
<span class="ln">262</span> $parent=Yii::app();
<span class="ln">263</span> if($parent->beforeControllerAction($this,$action))
<span class="ln">264</span> {
<span class="error"><span class="ln error-ln">265</span> $this->runActionWithFilters($action,$this->filters());
</span><span class="ln">266</span> $parent->afterControllerAction($this,$action);
<span class="ln">267</span> }
<span class="ln">268</span> }
<span class="ln">269</span> else
<span class="ln">270</span> $this->missingAction($actionID);
</pre></div> </td>
</tr>
<tr class="trace app collapsed">
<td class="number">
#11 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\WebSite\limesurvey\application\controllers\AdminController.php(165): <strong>CController</strong>-><strong>run</strong>("database") </div>
<div class="code"><pre><span class="ln">160</span> $this->redirect(array('/admin/authentication/sa/login'));
<span class="ln">161</span> }
<span class="ln">162</span> }
<span class="ln">163</span> }
<span class="ln">164</span>
<span class="error"><span class="ln error-ln">165</span> return parent::run($action);
</span><span class="ln">166</span> }
<span class="ln">167</span>
<span class="ln">168</span> /**
<span class="ln">169</span> * Routes all the actions to their respective places
<span class="ln">170</span> *
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#12 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\WebSite\limesurvey\framework\web\CWebApplication.php(282): <strong>AdminController</strong>-><strong>run</strong>("database") </div>
<div class="code"><pre><span class="ln">277</span> {
<span class="ln">278</span> list($controller,$actionID)=$ca;
<span class="ln">279</span> $oldController=$this->_controller;
<span class="ln">280</span> $this->_controller=$controller;
<span class="ln">281</span> $controller->init();
<span class="error"><span class="ln error-ln">282</span> $controller->run($actionID);
</span><span class="ln">283</span> $this->_controller=$oldController;
<span class="ln">284</span> }
<span class="ln">285</span> else
<span class="ln">286</span> throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".',
<span class="ln">287</span> array('{route}'=>$route===''?$this->defaultController:$route)));
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#13 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\WebSite\limesurvey\framework\web\CWebApplication.php(141): <strong>CWebApplication</strong>-><strong>runController</strong>("admin/database/index") </div>
<div class="code"><pre><span class="ln">136</span> foreach(array_splice($this->catchAllRequest,1) as $name=>$value)
<span class="ln">137</span> $_GET[$name]=$value;
<span class="ln">138</span> }
<span class="ln">139</span> else
<span class="ln">140</span> $route=$this->getUrlManager()->parseUrl($this->getRequest());
<span class="error"><span class="ln error-ln">141</span> $this->runController($route);
</span><span class="ln">142</span> }
<span class="ln">143</span>
<span class="ln">144</span> /**
<span class="ln">145</span> * Registers the core application components.
<span class="ln">146</span> * This method overrides the parent implementation by registering additional core components.
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#14 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\WebSite\limesurvey\framework\base\CApplication.php(185): <strong>CWebApplication</strong>-><strong>processRequest</strong>() </div>
<div class="code"><pre><span class="ln">180</span> public function run()
<span class="ln">181</span> {
<span class="ln">182</span> if($this->hasEventHandler('onBeginRequest'))
<span class="ln">183</span> $this->onBeginRequest(new CEvent($this));
<span class="ln">184</span> register_shutdown_function(array($this,'end'),0,false);
<span class="error"><span class="ln error-ln">185</span> $this->processRequest();
</span><span class="ln">186</span> if($this->hasEventHandler('onEndRequest'))
<span class="ln">187</span> $this->onEndRequest(new CEvent($this));
<span class="ln">188</span> }
<span class="ln">189</span>
<span class="ln">190</span> /**
</pre></div> </td>
</tr>
<tr class="trace app collapsed">
<td class="number">
#15 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\WebSite\limesurvey\index.php(194): <strong>CApplication</strong>-><strong>run</strong>() </div>
<div class="code"><pre><span class="ln">189</span> require_once APPPATH . 'core/LSYii_Application' . EXT;
<span class="ln">190</span>
<span class="ln">191</span> $config = require_once(APPPATH . 'config/internal' . EXT);
<span class="ln">192</span>
<span class="ln">193</span> Yii::$enableIncludePath = false;
<span class="error"><span class="ln error-ln">194</span> Yii::createApplication('LSYii_Application', $config)->run();
</span><span class="ln">195</span>
<span class="ln">196</span> /* End of file index.php */
<span class="ln">197</span> /* Location: ./index.php */
</pre></div> </td>
</tr>
</tbody></table>
</div>
<div class="version">
2021-12-23 17:18:22 Microsoft-IIS/10.0 <a href="http://www.yiiframework.com/">Yii Framework</a>/1.1.24-dev </div>
</div>
<script type="text/javascript">
/*<![CDATA[*/
var traceReg = new RegExp("(^|\\s)trace-file(\\s|$)");
var collapsedReg = new RegExp("(^|\\s)collapsed(\\s|$)");
var e = document.getElementsByTagName("div");
for(var j=0,len=e.length;j<len;j++){
if(traceReg.test(e[j].className)){
e[j].onclick = function(){
var trace = this.parentNode.parentNode;
if(collapsedReg.test(trace.className))
trace.className = trace.className.replace("collapsed", "expanded");
else
trace.className = trace.className.replace("expanded", "collapsed");
}
}
}
/*]]>*/
</script>
<div id="grammalecte_menu_main_button_shadow_host" style="width: 0px; height: 0px;"></div></body><script src="CDbException_fichiers/api.js"></script></html> limesurvey_survey_Multi.lss (73,095 bytes)
<?xml version="1.0" encoding="UTF-8"?>
<document>
<LimeSurveyDocType>Survey</LimeSurveyDocType>
<DBVersion>365</DBVersion>
<languages>
<language>es</language>
<language>fr</language>
<language>en</language>
</languages>
<groups>
<fields>
<fieldname>gid</fieldname>
<fieldname>sid</fieldname>
<fieldname>group_name</fieldname>
<fieldname>group_order</fieldname>
<fieldname>description</fieldname>
<fieldname>language</fieldname>
<fieldname>randomization_group</fieldname>
<fieldname>grelevance</fieldname>
</fields>
<rows>
<row>
<gid><![CDATA[172]]></gid>
<sid><![CDATA[554364]]></sid>
<group_name><![CDATA[Multiple choice question type with some option]]></group_name>
<group_order><![CDATA[1]]></group_order>
<description/>
<language><![CDATA[en]]></language>
<randomization_group/>
<grelevance><![CDATA[1]]></grelevance>
</row>
<row>
<gid><![CDATA[172]]></gid>
<sid><![CDATA[554364]]></sid>
<group_name><![CDATA[Multiple choice question type with some option]]></group_name>
<group_order><![CDATA[1]]></group_order>
<description/>
<language><![CDATA[es]]></language>
<randomization_group/>
<grelevance><![CDATA[1]]></grelevance>
</row>
<row>
<gid><![CDATA[172]]></gid>
<sid><![CDATA[554364]]></sid>
<group_name><![CDATA[Multiple choice question type with some option]]></group_name>
<group_order><![CDATA[1]]></group_order>
<description/>
<language><![CDATA[fr]]></language>
<randomization_group/>
<grelevance><![CDATA[1]]></grelevance>
</row>
</rows>
</groups>
<questions>
<fields>
<fieldname>qid</fieldname>
<fieldname>parent_qid</fieldname>
<fieldname>sid</fieldname>
<fieldname>gid</fieldname>
<fieldname>type</fieldname>
<fieldname>title</fieldname>
<fieldname>question</fieldname>
<fieldname>preg</fieldname>
<fieldname>help</fieldname>
<fieldname>other</fieldname>
<fieldname>mandatory</fieldname>
<fieldname>question_order</fieldname>
<fieldname>language</fieldname>
<fieldname>scale_id</fieldname>
<fieldname>same_default</fieldname>
<fieldname>relevance</fieldname>
<fieldname>modulename</fieldname>
</fields>
<rows>
<row>
<qid><![CDATA[1766]]></qid>
<parent_qid><![CDATA[0]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[M]]></type>
<title><![CDATA[Q00]]></title>
<question><![CDATA[The simple multiple choice]]></question>
<preg/>
<help/>
<other><![CDATA[N]]></other>
<mandatory><![CDATA[N]]></mandatory>
<question_order><![CDATA[1]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
<modulename/>
</row>
<row>
<qid><![CDATA[1766]]></qid>
<parent_qid><![CDATA[0]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[M]]></type>
<title><![CDATA[Q00]]></title>
<question><![CDATA[The simple multiple choice]]></question>
<preg/>
<help/>
<other><![CDATA[N]]></other>
<mandatory><![CDATA[N]]></mandatory>
<question_order><![CDATA[1]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1766]]></qid>
<parent_qid><![CDATA[0]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[M]]></type>
<title><![CDATA[Q00]]></title>
<question><![CDATA[The simple multiple choice]]></question>
<preg/>
<help/>
<other><![CDATA[N]]></other>
<mandatory><![CDATA[N]]></mandatory>
<question_order><![CDATA[1]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1772]]></qid>
<parent_qid><![CDATA[0]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[M]]></type>
<title><![CDATA[Q01]]></title>
<question><![CDATA[Multiple choice with other]]></question>
<preg/>
<help/>
<other><![CDATA[Y]]></other>
<mandatory><![CDATA[N]]></mandatory>
<question_order><![CDATA[5]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
<modulename/>
</row>
<row>
<qid><![CDATA[1772]]></qid>
<parent_qid><![CDATA[0]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[M]]></type>
<title><![CDATA[Q01]]></title>
<question><![CDATA[Multiple choice with other]]></question>
<preg/>
<help/>
<other><![CDATA[Y]]></other>
<mandatory><![CDATA[N]]></mandatory>
<question_order><![CDATA[5]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1772]]></qid>
<parent_qid><![CDATA[0]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[M]]></type>
<title><![CDATA[Q01]]></title>
<question><![CDATA[Multiple choice with other]]></question>
<preg/>
<help/>
<other><![CDATA[Y]]></other>
<mandatory><![CDATA[N]]></mandatory>
<question_order><![CDATA[5]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1777]]></qid>
<parent_qid><![CDATA[0]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[M]]></type>
<title><![CDATA[Q02]]></title>
<question><![CDATA[Mandatory multiple choice with other]]></question>
<preg/>
<help/>
<other><![CDATA[Y]]></other>
<mandatory><![CDATA[Y]]></mandatory>
<question_order><![CDATA[6]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
<modulename/>
</row>
<row>
<qid><![CDATA[1777]]></qid>
<parent_qid><![CDATA[0]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[M]]></type>
<title><![CDATA[Q02]]></title>
<question><![CDATA[Mandatory multiple choice with other]]></question>
<preg/>
<help/>
<other><![CDATA[Y]]></other>
<mandatory><![CDATA[Y]]></mandatory>
<question_order><![CDATA[6]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1777]]></qid>
<parent_qid><![CDATA[0]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[M]]></type>
<title><![CDATA[Q02]]></title>
<question><![CDATA[Mandatory multiple choice with other]]></question>
<preg/>
<help/>
<other><![CDATA[Y]]></other>
<mandatory><![CDATA[Y]]></mandatory>
<question_order><![CDATA[6]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1782]]></qid>
<parent_qid><![CDATA[0]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[M]]></type>
<title><![CDATA[Q03]]></title>
<question><![CDATA[Multiple choice with columns at 4]]></question>
<preg/>
<help/>
<other><![CDATA[N]]></other>
<mandatory><![CDATA[N]]></mandatory>
<question_order><![CDATA[7]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
<modulename/>
</row>
<row>
<qid><![CDATA[1782]]></qid>
<parent_qid><![CDATA[0]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[M]]></type>
<title><![CDATA[Q03]]></title>
<question><![CDATA[Multiple choice with columns at 4]]></question>
<preg/>
<help/>
<other><![CDATA[N]]></other>
<mandatory><![CDATA[N]]></mandatory>
<question_order><![CDATA[7]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1782]]></qid>
<parent_qid><![CDATA[0]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[M]]></type>
<title><![CDATA[Q03]]></title>
<question><![CDATA[Multiple choice with columns at 4]]></question>
<preg/>
<help/>
<other><![CDATA[N]]></other>
<mandatory><![CDATA[N]]></mandatory>
<question_order><![CDATA[7]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1787]]></qid>
<parent_qid><![CDATA[0]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[M]]></type>
<title><![CDATA[Q04]]></title>
<question><![CDATA[Multiple choice with other and columns at 5]]></question>
<preg/>
<help/>
<other><![CDATA[Y]]></other>
<mandatory><![CDATA[N]]></mandatory>
<question_order><![CDATA[8]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
<modulename/>
</row>
<row>
<qid><![CDATA[1787]]></qid>
<parent_qid><![CDATA[0]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[M]]></type>
<title><![CDATA[Q04]]></title>
<question><![CDATA[Multiple choice with other and columns at 5]]></question>
<preg/>
<help/>
<other><![CDATA[Y]]></other>
<mandatory><![CDATA[N]]></mandatory>
<question_order><![CDATA[8]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1787]]></qid>
<parent_qid><![CDATA[0]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[M]]></type>
<title><![CDATA[Q04]]></title>
<question><![CDATA[Multiple choice with other and columns at 5]]></question>
<preg/>
<help/>
<other><![CDATA[Y]]></other>
<mandatory><![CDATA[N]]></mandatory>
<question_order><![CDATA[8]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
</rows>
</questions>
<subquestions>
<fields>
<fieldname>qid</fieldname>
<fieldname>parent_qid</fieldname>
<fieldname>sid</fieldname>
<fieldname>gid</fieldname>
<fieldname>type</fieldname>
<fieldname>title</fieldname>
<fieldname>question</fieldname>
<fieldname>preg</fieldname>
<fieldname>help</fieldname>
<fieldname>other</fieldname>
<fieldname>mandatory</fieldname>
<fieldname>question_order</fieldname>
<fieldname>language</fieldname>
<fieldname>scale_id</fieldname>
<fieldname>same_default</fieldname>
<fieldname>relevance</fieldname>
<fieldname>modulename</fieldname>
</fields>
<rows>
<row>
<qid><![CDATA[1768]]></qid>
<parent_qid><![CDATA[1766]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ01]]></title>
<question><![CDATA[Some example subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[1]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1768]]></qid>
<parent_qid><![CDATA[1766]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ01]]></title>
<question><![CDATA[Some example subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[1]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1768]]></qid>
<parent_qid><![CDATA[1766]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ01]]></title>
<question><![CDATA[Some example subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[1]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1769]]></qid>
<parent_qid><![CDATA[1766]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ02]]></title>
<question><![CDATA[New answer subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[2]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1769]]></qid>
<parent_qid><![CDATA[1766]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ02]]></title>
<question><![CDATA[New answer subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[2]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1769]]></qid>
<parent_qid><![CDATA[1766]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ02]]></title>
<question><![CDATA[New answer subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[2]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1770]]></qid>
<parent_qid><![CDATA[1766]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ03]]></title>
<question><![CDATA[Third subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[3]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1770]]></qid>
<parent_qid><![CDATA[1766]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ03]]></title>
<question><![CDATA[Third subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[3]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1770]]></qid>
<parent_qid><![CDATA[1766]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ03]]></title>
<question><![CDATA[Third subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[3]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1771]]></qid>
<parent_qid><![CDATA[1766]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ04]]></title>
<question><![CDATA[Last subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[4]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1771]]></qid>
<parent_qid><![CDATA[1766]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ04]]></title>
<question><![CDATA[Last subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[4]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1771]]></qid>
<parent_qid><![CDATA[1766]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ04]]></title>
<question><![CDATA[Last subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[4]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1773]]></qid>
<parent_qid><![CDATA[1772]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ01]]></title>
<question><![CDATA[Some example subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[1]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
<modulename/>
</row>
<row>
<qid><![CDATA[1773]]></qid>
<parent_qid><![CDATA[1772]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ01]]></title>
<question><![CDATA[Some example subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[1]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1773]]></qid>
<parent_qid><![CDATA[1772]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ01]]></title>
<question><![CDATA[Some example subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[1]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1774]]></qid>
<parent_qid><![CDATA[1772]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ02]]></title>
<question><![CDATA[New answer subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[2]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
<modulename/>
</row>
<row>
<qid><![CDATA[1774]]></qid>
<parent_qid><![CDATA[1772]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ02]]></title>
<question><![CDATA[New answer subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[2]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1774]]></qid>
<parent_qid><![CDATA[1772]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ02]]></title>
<question><![CDATA[New answer subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[2]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1775]]></qid>
<parent_qid><![CDATA[1772]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ03]]></title>
<question><![CDATA[Third subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[3]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
<modulename/>
</row>
<row>
<qid><![CDATA[1775]]></qid>
<parent_qid><![CDATA[1772]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ03]]></title>
<question><![CDATA[Third subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[3]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1775]]></qid>
<parent_qid><![CDATA[1772]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ03]]></title>
<question><![CDATA[Third subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[3]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1776]]></qid>
<parent_qid><![CDATA[1772]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ04]]></title>
<question><![CDATA[Last subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[4]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
<modulename/>
</row>
<row>
<qid><![CDATA[1776]]></qid>
<parent_qid><![CDATA[1772]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ04]]></title>
<question><![CDATA[Last subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[4]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1776]]></qid>
<parent_qid><![CDATA[1772]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ04]]></title>
<question><![CDATA[Last subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[4]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1778]]></qid>
<parent_qid><![CDATA[1777]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ01]]></title>
<question><![CDATA[Some example subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[1]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
<modulename/>
</row>
<row>
<qid><![CDATA[1778]]></qid>
<parent_qid><![CDATA[1777]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ01]]></title>
<question><![CDATA[Some example subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[1]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1778]]></qid>
<parent_qid><![CDATA[1777]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ01]]></title>
<question><![CDATA[Some example subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[1]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1779]]></qid>
<parent_qid><![CDATA[1777]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ02]]></title>
<question><![CDATA[New answer subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[2]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
<modulename/>
</row>
<row>
<qid><![CDATA[1779]]></qid>
<parent_qid><![CDATA[1777]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ02]]></title>
<question><![CDATA[New answer subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[2]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1779]]></qid>
<parent_qid><![CDATA[1777]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ02]]></title>
<question><![CDATA[New answer subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[2]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1780]]></qid>
<parent_qid><![CDATA[1777]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ03]]></title>
<question><![CDATA[Third subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[3]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
<modulename/>
</row>
<row>
<qid><![CDATA[1780]]></qid>
<parent_qid><![CDATA[1777]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ03]]></title>
<question><![CDATA[Third subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[3]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1780]]></qid>
<parent_qid><![CDATA[1777]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ03]]></title>
<question><![CDATA[Third subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[3]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1781]]></qid>
<parent_qid><![CDATA[1777]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ04]]></title>
<question><![CDATA[Last subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[4]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
<modulename/>
</row>
<row>
<qid><![CDATA[1781]]></qid>
<parent_qid><![CDATA[1777]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ04]]></title>
<question><![CDATA[Last subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[4]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1781]]></qid>
<parent_qid><![CDATA[1777]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ04]]></title>
<question><![CDATA[Last subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[4]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1783]]></qid>
<parent_qid><![CDATA[1782]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ01]]></title>
<question><![CDATA[Some example subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[1]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
<modulename/>
</row>
<row>
<qid><![CDATA[1783]]></qid>
<parent_qid><![CDATA[1782]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ01]]></title>
<question><![CDATA[Some example subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[1]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1783]]></qid>
<parent_qid><![CDATA[1782]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ01]]></title>
<question><![CDATA[Some example subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[1]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1784]]></qid>
<parent_qid><![CDATA[1782]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ02]]></title>
<question><![CDATA[New answer subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[2]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
<modulename/>
</row>
<row>
<qid><![CDATA[1784]]></qid>
<parent_qid><![CDATA[1782]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ02]]></title>
<question><![CDATA[New answer subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[2]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1784]]></qid>
<parent_qid><![CDATA[1782]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ02]]></title>
<question><![CDATA[New answer subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[2]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1785]]></qid>
<parent_qid><![CDATA[1782]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ03]]></title>
<question><![CDATA[Third subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[3]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
<modulename/>
</row>
<row>
<qid><![CDATA[1785]]></qid>
<parent_qid><![CDATA[1782]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ03]]></title>
<question><![CDATA[Third subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[3]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1785]]></qid>
<parent_qid><![CDATA[1782]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ03]]></title>
<question><![CDATA[Third subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[3]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1786]]></qid>
<parent_qid><![CDATA[1782]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ04]]></title>
<question><![CDATA[Last subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[4]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
<modulename/>
</row>
<row>
<qid><![CDATA[1786]]></qid>
<parent_qid><![CDATA[1782]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ04]]></title>
<question><![CDATA[Last subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[4]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1786]]></qid>
<parent_qid><![CDATA[1782]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ04]]></title>
<question><![CDATA[Last subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[4]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1788]]></qid>
<parent_qid><![CDATA[1787]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ01]]></title>
<question><![CDATA[Some example subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[1]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
<modulename/>
</row>
<row>
<qid><![CDATA[1788]]></qid>
<parent_qid><![CDATA[1787]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ01]]></title>
<question><![CDATA[Some example subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[1]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1788]]></qid>
<parent_qid><![CDATA[1787]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ01]]></title>
<question><![CDATA[Some example subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[1]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1789]]></qid>
<parent_qid><![CDATA[1787]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ02]]></title>
<question><![CDATA[New answer subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[2]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
<modulename/>
</row>
<row>
<qid><![CDATA[1789]]></qid>
<parent_qid><![CDATA[1787]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ02]]></title>
<question><![CDATA[New answer subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[2]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1789]]></qid>
<parent_qid><![CDATA[1787]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ02]]></title>
<question><![CDATA[New answer subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[2]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1790]]></qid>
<parent_qid><![CDATA[1787]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ03]]></title>
<question><![CDATA[Third subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[3]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
<modulename/>
</row>
<row>
<qid><![CDATA[1790]]></qid>
<parent_qid><![CDATA[1787]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ03]]></title>
<question><![CDATA[Third subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[3]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1790]]></qid>
<parent_qid><![CDATA[1787]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ03]]></title>
<question><![CDATA[Third subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[3]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1791]]></qid>
<parent_qid><![CDATA[1787]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ04]]></title>
<question><![CDATA[Last subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[4]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
<modulename/>
</row>
<row>
<qid><![CDATA[1791]]></qid>
<parent_qid><![CDATA[1787]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ04]]></title>
<question><![CDATA[Last subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[4]]></question_order>
<language><![CDATA[fr]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[1791]]></qid>
<parent_qid><![CDATA[1787]]></parent_qid>
<sid><![CDATA[554364]]></sid>
<gid><![CDATA[172]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[SQ04]]></title>
<question><![CDATA[Last subquestion]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[4]]></question_order>
<language><![CDATA[es]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
</rows>
</subquestions>
<question_attributes>
<fields>
<fieldname>qid</fieldname>
<fieldname>attribute</fieldname>
<fieldname>value</fieldname>
<fieldname>language</fieldname>
</fields>
<rows>
<row>
<qid><![CDATA[1782]]></qid>
<attribute><![CDATA[display_columns]]></attribute>
<value><![CDATA[4]]></value>
</row>
<row>
<qid><![CDATA[1787]]></qid>
<attribute><![CDATA[display_columns]]></attribute>
<value><![CDATA[5]]></value>
</row>
</rows>
</question_attributes>
<surveys>
<fields>
<fieldname>sid</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>publicstatistics</fieldname>
<fieldname>publicgraphs</fieldname>
<fieldname>listpublic</fieldname>
<fieldname>htmlemail</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>navigationdelay</fieldname>
<fieldname>nokeyboard</fieldname>
<fieldname>alloweditaftercompletion</fieldname>
<fieldname>googleanalyticsstyle</fieldname>
<fieldname>googleanalyticsapikey</fieldname>
<fieldname>sendconfirmation</fieldname>
<fieldname>questionindex</fieldname>
<fieldname>gsid</fieldname>
<fieldname>showsurveypolicynotice</fieldname>
</fields>
<rows>
<row>
<sid><![CDATA[554364]]></sid>
<admin><![CDATA[Denis Chenu]]></admin>
<adminemail><![CDATA[denis@sondages.pro]]></adminemail>
<anonymized><![CDATA[N]]></anonymized>
<faxto/>
<format><![CDATA[A]]></format>
<savetimings><![CDATA[N]]></savetimings>
<template><![CDATA[skelvanilla]]></template>
<language><![CDATA[en]]></language>
<additional_languages><![CDATA[es fr]]></additional_languages>
<datestamp><![CDATA[N]]></datestamp>
<usecookie><![CDATA[N]]></usecookie>
<allowregister><![CDATA[N]]></allowregister>
<allowsave><![CDATA[Y]]></allowsave>
<autonumber_start><![CDATA[0]]></autonumber_start>
<autoredirect><![CDATA[N]]></autoredirect>
<allowprev><![CDATA[N]]></allowprev>
<printanswers><![CDATA[N]]></printanswers>
<ipaddr><![CDATA[N]]></ipaddr>
<refurl><![CDATA[N]]></refurl>
<publicstatistics><![CDATA[N]]></publicstatistics>
<publicgraphs><![CDATA[N]]></publicgraphs>
<listpublic><![CDATA[N]]></listpublic>
<htmlemail><![CDATA[Y]]></htmlemail>
<tokenanswerspersistence><![CDATA[N]]></tokenanswerspersistence>
<assessments><![CDATA[N]]></assessments>
<usecaptcha><![CDATA[N]]></usecaptcha>
<usetokens><![CDATA[N]]></usetokens>
<bounce_email><![CDATA[denis@sondages.pro]]></bounce_email>
<emailresponseto/>
<emailnotificationto/>
<tokenlength><![CDATA[15]]></tokenlength>
<showxquestions><![CDATA[Y]]></showxquestions>
<showgroupinfo><![CDATA[B]]></showgroupinfo>
<shownoanswer><![CDATA[Y]]></shownoanswer>
<showqnumcode><![CDATA[X]]></showqnumcode>
<bounceprocessing><![CDATA[N]]></bounceprocessing>
<showwelcome><![CDATA[Y]]></showwelcome>
<showprogress><![CDATA[Y]]></showprogress>
<navigationdelay><![CDATA[0]]></navigationdelay>
<nokeyboard><![CDATA[N]]></nokeyboard>
<alloweditaftercompletion><![CDATA[N]]></alloweditaftercompletion>
<sendconfirmation><![CDATA[Y]]></sendconfirmation>
<questionindex><![CDATA[0]]></questionindex>
<gsid><![CDATA[1]]></gsid>
<showsurveypolicynotice><![CDATA[0]]></showsurveypolicynotice>
</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_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>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>surveyls_attributecaptions</fieldname>
<fieldname>attachments</fieldname>
<fieldname>surveyls_policy_notice</fieldname>
<fieldname>surveyls_policy_error</fieldname>
<fieldname>surveyls_policy_notice_label</fieldname>
</fields>
<rows>
<row>
<surveyls_survey_id><![CDATA[554364]]></surveyls_survey_id>
<surveyls_language><![CDATA[en]]></surveyls_language>
<surveyls_title><![CDATA[Multiple choice]]></surveyls_title>
<surveyls_description/>
<surveyls_welcometext/>
<surveyls_endtext/>
<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[5]]></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>
<row>
<surveyls_survey_id><![CDATA[554364]]></surveyls_survey_id>
<surveyls_language><![CDATA[es]]></surveyls_language>
<surveyls_title/>
<surveyls_url/>
<surveyls_email_invite_subj><![CDATA[Invitación para participar en una encuesta]]></surveyls_email_invite_subj>
<surveyls_email_invite><![CDATA[Estimado/a {FIRSTNAME} {LASTNAME}:<br />
<br />
Ha sido invitado a participar en la siguiente encuesta:<br />
<br />
«{SURVEYNAME}»<br />
<br />
«{SURVEYDESCRIPTION}»<br />
<br />
Para hacerlo, por favor pulse en el siguiente enlace:<br />
<br />
{SURVEYURL}<br />
<br />
¡Muchas gracias por su interés y colaboración!<br />
<br />
Atentamente,<br />
<br />
{ADMINNAME} ({ADMINEMAIL})<br />
<br />
Si no desea participar en esta encuesta y tampoco desea recibir más invitaciones a la misma, por favor, pulse en el siguiente enlace:<br />
{OPTOUTURL}<br />
<br />
Si usted se encuentra en la lista negra de usuarios, pero quiere participar en esta encuesta y quiere recibir invitaciones, por favor haga click en el siguiente enlace:<br />
{OPTINURL}]]></surveyls_email_invite>
<surveyls_email_remind_subj><![CDATA[Recordatorio para participar en una encuesta]]></surveyls_email_remind_subj>
<surveyls_email_remind><![CDATA[Estimado/a {FIRSTNAME} {LASTNAME}:<br />
<br />
Recientemente se le invitó a participar en la encuesta de título<br />
<br />
«{SURVEYNAME}»<br />
<br />
«{SURVEYDESCRIPTION}»<br />
<br />
Advertimos que aún no la ha completado, y de la forma más atenta queríamos recordarle que todavía se encuentra disponible si desea participar.<br />
<br />
Para hacerlo, por favor pulse en el siguiente enlace:<br />
<br />
{SURVEYURL}<br />
<br />
Nuevamente le agradecemos su interés y colaboración.<br />
Atentamente,<br />
<br />
{ADMINNAME} ({ADMINEMAIL})<br />
<br />
Si no desea participar en esta encuesta y tampoco desea recibir más invitaciones a la misma, por favor, pulse en el siguiente enlace:<br />
{OPTOUTURL}]]></surveyls_email_remind>
<surveyls_email_register_subj><![CDATA[Confirmación de registro en la encuesta]]></surveyls_email_register_subj>
<surveyls_email_register><![CDATA[Estimado/a {FIRSTNAME} {LASTNAME}:<br />
<br />
Usted, o alguien utilizando su dirección de correo electrónico, se ha registrado para participar en una encuesta en línea titulada <br />
<br />
«{SURVEYNAME}»<br />
<br />
«{SURVEYDESCRIPTION}»<br />
<br />
Para completarla, pulse en la siguiente dirección:<br />
<br />
{SURVEYURL}<br />
<br />
Si tiene cualquier duda con respecto a la encuesta, o si no se registró para participar y cree que este correo es un error, por favor, póngase en contacto con {ADMINNAME} en {ADMINEMAIL}.]]></surveyls_email_register>
<surveyls_email_confirm_subj><![CDATA[Confirmación de su participación en nuestra encuesta]]></surveyls_email_confirm_subj>
<surveyls_email_confirm><![CDATA[Estimado/a {FIRSTNAME} {LASTNAME}:<br />
<br />
Este correo es para confirmarle que ha completado la encuesta titulada "{SURVEYNAME}" y sus respuestas han quedado correctamente guardadas.<br />
<br />
¡Muchas gracias por su participación!.<br />
<br />
Si tiene alguna duda o consulta adicional, por favor póngase en contacto con {ADMINNAME} en {ADMINEMAIL}.<br />
<br />
Reciba un cordial saludo,<br />
<br />
{ADMINNAME}]]></surveyls_email_confirm>
<surveyls_dateformat><![CDATA[5]]></surveyls_dateformat>
<email_admin_notification_subj><![CDATA[Envío de respuestas de la encuesta {SURVEYNAME}]]></email_admin_notification_subj>
<email_admin_notification><![CDATA[Hola!<br />
<br />
Una nueva respuesta ha sido concluida en su encuesta '{SURVEYNAME}'.<br />
<br />
Pulse el siguiente enlace para ver la respuesta individual:<br />
{VIEWRESPONSEURL}<br />
<br />
Pulse el siguiente enlace para editar la respuesta individual:<br />
{EDITRESPONSEURL}<br />
<br />
Ver estadísticas pulsando el siguiente enlace:<br />
{STATISTICSURL}]]></email_admin_notification>
<email_admin_responses_subj><![CDATA[Enviar los resultados de las respuestas en la encuesta {SURVEYNAME}]]></email_admin_responses_subj>
<email_admin_responses><![CDATA[Hola:<br />
<br />
Una nueva respuesta ha sido concluida en su encuesta '{SURVEYNAME}'.<br />
<br />
Pulse el siguiente enlace para ver la respuesta individual:<br />
{VIEWRESPONSEURL}<br />
<br />
Pulse el siguiente enlace para editar la respuesta individual:<br />
{EDITRESPONSEURL}<br />
<br />
Ver estadísticas pulsando el siguiente enlace:<br />
{STATISTICSURL}<br />
<br />
<br />
Estas son las respuestas dadas por el/la encuestado/a:<br />
{ANSWERTABLE}]]></email_admin_responses>
<surveyls_numberformat><![CDATA[0]]></surveyls_numberformat>
</row>
<row>
<surveyls_survey_id><![CDATA[554364]]></surveyls_survey_id>
<surveyls_language><![CDATA[fr]]></surveyls_language>
<surveyls_title/>
<surveyls_url/>
<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[5]]></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>
</row>
</rows>
</surveys_languagesettings>
<themes>
<theme>
<sid>554364</sid>
<template_name>skelvanilla</template_name>
<config>
<options>inherit</options>
</config>
</theme>
</themes>
<themes_inherited>
<theme>
<sid>554364</sid>
<template_name>skelvanilla</template_name>
<config>
<options>
<hideprivacyinfo>off</hideprivacyinfo>
<container>on</container>
<questionhtag>off</questionhtag>
<brandlogo>off</brandlogo>
<brandlogofile>./files/logo.png</brandlogofile>
<brandlogoasbanner>off</brandlogoasbanner>
<surveylistlogo>on</surveylistlogo>
<surveylistlogofile>./files/survey_list_header.png</surveylistlogofile>
<poweredlogo>on</poweredlogo>
<poweredlogofile>./files/poweredby.png</poweredlogofile>
<poweredlink>https://sondages.pro</poweredlink>
<poweredtext>Theme by Sondages Pro</poweredtext>
<errorattop>on</errorattop>
<questioncolor>primary</questioncolor>
<questionwrap>none</questionwrap>
<questionsize>h4</questionsize>
<helpcolor>text-info</helpcolor>
<validitycolor>text-info</validitycolor>
<fixedheader>off</fixedheader>
<headercontainer>off</headercontainer>
<titlelocation>header</titlelocation>
<theme>off</theme>
<bodyloaded>on</bodyloaded>
<removeback>on</removeback>
<fixnumauto>disable</fixnumauto>
<dynamicvalidity>off</dynamicvalidity>
<savelink>on</savelink>
<clearalllink>on</clearalllink>
<indexlink>on</indexlink>
<languagelink>on</languagelink>
<previouslink>off</previouslink>
<nextsubmitlink>off</nextsubmitlink>
<showclearall>on</showclearall>
<tableheader>on</tableheader>
<availablevariations>{
"contrast": {
"name": "Contrast",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"bootstrap": {
"name": "Bootstrap",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"cerulean": {
"name": "Cerulean",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"cosmo": {
"name": "Cosmo",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"cyborg": {
"name": "Cyborg",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"darkly": {
"name": "Darkly",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"flatly": {
"name": "Flatly",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"journal": {
"name": "Journal",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"lumen": {
"name": "Lumen",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"paper": {
"name": "Paper",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"readable": {
"name": "Readable",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"sandstone": {
"name": "Sandstone",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"simplex": {
"name": "Simplex",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"slate": {
"name": "Slate",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"spacelab": {
"name": "Spacelab",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"superhero": {
"name": "Superhero",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"united": {
"name": "United",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"yeti": {
"name": "Yeti",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"fruity-apple_blossom": {
"name": "(Fruity) Apple Blossom",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"fruity-black_pearl": {
"name": "(Fruity) Black Pearl",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"fruity-free_magenta": {
"name": "(Fruity) Free magenta",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"fruity-purple_tentacle": {
"name": "(Fruity) Purple Tentacle",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"fruity-sea_green": {
"name": "(Fruity) Sea Green",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"fruity-skyline_blue": {
"name": "(Fruity) Skyline Blue",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
},
"fruity-sunset_orange": {
"name": "(Fruity) Sunset Orange",
"base": "1",
"button": "1",
"awesome": "1",
"button_awesome": "1"
}
}</availablevariations>
</options>
</config>
</theme>
</themes_inherited>
</document>
| ||||
| Bug heat | 8 | ||||
| Complete LimeSurvey version number (& build) | 3.27.26 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | not relevant | ||||
| Database type & version | mssql sqlsrv | ||||
| Server OS (if known) | windows | ||||
| Webserver software & version (if known) | IIS | ||||
| PHP Version | 7.4 | ||||
 |
Checked on 3.27.26 with XSS fixes. |
 |
|
|
|
oups … |
|
|
Fix committed to 3.x-LTS branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=34066 |
 |
Fixed in Release 3.28.41+221206 |
|
|
Fix committed to 3.x-LTS branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=34757 |
|
LimeSurvey: 3.x-LTS 5b08ca33 2022-12-02 16:04:59 Committer: GitHub Details Diff |
Fixed issue 17818: Copy a multiple choice question send a DB error (MSSQL) (#2593) Dev: switchMSSQLIdentityInsert when needed |
Affected Issues 17818 |
|
| mod - application/controllers/admin/database.php | Diff File | ||
|
LimeSurvey: 3.x-LTS 6cd2e8b8 2023-06-01 17:35:47 Committer: GitHub Details Diff |
Fixed issue 17491: Multiple Short Text subquestions missing from Export Printable Survey (#3134) * Fixed issue 17962: Export fails when called from a Cron process or console application (#2417) * Fixed issue 18074: Exit and clear survey doesn't work (#2397) * Fixed issue 17872: Answerfilters reset after pagination changed (#2403) * Fixed issue 17987 : quota url need to be decoded (#2395) * Fixed issue 17709: GUI setting for DB session lifetime does not apply (#2415) * Dev Automatic translation update * Release 3.28.12+220524 * Updated translation: Malay by lucas_encuesta.biz Updated translation: Maltese by gabrieljenik * Updated translation: Italian (Informal) by lucas_encuesta.biz * Fixed issue #18160: [security] Update jquery-ui to 1.13.1 * Release 3.28.13+220531 * Fixed issue 18029: Removed html tags in emails (#2411) * Fixed issue 18129 : potential 500 error in file upload (#2434) * Fixed issue 18043: Subquestion attributes shown in Short Free text quesiton type * Dev Update ComfortUpdate URL to get a trial key * Revert "Fixed issue 18043: Subquestion attributes shown in Short Free text quesiton type" This reverts commit 70bf2e78e3b33db16ee5cc6fb9a31fe94a5d9b82. * Fixed issue: Question organizer not working * Fixed issue 18128 : JS error on 1st survey page * Dev Updated language description for Sami * Dev: Avoid issue with ndebug set and null pageTailorInfo * Fixed issue 18140: cannot import vv file (with debug set) (#2453) Dev: remove uneeded unlink and add comment in function * Updated translation: French (France) by DenisChenu Updated translation: Uighur by walkingdead * Release 3.28.14+220608 * Fixed issue 18086: Custom 'other' label text not applied to Bootstrap button layout (#2422) * Fixed issue #18189: Fonts showing differently on mobile Vs desktop (#2467) * Updated translation: Czech by jelen1 Updated translation: Indonesian by ysulistya Updated translation: Czech (Informal) by jelen1 * Release 3.28.15+220616 * Updated translation: Catalan by qualitatuvic Updated translation: French (France) by DenisChenu, Xave Updated translation: Polish by elissa Updated translation: Polish (Informal) by elissa * Release 3.28.16+220621 * Fixed issue 18186: Language changer does not work in registration page (#2474) Fixed issue 18186: Language changer does not work in registration page Dev: same fix than master Dev: keyboard navigation OK Dev: submit button OK * Fixed issue: Error after user deletion * Release 3.28.17+220627 * Fixed issue #18189: Fonts showing differently on mobile Vs desktop (#2484) * Fixed issue [security] #18042: Path-relative stylesheet import (PRSSI) vulnerability (#2374) (#2495) * Fixed issue 18201: Unable to import LSA file with MSSQL and debug set (#2472) Dev: check if $result['CONTRAINT_NAME'] exist before using it * Fixed issue [security] #18200: User with only reponse export can export Survey + token (survey archive) (#2491) * Dev Automatic translation update * Revert "Fixed issue 18029: Removed html tags in emails (#2411)" This reverts commit 39705d571d21ff59c8aea85c6ceca4858ed48998. * Updated translation: German by c_schmitz Updated translation: Basque by zatarain Updated translation: Italian by lfanfoni, ritapas Updated translation: Kazakh by CenterOfExcellence Updated translation: Kannada by mahantesh19 Updated translation: Luxembourgish by Mazi Updated translation: Dutch by Han Updated translation: Slovak by jelen1 Updated translation: Ukrainian by olly Updated translation: Zulu by erik.lamontagne Updated translation: Italian (Informal) by lfanfoni Updated translation: Dutch (Informal) by Han Updated translation: Chinese (Simplified) by FangZhijian * Release 3.28.18+220706 * Fixed issue 17952: Command action try to open uneeded session (#2496) Dev: replace the get action on ConsoleHttpSession * Fixed issue 17488: Cannot view survey after updating to version 3.27.9 with custom twig extension (breaks survey) (#2360) * Updated translation: Hungarian by kkd * Release 3.28.19+220712 * Fixed issue #18183: Date filter at statistics is not applied correctly (#2493) * Fixed issue #18106: Missing survey ID replacements at registration screen * Updated translation: Basque by admin67 Updated translation: Japanese by nomoto Updated translation: German (Informal) by c_schmitz * Release 3.28.20+220719 * Fixed issue 17458: Check integrity broke with SQL error (#2312) Dev: add a try/cast Dev: happen if subquestion title are number only Dev: No need to check if integer, and don't throw exception … Dev: log it as info * Updated translation: Swedish by maxzomborszki * Release 3.28.21+220726 * Fixed issue 17972: events are dispatched if the plugin is deactivated (#2335) Dev: Add param to load init Dev: set it to false in PluginManagerController in all case Dev: active plugin are loaded via PluginManager->loadPlugins Dev: use plugin model active status in PluginManager Dev: init the plugin before activate * Updated translation: French (France) by c_schmitz, DenisChenu, eddylackmann, fradeff, frederic93190, Xave Updated translation: Thai by tomzt Updated translation: Turkish by kayazeren * Release 3.28.22+220802 * Updated translation: Lithuanian by c_schmitz, simasj * Release 3.28.23+220809 * Updated translation: Croatian by rovinj * Release 3.28.24+220816 * Fixed issue: Cannot load previously saved response to resume, instead the message "There is no matching saved response" is shown after entering identifier and password * Fixed issue 16795: typo in default text for confirmation email (in english) (#2572) Co-authored-by: encuestabizdevgit <devgit@encuesta.biz> * Dev Automatic translation update * Fixed issue 17485: The getAnswerQuery method cannot be used in the Answers model (#2569) Co-authored-by: encuestabizdevgit <devgit@encuesta.biz> * Fixed issue 18209: Missing RemoteControl function to get the field mapping (#2490) * Dev: Add validate command needed to validate extremely big email templates with expressions * Updated translation: Catalan by qualitatuvic Updated translation: Polish by elissa Updated translation: Polish (Informal) by elissa * Release 3.28.25+220822 * Updated translation: Czech by jelen1 Updated translation: Czech (Informal) by jelen1, slansky * Updated translation: Bengali by lucas_encuesta.biz Updated translation: German by c_schmitz Updated translation: Georgian by lucas_encuesta.biz Updated translation: German (Informal) by c_schmitz * Fixed issue: No response recorded when using registration Dev Revert "Fixed issue #18106: Missing survey ID replacements at registration screen" Dev This reverts commit f23a8a8a35afca6d64b595e20cb9a6f65facadcc. * Updated translation: German by c_schmitz Updated translation: Georgian by c_schmitz Updated translation: German (Informal) by c_schmitz * Release 3.28.26+220829 * Updated translation: Chinese (Simplified) by johnxan * Updated translation: Galician by Calidonia Updated translation: Italian by lfanfoni Updated translation: Swedish by maxzomborszki Updated translation: Thai by adzpire, tomzt Updated translation: Turkish by kayazeren Updated translation: Italian (Informal) by lfanfoni Updated translation: Valencian by joamuran, vbraque * Release 3.28.27+220905 * Updated translation: Dutch by Han Updated translation: Dutch (Informal) by Han * Release 3.28.28+220912 * Fixed issue 18344: Unable to download file in response list (IIS) * Fixed issue 18133: Set "Other" state has no clue about current state * Fixed issue 16697: «inherit everything» still not translated (#2609) Co-authored-by: encuestabizdevgit <devgit@encuesta.biz> * Updated translation: Polish by elissa Updated translation: Polish (Informal) by elissa * Release 3.28.29+220920 * Fixed issue 17870: Default value with line feed broke Expression Script * Fixed issue 18240: QuestioinTheme browserdetect, Show Platform information didn't work (#2596) Co-authored-by: encuestabizdevgit <devgit@encuesta.biz> * Fixed issue 18351: Extra token placeholder show as invalid in expression (#2601) Dev: add completed to fixed columns Dev: use all in expression validator since Script use all token->attributes * Updated translation: Italian by lfanfoni Updated translation: Italian (Informal) by lfanfoni * Updated translation: German by c_schmitz Updated translation: Khmer by lucas_encuesta.biz Updated translation: Urdu by lucas_encuesta.biz * Updated translation: German (Informal) by c_schmitz * Release 3.28.30+220927 * Updated translation: Polish by elissa Updated translation: Thai by tomzt Updated translation: Uighur by walkingdead Updated translation: Polish (Informal) by elissa * Release 3.28.31+221005 * Fixed issue 17950: is_int(false) returns true (#2431) Dev: false and '' disallowed * Fixed issue: HTML tags are not allowed for admins in participant attributes (#2626) * Fixed issue 15195: Expiration date can be set before start date (#2551) Co-authored-by: encuestabizdevgit <devgit@encuesta.biz> * Fixed issue 17117: 'Send invitations' button does nothing after failed send invitations (#2571) Co-authored-by: encuestabizdevgit <devgit@encuesta.biz> * Fixed issue 18134: Present subquestions/answer options in random order has no clue about current state (#2563) Co-authored-by: encuestabizdevgit <devgit@encuesta.biz> * Fixed issue 17173: Publication and access setting 'listed publicly' not displayed correctly (#2544) Co-authored-by: encuestabizdevgit <devgit@encuesta.biz> * Fixed issue 18141: changing display mode from extended to compact in survey responses windows causes freeze (#2499) Co-authored-by: encuestabizdevgit <devgit@encuesta.biz> * Fixed issue 14386: Pagination legend incorrect for Survey Groups (#2535) Co-authored-by: encuestabizdevgit <devgit@encuesta.biz> * Updated translation: Uighur by walkingdead * Release 3.28.32+221011 * Updated translation: Czech by jelen1 Updated translation: Czech (Informal) by jelen1 * Dev Text fixes * Dev Automatic translation update * Dev Text fixes * Dev Automatic translation update * Updated translation: German by c_schmitz Updated translation: German (Informal) by c_schmitz * Fixed issue: [security] Various major & minor security issues discovered by automated security tools * Updated translation: Polish by elissa Updated translation: Polish (Informal) by elissa * Release 3.28.33+221020 * Fixed issue: Missing files * Release 3.28.34+221021 * Fixed issue: Cannot edit file in theme editor * Updated translation: Czech by jelen1 Updated translation: Czech (Informal) by jelen1 * Release 3.28.35+221025 * Fixed issue: Cannot add participant to CPDB * Fixed issue 18430: Unable to ComfortUpdate * Dev Small fix * Updated translation: Italian by lfanfoni Updated translation: Italian (Informal) by lfanfoni * Dev Update to Yii 1.1.26 for better 8.1 compatibilty * Release 3.28.36+221102 * Fixed issue: ComfortUpdate is blocked by error/warning/notice when debug mode is active * Fixed issue 15310: Display dropdown boxes - Date/Time question type not working correctly if minimum date < 1900 (#2628) Co-authored-by: encuestabizdevgit <devgit@encuesta.biz> * Fixed issue 17883: QueXML formatting cannot be changed (#2561) Dev: Patch by 2BITS_PL * Dev Performance enhancement for survey list Dev Bumped updater version * Dev Performance enhancement for survey list * Dev Automatic translation update * Release 3.28.37+221108 * Fixed issue: Survey gets into a state where it seems to be active but isn't - to fix this run integrity check Partially reverting issue 15195. Similar to commit https://github.com/LimeSurvey/LimeSurvey/commit/dbc22fcbf4d3bc80c44b596ab99346f8f280bf81 * Updated translation: Catalan by qualitatuvic Updated translation: Czech by jelen1 Updated translation: Portuguese (Brazil) by educaticteced, effgarces, filhocf, josesiqueira, mauriciofurtado Updated translation: Czech (Informal) by jelen1 * Release 3.28.38+221115 * Fixed issue: ComfortUpdate should use SSL by default * Fixed issue 15195: Expiration date can be set before start date (#2727) * Fixed issue 18488: Conditions are not properly highlighted if they have additional spaces (#2736) * Updated translation: Hungarian by kkd Updated translation: Valencian by vbraque * Release 3.28.39+221122 * Fixed issue 16187: Cant Create Custom Survey ID (need proper error message) (#2725) Co-authored-by: lapiudevgit <devgit@lapiu.biz> * Fixed issue 18461 Survey groups at survey list screen should be listed alphabetically (#2723) Co-authored-by: lapiudevgit <devgit@lapiu.biz> * Fixed issue 14310: Google Analytics functionality doesn't work (#2643) Co-authored-by: encuestabizdevgit <devgit@encuesta.biz> * Updated translation: Italian by lfanfoni, ritapas Updated translation: Polish by elissa Updated translation: Italian (Informal) by lfanfoni, ritapas Updated translation: Polish (Informal) by elissa * Release 3.28.40+221129 * Fixed issue 17818: Copy a multiple choice question send a DB error (MSSQL) (#2593) Dev: switchMSSQLIdentityInsert when needed * Updated translation: French (France) by arnaud21, DenisChenu, Xave Updated translation: Italian by lfanfoni Updated translation: Dutch by c_schmitz, Han Updated translation: Polish by elissa Updated translation: Italian (Informal) by lfanfoni Updated translation: Dutch (Informal) by c_schmitz, Han Updated translation: Polish (Informal) by elissa * Release 3.28.41+221206 * Fixed issue [security] #18514 : no CSRF control when delete token table (#2760) Dev: move to POST action * Updated translation: Catalan by qualitatuvic Updated translation: Galician by Calidonia Updated translation: Japanese by c_schmitz, d_inoue, nomoto Updated translation: Portuguese (Brazil) by mauriciofurtado * Release 3.28.42+221213 * Updated translation: Azerbaijani by PawelAtroszko Updated translation: Bosnian by PawelAtroszko Updated translation: Galician by Calidonia Updated translation: Luxembourgish by Mazi * Fixed issue 18086: Custom "other" label text not applied to Bootstrap button layout (#2749) Co-authored-by: lapiudevgit <devgit@lapiu.biz> * Fixed issue 18338: For participants, expiration date can be set before start date (#2726) Co-authored-by: lapiudevgit <devgit@lapiu.biz> Co-authored-by: Olle Härstedt <olleharstedt@yahoo.com> * Updated translation: Bosnian by PawelAtroszko Updated translation: German by c_schmitz, eddylackmann * Dev: Fix CI * Dev: Fix CI * Dev: Fix CI * Dev: Fix CI * Dev: Debug index.php * Updated translation: Catalan by qualitatuvic * Dev: Missing mbstring in CI * Dev: Missing FF capabilities for local cert (CI) * Dev: Try with testdox (CI) * Dev: Insert authdb plugin row before running tests (CI) * Dev: Fix typo * Dev: Use -b limesurvey (CI) * Dev: testdox swallows errors :( (CI) * Dev: cat config.php (CI) * Dev: Wait longer at login screen (CI) * Dev: Test to sleep (CI) * Dev: Dump body (CI) * Dev: Add missing xml lib ext (CI) * Updated translation: Polish by elissa Updated translation: Polish (Informal) by elissa * Dev: Remove try-catch around index * Release 3.28.43+221221 * Dev Automatic translation update * Dev: Fix iframe bug in unit test * Updated translation: Czech by jelen1 Updated translation: Italian by lfanfoni Updated translation: Czech (Informal) by jelen1 Updated translation: Italian (Informal) by lfanfoni * Release 3.28.44+230110 * Updated translation: Afrikaans by c_schmitz Updated translation: Arabic by c_schmitz, Shatha Updated translation: Bulgarian by c_schmitz Updated translation: Danish by c_schmitz Updated translation: Greek by c_schmitz Updated translation: Spanish (Spain) by c_schmitz Updated translation: Spanish (Mexican) by c_schmitz Updated translation: Estonian by c_schmitz Updated translation: Hindi by c_schmitz Updated translation: Croatian by c_schmitz Updated translation: Hungarian by c_schmitz Updated translation: Indonesian by c_schmitz Updated translation: Korean by c_schmitz Updated translation: Luxembourgish by Mazi Updated translation: Lithuanian by c_schmitz Updated translation: Latvian by c_schmitz Updated translation: Mongolian by c_schmitz Updated translation: Norwegian (Bokmål) by c_schmitz Updated translation: Norwegian (Nynorsk) by c_schmitz Updated translation: Polish by c_schmitz, elissa Updated translation: Portuguese (Brazil) by c_schmitz Updated translation: Romanian by c_schmitz Updated translation: Russian by c_schmitz Updated translation: Slovenian by c_schmitz Updated translation: Swedish by c_schmitz Updated translation: Thai by c_schmitz Updated translation: Turkish by c_schmitz Updated translation: Ukrainian by c_schmitz Updated translation: Vietnamese by c_schmitz Updated translation: Spanish (Argentina) (Informal) by c_schmitz Updated translation: Polish (Informal) by elissa Updated translation: Chinese (Simplified) by c_schmitz * Release 3.28.45+230117 * Updated translation: Dutch by Han Updated translation: Dutch (Informal) by Han * Release 3.28.46+230124 * Updated translation: Bulgarian by c_schmitz Updated translation: Bosnian by DenisChenu Updated translation: French (France) by DenisChenu Updated translation: Hindi by lucas_encuesta.biz, PawelAtroszko Updated translation: Malay by PawelAtroszko Updated translation: Urdu by lucas_encuesta.biz * Fixed issue 18562: Upload question type partially broken (#2811) Co-authored-by: lapiudevgit <devgit@lapiu.biz> * Dev Automatic translation update * Release 3.28.47+230131 * Updated translation: Armenian by c_schmitz * Fixed issue: Unable to remove an expired ComfortUpdate key * Dev Raised updater version to 18 * Fixed issue: Unable to remove an expired ComfortUpdate key * Updated translation: Croatian by c_schmitz Updated translation: Swedish by c_schmitz Updated translation: Turkish by c_schmitz Updated translation: Chinese (Simplified) by c_schmitz * Updated translation: Filipino by TobyCarslake Updated translation: Maltese by PawelAtroszko Updated translation: Urdu by PawelAtroszko * Fixed issue: Unable to add an new ComfortUpdate key * Updated translation: Danish by c_schmitz Updated translation: German by c_schmitz Updated translation: Spanish (Mexican) by c_schmitz Updated translation: Hindi by c_schmitz Updated translation: Indonesian by c_schmitz Updated translation: Korean by c_schmitz Updated translation: Mongolian by c_schmitz Updated translation: Norwegian (Bokmål) by c_schmitz Updated translation: Portuguese (Brazil) by tamiel Updated translation: Romanian by c_schmitz Updated translation: Russian by c_schmitz Updated translation: Vietnamese by c_schmitz Updated translation: German (Informal) by c_schmitz, eddylackmann, moeller Updated translation: Chinese (Taiwan) (Traditional) by c_schmitz * Updated translation: Portuguese (Brazil) by c_schmitz * Updated translation: Portuguese (Portugal) by c_schmitz Updated translation: Portuguese (Brazil) by tamiel Updated translation: German (Easy) by c_schmitz * Release 3.28.48+230207 * Updated translation: Malay by c_schmitz Updated translation: Tagalog by c_schmitz * Fixed issue: Intermittent unstyled page when creating/copying a survey * Updated translation: Malay by c_schmitz * Updated translation: Bengali by PawelAtroszko * Release 3.28.49+230215 * Fixed issue #18492: [security] Updates for several JS libraries Dev Updated moment.js to version 2.29.4 * Fixed issue #18492: [security] Updates for several JS libraries Dev Updated jQuery UI to version v1.13.2 * Fixed issue #18492: [security] Updates for several JS libraries Dev Updated ckEditor to 4.20.2 * Fixed issue #18492: [security] Updates for several JS libraries Dev Updated Select2 to 4.0.13 * Release 3.28.50+230221 * Fixed issue 18407: On-page conditions not working when pre-filling question with equation on the same page (#2676) Dev: ASSIGN didn't work really with javascript, Dev: Minimal fix to don't throw JS error * Fixed issue 18532: Data entry screen incorrectly assigns 0 value to empty multiflex array checkbox values (PR #2755) Fixed issue 18532: Data entry screen incorrectly assigns 0 value to empty multiflex array checkbox values * Updated translation: Bosnian by amer.kurta Updated translation: Ukrainian by c_schmitz * Release 3.28.51+230228 * Renamed wrong "nameaccesskey" to "accesskey" * Updated translation: Basque by admin67 Updated translation: Valencian by vbraque * Fixed issue: Unable to run integrity check on databases with a big number of surveys * Updated translation: Russian by vipgroup * Release 3.28.52+230307 * Updated translation: Japanese by d_inoue Updated translation: Polish by elissa * Release 3.28.53+230314 * Fixed issue: $aFiles can be null * Feature 18197: Allow GA4 tracking (#2962) Co-authored-by: lapiudevgit <devgit@lapiu.biz> * Dev: Null coalesce operator is not available in PHP 5.6 * Release 3.28.54+230321 * Fixed issue 18071: Importing Qaestion through Remote Control may fail if the imported question already exists (#2972) Co-authored-by: Gabriel Jenik <gabriel.jenik@gmail.com> * Fixed issue: Division by Zero error when running statistics * Dev Automatic translation update * Release 3.28.55+230328 * Fixed issue: PCLZip error on last step of ComfortUpdate when trying to update from version 3 to latest version * Release 3.28.56+230404 * Fixed issue 18703: Upload files show error if not seen (using index) (#3014) * Dev Small test change * Dev Updated runner for Github actions * Updated translation: Norwegian (Bokmål) by pmonstad Updated translation: Turkish by kayazeren Updated translation: German (Easy) by c_schmitz * Release 3.28.57+230425 * Fixed issue 18603: Set Minimum number of files for File Upload not working (#2864) Dev: allow "" and max and min file * Fixed issue 18639: Token browse can be unusable with lot of data in attribute (#2915) Dev: wrap value inside in cell (and encode) Dev: PHP part, need a micro CSS art after Dev: css part, apply to .grid-view .table td .text-content Dev: PSR Dev: Move to CustomFormatter->formatLongText Dev: apply max-width and min-width with less than 50 caracter too * Updated translation: Norwegian (Bokmål) by pmonstad * Updated translation: Swedish by maxzomborszki * Dev: Spit out php version and modules in CI * Dev: More info in error message * Dev: Do MySQL service fixes before installation (CI) * Release 3.28.58+230504 * Dev: Dump available logs (CI) * Dev: Tail MySQL error log (CI) * Dev: Tail as background task (CI) * Dev: YML syntax error * Dev: More CI debugging * Fixed issue 18343: Problem with interpreting double slash in URL (IIS) (#2630) Dev: use PHP to construct the url Dev: check if non empty before adding it Dev: editorurl * Fixed issue 18634: Export single selected response can export a empty line (#2909) * Fixed issue 18634: Export single selected response can export a empty line Dev: id set in url, resonseId in POST (by session) Dev: remove session usage Dev: can move to window-location-href, but ready for POST * Dev: separator to , * Dev: oups, lost the allow separator in widget * Dev: Fixed new tab opens * Dev Automatic translation update * Dev: Must check PHP 5.6 syntax before anything else (CI) * Dev: Wrong ordering (CI) * Revert "Fixed issue 18343: Problem with interpreting double slash in URL (IIS) (#2630)" (#3130) This reverts commit ebb447a803af3a2c010437c69e92a66904a08ab8. * Fixed issue 17491: Multiple Short Text subquestions missing from Export Printable Survey --------- Co-authored-by: Gabriel Jenik <gabriel.jenik@gmail.com> Co-authored-by: Denis Chenu <denis@sondages.pro> Co-authored-by: LimeSurvey Translations Bot <translations@limesurvey.org> Co-authored-by: olleharstedt <olleharstedt@yahoo.com> Co-authored-by: Carsten Schmitz <carsten.schmitz@limesurvey.org> Co-authored-by: François Charles Hébert <68611027+fsay2604@users.noreply.github.com> Co-authored-by: Roberto Longobardi <530743+seccanj@users.noreply.github.com> Co-authored-by: c-schmitz <carsten.schmitz.hh@gamil.com> Co-authored-by: encuestabizdevgit <devgit@encuesta.biz> Co-authored-by: Olle Haerstedt <olle.haerstedt@limesurvey.org> Co-authored-by: Carsten Schmitz <c_schmitz@users.sourceforge.net> Co-authored-by: lapiudevgit <devgit@lapiu.biz> Co-authored-by: Marcel Minke <maziminke@web.de> |
Affected Issues 14310, 14386, 15195, 15310, 16187, 16697, 16795, 17117, 17173, 17458, 17488, 17491, 17709, 17818, 17870, 17872, 17883, 17950, 17952, 17962, 17972, 17987, 18029, 18043, 18071, 18074, 18086, 18106, 18128, 18129, 18133, 18134, 18140, 18141, 18160, 18183, 18186, 18189, 18201, 18209, 18240, 18338, 18343, 18344, 18351, 18407, 18430, 18461, 18488, 18492, 18532, 18562, 18603, 18634, 18639, 18703 |
|
| mod - application/controllers/admin/printablesurvey.php | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-12-23 18:27 | DenisChenu | New Issue | |
| 2021-12-23 18:27 | DenisChenu | File Added: 500 Internal Server Error.html | |
| 2021-12-23 18:27 | DenisChenu | File Added: CDbException.html | |
| 2021-12-23 18:27 | DenisChenu | File Added: limesurvey_survey_Multi.lss | |
| 2021-12-23 18:28 | DenisChenu | Note Added: 67862 | |
| 2021-12-23 18:28 | DenisChenu | Bug heat | 0 => 2 |
| 2021-12-27 09:06 | galads | Assigned To | => galads |
| 2021-12-27 09:06 | galads | Status | new => acknowledged |
| 2022-09-12 18:01 | DenisChenu | Assigned To | galads => DenisChenu |
| 2022-09-12 18:05 | DenisChenu | Status | acknowledged => assigned |
| 2022-09-12 18:10 | DenisChenu | Assigned To | DenisChenu => gabrieljenik |
| 2022-09-12 18:10 | DenisChenu | Status | assigned => ready for code review |
| 2022-09-12 20:44 | gabrieljenik | Note Added: 71686 | |
| 2022-09-12 20:44 | gabrieljenik | Bug heat | 2 => 4 |
| 2022-09-12 20:45 | gabrieljenik | Note Edited: 71686 | |
| 2022-09-13 09:09 | DenisChenu | Note Added: 71696 | |
| 2022-09-13 09:09 | DenisChenu | Assigned To | gabrieljenik => |
| 2022-09-13 09:09 | DenisChenu | Status | ready for code review => ready for testing |
| 2022-12-02 16:05 | DenisChenu | Changeset attached | => LimeSurvey 3.x-LTS 5b08ca33 |
| 2022-12-02 16:05 | DenisChenu | Note Added: 72984 | |
| 2022-12-02 16:05 | DenisChenu | Assigned To | => DenisChenu |
| 2022-12-02 16:05 | DenisChenu | Resolution | open => fixed |
| 2022-12-02 16:38 | DenisChenu | Status | ready for testing => resolved |
| 2022-12-05 10:54 | LimeBot | Note Added: 72997 | |
| 2022-12-05 10:54 | LimeBot | Status | resolved => closed |
| 2022-12-05 10:54 | LimeBot | Bug heat | 4 => 6 |
| 2023-06-01 17:44 | adamzammit | Changeset attached | => LimeSurvey 3.x-LTS 6cd2e8b8 |
| 2023-06-01 17:44 | adamzammit | Note Added: 75363 | |
| 2023-06-01 17:44 | adamzammit | Bug heat | 6 => 8 |
| 2023-06-01 17:44 | adamzammit | Assigned To | DenisChenu => adamzammit |
