Relationship Graph
related to 
child of 
duplicate of View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 17458 | Bug reports | Database design | public | 2021-07-21 12:32 | 2022-06-27 01:52 |
| Reporter | DenisChenu | Assigned To | |||
| Priority | none | Severity | partial_block | ||
| Status | ready for code review | Resolution | open | ||
| Product Version | 3.25.17 | ||||
| Summary | 17458: Check integrety broke with SQL error | ||||
| Description | When have subquestion with integer : checkintegrity can break | ||||
| Steps To Reproduce |
For me : qid : 339316 / 87481 | ||||
| Additional Information | MS SQL only ? What is your biggest number at limeservice ? | ||||
| Tags | No tags attached. | ||||
| Bug heat | 16 | ||||
| Complete LimeSurvey version number (& build) | 3.27.7 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | not relevant | ||||
| Database type & version | mssql 12.00.6433 | ||||
| Server OS (if known) | IIS | ||||
| Webserver software & version (if known) | windows | ||||
| PHP Version | 7.4.20 | ||||
| has duplicate | 17981 | closed | "check data integrity" issue |
 |
CDbException.html (25,634 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[22003]:
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]The conversion of
the nvarchar value '33931687481' overflowed an int column.. The SQL
statement executed was: SELECT TOP 1 * FROM [dbo].[lime_questions] [t]
WHERE [t].[qid]=:yp0 AND [t].[language]=:yp1 AND [t].[sid]=:yp2 </p>
<div class="source">
<p class="file">.\limesurvey\framework\db\CDbCommand.php(543)</p>
<div class="code"><pre><span class="ln">531</span> {
<span class="ln">532</span> if($this->_connection->enableProfiling)
<span class="ln">533</span> Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query');
<span class="ln">534</span>
<span class="ln">535</span> $errorInfo=$e instanceof PDOException ? $e->errorInfo : null;
<span class="ln">536</span> $message=$e->getMessage();
<span class="ln">537</span> Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',
<span class="ln">538</span> array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
<span class="ln">539</span>
<span class="ln">540</span> if(YII_DEBUG)
<span class="ln">541</span> $message.='. The SQL statement executed was: '.$this->getText().$par;
<span class="ln">542</span>
<span class="error"><span class="ln error-ln">543</span> throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
</span><span class="ln">544</span> array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
<span class="ln">545</span> }
<span class="ln">546</span> }
<span class="ln">547</span>
<span class="ln">548</span> /**
<span class="ln">549</span> * Builds a SQL SELECT statement from the given query specification.
<span class="ln">550</span> * @param array $query the query specification in name-value pairs. The following
<span class="ln">551</span> * query options are supported: {@link select}, {@link distinct}, {@link from},
<span class="ln">552</span> * {@link where}, {@link join}, {@link group}, {@link having}, {@link order},
<span class="ln">553</span> * {@link limit}, {@link offset} and {@link union}.
<span class="ln">554</span> * @throws CDbException if "from" key is not present in given query parameter
<span class="ln">555</span> * @return string the SQL statement
</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>
.\limesurvey\framework\db\CDbCommand.php(415): <strong>CDbCommand</strong>-><strong>queryInternal</strong>("fetch", array(2), array()) </div>
<div class="code"><pre><span class="ln">410</span> * @return mixed the first row (in terms of an array) of the query result, false if no result.
<span class="ln">411</span> * @throws CException execution failed
<span class="ln">412</span> */
<span class="ln">413</span> public function queryRow($fetchAssociative=true,$params=array())
<span class="ln">414</span> {
<span class="error"><span class="ln error-ln">415</span> return $this->queryInternal('fetch',$fetchAssociative ? $this->_fetchMode : PDO::FETCH_NUM, $params);
</span><span class="ln">416</span> }
<span class="ln">417</span>
<span class="ln">418</span> /**
<span class="ln">419</span> * Executes the SQL statement and returns the value of the first column in the first row of data.
<span class="ln">420</span> * This is a convenient method of {@link query} when only a single scalar
</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>
.\limesurvey\framework\db\ar\CActiveRecord.php(1359): <strong>CDbCommand</strong>-><strong>queryRow</strong>() </div>
<div class="code"><pre><span class="ln">1354</span> if(empty($criteria->with))
<span class="ln">1355</span> {
<span class="ln">1356</span> if(!$all)
<span class="ln">1357</span> $criteria->limit=1;
<span class="ln">1358</span> $command=$this->getCommandBuilder()->createFindCommand($this->getTableSchema(),$criteria);
<span class="error"><span class="ln error-ln">1359</span> return $all ? $this->populateRecords($command->queryAll(), true, $criteria->index) : $this->populateRecord($command->queryRow());
</span><span class="ln">1360</span> }
<span class="ln">1361</span> else
<span class="ln">1362</span> {
<span class="ln">1363</span> $finder=$this->getActiveFinder($criteria->with);
<span class="ln">1364</span> return $finder->query($criteria,$all);
</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>
.\limesurvey\application\models\LSActiveRecord.php(73): <strong>CActiveRecord</strong>-><strong>query</strong>(CDbCriteria, false) </div>
<div class="code"><pre><span class="ln">68</span> * @since 1.1.7
<span class="ln">69</span> */
<span class="ln">70</span> protected function query($criteria, $all = false, $asAR = true)
<span class="ln">71</span> {
<span class="ln">72</span> if ($asAR === true) {
<span class="error"><span class="ln error-ln">73</span> return parent::query($criteria, $all);
</span><span class="ln">74</span> } else {
<span class="ln">75</span> $this->beforeFind();
<span class="ln">76</span> $this->applyScopes($criteria);
<span class="ln">77</span> if (!$all) {
<span class="ln">78</span> $criteria->limit = 1;
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#3 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
.\limesurvey\framework\db\ar\CActiveRecord.php(1527): <strong>LSActiveRecord</strong>-><strong>query</strong>(CDbCriteria) </div>
<div class="code"><pre><span class="ln">1522</span> public function findByAttributes($attributes,$condition='',$params=array())
<span class="ln">1523</span> {
<span class="ln">1524</span> Yii::trace(get_class($this).'.findByAttributes()','system.db.ar.CActiveRecord');
<span class="ln">1525</span> $prefix=$this->getTableAlias(true).'.';
<span class="ln">1526</span> $criteria=$this->getCommandBuilder()->createColumnCriteria($this->getTableSchema(),$attributes,$condition,$params,$prefix);
<span class="error"><span class="ln error-ln">1527</span> return $this->query($criteria);
</span><span class="ln">1528</span> }
<span class="ln">1529</span>
<span class="ln">1530</span> /**
<span class="ln">1531</span> * Finds all active records that have the specified attribute values.
<span class="ln">1532</span> * See {@link find()} for detailed explanation about $condition and $params.
</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>
.\limesurvey\application\controllers\admin\checkintegrity.php(537): <strong>CActiveRecord</strong>-><strong>findByAttributes</strong>(array("qid" => "33931687481", "language" => "en", "sid" => "152625")) </div>
<div class="code"><pre><span class="ln">532</span> if ((string) intval($sQID) !== $sQID) {
<span class="ln">533</span> throw new \Exception('sQID is not an integer: ' . $sQID);
<span class="ln">534</span> }
<span class="ln">535</span>
<span class="ln">536</span> // Here, we get the question as defined in backend
<span class="error"><span class="ln error-ln">537</span> $oQuestion = Question::model()->findByAttributes([ 'qid' => $sQID , 'language' => $oSurvey->language, 'sid' => $oSurvey->sid ]);
</span><span class="ln">538</span> if (is_a($oQuestion, 'Question')){
<span class="ln">539</span>
<span class="ln">540</span> // We check if its GID is the same as the one defined in the column name
<span class="ln">541</span> if ($oQuestion->gid != $sGid){
<span class="ln">542</span>
</pre></div> </td>
</tr>
<tr class="trace app expanded">
<td class="number">
#5 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
.\limesurvey\application\controllers\admin\checkintegrity.php(40): <strong>CheckIntegrity</strong>-><strong>_checkintegrity</strong>() </div>
<div class="code"><pre><span class="ln">35</span> Yii::app()->loadHelper('surveytranslator');
<span class="ln">36</span> }
<span class="ln">37</span>
<span class="ln">38</span> public function index()
<span class="ln">39</span> {
<span class="error"><span class="ln error-ln">40</span> $aData = $this->_checkintegrity();
</span><span class="ln">41</span>
<span class="ln">42</span>
<span class="ln">43</span> $aData['fullpagebar']['returnbutton']['url'] = 'admin/index';
<span class="ln">44</span> $aData['fullpagebar']['returnbutton']['text'] = gT('Return to admin home');
<span class="ln">45</span>
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#6 </td>
<td class="content">
<div class="trace-file">
unknown(0): <strong>CheckIntegrity</strong>-><strong>index</strong>() </div>
</td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#7 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
.\limesurvey\framework\web\actions\CAction.php(115): <strong>ReflectionMethod</strong>-><strong>invokeArgs</strong>(CheckIntegrity, 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">
#8 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
.\limesurvey\application\core\Survey_Common_Action.php(83): <strong>CAction</strong>-><strong>runWithParamsInternal</strong>(CheckIntegrity, ReflectionMethod, array("r" => "admin/checkintegrity")) </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">
#9 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
.\limesurvey\framework\web\CController.php(308): <strong>Survey_Common_Action</strong>-><strong>runWithParams</strong>(array("r" => "admin/checkintegrity")) </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">
#10 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
.\limesurvey\framework\web\CController.php(286): <strong>CController</strong>-><strong>runAction</strong>(CheckIntegrity) </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">
#11 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
.\limesurvey\framework\web\CController.php(265): <strong>CController</strong>-><strong>runActionWithFilters</strong>(CheckIntegrity, 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">
#12 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
.\limesurvey\application\controllers\AdminController.php(165): <strong>CController</strong>-><strong>run</strong>("checkintegrity") </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">
#13 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
.\limesurvey\framework\web\CWebApplication.php(282): <strong>AdminController</strong>-><strong>run</strong>("checkintegrity") </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">
#14 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
.\limesurvey\framework\web\CWebApplication.php(141): <strong>CWebApplication</strong>-><strong>runController</strong>("admin/checkintegrity") </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">
#15 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
.\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">
#16 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
.\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-07-21 10:13:31 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>
|
 |
lss? |
|
|
Why ? But i check with 99999999999999999997 to see what happen on mariadb too |
|
|
No int (php) 500 Erreur interne au serveur.html (13,053 bytes)
<!DOCTYPE html>
<html dir="ltr" class="fr dir-ltr no-js " lang="fr"><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="generator" content="LimeSurvey http://www.limesurvey.org">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" type="text/css" href="500%20Erreur%20interne%20au%20serveur_fichiers/jquery-ui.css">
<link rel="stylesheet" type="text/css" href="500%20Erreur%20interne%20au%20serveur_fichiers/font-awesome.css">
<link rel="stylesheet" type="text/css" href="500%20Erreur%20interne%20au%20serveur_fichiers/bootstrap_002.css">
<link rel="stylesheet" type="text/css" href="500%20Erreur%20interne%20au%20serveur_fichiers/yiistrap.css">
<link rel="stylesheet" type="text/css" href="500%20Erreur%20interne%20au%20serveur_fichiers/bootstrap-switch.css">
<link rel="stylesheet" type="text/css" href="500%20Erreur%20interne%20au%20serveur_fichiers/select2.css">
<link rel="stylesheet" type="text/css" href="500%20Erreur%20interne%20au%20serveur_fichiers/select2-bootstrap.css">
<link rel="stylesheet" type="text/css" href="500%20Erreur%20interne%20au%20serveur_fichiers/bootstrap-datetimepicker.css">
<link rel="stylesheet" type="text/css" href="500%20Erreur%20interne%20au%20serveur_fichiers/roboto.css">
<link rel="stylesheet" type="text/css" href="500%20Erreur%20interne%20au%20serveur_fichiers/icomoon.css">
<link rel="stylesheet" type="text/css" href="500%20Erreur%20interne%20au%20serveur_fichiers/lstutorial.css">
<link rel="stylesheet" type="text/css" href="500%20Erreur%20interne%20au%20serveur_fichiers/adminbasics.css">
<link rel="stylesheet" type="text/css" href="500%20Erreur%20interne%20au%20serveur_fichiers/adminsidepanel.css">
<link rel="stylesheet" type="text/css" href="500%20Erreur%20interne%20au%20serveur_fichiers/lime-admin-colors.css">
<link rel="stylesheet" type="text/css" href="500%20Erreur%20interne%20au%20serveur_fichiers/statistics.css">
<link rel="stylesheet" type="text/css" href="500%20Erreur%20interne%20au%20serveur_fichiers/own-fix.css">
<link rel="stylesheet" type="text/css" href="500%20Erreur%20interne%20au%20serveur_fichiers/survey.css">
<link rel="stylesheet" type="text/css" href="500%20Erreur%20interne%20au%20serveur_fichiers/custom.css">
<link rel="stylesheet" type="text/css" href="500%20Erreur%20interne%20au%20serveur_fichiers/minimal.css">
<link rel="stylesheet" type="text/css" href="500%20Erreur%20interne%20au%20serveur_fichiers/skelvanilla.css">
<link rel="stylesheet" type="text/css" href="500%20Erreur%20interne%20au%20serveur_fichiers/bootstrap.css">
<link rel="stylesheet" type="text/css" href="500%20Erreur%20interne%20au%20serveur_fichiers/theme.css">
<script type="text/javascript">window.debugState = {frontend : (0 === 1), backend : (0 === 1)};</script><script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/jquery-3.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/jquery-migrate-3.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/jquery-ui.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/adminbasics.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/adminsidepanel.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/js.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/bootstrap.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/bootstrapconfirm.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/moment-with-locales.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/select2.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/lslog.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/pjax_002.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/ckeditor.js" class="headScriptTag"></script><style>.cke{visibility:hidden;}</style>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/config.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/ckeditoradditions.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/adapt.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/survey.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/template-core.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/pjax.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/custom.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/aria-live.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/theme-vanilla.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/skelvanilla.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/theme.js" class="headScriptTag"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/em_javascript.js" class="headScriptTag"></script>
<script type="text/javascript">
/*<![CDATA[*/
LS.globalUserId = "1";
LSvar= LSvar || {};
LSvar.bFixNumAuto = 0;
LSvar.bNumRealValue = 1;
/*]]>*/
</script>
<title>
500 : Erreur interne au serveur
</title>
<script type="text/javascript">
if(window.basicThemeScripts === undefined){
window.basicThemeScripts = new ThemeScripts();
}
$.fn.select2.defaults.set("theme", "bootstrap");
</script>
<link rel="icon" type="image/png" sizes="32x32" href="http://limesurvey.local/3LTS/tmp/assets/8847910a/favicon-32x32.png">
<link rel="icon" type="image/png" sizes="96x96" href="http://limesurvey.local/3LTS/tmp/assets/8847910a/favicon-96x96.png">
<link rel="icon" type="image/png" sizes="16x16" href="http://limesurvey.local/3LTS/tmp/assets/8847910a/favicon-16x16.png">
</head>
<body class="skelvanilla vanilla minimal bootstrap lang-fr table-fixed-header body-loaded"><script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_fichiers/bootstrap-switch.js"></script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_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;
relChange3652=false;
relChangeG0=false;
LEMrel3652(sgqa);
LEMrel3652(sgqa);
}
function LEMrel3652(sgqa){
var UsesVars = ' ';
if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
return;
}
if (1)
{
LEMval3652(sgqa);
relChange3652=true;
$('#relevance3652').val('1');
}
$('#relevance3652').val('1'); // always true
}
function LEMval3652(sgqa){
isValidSum3652=true;
isValidOther3652=true;
isValidOtherComment3652=true;
if(((1))){
$('#vmsg_3652_default').trigger('classChangeGood');
}
else {
$('#vmsg_3652_default').trigger('classChangeError');
isValidOther3652=false;
}
if(isValidSum3652){
$('#totalvalue_3652').trigger('classChangeGood');
}
else {
$('#totalvalue_3652').trigger('classChangeError');
}
}
/*]]>*/
</script>
<div id="dynamicReloadContainer">
<!-- Bootstrap Navigation Bar -->
<header class=" navbar navbar-default navbar-static-top hidden-print" role="banner">
<div class="container-fluid" role="navigation">
<div class=" navbar-header ">
<h1 class=" navbar-brand ">
500 : Erreur interne au serveur
</h1>
</div>
</div>
</header>
<!-- Outer Frame Container -->
<main class=" outerframe container " id="outerframeContainer">
<div class="well">
<h1 class="text-danger">500 : Erreur interne au serveur</h1>
<div class="h2">sQID is not an integer: 36529999999999999999997
<div>
Une erreur interne est survenue quand le serveur Web traitait votre requête.
</div>
<p class="small text-right">
Veuillez contacter Denis Chenu pour rapporter ce problème.
</p>
</div>
</div></main>
<!-- Bootstrap Modal Alert -->
<div id="bootstrap-alert-box-modal" class=" modal fade ">
<div class=" modal-dialog ">
<div class=" modal-content ">
<div class=" modal-header " style="min-height:40px;">
<button type="button" data-dismiss="modal" aria-hidden="true" aria-label="Fermer" class=" close "><span aria-hidden="true">×</span><span class="sr-only">Fermer</span></button>
<div class=" modal-title h4 "> </div>
</div>
<div class=" modal-body ">
</div>
<div class=" modal-footer ">
<a href="#" data-dismiss="modal" class=" btn btn-default ">Fermer</a>
</div>
</div>
</div>
</div>
<!-- <footer class="navbar-default"></footer> -->
</div>
<div id="ajax-loading" aria-hidden="true"><i class="loader fa fa-circle-o-notch fa-spin fa-3x fa-fw text-muted"></i></div>
<script>
if (!window.jQuery) {
window.onload = function() {
body = document.getElementsByTagName('body')[0];
body.className = body.className.replace(/\body-loading\b/,'body-loaded');
};
}
</script>
<script>
if(window.basicThemeScripts === undefined){
window.basicThemeScripts = new ThemeScripts();
}
basicThemeScripts.initGlobal();
window.basicThemeScripts.init();
window.TemplateAccessible.init({"dynamicValidity":false});
window.skelVanilla.init({"bodyLoaded":true,"removeBack":false,"errorTopLinks":true});
</script>
<script type="text/javascript" src="500%20Erreur%20interne%20au%20serveur_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() {
activateActionLink();
activateConfirmButton();
basicThemeScripts.initTopMenuLanguageChanger('.ls-language-link ', 'form#limesurvey');
updateMandatoryErrorClass();
});
/*]]>*/
</script>
<div id="grammalecte_menu_main_button_shadow_host" style="width: 0px; height: 0px;"></div></body><script src="500%20Erreur%20interne%20au%20serveur_fichiers/api.js"></script></html> limesurvey_survey_NoInt500.lss (22,634 bytes)
<?xml version="1.0" encoding="UTF-8"?>
<document>
<LimeSurveyDocType>Survey</LimeSurveyDocType>
<DBVersion>365</DBVersion>
<languages>
<language>fr</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[202]]></gid>
<sid><![CDATA[599332]]></sid>
<group_name><![CDATA[Mon premier groupe de question]]></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[3652]]></qid>
<parent_qid><![CDATA[0]]></parent_qid>
<sid><![CDATA[599332]]></sid>
<gid><![CDATA[202]]></gid>
<type><![CDATA[M]]></type>
<title><![CDATA[Q00]]></title>
<question><![CDATA[Une première question comme exemple. Veuillez répondre à cette question :]]></question>
<preg/>
<help><![CDATA[Ceci est une texte d’aide pour la question.]]></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>
<modulename/>
</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[3653]]></qid>
<parent_qid><![CDATA[3652]]></parent_qid>
<sid><![CDATA[599332]]></sid>
<gid><![CDATA[202]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[9999999999999999997]]></title>
<question><![CDATA[7]]></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[3654]]></qid>
<parent_qid><![CDATA[3652]]></parent_qid>
<sid><![CDATA[599332]]></sid>
<gid><![CDATA[202]]></gid>
<type><![CDATA[T]]></type>
<title><![CDATA[9999999999999999998]]></title>
<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>
</rows>
</subquestions>
<surveys>
<fields>
<fieldname>sid</fieldname>
<fieldname>gsid</fieldname>
<fieldname>admin</fieldname>
<fieldname>expires</fieldname>
<fieldname>startdate</fieldname>
<fieldname>adminemail</fieldname>
<fieldname>anonymized</fieldname>
<fieldname>faxto</fieldname>
<fieldname>format</fieldname>
<fieldname>savetimings</fieldname>
<fieldname>template</fieldname>
<fieldname>language</fieldname>
<fieldname>additional_languages</fieldname>
<fieldname>datestamp</fieldname>
<fieldname>usecookie</fieldname>
<fieldname>allowregister</fieldname>
<fieldname>allowsave</fieldname>
<fieldname>autonumber_start</fieldname>
<fieldname>autoredirect</fieldname>
<fieldname>allowprev</fieldname>
<fieldname>printanswers</fieldname>
<fieldname>ipaddr</fieldname>
<fieldname>refurl</fieldname>
<fieldname>showsurveypolicynotice</fieldname>
<fieldname>publicstatistics</fieldname>
<fieldname>publicgraphs</fieldname>
<fieldname>listpublic</fieldname>
<fieldname>htmlemail</fieldname>
<fieldname>sendconfirmation</fieldname>
<fieldname>tokenanswerspersistence</fieldname>
<fieldname>assessments</fieldname>
<fieldname>usecaptcha</fieldname>
<fieldname>usetokens</fieldname>
<fieldname>bounce_email</fieldname>
<fieldname>attributedescriptions</fieldname>
<fieldname>emailresponseto</fieldname>
<fieldname>emailnotificationto</fieldname>
<fieldname>tokenlength</fieldname>
<fieldname>showxquestions</fieldname>
<fieldname>showgroupinfo</fieldname>
<fieldname>shownoanswer</fieldname>
<fieldname>showqnumcode</fieldname>
<fieldname>bouncetime</fieldname>
<fieldname>bounceprocessing</fieldname>
<fieldname>bounceaccounttype</fieldname>
<fieldname>bounceaccounthost</fieldname>
<fieldname>bounceaccountpass</fieldname>
<fieldname>bounceaccountencryption</fieldname>
<fieldname>bounceaccountuser</fieldname>
<fieldname>showwelcome</fieldname>
<fieldname>showprogress</fieldname>
<fieldname>questionindex</fieldname>
<fieldname>navigationdelay</fieldname>
<fieldname>nokeyboard</fieldname>
<fieldname>alloweditaftercompletion</fieldname>
<fieldname>googleanalyticsstyle</fieldname>
<fieldname>googleanalyticsapikey</fieldname>
</fields>
<rows>
<row>
<sid><![CDATA[599332]]></sid>
<gsid><![CDATA[1]]></gsid>
<admin><![CDATA[Denis Chenu]]></admin>
<adminemail><![CDATA[denis@shnoulle.net]]></adminemail>
<anonymized><![CDATA[N]]></anonymized>
<faxto/>
<format><![CDATA[G]]></format>
<savetimings><![CDATA[N]]></savetimings>
<template><![CDATA[skelvanilla]]></template>
<language><![CDATA[fr]]></language>
<additional_languages/>
<datestamp><![CDATA[N]]></datestamp>
<usecookie><![CDATA[N]]></usecookie>
<allowregister><![CDATA[N]]></allowregister>
<allowsave><![CDATA[Y]]></allowsave>
<autonumber_start><![CDATA[1]]></autonumber_start>
<autoredirect><![CDATA[N]]></autoredirect>
<allowprev><![CDATA[N]]></allowprev>
<printanswers><![CDATA[N]]></printanswers>
<ipaddr><![CDATA[N]]></ipaddr>
<refurl><![CDATA[N]]></refurl>
<showsurveypolicynotice><![CDATA[0]]></showsurveypolicynotice>
<publicstatistics><![CDATA[N]]></publicstatistics>
<publicgraphs><![CDATA[N]]></publicgraphs>
<listpublic><![CDATA[N]]></listpublic>
<htmlemail><![CDATA[Y]]></htmlemail>
<sendconfirmation><![CDATA[Y]]></sendconfirmation>
<tokenanswerspersistence><![CDATA[N]]></tokenanswerspersistence>
<assessments><![CDATA[N]]></assessments>
<usecaptcha><![CDATA[N]]></usecaptcha>
<usetokens><![CDATA[N]]></usetokens>
<bounce_email><![CDATA[denis@shnoulle.net]]></bounce_email>
<emailresponseto/>
<emailnotificationto/>
<tokenlength><![CDATA[15]]></tokenlength>
<showxquestions><![CDATA[Y]]></showxquestions>
<showgroupinfo><![CDATA[B]]></showgroupinfo>
<shownoanswer><![CDATA[N]]></shownoanswer>
<showqnumcode><![CDATA[X]]></showqnumcode>
<bounceprocessing><![CDATA[N]]></bounceprocessing>
<showwelcome><![CDATA[Y]]></showwelcome>
<showprogress><![CDATA[Y]]></showprogress>
<questionindex><![CDATA[0]]></questionindex>
<navigationdelay><![CDATA[0]]></navigationdelay>
<nokeyboard><![CDATA[N]]></nokeyboard>
<alloweditaftercompletion><![CDATA[N]]></alloweditaftercompletion>
</row>
</rows>
</surveys>
<surveys_languagesettings>
<fields>
<fieldname>surveyls_survey_id</fieldname>
<fieldname>surveyls_language</fieldname>
<fieldname>surveyls_title</fieldname>
<fieldname>surveyls_description</fieldname>
<fieldname>surveyls_welcometext</fieldname>
<fieldname>surveyls_endtext</fieldname>
<fieldname>surveyls_policy_notice</fieldname>
<fieldname>surveyls_policy_error</fieldname>
<fieldname>surveyls_policy_notice_label</fieldname>
<fieldname>surveyls_url</fieldname>
<fieldname>surveyls_urldescription</fieldname>
<fieldname>surveyls_email_invite_subj</fieldname>
<fieldname>surveyls_email_invite</fieldname>
<fieldname>surveyls_email_remind_subj</fieldname>
<fieldname>surveyls_email_remind</fieldname>
<fieldname>surveyls_email_register_subj</fieldname>
<fieldname>surveyls_email_register</fieldname>
<fieldname>surveyls_email_confirm_subj</fieldname>
<fieldname>surveyls_email_confirm</fieldname>
<fieldname>surveyls_dateformat</fieldname>
<fieldname>surveyls_attributecaptions</fieldname>
<fieldname>email_admin_notification_subj</fieldname>
<fieldname>email_admin_notification</fieldname>
<fieldname>email_admin_responses_subj</fieldname>
<fieldname>email_admin_responses</fieldname>
<fieldname>surveyls_numberformat</fieldname>
<fieldname>attachments</fieldname>
</fields>
<rows>
<row>
<surveyls_survey_id><![CDATA[599332]]></surveyls_survey_id>
<surveyls_language><![CDATA[fr]]></surveyls_language>
<surveyls_title><![CDATA[Check]]></surveyls_title>
<surveyls_description/>
<surveyls_welcometext/>
<surveyls_endtext/>
<surveyls_url/>
<surveyls_urldescription/>
<surveyls_email_invite_subj><![CDATA[Invitation à participer à un questionnaire]]></surveyls_email_invite_subj>
<surveyls_email_invite><![CDATA[Cher(e) {FIRSTNAME},<br />
<br />
Vous avez été invité(e) à participer à un questionnaire.<br />
<br />
Celui-ci est intitulé :<br />
"{SURVEYNAME}"<br />
<br />
"{SURVEYDESCRIPTION}"<br />
<br />
Pour participer, veuillez cliquer sur le lien ci-dessous.<br />
<br />
Cordialement,<br />
<br />
{ADMINNAME} ({ADMINEMAIL})<br />
<br />
----------------------------------------------<br />
Cliquez ici pour remplir ce questionnaire :<br />
{SURVEYURL}<br />
<br />
Si vous ne souhaitez pas participer à ce questionnaire et ne souhaitez plus recevoir aucune invitation, veuillez cliquer sur le lien suivant :<br />
{OPTOUTURL}<br />
<br />
Si vous êtes sur liste noire mais que vous voulez participer à ce questionnaire et recevoir les invitations, merci de cliquer sur le lien suivant :<br />
{OPTINURL}]]></surveyls_email_invite>
<surveyls_email_remind_subj><![CDATA[Rappel pour participer à un questionnaire]]></surveyls_email_remind_subj>
<surveyls_email_remind><![CDATA[Cher(e) {FIRSTNAME},<br />
<br />
Vous avez été invité(e) à participer à un questionnaire récemment.<br />
<br />
Nous avons pris en compte que vous n’avez pas encore complété le questionnaire, et nous vous rappelons que celui-ci est toujours disponible si vous souhaitez participer.<br />
<br />
Le questionnaire est intitulé :<br />
"{SURVEYNAME}"<br />
<br />
"{SURVEYDESCRIPTION}"<br />
<br />
Pour participer, veuillez cliquer sur le lien ci-dessous.<br />
<br />
Cordialement,<br />
<br />
{ADMINNAME} ({ADMINEMAIL})<br />
<br />
----------------------------------------------<br />
Cliquez ici pour faire le questionnaire :<br />
{SURVEYURL}<br />
<br />
Si vous ne souhaitez pas participer à ce questionnaire et ne souhaitez plus recevoir aucune invitation, veuillez cliquer sur le lien suivant :<br />
{OPTOUTURL}]]></surveyls_email_remind>
<surveyls_email_register_subj><![CDATA[Confirmation d’enregistrement pour le questionnaire]]></surveyls_email_register_subj>
<surveyls_email_register><![CDATA[Bonjour {FIRSTNAME},<br />
<br />
Vous (ou quelqu’un utilisant votre adresse électronique) vous êtes enregistré pour participer à un questionnaire en ligne intitulé {SURVEYNAME}.<br />
<br />
Pour compléter ce questionnaire, cliquez sur le lien suivant :<br />
{SURVEYURL}<br />
<br />
Si vous avez des questions à propos de ce questionnaire, ou si vous ne vous êtes pas enregistré pour participer à celui-ci et croyez que ce message est une erreur, veuillez contacter {ADMINNAME} à l’adresse {ADMINEMAIL}]]></surveyls_email_register>
<surveyls_email_confirm_subj><![CDATA[Confirmation de votre participation à notre questionnaire]]></surveyls_email_confirm_subj>
<surveyls_email_confirm><![CDATA[Bonjour {FIRSTNAME},<br />
<br />
Ce message vous confirme que vous avez complété le questionnaire intitulé {SURVEYNAME} et que votre réponse a été enregistrée. Merci pour votre participation.<br />
<br />
Si vous avez des questions à propos de ce message, veuillez contacter {ADMINNAME} à l’adresse {ADMINEMAIL}.<br />
<br />
Cordialement,<br />
<br />
{ADMINNAME}]]></surveyls_email_confirm>
<surveyls_dateformat><![CDATA[1]]></surveyls_dateformat>
<email_admin_notification_subj><![CDATA[Soumission de réponse pour le questionnaire {SURVEYNAME}]]></email_admin_notification_subj>
<email_admin_notification><![CDATA[Bonjour,<br />
<br />
Une nouvelle réponse a été soumise pour votre questionnaire '{SURVEYNAME}'.<br />
<br />
Cliquez sur le lien suivant pour voir la réponse :<br />
{VIEWRESPONSEURL}<br />
<br />
Cliquez sur le lien suivant pour éditer la réponse :<br />
{EDITRESPONSEURL}<br />
<br />
Visualisez les statistiques en cliquant ici :<br />
{STATISTICSURL}]]></email_admin_notification>
<email_admin_responses_subj><![CDATA[Soumission de réponse pour le questionnaire {SURVEYNAME} avec résultats]]></email_admin_responses_subj>
<email_admin_responses><![CDATA[Bonjour,<br />
<br />
Une nouvelle réponse a été soumise pour votre questionnaire '{SURVEYNAME}'.<br />
<br />
Cliquez sur le lien suivant pour voir cette réponse :<br />
{VIEWRESPONSEURL}<br />
<br />
Cliquez sur le lien suivant pour éditer cette réponse individuelle :<br />
{EDITRESPONSEURL}<br />
<br />
Visualisez les statistiques en cliquant ici :<br />
{STATISTICSURL}<br />
<br />
<br />
Les réponses suivantes ont été données par le participant :<br />
{ANSWERTABLE}]]></email_admin_responses>
<surveyls_numberformat><![CDATA[0]]></surveyls_numberformat>
</row>
</rows>
</surveys_languagesettings>
<themes>
<theme>
<sid>599332</sid>
<template_name>skelvanilla</template_name>
<config>
<options>inherit</options>
</config>
</theme>
</themes>
<themes_inherited>
<theme>
<sid>599332</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>
|
|
|
qid: 3652 / subqid code 999997 : no issue in mariadb Check with 2147483647 : still no SQL broke (on mariadb) limesurvey_survey_2147483647.lss (22,671 bytes)
<?xml version="1.0" encoding="UTF-8"?>
<document>
<LimeSurveyDocType>Survey</LimeSurveyDocType>
<DBVersion>365</DBVersion>
<languages>
<language>fr</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[202]]></gid>
<sid><![CDATA[599332]]></sid>
<group_name><![CDATA[Mon premier groupe de question]]></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[3652]]></qid>
<parent_qid><![CDATA[0]]></parent_qid>
<sid><![CDATA[599332]]></sid>
<gid><![CDATA[202]]></gid>
<type><![CDATA[M]]></type>
<title><![CDATA[Q00]]></title>
<question><![CDATA[Une première question comme exemple. Veuillez répondre à cette question :]]></question>
<preg/>
<help><![CDATA[Ceci est une texte d’aide pour la question.]]></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>
<modulename/>
</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[3653]]></qid>
<parent_qid><![CDATA[3652]]></parent_qid>
<sid><![CDATA[599332]]></sid>
<gid><![CDATA[202]]></gid>
<type><![CDATA[M]]></type>
<title><![CDATA[2147483647]]></title>
<question><![CDATA[2147483647 (int mariadb)]]></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[3654]]></qid>
<parent_qid><![CDATA[3652]]></parent_qid>
<sid><![CDATA[599332]]></sid>
<gid><![CDATA[202]]></gid>
<type><![CDATA[M]]></type>
<title><![CDATA[3000000000]]></title>
<question><![CDATA[3000000000]]></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>
</rows>
</subquestions>
<surveys>
<fields>
<fieldname>sid</fieldname>
<fieldname>gsid</fieldname>
<fieldname>admin</fieldname>
<fieldname>expires</fieldname>
<fieldname>startdate</fieldname>
<fieldname>adminemail</fieldname>
<fieldname>anonymized</fieldname>
<fieldname>faxto</fieldname>
<fieldname>format</fieldname>
<fieldname>savetimings</fieldname>
<fieldname>template</fieldname>
<fieldname>language</fieldname>
<fieldname>additional_languages</fieldname>
<fieldname>datestamp</fieldname>
<fieldname>usecookie</fieldname>
<fieldname>allowregister</fieldname>
<fieldname>allowsave</fieldname>
<fieldname>autonumber_start</fieldname>
<fieldname>autoredirect</fieldname>
<fieldname>allowprev</fieldname>
<fieldname>printanswers</fieldname>
<fieldname>ipaddr</fieldname>
<fieldname>refurl</fieldname>
<fieldname>showsurveypolicynotice</fieldname>
<fieldname>publicstatistics</fieldname>
<fieldname>publicgraphs</fieldname>
<fieldname>listpublic</fieldname>
<fieldname>htmlemail</fieldname>
<fieldname>sendconfirmation</fieldname>
<fieldname>tokenanswerspersistence</fieldname>
<fieldname>assessments</fieldname>
<fieldname>usecaptcha</fieldname>
<fieldname>usetokens</fieldname>
<fieldname>bounce_email</fieldname>
<fieldname>attributedescriptions</fieldname>
<fieldname>emailresponseto</fieldname>
<fieldname>emailnotificationto</fieldname>
<fieldname>tokenlength</fieldname>
<fieldname>showxquestions</fieldname>
<fieldname>showgroupinfo</fieldname>
<fieldname>shownoanswer</fieldname>
<fieldname>showqnumcode</fieldname>
<fieldname>bouncetime</fieldname>
<fieldname>bounceprocessing</fieldname>
<fieldname>bounceaccounttype</fieldname>
<fieldname>bounceaccounthost</fieldname>
<fieldname>bounceaccountpass</fieldname>
<fieldname>bounceaccountencryption</fieldname>
<fieldname>bounceaccountuser</fieldname>
<fieldname>showwelcome</fieldname>
<fieldname>showprogress</fieldname>
<fieldname>questionindex</fieldname>
<fieldname>navigationdelay</fieldname>
<fieldname>nokeyboard</fieldname>
<fieldname>alloweditaftercompletion</fieldname>
<fieldname>googleanalyticsstyle</fieldname>
<fieldname>googleanalyticsapikey</fieldname>
</fields>
<rows>
<row>
<sid><![CDATA[599332]]></sid>
<gsid><![CDATA[1]]></gsid>
<admin><![CDATA[Denis Chenu]]></admin>
<adminemail><![CDATA[denis@shnoulle.net]]></adminemail>
<anonymized><![CDATA[N]]></anonymized>
<faxto/>
<format><![CDATA[G]]></format>
<savetimings><![CDATA[N]]></savetimings>
<template><![CDATA[skelvanilla]]></template>
<language><![CDATA[fr]]></language>
<additional_languages/>
<datestamp><![CDATA[N]]></datestamp>
<usecookie><![CDATA[N]]></usecookie>
<allowregister><![CDATA[N]]></allowregister>
<allowsave><![CDATA[Y]]></allowsave>
<autonumber_start><![CDATA[1]]></autonumber_start>
<autoredirect><![CDATA[N]]></autoredirect>
<allowprev><![CDATA[N]]></allowprev>
<printanswers><![CDATA[N]]></printanswers>
<ipaddr><![CDATA[N]]></ipaddr>
<refurl><![CDATA[N]]></refurl>
<showsurveypolicynotice><![CDATA[0]]></showsurveypolicynotice>
<publicstatistics><![CDATA[N]]></publicstatistics>
<publicgraphs><![CDATA[N]]></publicgraphs>
<listpublic><![CDATA[N]]></listpublic>
<htmlemail><![CDATA[Y]]></htmlemail>
<sendconfirmation><![CDATA[Y]]></sendconfirmation>
<tokenanswerspersistence><![CDATA[N]]></tokenanswerspersistence>
<assessments><![CDATA[N]]></assessments>
<usecaptcha><![CDATA[N]]></usecaptcha>
<usetokens><![CDATA[N]]></usetokens>
<bounce_email><![CDATA[denis@shnoulle.net]]></bounce_email>
<emailresponseto/>
<emailnotificationto/>
<tokenlength><![CDATA[15]]></tokenlength>
<showxquestions><![CDATA[Y]]></showxquestions>
<showgroupinfo><![CDATA[B]]></showgroupinfo>
<shownoanswer><![CDATA[N]]></shownoanswer>
<showqnumcode><![CDATA[X]]></showqnumcode>
<bounceprocessing><![CDATA[N]]></bounceprocessing>
<showwelcome><![CDATA[Y]]></showwelcome>
<showprogress><![CDATA[Y]]></showprogress>
<questionindex><![CDATA[0]]></questionindex>
<navigationdelay><![CDATA[0]]></navigationdelay>
<nokeyboard><![CDATA[N]]></nokeyboard>
<alloweditaftercompletion><![CDATA[N]]></alloweditaftercompletion>
</row>
</rows>
</surveys>
<surveys_languagesettings>
<fields>
<fieldname>surveyls_survey_id</fieldname>
<fieldname>surveyls_language</fieldname>
<fieldname>surveyls_title</fieldname>
<fieldname>surveyls_description</fieldname>
<fieldname>surveyls_welcometext</fieldname>
<fieldname>surveyls_endtext</fieldname>
<fieldname>surveyls_policy_notice</fieldname>
<fieldname>surveyls_policy_error</fieldname>
<fieldname>surveyls_policy_notice_label</fieldname>
<fieldname>surveyls_url</fieldname>
<fieldname>surveyls_urldescription</fieldname>
<fieldname>surveyls_email_invite_subj</fieldname>
<fieldname>surveyls_email_invite</fieldname>
<fieldname>surveyls_email_remind_subj</fieldname>
<fieldname>surveyls_email_remind</fieldname>
<fieldname>surveyls_email_register_subj</fieldname>
<fieldname>surveyls_email_register</fieldname>
<fieldname>surveyls_email_confirm_subj</fieldname>
<fieldname>surveyls_email_confirm</fieldname>
<fieldname>surveyls_dateformat</fieldname>
<fieldname>surveyls_attributecaptions</fieldname>
<fieldname>email_admin_notification_subj</fieldname>
<fieldname>email_admin_notification</fieldname>
<fieldname>email_admin_responses_subj</fieldname>
<fieldname>email_admin_responses</fieldname>
<fieldname>surveyls_numberformat</fieldname>
<fieldname>attachments</fieldname>
</fields>
<rows>
<row>
<surveyls_survey_id><![CDATA[599332]]></surveyls_survey_id>
<surveyls_language><![CDATA[fr]]></surveyls_language>
<surveyls_title><![CDATA[Check]]></surveyls_title>
<surveyls_description/>
<surveyls_welcometext/>
<surveyls_endtext/>
<surveyls_url/>
<surveyls_urldescription/>
<surveyls_email_invite_subj><![CDATA[Invitation à participer à un questionnaire]]></surveyls_email_invite_subj>
<surveyls_email_invite><![CDATA[Cher(e) {FIRSTNAME},<br />
<br />
Vous avez été invité(e) à participer à un questionnaire.<br />
<br />
Celui-ci est intitulé :<br />
"{SURVEYNAME}"<br />
<br />
"{SURVEYDESCRIPTION}"<br />
<br />
Pour participer, veuillez cliquer sur le lien ci-dessous.<br />
<br />
Cordialement,<br />
<br />
{ADMINNAME} ({ADMINEMAIL})<br />
<br />
----------------------------------------------<br />
Cliquez ici pour remplir ce questionnaire :<br />
{SURVEYURL}<br />
<br />
Si vous ne souhaitez pas participer à ce questionnaire et ne souhaitez plus recevoir aucune invitation, veuillez cliquer sur le lien suivant :<br />
{OPTOUTURL}<br />
<br />
Si vous êtes sur liste noire mais que vous voulez participer à ce questionnaire et recevoir les invitations, merci de cliquer sur le lien suivant :<br />
{OPTINURL}]]></surveyls_email_invite>
<surveyls_email_remind_subj><![CDATA[Rappel pour participer à un questionnaire]]></surveyls_email_remind_subj>
<surveyls_email_remind><![CDATA[Cher(e) {FIRSTNAME},<br />
<br />
Vous avez été invité(e) à participer à un questionnaire récemment.<br />
<br />
Nous avons pris en compte que vous n’avez pas encore complété le questionnaire, et nous vous rappelons que celui-ci est toujours disponible si vous souhaitez participer.<br />
<br />
Le questionnaire est intitulé :<br />
"{SURVEYNAME}"<br />
<br />
"{SURVEYDESCRIPTION}"<br />
<br />
Pour participer, veuillez cliquer sur le lien ci-dessous.<br />
<br />
Cordialement,<br />
<br />
{ADMINNAME} ({ADMINEMAIL})<br />
<br />
----------------------------------------------<br />
Cliquez ici pour faire le questionnaire :<br />
{SURVEYURL}<br />
<br />
Si vous ne souhaitez pas participer à ce questionnaire et ne souhaitez plus recevoir aucune invitation, veuillez cliquer sur le lien suivant :<br />
{OPTOUTURL}]]></surveyls_email_remind>
<surveyls_email_register_subj><![CDATA[Confirmation d’enregistrement pour le questionnaire]]></surveyls_email_register_subj>
<surveyls_email_register><![CDATA[Bonjour {FIRSTNAME},<br />
<br />
Vous (ou quelqu’un utilisant votre adresse électronique) vous êtes enregistré pour participer à un questionnaire en ligne intitulé {SURVEYNAME}.<br />
<br />
Pour compléter ce questionnaire, cliquez sur le lien suivant :<br />
{SURVEYURL}<br />
<br />
Si vous avez des questions à propos de ce questionnaire, ou si vous ne vous êtes pas enregistré pour participer à celui-ci et croyez que ce message est une erreur, veuillez contacter {ADMINNAME} à l’adresse {ADMINEMAIL}]]></surveyls_email_register>
<surveyls_email_confirm_subj><![CDATA[Confirmation de votre participation à notre questionnaire]]></surveyls_email_confirm_subj>
<surveyls_email_confirm><![CDATA[Bonjour {FIRSTNAME},<br />
<br />
Ce message vous confirme que vous avez complété le questionnaire intitulé {SURVEYNAME} et que votre réponse a été enregistrée. Merci pour votre participation.<br />
<br />
Si vous avez des questions à propos de ce message, veuillez contacter {ADMINNAME} à l’adresse {ADMINEMAIL}.<br />
<br />
Cordialement,<br />
<br />
{ADMINNAME}]]></surveyls_email_confirm>
<surveyls_dateformat><![CDATA[1]]></surveyls_dateformat>
<email_admin_notification_subj><![CDATA[Soumission de réponse pour le questionnaire {SURVEYNAME}]]></email_admin_notification_subj>
<email_admin_notification><![CDATA[Bonjour,<br />
<br />
Une nouvelle réponse a été soumise pour votre questionnaire '{SURVEYNAME}'.<br />
<br />
Cliquez sur le lien suivant pour voir la réponse :<br />
{VIEWRESPONSEURL}<br />
<br />
Cliquez sur le lien suivant pour éditer la réponse :<br />
{EDITRESPONSEURL}<br />
<br />
Visualisez les statistiques en cliquant ici :<br />
{STATISTICSURL}]]></email_admin_notification>
<email_admin_responses_subj><![CDATA[Soumission de réponse pour le questionnaire {SURVEYNAME} avec résultats]]></email_admin_responses_subj>
<email_admin_responses><![CDATA[Bonjour,<br />
<br />
Une nouvelle réponse a été soumise pour votre questionnaire '{SURVEYNAME}'.<br />
<br />
Cliquez sur le lien suivant pour voir cette réponse :<br />
{VIEWRESPONSEURL}<br />
<br />
Cliquez sur le lien suivant pour éditer cette réponse individuelle :<br />
{EDITRESPONSEURL}<br />
<br />
Visualisez les statistiques en cliquant ici :<br />
{STATISTICSURL}<br />
<br />
<br />
Les réponses suivantes ont été données par le participant :<br />
{ANSWERTABLE}]]></email_admin_responses>
<surveyls_numberformat><![CDATA[0]]></surveyls_numberformat>
</row>
</rows>
</surveys_languagesettings>
<themes>
<theme>
<sid>599332</sid>
<template_name>skelvanilla</template_name>
<config>
<options>inherit</options>
</config>
</theme>
</themes>
<themes_inherited>
<theme>
<sid>599332</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>
|
|
|
|
|
|
Oh, because max int value? |
|
|
"99999999999999999999999999" -> int overflow when cast to int. |
|
|
Yes, Then need a try/cast at https://github.com/LimeSurvey/LimeSurvey/blob/a90933d7c1c1084d69a94e2ff60c005e1d9510e7/application/controllers/admin/checkintegrity.php#L537 |
|
|
Lol, No need MSSQL, import included survey, and try to check integrity.$ |
|
|
|
|
|
|
 |
I am noticing you have 2 PRs already for this. |
|
|
I didn't set it as "code review" |
|
|
review by other dev :) |
|
|
On Master: After importing the survey, run "Data Integrity", no dump. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-07-21 12:32 | DenisChenu | New Issue | |
| 2021-07-21 12:32 | DenisChenu | File Added: Capture d’écran du 2021-07-21 12-18-05.png | |
| 2021-07-21 12:32 | DenisChenu | File Added: CDbException.html | |
| 2021-07-21 12:33 | DenisChenu | Severity | block => partial_block |
| 2021-07-21 12:36 | ollehar | Note Added: 65516 | |
| 2021-07-21 12:44 | DenisChenu | Note Added: 65517 | |
| 2021-07-21 12:46 | DenisChenu | Note Added: 65518 | |
| 2021-07-21 12:46 | DenisChenu | File Added: 500 Erreur interne au serveur.html | |
| 2021-07-21 12:46 | DenisChenu | File Added: limesurvey_survey_NoInt500.lss | |
| 2021-07-21 12:53 | DenisChenu | Note Added: 65519 | |
| 2021-07-21 12:53 | DenisChenu | File Added: limesurvey_survey_2147483647.lss | |
| 2021-07-21 15:55 | DenisChenu | Note Added: 65531 | |
| 2021-07-21 15:57 | DenisChenu | Note Edited: 65531 | |
| 2021-07-21 15:58 | ollehar | Note Added: 65533 | |
| 2021-07-21 15:58 | ollehar | Note Added: 65534 | |
| 2021-07-21 16:32 | DenisChenu | Note Added: 65542 | |
| 2021-08-19 15:39 | duvemyster | Issue Monitored: duvemyster | |
| 2021-08-19 15:39 | duvemyster | Bug heat | 4 => 6 |
| 2021-10-28 09:32 | galads | Assigned To | => galads |
| 2021-10-28 09:32 | galads | Status | new => confirmed |
| 2022-03-22 20:45 | DenisChenu | Relationship added | has duplicate 17981 |
| 2022-03-22 20:45 | DenisChenu | Bug heat | 6 => 12 |
| 2022-03-22 20:58 | labd1301 | Bug heat | 12 => 14 |
| 2022-03-24 14:23 | DenisChenu | Note Added: 68794 | |
| 2022-03-24 14:23 | DenisChenu | File Added: Capture d’écran du 2022-03-24 14-21-38.png | |
| 2022-03-24 14:23 | DenisChenu | File Added: survey_archive_542957.lsa | |
| 2022-03-24 18:06 | DenisChenu | Note Added: 68795 | |
| 2022-03-24 18:19 | DenisChenu | Note Added: 68796 | |
| 2022-05-04 08:28 | galads | Assigned To | galads => gabrieljenik |
| 2022-05-04 08:28 | galads | Status | confirmed => assigned |
| 2022-05-05 18:54 | gabrieljenik | Note Added: 69430 | |
| 2022-05-05 18:54 | gabrieljenik | Bug heat | 14 => 16 |
| 2022-05-05 18:55 | gabrieljenik | Assigned To | gabrieljenik => DenisChenu |
| 2022-05-05 20:51 | DenisChenu | Status | assigned => ready for code review |
| 2022-05-05 20:52 | DenisChenu | Note Added: 69441 | |
| 2022-05-06 08:48 | DenisChenu | Assigned To | DenisChenu => |
| 2022-05-06 08:48 | DenisChenu | Note Added: 69453 | |
| 2022-06-27 01:52 | gabrieljenik | Note Added: 70541 | |
| 2022-06-27 01:52 | gabrieljenik | File Added: image.png |
