17458: Check integrety broke with SQL error - LimeSurvey bugs and feature requests

This bug affects 2 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

17458	Bug reports	Database design	public	2021-07-21 12:32	2023-06-01 17:44

Reporter	DenisChenu	Assigned To	adamzammit
Priority	none	Severity	partial_block
Status	closed	Resolution	fixed
Product Version	3.25.17
Fixed in Version	3.28.x

Summary	17458: Check integrety broke with SQL error
Description	When have subquestion with integer : checkintegrity can break
Steps To Reproduce	Create a lot of question Create a subquestion with 99999 for code. For me : qid : 339316 / 87481
Additional Information	MS SQL only ? Maybe we can move to bigint for qid ? What is your biggest number at limeservice ?
Tags	No tags attached.
Attached Files	Capture d’écran du 2021-07-21 12-18-05.png (31,908 bytes) Capture d’écran du 2021-07-21 12-18-05.png (31,908 bytes) 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> CDbException.html (25,634 bytes)

Bug heat	28
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

User List	duvemyster, labd1301

ollehar 2021-07-21 12:36 administrator ~65516	lss?

DenisChenu 2021-07-21 12:44 developer ~65517	Why ? qid is resetted … But i check with 99999999999999999997 to see what happen on mariadb too

DenisChenu 2021-07-21 12:46 developer ~65518	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> 500 Erreur interne au serveur.html (13,053 bytes) 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> limesurvey_survey_NoInt500.lss (22,634 bytes)

DenisChenu 2021-07-21 12:53 developer ~65519	qid: 3652 / subqid code 999997 : no issue in mariadb even if 3652999997 > 2147483647 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> limesurvey_survey_2147483647.lss (22,671 bytes)

DenisChenu 2021-07-21 15:55 developer ~65531 Last edited: 2021-07-21 15:57	broken line : https://github.com/LimeSurvey/LimeSurvey/blob/a90933d7c1c1084d69a94e2ff60c005e1d9510e7/application/controllers/admin/checkintegrity.php#L533 Since : https://github.com/LimeSurvey/LimeSurvey/blob/a90933d7c1c1084d69a94e2ff60c005e1d9510e7/application/controllers/admin/checkintegrity.php#L560

ollehar 2021-07-21 15:58 administrator ~65533	Oh, because max int value?

ollehar 2021-07-21 15:58 administrator ~65534	"99999999999999999999999999" -> int overflow when cast to int.

DenisChenu 2021-07-21 16:32 developer ~65542	"99999999999999999999999999" -> int overflow when cast to int. Yes, BUT : with SQL sometime PHP int is bigger than SQL int. Then need a try/cast at https://github.com/LimeSurvey/LimeSurvey/blob/a90933d7c1c1084d69a94e2ff60c005e1d9510e7/application/controllers/admin/checkintegrity.php#L537

DenisChenu 2022-03-24 14:23 developer ~68794	Lol, No need MSSQL, import included survey, and try to check integrity.$ Capture d’écran du 2022-03-24 14-21-38.png (126,654 bytes) survey_archive_542957.lsa (4,126 bytes)

DenisChenu 2022-03-24 18:06 developer ~68795	https://github.com/LimeSurvey/LimeSurvey/pull/2312

DenisChenu 2022-03-24 18:19 developer ~68796	https://github.com/LimeSurvey/LimeSurvey/pull/2313

gabrieljenik 2022-05-05 18:54 manager ~69430	@DenisChenu I am noticing you have 2 PRs already for this. Assigning it to you.

DenisChenu 2022-05-05 20:52 developer ~69441	I didn't set it as "code review"

DenisChenu 2022-05-06 08:48 developer ~69453	review by other dev :)

gabrieljenik 2022-06-27 01:52 manager ~70541	On Master: After importing the survey, run "Data Integrity", no dump. image.png (62,026 bytes) image.png (62,026 bytes)

DenisChenu 2022-07-20 10:28 developer ~71043	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=33662

DenisChenu 2022-07-21 11:42 developer ~71070	Fix committed to 3.x-LTS branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=33665

DenisChenu 2022-07-21 11:43 developer ~71071	and 5.X

LimeBot 2022-07-25 10:15 administrator ~71112	Fixed in Release 3.28.21+220726

adamzammit 2023-06-01 17:44 developer ~75339	Fix committed to 3.x-LTS branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=34757

LimeSurvey: master 1dc8b53e 2022-07-20 12:28 DenisChenu Committer: GitHub Details Diff	Fixed issue 17458: Check integrty broke fpor subquestion with only number (#2313) Dev: Try cast and don't throw error	Affected Issues 17458
	mod - application/controllers/admin/CheckIntegrity.php	Diff File
LimeSurvey: 3.x-LTS 5031c861 2022-07-21 13:42 DenisChenu Committer: GitHub Details Diff	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	Affected Issues 17458
	mod - application/controllers/admin/checkintegrity.php	Diff File
LimeSurvey: 3.x-LTS 6cd2e8b8 2023-06-01 19:35 adamzammit 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 ---------	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, 18128, 18129, 18133, 18134, 18140, 18141, 18186, 18201, 18209, 18240, 18338, 18343, 18344, 18351, 18407, 18430, 18461, 18488, 18532, 18562, 18603, 18634, 18639, 18703
	mod - application/controllers/admin/printablesurvey.php	Diff File

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
2022-07-04 22:05	labd1301	Issue Monitored: labd1301
2022-07-04 22:05	labd1301	Bug heat	16 => 24
2022-07-14 15:38	gabrieljenik	Status	ready for code review => ready for testing
2022-07-20 10:28	DenisChenu	Changeset attached	=> LimeSurvey master 1dc8b53e
2022-07-20 10:28	DenisChenu	Note Added: 71043
2022-07-20 10:28	DenisChenu	Assigned To	=> DenisChenu
2022-07-20 10:28	DenisChenu	Resolution	open => fixed
2022-07-21 11:42	DenisChenu	Changeset attached	=> LimeSurvey 3.x-LTS 5031c861
2022-07-21 11:42	DenisChenu	Note Added: 71070
2022-07-21 11:43	DenisChenu	Status	ready for testing => resolved
2022-07-21 11:43	DenisChenu	Fixed in Version	=> 3.28.x
2022-07-21 11:43	DenisChenu	Note Added: 71071
2022-07-25 10:15	LimeBot	Note Added: 71112
2022-07-25 10:15	LimeBot	Status	resolved => closed
2022-07-25 10:15	LimeBot	Bug heat	24 => 26
2023-02-02 18:07	DenisChenu	Relationship added	related to 18614
2023-06-01 17:44	adamzammit	Changeset attached	=> LimeSurvey 3.x-LTS 6cd2e8b8
2023-06-01 17:44	adamzammit	Note Added: 75339
2023-06-01 17:44	adamzammit	Bug heat	26 => 28
2023-06-01 17:44	adamzammit	Assigned To	DenisChenu => adamzammit

View Issue Details

Relationships

Users monitoring this issue

Activities

Related Changesets

Issue History

has duplicate	17981	closed		"check data integrity" issue
related to	18614	closed	c_schmitz	lime_questions ERROR: Value '27373432210' is out of bounds for type integer at character 52