|
|
Has this happened more than once?
Can you please provide more precise instructions on how to reproduce? Preferably in a step-by-step manner, like 1) Go to question x; 2) Click button y; 3) Expected z but saw v. Thank you very much. |
|
|
|
Yes. This happened when the survey is more than 200 responses.
Also, it is found that there are no duplication in the submission table.
Step-by-Step manner:
- Select an survey with more than 200 responses
- Select Responses and Statistic under Responses
- Select Export responses under Export
- Select "Export Format" as Microsoft Excel and Completed Responses only
- Export
After that, the downloaded excel contains duplicated entries in the file.
Thank you. |
|
|
|
Does this happen on many surveys or just one? |
|
|
|
But here : it's not duplicate for sure. Order of id can be different when export thand ASC
Can you export the LSA (private upload is possible) |
|
|
|
The problem happened in all the Surveys |
|
|
|
Can you export the 453141 data here ? Want to check something.
(i can not reproduce with the lsa) |
|
|
|
WTF …
No idea here … |
|
|
|
Hi Denis,
I would like to supplement additional information to see if you could simulate our case.
- We are using Microsoft SQL Server 2016 as the database
- I have tried to install the latest version, i.e. v5.3.17+220525 and import the lsa, the problem still occurs
I am wondering if it is related to the database we are using.
Thank you. |
|
|
|
Oh,
let let check on MS SQL |
|
|
|
I am sorry. I wasn't able to reproduce the issue.
Maybe you have 2 copies of the plugins working together?
Can you please try on a fresh installation?
I am sorry to suggest this, but not sure there is much to suggest without debugging on your ENV (which is kind of out of the scope) :) Hope you understand.
Thanks |
|
|
|
I have tried to import the LSA in a fresh installation of the limesurvey and the issue is still exists.
I am not sure if the issue is related to the environment or not.
We are using Windows Server 2016 with SQL Server 2016 as the database. |
|
|
|
let let check on MS SQL
@DenisChenu Were you able to reproduce with MsSQL? |
|
|
|
Need to found time … |
|
|
|
hi Gabriel & Denis,
I have just tried to install the a clean LimeSurvey Version 5.3.17+220525 , SQL Server 2016, PHP 8.1 and php_pdo_sqlsrv_81 in another Windows Server and import the LSA again.
The export issue also exist.
I think it is very likely a SQL server issue. |
|
|
|
Issue confirmed with 5.3.9 / PHP 7.4.27 / IIS/10.0 / SQLServer 15
happen after 763 id, goes to 673 id (already export before
I update to last and check again. |
|
|
|
last git : confirmed |
|
|
|
timing related ?
'from' => '[{{survey_453141}}]'
'join' => array
(
0 => 'LEFT JOIN [{{survey_453141_timings}}] [survey_timings] ON {{survey_453141}}.id = survey_timings.id'
)
'where' => '{{survey_453141}}.id >= :min AND {{survey_453141}}.id <= :max'
'order' => '[{{survey_453141}}].[id] ASC'
'select' => '[{{survey_453141}}].[id], [survey_timings].[interviewtime], [survey_timings].[453141X27time], [survey_timings].[453141X27X830time], [survey_timings].[453141X27X834time], [survey_timings].[453141X27X835time], [survey_timings].[453141X27X831time], [survey_timings].[453141X27X832time], [survey_timings].[453141X27X833time], [survey_timings].[453141X27X836time]'
)
|
|
|
|
Hi Denis,
I am not sure about the source code above... |
|
|
|
@hinghang : it the instruction done when try to export data with MS SQL.
It's a really hard issue to fix … 1. i don't have a direct access to a SQL database ;) 2. There are no clean error error here 3. No issue in code 4. SQL issue like this is always more complex to trace … |
|
|
|
@DenisChenu
Sorry to interrupt again. Any idea for fixing the issue? :) |
|
|
|
Same problem here... but with surveys with more than 100 responses :( |
|
|
|
Sorry to interrupt again. Any idea for fixing the issue? :)
No i have to find where and why it happens only to MSSQL
@Maxlo158 : this picture show only disorder not duplicate |
|
|
|
...for more clarity |
|
|
|
MS SQL too ?
Timing activated ?
(i try to reproduce with a more simple survey to find where it broken …) |
|
|
|
Yes, we're using MS SQL on SUSE linux.
Where to check timings/activate them?
(PS: sorry, I'm new to LimeSurvey administration) |
|
|
|
Origin of this issue https://github.com/LimeSurvey/LimeSurvey/commit/b72beace8740d02e13c478cf2f390cc731948370
Maybe fixed in Yii 2 : https://github.com/yiisoft/yii2/blob/364e907875fd57ee218085cca796ac5d1c3c8d51/framework/db/mssql/QueryBuilder.php#L73 |
|
|
|
See the issue when not check reponse id :
CDbException.html (22,795 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[42S22]:
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column
name 'id'.. The SQL statement executed was: SELECT * FROM (SELECT TOP
100 * FROM (SELECT TOP 200 [lime_survey_444682].[submitdate],
[tokentable].[tid], [tokentable].[participant_id],
[tokentable].[firstname], [tokentable].[lastname], [tokentable].[email],
[tokentable].[emailstatus], [tokentable].[language],
[tokentable].[blacklisted], [tokentable].[sent],
[tokentable].[remindersent], [tokentable].[remindercount],
[tokentable].[completed], [tokentable].[usesleft],
[tokentable].[validfrom], [tokentable].[validuntil],
[tokentable].[mpid], [tokentable].[attribute_1],
[tokentable].[attribute_2], [tokentable].[attribute_3]<br>
FROM [lime_survey_444682]<br>
LEFT JOIN [lime_tokens_444682] [tokentable] ON lime_survey_444682.token=tokentable.token<br>
WHERE lime_survey_444682.id >= :min AND lime_survey_444682.id <= :max<br>
ORDER BY [lime_survey_444682].[id] ASC) as [__inner__] ORDER BY
[__inner__].[id] DESC) as [__outer__] ORDER BY [__outer__].[id] ASC </p>
<div class="source">
<p class="file">E:\IIS\website\third_party\yiisoft\yii\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>
E:\IIS\website\third_party\yiisoft\yii\framework\db\CDbCommand.php(377): <strong>CDbCommand</strong>-><strong>queryInternal</strong>("", 0, array("min" => "4814", "max" => "5082")) </div>
<div class="code"><pre><span class="ln">372</span> * @return CDbDataReader the reader object for fetching the query result
<span class="ln">373</span> * @throws CException execution failed
<span class="ln">374</span> */
<span class="ln">375</span> public function query($params=array())
<span class="ln">376</span> {
<span class="error"><span class="ln error-ln">377</span> return $this->queryInternal('',0,$params);
</span><span class="ln">378</span> }
<span class="ln">379</span>
<span class="ln">380</span> /**
<span class="ln">381</span> * Executes the SQL statement and returns all rows.
<span class="ln">382</span> * @param boolean $fetchAssociative whether each row should be returned as an associated array with
</pre></div> </td>
</tr>
<tr class="trace app expanded">
<td class="number">
#1 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\IIS\website\application\helpers\admin\exportresults_helper.php(118): <strong>CDbCommand</strong>-><strong>query</strong>() </div>
<div class="code"><pre><span class="ln">113</span> for ($i = 0; $i < $maxPages; $i++) {
<span class="ln">114</span> $offset = $i * $maxRows;
<span class="ln">115</span> $responsesQuery = $surveyDao->loadSurveyResults($survey, $oOptions->responseMinRecord, $oOptions->responseMaxRecord, $sFilter, $oOptions->responseCompletionState, $oOptions->selectedColumns, $oOptions->aResponses);
<span class="ln">116</span> $responsesQuery->offset($offset);
<span class="ln">117</span> $responsesQuery->limit($maxRows);
<span class="error"><span class="ln error-ln">118</span> $survey->responses = $responsesQuery->query();
</span><span class="ln">119</span> $writer->write($survey, $sLanguageCode, $oOptions, true);
<span class="ln">120</span> }
<span class="ln">121</span> $result = $writer->close();
<span class="ln">122</span>
<span class="ln">123</span> // Close resultset if needed
</pre></div> </td>
</tr>
<tr class="trace app expanded">
<td class="number">
#2 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\IIS\website\application\controllers\admin\Export.php(359): <strong>ExportSurveyResultsService</strong>-><strong>exportResponses</strong>("444682", "en", "csv", FormattingOptions, ...) </div>
<div class="code"><pre><span class="ln">354</span> } else {
<span class="ln">355</span> $sFilter = '';
<span class="ln">356</span> }
<span class="ln">357</span>
<span class="ln">358</span> viewHelper::disableHtmlLogging();
<span class="error"><span class="ln error-ln">359</span> $resultsService->exportResponses($iSurveyID, $explang, $sExportType, $options, $sFilter);
</span><span class="ln">360</span>
<span class="ln">361</span> Yii::app()->end();
<span class="ln">362</span> }
<span class="ln">363</span>
<span class="ln">364</span> /**
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#3 </td>
<td class="content">
<div class="trace-file">
unknown(0): <strong>Export</strong>-><strong>exportresults</strong>() </div>
</td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#4 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\IIS\website\third_party\yiisoft\yii\framework\web\actions\CAction.php(115): <strong>ReflectionMethod</strong>-><strong>invokeArgs</strong>(Export, 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 expanded">
<td class="number">
#5 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\IIS\website\application\core\SurveyCommonAction.php(83): <strong>CAction</strong>-><strong>runWithParamsInternal</strong>(Export,
ReflectionMethod, array("r" =>
"admin/export/sa/exportresults/surveyid/444682", "sa" =>
"exportresults", "surveyid" => "444682", "iSurveyId" => "444682",
...)) </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">
#6 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\IIS\website\third_party\yiisoft\yii\framework\web\CController.php(308): <strong>SurveyCommonAction</strong>-><strong>runWithParams</strong>(array("r"
=> "admin/export/sa/exportresults/surveyid/444682", "sa" =>
"exportresults", "surveyid" => "444682", "iSurveyId" => "444682",
...)) </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">
#7 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\IIS\website\third_party\yiisoft\yii\framework\web\CController.php(286): <strong>CController</strong>-><strong>runAction</strong>(Export) </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">
#8 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\IIS\website\third_party\yiisoft\yii\framework\web\CController.php(265): <strong>CController</strong>-><strong>runActionWithFilters</strong>(Export, 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">
#9 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\IIS\website\application\controllers\AdminController.php(202): <strong>CController</strong>-><strong>run</strong>("export") </div>
<div class="code"><pre><span class="ln">197</span> }
<span class="ln">198</span>
<span class="ln">199</span> $this->runModuleController($action);
<span class="ln">200</span>
<span class="ln">201</span>
<span class="error"><span class="ln error-ln">202</span> return parent::run($action);
</span><span class="ln">203</span> }
<span class="ln">204</span>
<span class="ln">205</span> /**
<span class="ln">206</span> * Starting with LS4, 3rd party developer can extends any of the LimeSurve controllers.
<span class="ln">207</span> *
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#10 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\IIS\website\third_party\yiisoft\yii\framework\web\CWebApplication.php(282): <strong>AdminController</strong>-><strong>run</strong>("export") </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">
#11 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\IIS\website\third_party\yiisoft\yii\framework\web\CWebApplication.php(141): <strong>CWebApplication</strong>-><strong>runController</strong>("admin/export/sa/exportresults/surveyid/444682") </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">
#12 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\IIS\website\third_party\yiisoft\yii\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">
#13 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
E:\IIS\website\index.php(192): <strong>CApplication</strong>-><strong>run</strong>() </div>
<div class="code"><pre><span class="ln">187</span> require_once APPPATH . 'core/LSYii_Application' . EXT;
<span class="ln">188</span>
<span class="ln">189</span> $config = require_once(APPPATH . 'config/internal' . EXT);
<span class="ln">190</span>
<span class="ln">191</span> Yii::$enableIncludePath = false;
<span class="error"><span class="ln error-ln">192</span> Yii::createApplication('LSYii_Application', $config)->run();
</span><span class="ln">193</span>
<span class="ln">194</span> /* End of file index.php */
<span class="ln">195</span> /* Location: ./index.php */
</pre></div> </td>
</tr>
</tbody></table>
</div>
<div class="version">
2022-10-13 16:50:48 Microsoft-IIS/10.0 <a href="https://www.yiiframework.com/">Yii Framework</a>/1.1.26-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>
|
|
|
|
Argl … even replacing function applyLimit didn't fix the issue … |
|
|
|
@Maxlo158 : if you can find time to test https://github.com/LimeSurvey/LimeSurvey/pull/2673 |
|
|
|
I saw the fix.
Still don't uderstand the problem.
What's wrong? Why is this happening only on the export? |
|
|
|
What's wrong? Why is this happening only on the export?
Unsure the "only" , maybe it happen on other part … each time where you have a limit and an offset.
MS SQL server have some strange issue sometimes …
Else: see issue in Yii 2 :
https://github.com/yiisoft/yii2/commit/212c5ee3ef2eb244f7ca346ea1825427200b3394
https://github.com/yiisoft/yii2/pull/4254#issuecomment-48734900
This is surely not only for export, but have multiple times same sid on dynamic list are less seen ?
See 2 times same survey when move next/previous is not a BIG issue …
I try to check if it's happen :) in 3.X |
|
|
|
I try to check if it's happen :) in 3.X
Not happen in browse response 10 by ten. But all id are here , maybe related ? I check with another one.
And i need more than200 response :) and limit by 100 …
Yes. This happened when the survey is more than 200 responses.
|
|
|
|
Maybe we should place it in dev branch?
Better if release on a major upgrade |
|
|
|
It's a MAJOR issue for ALL sql user,
And it potentially broke only SQL user … |
|
|
|
Yes, but so far only found on export, very hard to test and hence possible of destabilization.
Analyzing "Current Pain vs Risk vs Reward" doesn't look tempting to push it soon.
Maybe some MsSQL user can test the PR and hae the patch installed for a while before releasing. |
|
|
|
Maybe some MsSQL user can test the PR and hae the patch installed for a while before releasing.
I have it … and i have another server for testing (need to go to it via 3 VPN server)
But yes : need other tester … i never say i'm the only one
Have a survey system where you can be sure of the export (and mybe some other place) : don't use this system … |
|
|
|
I am not worries about testing the export process.
I am worried about collateral effects.
That's why I suggest to have some user to install it on a system of their own, so the patch can be used in different situations |
|
|
|
I think i got it :
It seems to happen at end of the export
SQL server use limit before offset, then : at end take the 100 last.
Why this is not shown in grid : because seeing 10 value at end IS ok
But with mysql : if you have 15 value : 1st page have 10 and 2nd have 5
With MS sql : 1st page have 10 and 2nd have 10
I create the issue for 3X too when i found time |
|
|
|
@ahhsung please : can you test the patch
https://github.com/LimeSurvey/LimeSurvey/pull/2673 |
|
|
|
Same issue happen in 3.X : https://bugs.limesurvey.org/view.php?id=18420
But not a real issue |
|
|
|
@DenisChenu
I cannot login my original account @ahhsung :( . Anyway, it is verified the fix is working in LimeSurvey v5.3.18 |
|
|
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=33988 |
|
|
|
Fixed in Release 5.4.9+221101 |
|
