View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 07083 | Bug reports | Response browsing | public | 2012-12-14 13:25 | 2013-01-08 22:32 |
| Reporter | pfpDave | Assigned To | c_schmitz | ||
| Priority | normal | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 2.00+ | ||||
| Fixed in Version | 2.00+ | ||||
| Summary | 07083: CDbException error when using the Show Next / Show Last buttons in the response browser | ||||
| Description | When browsing responses that span onto several pages, clicking the 'Show Next' (page) or 'Show Last' buttons gives the error: CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]The column 'token' was specified multiple times for 'inner'.. The SQL statement executed was: SELECT FROM (SELECT TOP 10 FROM (SELECT TOP 20 tokens., t. FROM [dbo].[survey_678563] [t] LEFT JOIN tokens_678563 tokens ON t.token = tokens.token ORDER BY id asc) as [inner] ORDER BY [id] DESC) as [outer] ORDER BY [id] asc Full exception attached | ||||
| Steps To Reproduce |
| ||||
| Tags | No tags attached. | ||||
| Attached Files | CDbException.htm (37,359 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[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]The column 'token' was specified multiple times for '__inner__'.. The SQL statement executed was: SELECT * FROM (SELECT TOP 10 * FROM (SELECT TOP 20 tokens.*, t.* FROM [dbo].[survey_678563] [t] LEFT JOIN tokens_678563 tokens ON t.token = tokens.token ORDER BY id asc) as [__inner__] ORDER BY [id] DESC) as [__outer__] ORDER BY [id] asc </p>
<div class="source">
<p class="file">C:\limesurvey_test\framework\db\CDbCommand.php(528)</p>
<div class="code"><pre><span class="ln">516</span> return $result;
<span class="ln">517</span> }
<span class="ln">518</span> catch(Exception $e)
<span class="ln">519</span> {
<span class="ln">520</span> if($this->_connection->enableProfiling)
<span class="ln">521</span> Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query');
<span class="ln">522</span> $errorInfo = $e instanceof PDOException ? $e->errorInfo : null;
<span class="ln">523</span> $message = $e->getMessage();
<span class="ln">524</span> Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',
<span class="ln">525</span> array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
<span class="ln">526</span> if(YII_DEBUG)
<span class="ln">527</span> $message .= '. The SQL statement executed was: '.$this->getText().$par;
<span class="error"><span class="ln error-ln">528</span> throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
</span><span class="ln">529</span> array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
<span class="ln">530</span> }
<span class="ln">531</span> }
<span class="ln">532</span>
<span class="ln">533</span> /**
<span class="ln">534</span> * Builds a SQL SELECT statement from the given query specification.
<span class="ln">535</span> * @param array $query the query specification in name-value pairs. The following
<span class="ln">536</span> * query options are supported: {@link select}, {@link distinct}, {@link from},
<span class="ln">537</span> * {@link where}, {@link join}, {@link group}, {@link having}, {@link order},
<span class="ln">538</span> * {@link limit}, {@link offset} and {@link union}.
<span class="ln">539</span> * @return string the SQL statement
<span class="ln">540</span> * @since 1.1.6
</pre></div> </div>
<div class="traces">
<h2>Stack Trace</h2>
<table style="width:100%;">
<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>
C:\limesurvey_test\framework\db\CDbCommand.php(390): <strong>CDbCommand</strong>-><strong>queryInternal</strong>("fetchAll", array(2), array()) </div>
<div class="code"><pre><span class="ln">385</span> * An empty array is returned if the query results in nothing.
<span class="ln">386</span> * @throws CException execution failed
<span class="ln">387</span> */
<span class="ln">388</span> public function queryAll($fetchAssociative=true,$params=array())
<span class="ln">389</span> {
<span class="error"><span class="ln error-ln">390</span> return $this->queryInternal('fetchAll',$fetchAssociative ? $this->_fetchMode : PDO::FETCH_NUM, $params);
</span><span class="ln">391</span> }
<span class="ln">392</span>
<span class="ln">393</span> /**
<span class="ln">394</span> * Executes the SQL statement and returns the first row of the result.
<span class="ln">395</span> * This is a convenient method of {@link query} when only the first row of data is needed.
</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>
C:\limesurvey_test\application\models\LSActiveRecord.php(48): <strong>CDbCommand</strong>-><strong>queryAll</strong>() </div>
<div class="code"><pre><span class="ln">43</span>
<span class="ln">44</span> $command = $this->getCommandBuilder()->createFindCommand($this->getTableSchema(), $criteria);
<span class="ln">45</span> //For debug, this command will get you the generated sql:
<span class="ln">46</span> //echo $command->getText();
<span class="ln">47</span>
<span class="error"><span class="ln error-ln">48</span> return $all ? $command->queryAll() : $command->queryRow();
</span><span class="ln">49</span> }
<span class="ln">50</span> }
<span class="ln">51</span>
<span class="ln">52</span> /**
<span class="ln">53</span> * Finds all active records satisfying the specified condition but returns them as array
</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>
C:\limesurvey_test\application\models\LSActiveRecord.php(64): <strong>LSActiveRecord</strong>-><strong>query</strong>(CDbCriteria, true, false) </div>
<div class="code"><pre><span class="ln">59</span> */
<span class="ln">60</span> public function findAllAsArray($condition = '', $params = array())
<span class="ln">61</span> {
<span class="ln">62</span> Yii::trace(get_class($this) . '.findAll()', 'system.db.ar.CActiveRecord');
<span class="ln">63</span> $criteria = $this->getCommandBuilder()->createCriteria($condition, $params);
<span class="error"><span class="ln error-ln">64</span> return $this->query($criteria, true, false); //Notice the third parameter 'false'
</span><span class="ln">65</span> }
<span class="ln">66</span> }</pre></div> </td>
</tr>
<tr class="trace app expanded">
<td class="number">
#3 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
C:\limesurvey_test\application\controllers\admin\responses.php(522): <strong>LSActiveRecord</strong>-><strong>findAllAsArray</strong>(CDbCriteria) </div>
<div class="code"><pre><span class="ln">517</span>
<span class="ln">518</span> $oCriteria->order = 'id ' . (Yii::app()->request->getParam('order') == 'desc' ? 'desc' : 'asc');
<span class="ln">519</span> $oCriteria->offset = $start;
<span class="ln">520</span> $oCriteria->limit = $limit;
<span class="ln">521</span>
<span class="error"><span class="ln error-ln">522</span> $dtresult = Survey_dynamic::model($iSurveyID)->findAllAsArray($oCriteria);
</span><span class="ln">523</span>
<span class="ln">524</span> $dtcount2 = count($dtresult);
<span class="ln">525</span> $cells = $fncount + 1;
<span class="ln">526</span>
<span class="ln">527</span> //CONTROL MENUBAR
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#4 </td>
<td class="content">
<div class="trace-file">
unknown(0): <strong>responses</strong>-><strong>browse</strong>("678563") </div>
</td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#5 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
C:\limesurvey_test\framework\web\actions\CAction.php(107): <strong>ReflectionMethod</strong>-><strong>invokeArgs</strong>(responses, array("678563")) </div>
<div class="code"><pre><span class="ln">102</span> else if($param->isDefaultValueAvailable())
<span class="ln">103</span> $ps[]=$param->getDefaultValue();
<span class="ln">104</span> else
<span class="ln">105</span> return false;
<span class="ln">106</span> }
<span class="error"><span class="ln error-ln">107</span> $method->invokeArgs($object,$ps);
</span><span class="ln">108</span> return true;
<span class="ln">109</span> }
<span class="ln">110</span> }
</pre></div> </td>
</tr>
<tr class="trace app collapsed">
<td class="number">
#6 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
C:\limesurvey_test\application\core\Survey_Common_Action.php(82): <strong>CAction</strong>-><strong>runWithParamsInternal</strong>(responses, ReflectionMethod, array("surveyid" => "678563", "start" => "10", "limit" => "10", "sa" => "browse", ...)) </div>
<div class="code"><pre><span class="ln">77</span> $oMethod = new ReflectionMethod($this, $sDefault);
<span class="ln">78</span> }
<span class="ln">79</span>
<span class="ln">80</span> // We're all good to go, let's execute it
<span class="ln">81</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">82</span> return parent::runWithParamsInternal($this, $oMethod, $params);
</span><span class="ln">83</span> }
<span class="ln">84</span>
<span class="ln">85</span> /**
<span class="ln">86</span> * Some functions have different parameters, which are just an alias of the
<span class="ln">87</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">
#7 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
C:\limesurvey_test\framework\web\CController.php(309): <strong>Survey_Common_Action</strong>-><strong>runWithParams</strong>(array("surveyid" => "678563", "start" => "10", "limit" => "10", "sa" => "browse")) </div>
<div class="code"><pre><span class="ln">304</span> {
<span class="ln">305</span> $priorAction=$this->_action;
<span class="ln">306</span> $this->_action=$action;
<span class="ln">307</span> if($this->beforeAction($action))
<span class="ln">308</span> {
<span class="error"><span class="ln error-ln">309</span> if($action->runWithParams($this->getActionParams())===false)
</span><span class="ln">310</span> $this->invalidActionParams($action);
<span class="ln">311</span> else
<span class="ln">312</span> $this->afterAction($action);
<span class="ln">313</span> }
<span class="ln">314</span> $this->_action=$priorAction;
</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>
C:\limesurvey_test\framework\web\CController.php(287): <strong>CController</strong>-><strong>runAction</strong>(responses) </div>
<div class="code"><pre><span class="ln">282</span> * @see runAction
<span class="ln">283</span> */
<span class="ln">284</span> public function runActionWithFilters($action,$filters)
<span class="ln">285</span> {
<span class="ln">286</span> if(empty($filters))
<span class="error"><span class="ln error-ln">287</span> $this->runAction($action);
</span><span class="ln">288</span> else
<span class="ln">289</span> {
<span class="ln">290</span> $priorAction=$this->_action;
<span class="ln">291</span> $this->_action=$action;
<span class="ln">292</span> CFilterChain::create($this,$action,$filters)->run();
</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>
C:\limesurvey_test\framework\web\CController.php(266): <strong>CController</strong>-><strong>runActionWithFilters</strong>(responses, array()) </div>
<div class="code"><pre><span class="ln">261</span> {
<span class="ln">262</span> if(($parent=$this->getModule())===null)
<span class="ln">263</span> $parent=Yii::app();
<span class="ln">264</span> if($parent->beforeControllerAction($this,$action))
<span class="ln">265</span> {
<span class="error"><span class="ln error-ln">266</span> $this->runActionWithFilters($action,$this->filters());
</span><span class="ln">267</span> $parent->afterControllerAction($this,$action);
<span class="ln">268</span> }
<span class="ln">269</span> }
<span class="ln">270</span> else
<span class="ln">271</span> $this->missingAction($actionID);
</pre></div> </td>
</tr>
<tr class="trace app collapsed">
<td class="number">
#10 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
C:\limesurvey_test\application\controllers\AdminController.php(169): <strong>CController</strong>-><strong>run</strong>("responses") </div>
<div class="code"><pre><span class="ln">164</span> $this->redirect($this->createUrl('/admin/authentication/sa/login'));
<span class="ln">165</span> }
<span class="ln">166</span>
<span class="ln">167</span> }
<span class="ln">168</span>
<span class="error"><span class="ln error-ln">169</span> return parent::run($action);
</span><span class="ln">170</span> }
<span class="ln">171</span>
<span class="ln">172</span> /**
<span class="ln">173</span> * Routes all the actions to their respective places
<span class="ln">174</span> *
</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>
C:\limesurvey_test\framework\web\CWebApplication.php(276): <strong>AdminController</strong>-><strong>run</strong>("responses") </div>
<div class="code"><pre><span class="ln">271</span> {
<span class="ln">272</span> list($controller,$actionID)=$ca;
<span class="ln">273</span> $oldController=$this->_controller;
<span class="ln">274</span> $this->_controller=$controller;
<span class="ln">275</span> $controller->init();
<span class="error"><span class="ln error-ln">276</span> $controller->run($actionID);
</span><span class="ln">277</span> $this->_controller=$oldController;
<span class="ln">278</span> }
<span class="ln">279</span> else
<span class="ln">280</span> throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".',
<span class="ln">281</span> array('{route}'=>$route===''?$this->defaultController:$route)));
</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>
C:\limesurvey_test\framework\web\CWebApplication.php(135): <strong>CWebApplication</strong>-><strong>runController</strong>("admin/responses/sa/browse") </div>
<div class="code"><pre><span class="ln">130</span> foreach(array_splice($this->catchAllRequest,1) as $name=>$value)
<span class="ln">131</span> $_GET[$name]=$value;
<span class="ln">132</span> }
<span class="ln">133</span> else
<span class="ln">134</span> $route=$this->getUrlManager()->parseUrl($this->getRequest());
<span class="error"><span class="ln error-ln">135</span> $this->runController($route);
</span><span class="ln">136</span> }
<span class="ln">137</span>
<span class="ln">138</span> /**
<span class="ln">139</span> * Registers the core application components.
<span class="ln">140</span> * This method overrides the parent implementation by registering additional core components.
</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>
C:\limesurvey_test\framework\base\CApplication.php(162): <strong>CWebApplication</strong>-><strong>processRequest</strong>() </div>
<div class="code"><pre><span class="ln">157</span> */
<span class="ln">158</span> public function run()
<span class="ln">159</span> {
<span class="ln">160</span> if($this->hasEventHandler('onBeginRequest'))
<span class="ln">161</span> $this->onBeginRequest(new CEvent($this));
<span class="error"><span class="ln error-ln">162</span> $this->processRequest();
</span><span class="ln">163</span> if($this->hasEventHandler('onEndRequest'))
<span class="ln">164</span> $this->onEndRequest(new CEvent($this));
<span class="ln">165</span> }
<span class="ln">166</span>
<span class="ln">167</span> /**
</pre></div> </td>
</tr>
<tr class="trace app collapsed">
<td class="number">
#14 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
C:\limesurvey_test\index.php(178): <strong>CApplication</strong>-><strong>run</strong>() </div>
<div class="code"><pre><span class="ln">173</span> *
<span class="ln">174</span> */
<span class="ln">175</span> require_once BASEPATH . 'yii' . EXT;
<span class="ln">176</span> require_once APPPATH . 'core/LSYii_Application' . EXT;
<span class="ln">177</span>
<span class="error"><span class="ln error-ln">178</span> Yii::createApplication('LSYii_Application', APPPATH . 'config/config' . EXT)->run();
</span><span class="ln">179</span>
<span class="ln">180</span> /* End of file index.php */
<span class="ln">181</span> /* Location: ./index.php */
</pre></div> </td>
</tr>
</table>
</div>
<div class="version">
2012-12-14 12:23:40 Microsoft-IIS/7.5 <a href="http://www.yiiframework.com/">Yii Framework</a>/1.1.10 </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>
</body>
</html>
<script type="text/javascript">
/*<![CDATA[*/
if(typeof(console)=='object')
{
console.group("Application Log");
console.log("[12:23:39.868][trace][system.db.CDbConnection] Opening DB connection");
console.log("[12:23:39.873][trace][system.db.CDbCommand] Querying SQL: \t\tSELECT k.column_name field_name\n\t\t\tFROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k\n\t\t LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c\n\t\t ON k.table_name = c.table_name\n\t\t AND k.constraint_name = c.constraint_name\n\t\t WHERE c.constraint_type =\'PRIMARY KEY\'\n\t\t \t AND k.table_name = :table\n\t\t\t\tAND k.table_schema = :schema. Bound with :table=\'settings_global\', :schema=\'dbo\'");
console.log("[12:23:39.877][trace][system.db.CDbCommand] Querying SQL: \t\tSELECT\n\t\t KCU1.CONSTRAINT_NAME AS \'FK_CONSTRAINT_NAME\'\n\t\t , KCU1.TABLE_NAME AS \'FK_TABLE_NAME\'\n\t\t , KCU1.COLUMN_NAME AS \'FK_COLUMN_NAME\'\n\t\t , KCU1.ORDINAL_POSITION AS \'FK_ORDINAL_POSITION\'\n\t\t , KCU2.CONSTRAINT_NAME AS \'UQ_CONSTRAINT_NAME\'\n\t\t , KCU2.TABLE_NAME AS \'UQ_TABLE_NAME\'\n\t\t , KCU2.COLUMN_NAME AS \'UQ_COLUMN_NAME\'\n\t\t , KCU2.ORDINAL_POSITION AS \'UQ_ORDINAL_POSITION\'\n\t\tFROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC\n\t\tJOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1\n\t\tON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG\n\t\t AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA\n\t\t AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME\n\t\tJOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2\n\t\tON KCU2.CONSTRAINT_CATALOG =\n\t\tRC.UNIQUE_CONSTRAINT_CATALOG\n\t\t AND KCU2.CONSTRAINT_SCHEMA =\n\t\tRC.UNIQUE_CONSTRAINT_SCHEMA\n\t\t AND KCU2.CONSTRAINT_NAME =\n\t\tRC.UNIQUE_CONSTRAINT_NAME\n\t\t AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION\n\t\tWHERE KCU1.TABLE_NAME = :table. Bound with :table=\'settings_global\'");
console.log("[12:23:39.879][trace][system.db.CDbCommand] Querying SQL: SELECT *, columnproperty(object_id(table_schema+\'.\'+table_name), column_name, \'IsIdentity\') as IsIdentity FROM [INFORMATION_SCHEMA].[COLUMNS] WHERE TABLE_NAME=\'settings_global\' AND TABLE_SCHEMA=\'dbo\'");
console.log("[12:23:39.880][trace][system.db.ar.CActiveRecord] Settings_global.findAll()");
console.log("[12:23:39.883][trace][system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[settings_global] [t]");
console.log("[12:23:39.926][trace][system.db.ar.CActiveRecord] Settings_global.findByPk()");
console.log("[12:23:39.926][trace][system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[settings_global] [t] WHERE [t].[stg_name]=\'updatelastcheck\'");
console.log("[12:23:39.930][trace][system.db.CDbCommand] Querying SQL: \t\tSELECT k.column_name field_name\n\t\t\tFROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k\n\t\t LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c\n\t\t ON k.table_name = c.table_name\n\t\t AND k.constraint_name = c.constraint_name\n\t\t WHERE c.constraint_type =\'PRIMARY KEY\'\n\t\t \t AND k.table_name = :table\n\t\t\t\tAND k.table_schema = :schema. Bound with :table=\'surveys\', :schema=\'dbo\'");
console.log("[12:23:39.934][trace][system.db.CDbCommand] Querying SQL: \t\tSELECT\n\t\t KCU1.CONSTRAINT_NAME AS \'FK_CONSTRAINT_NAME\'\n\t\t , KCU1.TABLE_NAME AS \'FK_TABLE_NAME\'\n\t\t , KCU1.COLUMN_NAME AS \'FK_COLUMN_NAME\'\n\t\t , KCU1.ORDINAL_POSITION AS \'FK_ORDINAL_POSITION\'\n\t\t , KCU2.CONSTRAINT_NAME AS \'UQ_CONSTRAINT_NAME\'\n\t\t , KCU2.TABLE_NAME AS \'UQ_TABLE_NAME\'\n\t\t , KCU2.COLUMN_NAME AS \'UQ_COLUMN_NAME\'\n\t\t , KCU2.ORDINAL_POSITION AS \'UQ_ORDINAL_POSITION\'\n\t\tFROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC\n\t\tJOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1\n\t\tON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG\n\t\t AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA\n\t\t AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME\n\t\tJOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2\n\t\tON KCU2.CONSTRAINT_CATALOG =\n\t\tRC.UNIQUE_CONSTRAINT_CATALOG\n\t\t AND KCU2.CONSTRAINT_SCHEMA =\n\t\tRC.UNIQUE_CONSTRAINT_SCHEMA\n\t\t AND KCU2.CONSTRAINT_NAME =\n\t\tRC.UNIQUE_CONSTRAINT_NAME\n\t\t AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION\n\t\tWHERE KCU1.TABLE_NAME = :table. Bound with :table=\'surveys\'");
console.log("[12:23:39.936][trace][system.db.CDbCommand] Querying SQL: SELECT *, columnproperty(object_id(table_schema+\'.\'+table_name), column_name, \'IsIdentity\') as IsIdentity FROM [INFORMATION_SCHEMA].[COLUMNS] WHERE TABLE_NAME=\'surveys\' AND TABLE_SCHEMA=\'dbo\'");
console.log("[12:23:39.943][trace][system.db.ar.CActiveRecord] Settings_global.findByPk()");
console.log("[12:23:39.943][trace][system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[settings_global] [t] WHERE [t].[stg_name]=\'DBVersion\'");
console.log("[12:23:39.944][trace][system.db.ar.CActiveRecord] Settings_global.findByPk()");
console.log("[12:23:39.944][trace][system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[settings_global] [t] WHERE [t].[stg_name]=\'SessionName\'");
console.log("[12:23:39.952][trace][system.db.ar.CActiveRecord] Survey.findAll()");
console.log("[12:23:39.953][trace][system.db.CDbCommand] Querying SQL: SELECT sid, active FROM [dbo].[surveys] [t] INNER JOIN surveys_languagesettings as b on (b.surveyls_survey_id=sid and b.surveyls_language=language) WHERE sid=:survey. Bound with :survey=\'678563\'");
console.log("[12:23:39.953][trace][system.db.ar.CActiveRecord] Survey.findByPk()");
console.log("[12:23:39.953][trace][system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[surveys] [t] WHERE [t].[sid]=678563");
console.log("[12:23:39.955][trace][system.db.CDbCommand] Querying SQL: \t\tSELECT k.column_name field_name\n\t\t\tFROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k\n\t\t LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c\n\t\t ON k.table_name = c.table_name\n\t\t AND k.constraint_name = c.constraint_name\n\t\t WHERE c.constraint_type =\'PRIMARY KEY\'\n\t\t \t AND k.table_name = :table\n\t\t\t\tAND k.table_schema = :schema. Bound with :table=\'surveys_languagesettings\', :schema=\'dbo\'");
console.log("[12:23:39.959][trace][system.db.CDbCommand] Querying SQL: \t\tSELECT\n\t\t KCU1.CONSTRAINT_NAME AS \'FK_CONSTRAINT_NAME\'\n\t\t , KCU1.TABLE_NAME AS \'FK_TABLE_NAME\'\n\t\t , KCU1.COLUMN_NAME AS \'FK_COLUMN_NAME\'\n\t\t , KCU1.ORDINAL_POSITION AS \'FK_ORDINAL_POSITION\'\n\t\t , KCU2.CONSTRAINT_NAME AS \'UQ_CONSTRAINT_NAME\'\n\t\t , KCU2.TABLE_NAME AS \'UQ_TABLE_NAME\'\n\t\t , KCU2.COLUMN_NAME AS \'UQ_COLUMN_NAME\'\n\t\t , KCU2.ORDINAL_POSITION AS \'UQ_ORDINAL_POSITION\'\n\t\tFROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC\n\t\tJOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1\n\t\tON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG\n\t\t AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA\n\t\t AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME\n\t\tJOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2\n\t\tON KCU2.CONSTRAINT_CATALOG =\n\t\tRC.UNIQUE_CONSTRAINT_CATALOG\n\t\t AND KCU2.CONSTRAINT_SCHEMA =\n\t\tRC.UNIQUE_CONSTRAINT_SCHEMA\n\t\t AND KCU2.CONSTRAINT_NAME =\n\t\tRC.UNIQUE_CONSTRAINT_NAME\n\t\t AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION\n\t\tWHERE KCU1.TABLE_NAME = :table. Bound with :table=\'surveys_languagesettings\'");
console.log("[12:23:39.960][trace][system.db.CDbCommand] Querying SQL: SELECT *, columnproperty(object_id(table_schema+\'.\'+table_name), column_name, \'IsIdentity\') as IsIdentity FROM [INFORMATION_SCHEMA].[COLUMNS] WHERE TABLE_NAME=\'surveys_languagesettings\' AND TABLE_SCHEMA=\'dbo\'");
console.log("[12:23:39.964][trace][system.db.ar.CActiveRecord] Surveys_languagesettings.findAllByAttributes()");
console.log("[12:23:39.967][trace][system.db.CDbCommand] Querying SQL: SELECT [t].[surveyls_survey_id] AS [t0_c0], [t].[surveyls_language] AS [t0_c1], [t].[surveyls_title] AS [t0_c2], [t].[surveyls_description] AS [t0_c3], [t].[surveyls_welcometext] AS [t0_c4], [t].[surveyls_endtext] AS [t0_c5], [t].[surveyls_url] AS [t0_c6], [t].[surveyls_urldescription] AS [t0_c7], [t].[surveyls_email_invite_subj] AS [t0_c8], [t].[surveyls_email_invite] AS [t0_c9], [t].[surveyls_email_remind_subj] AS [t0_c10], [t].[surveyls_email_remind] AS [t0_c11], [t].[surveyls_email_register_subj] AS [t0_c12], [t].[surveyls_email_register] AS [t0_c13], [t].[surveyls_email_confirm_subj] AS [t0_c14], [t].[surveyls_email_confirm] AS [t0_c15], [t].[surveyls_dateformat] AS [t0_c16], [t].[surveyls_attributecaptions] AS [t0_c17], [t].[email_admin_notification_subj] AS [t0_c18], [t].[email_admin_notification] AS [t0_c19], [t].[email_admin_responses_subj] AS [t0_c20], [t].[email_admin_responses] AS [t0_c21], [t].[surveyls_numberformat] AS [t0_c22], [survey].[sid] AS [t1_c0], [survey].[owner_id] AS [t1_c1], [survey].[admin] AS [t1_c2], [survey].[active] AS [t1_c3], [survey].[expires] AS [t1_c4], [survey].[startdate] AS [t1_c5], [survey].[adminemail] AS [t1_c6], [survey].[anonymized] AS [t1_c7], [survey].[faxto] AS [t1_c8], [survey].[format] AS [t1_c9], [survey].[savetimings] AS [t1_c10], [survey].[template] AS [t1_c11], [survey].[language] AS [t1_c12], [survey].[additional_languages] AS [t1_c13], [survey].[datestamp] AS [t1_c14], [survey].[usecookie] AS [t1_c15], [survey].[allowregister] AS [t1_c16], [survey].[allowsave] AS [t1_c17], [survey].[autonumber_start] AS [t1_c18], [survey].[autoredirect] AS [t1_c19], [survey].[allowprev] AS [t1_c20], [survey].[printanswers] AS [t1_c21], [survey].[ipaddr] AS [t1_c22], [survey].[refurl] AS [t1_c23], [survey].[datecreated] AS [t1_c24], [survey].[publicstatistics] AS [t1_c25], [survey].[publicgraphs] AS [t1_c26], [survey].[listpublic] AS [t1_c27], [survey].[htmlemail] AS [t1_c28], [survey].[sendconfirmation] AS [t1_c29], [survey].[tokenanswerspersistence] AS [t1_c30], [survey].[assessments] AS [t1_c31], [survey].[usecaptcha] AS [t1_c32], [survey].[usetokens] AS [t1_c33], [survey].[bounce_email] AS [t1_c34], [survey].[attributedescriptions] AS [t1_c35], [survey].[emailresponseto] AS [t1_c36], [survey].[emailnotificationto] AS [t1_c37], [survey].[tokenlength] AS [t1_c38], [survey].[showxquestions] AS [t1_c39], [survey].[showgroupinfo] AS [t1_c40], [survey].[shownoanswer] AS [t1_c41], [survey].[showqnumcode] AS [t1_c42], [survey].[bouncetime] AS [t1_c43], [survey].[bounceprocessing] AS [t1_c44], [survey].[bounceaccounttype] AS [t1_c45], [survey].[bounceaccounthost] AS [t1_c46], [survey].[bounceaccountpass] AS [t1_c47], [survey].[bounceaccountencryption] AS [t1_c48], [survey].[bounceaccountuser] AS [t1_c49], [survey].[showwelcome] AS [t1_c50], [survey].[showprogress] AS [t1_c51], [survey].[allowjumps] AS [t1_c52], [survey].[navigationdelay] AS [t1_c53], [survey].[nokeyboard] AS [t1_c54], [survey].[alloweditaftercompletion] AS [t1_c55], [survey].[googleanalyticsstyle] AS [t1_c56], [survey].[googleanalyticsapikey] AS [t1_c57] FROM [dbo].[surveys_languagesettings] [t] LEFT OUTER JOIN [dbo].[surveys] [survey] ON (t.surveyls_survey_id = survey.sid) WHERE ([t].[surveyls_survey_id]=:yp0 AND [t].[surveyls_language]=:yp1). Bound with :yp0=\'678563\', :yp1=\'en\'");
console.log("[12:23:39.969][trace][system.db.CDbCommand] Querying SQL: SELECT TABLE_NAME, TABLE_SCHEMA FROM [INFORMATION_SCHEMA].[TABLES]\nWHERE TABLE_SCHEMA=:schema AND TABLE_TYPE in (\'BASE TABLE\',\'VIEW\'). Bound with :schema=\'dbo\'");
console.log("[12:23:39.977][trace][system.db.CDbCommand] Querying SQL: \t\tSELECT k.column_name field_name\n\t\t\tFROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k\n\t\t LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c\n\t\t ON k.table_name = c.table_name\n\t\t AND k.constraint_name = c.constraint_name\n\t\t WHERE c.constraint_type =\'PRIMARY KEY\'\n\t\t \t AND k.table_name = :table\n\t\t\t\tAND k.table_schema = :schema. Bound with :table=\'survey_678563\', :schema=\'dbo\'");
console.log("[12:23:40.002][trace][system.db.CDbCommand] Querying SQL: \t\tSELECT\n\t\t KCU1.CONSTRAINT_NAME AS \'FK_CONSTRAINT_NAME\'\n\t\t , KCU1.TABLE_NAME AS \'FK_TABLE_NAME\'\n\t\t , KCU1.COLUMN_NAME AS \'FK_COLUMN_NAME\'\n\t\t , KCU1.ORDINAL_POSITION AS \'FK_ORDINAL_POSITION\'\n\t\t , KCU2.CONSTRAINT_NAME AS \'UQ_CONSTRAINT_NAME\'\n\t\t , KCU2.TABLE_NAME AS \'UQ_TABLE_NAME\'\n\t\t , KCU2.COLUMN_NAME AS \'UQ_COLUMN_NAME\'\n\t\t , KCU2.ORDINAL_POSITION AS \'UQ_ORDINAL_POSITION\'\n\t\tFROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC\n\t\tJOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1\n\t\tON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG\n\t\t AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA\n\t\t AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME\n\t\tJOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2\n\t\tON KCU2.CONSTRAINT_CATALOG =\n\t\tRC.UNIQUE_CONSTRAINT_CATALOG\n\t\t AND KCU2.CONSTRAINT_SCHEMA =\n\t\tRC.UNIQUE_CONSTRAINT_SCHEMA\n\t\t AND KCU2.CONSTRAINT_NAME =\n\t\tRC.UNIQUE_CONSTRAINT_NAME\n\t\t AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION\n\t\tWHERE KCU1.TABLE_NAME = :table. Bound with :table=\'survey_678563\'");
console.log("[12:23:40.003][trace][system.db.CDbCommand] Querying SQL: SELECT *, columnproperty(object_id(table_schema+\'.\'+table_name), column_name, \'IsIdentity\') as IsIdentity FROM [INFORMATION_SCHEMA].[COLUMNS] WHERE TABLE_NAME=\'survey_678563\' AND TABLE_SCHEMA=\'dbo\'");
console.log("[12:23:40.010][trace][system.db.ar.CActiveRecord] Survey_dynamic.count()");
console.log("[12:23:40.010][trace][system.db.CDbCommand] Querying SQL: SELECT COUNT(*) FROM [dbo].[survey_678563] [t] LEFT JOIN tokens_678563 tokens ON t.token = tokens.token");
console.log("[12:23:40.012][trace][system.db.ar.CActiveRecord] Survey_dynamic.findAll()");
console.log("[12:23:40.012][trace][system.db.CDbCommand] Querying SQL: SELECT * FROM (SELECT TOP 10 * FROM (SELECT TOP 20 tokens.*, t.* FROM [dbo].[survey_678563] [t] LEFT JOIN tokens_678563 tokens ON t.token = tokens.token ORDER BY id asc) as [__inner__] ORDER BY [id] DESC) as [__outer__] ORDER BY [id] asc");
console.groupEnd();
}
/*]]>*/
</script> CSVExportError.htm (43,377 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[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]The column 'token' was specified multiple times for '__inner__'.. The SQL statement executed was: SELECT * FROM (SELECT TOP 100 * FROM (SELECT TOP 200 *<br />
FROM [survey_489924]<br />
LEFT JOIN [tokens_489924] ON tokens_489924.token=survey_489924.token<br />
LEFT JOIN [survey_489924_timings] [survey_timings] ON survey_489924.id = survey_timings.id<br />
ORDER BY [survey_489924].[id]) as [__inner__] ORDER BY [__inner__].[id] DESC) as [__outer__] ORDER BY [__outer__].[id] ASC </p>
<div class="source">
<p class="file">C:\limesurvey_test\framework\db\CDbCommand.php(528)</p>
<div class="code"><pre><span class="ln">516</span> return $result;
<span class="ln">517</span> }
<span class="ln">518</span> catch(Exception $e)
<span class="ln">519</span> {
<span class="ln">520</span> if($this->_connection->enableProfiling)
<span class="ln">521</span> Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query');
<span class="ln">522</span> $errorInfo = $e instanceof PDOException ? $e->errorInfo : null;
<span class="ln">523</span> $message = $e->getMessage();
<span class="ln">524</span> Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',
<span class="ln">525</span> array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
<span class="ln">526</span> if(YII_DEBUG)
<span class="ln">527</span> $message .= '. The SQL statement executed was: '.$this->getText().$par;
<span class="error"><span class="ln error-ln">528</span> throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
</span><span class="ln">529</span> array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
<span class="ln">530</span> }
<span class="ln">531</span> }
<span class="ln">532</span>
<span class="ln">533</span> /**
<span class="ln">534</span> * Builds a SQL SELECT statement from the given query specification.
<span class="ln">535</span> * @param array $query the query specification in name-value pairs. The following
<span class="ln">536</span> * query options are supported: {@link select}, {@link distinct}, {@link from},
<span class="ln">537</span> * {@link where}, {@link join}, {@link group}, {@link having}, {@link order},
<span class="ln">538</span> * {@link limit}, {@link offset} and {@link union}.
<span class="ln">539</span> * @return string the SQL statement
<span class="ln">540</span> * @since 1.1.6
</pre></div> </div>
<div class="traces">
<h2>Stack Trace</h2>
<table style="width:100%;">
<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>
C:\limesurvey_test\framework\db\CDbCommand.php(372): <strong>CDbCommand</strong>-><strong>queryInternal</strong>("", 0, array()) </div>
<div class="code"><pre><span class="ln">367</span> * @return CDbDataReader the reader object for fetching the query result
<span class="ln">368</span> * @throws CException execution failed
<span class="ln">369</span> */
<span class="ln">370</span> public function query($params=array())
<span class="ln">371</span> {
<span class="error"><span class="ln error-ln">372</span> return $this->queryInternal('',0,$params);
</span><span class="ln">373</span> }
<span class="ln">374</span>
<span class="ln">375</span> /**
<span class="ln">376</span> * Executes the SQL statement and returns all rows.
<span class="ln">377</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>
C:\limesurvey_test\application\helpers\admin\exportresults_helper.php(326): <strong>CDbCommand</strong>-><strong>query</strong>() </div>
<div class="code"><pre><span class="ln">321</span> if ($iOffset+$iLimit>$iMaximum)
<span class="ln">322</span> {
<span class="ln">323</span> $iLimit=$iMaximum-$iOffset;
<span class="ln">324</span> }
<span class="ln">325</span>
<span class="error"><span class="ln error-ln">326</span> $survey->responses=$oRecordSet->order('{{survey_' . $survey->id . '}}.id')->limit($iLimit, $iOffset)->query()->readAll();
</span><span class="ln">327</span>
<span class="ln">328</span> return count($survey->responses);
<span class="ln">329</span> }
<span class="ln">330</span> }
<span class="ln">331</span>
</pre></div> </td>
</tr>
<tr class="trace app expanded">
<td class="number">
#2 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">�</div>
C:\limesurvey_test\application\helpers\admin\exportresults_helper.php(108): <strong>SurveyDao</strong>-><strong>loadSurveyResults</strong>(SurveyObj, 100, 100, "523", ...) </div>
<div class="code"><pre><span class="ln">103</span>
<span class="ln">104</span> $iBatchSize=100; $iCurrentRecord=$oOptions->responseMinRecord-1;
<span class="ln">105</span> $bMoreRecords=true; $first=true;
<span class="ln">106</span> while ($bMoreRecords)
<span class="ln">107</span> {
<span class="error"><span class="ln error-ln">108</span> $iExported= $surveyDao->loadSurveyResults($survey, $iBatchSize, $iCurrentRecord, $oOptions->responseMaxRecord, $sFilter);
</span><span class="ln">109</span> $iCurrentRecord+=$iExported;
<span class="ln">110</span> $writer->write($survey, $sLanguageCode, $oOptions,$first);
<span class="ln">111</span> $first=false;
<span class="ln">112</span> $bMoreRecords= ($iExported == $iBatchSize);
<span class="ln">113</span> }
</pre></div> </td>
</tr>
<tr class="trace app expanded">
<td class="number">
#3 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">�</div>
C:\limesurvey_test\application\controllers\admin\export.php(270): <strong>ExportSurveyResultsService</strong>-><strong>exportSurvey</strong>("489924", "en", "csv", FormattingOptions, ...) </div>
<div class="code"><pre><span class="ln">265</span> else
<span class="ln">266</span> {
<span class="ln">267</span> $sFilter='';
<span class="ln">268</span> }
<span class="ln">269</span> $resultsService = new ExportSurveyResultsService();
<span class="error"><span class="ln error-ln">270</span> $resultsService->exportSurvey($iSurveyID, $explang, $type, $options, $sFilter);
</span><span class="ln">271</span>
<span class="ln">272</span> exit;
<span class="ln">273</span> }
<span class="ln">274</span>
<span class="ln">275</span> /*
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#4 </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">
#5 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">�</div>
C:\limesurvey_test\framework\web\actions\CAction.php(107): <strong>ReflectionMethod</strong>-><strong>invokeArgs</strong>(export, array()) </div>
<div class="code"><pre><span class="ln">102</span> else if($param->isDefaultValueAvailable())
<span class="ln">103</span> $ps[]=$param->getDefaultValue();
<span class="ln">104</span> else
<span class="ln">105</span> return false;
<span class="ln">106</span> }
<span class="error"><span class="ln error-ln">107</span> $method->invokeArgs($object,$ps);
</span><span class="ln">108</span> return true;
<span class="ln">109</span> }
<span class="ln">110</span> }
</pre></div> </td>
</tr>
<tr class="trace app collapsed">
<td class="number">
#6 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">�</div>
C:\limesurvey_test\application\core\Survey_Common_Action.php(82): <strong>CAction</strong>-><strong>runWithParamsInternal</strong>(export, ReflectionMethod, array("surveyid" => "489924", "sa" => "exportresults", "iSurveyId" => "489924", "iSurveyID" => "489924")) </div>
<div class="code"><pre><span class="ln">77</span> $oMethod = new ReflectionMethod($this, $sDefault);
<span class="ln">78</span> }
<span class="ln">79</span>
<span class="ln">80</span> // We're all good to go, let's execute it
<span class="ln">81</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">82</span> return parent::runWithParamsInternal($this, $oMethod, $params);
</span><span class="ln">83</span> }
<span class="ln">84</span>
<span class="ln">85</span> /**
<span class="ln">86</span> * Some functions have different parameters, which are just an alias of the
<span class="ln">87</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">
#7 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">�</div>
C:\limesurvey_test\framework\web\CController.php(309): <strong>Survey_Common_Action</strong>-><strong>runWithParams</strong>(array("surveyid" => "489924", "sa" => "exportresults")) </div>
<div class="code"><pre><span class="ln">304</span> {
<span class="ln">305</span> $priorAction=$this->_action;
<span class="ln">306</span> $this->_action=$action;
<span class="ln">307</span> if($this->beforeAction($action))
<span class="ln">308</span> {
<span class="error"><span class="ln error-ln">309</span> if($action->runWithParams($this->getActionParams())===false)
</span><span class="ln">310</span> $this->invalidActionParams($action);
<span class="ln">311</span> else
<span class="ln">312</span> $this->afterAction($action);
<span class="ln">313</span> }
<span class="ln">314</span> $this->_action=$priorAction;
</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>
C:\limesurvey_test\framework\web\CController.php(287): <strong>CController</strong>-><strong>runAction</strong>(export) </div>
<div class="code"><pre><span class="ln">282</span> * @see runAction
<span class="ln">283</span> */
<span class="ln">284</span> public function runActionWithFilters($action,$filters)
<span class="ln">285</span> {
<span class="ln">286</span> if(empty($filters))
<span class="error"><span class="ln error-ln">287</span> $this->runAction($action);
</span><span class="ln">288</span> else
<span class="ln">289</span> {
<span class="ln">290</span> $priorAction=$this->_action;
<span class="ln">291</span> $this->_action=$action;
<span class="ln">292</span> CFilterChain::create($this,$action,$filters)->run();
</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>
C:\limesurvey_test\framework\web\CController.php(266): <strong>CController</strong>-><strong>runActionWithFilters</strong>(export, array()) </div>
<div class="code"><pre><span class="ln">261</span> {
<span class="ln">262</span> if(($parent=$this->getModule())===null)
<span class="ln">263</span> $parent=Yii::app();
<span class="ln">264</span> if($parent->beforeControllerAction($this,$action))
<span class="ln">265</span> {
<span class="error"><span class="ln error-ln">266</span> $this->runActionWithFilters($action,$this->filters());
</span><span class="ln">267</span> $parent->afterControllerAction($this,$action);
<span class="ln">268</span> }
<span class="ln">269</span> }
<span class="ln">270</span> else
<span class="ln">271</span> $this->missingAction($actionID);
</pre></div> </td>
</tr>
<tr class="trace app collapsed">
<td class="number">
#10 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">�</div>
C:\limesurvey_test\application\controllers\AdminController.php(169): <strong>CController</strong>-><strong>run</strong>("export") </div>
<div class="code"><pre><span class="ln">164</span> $this->redirect($this->createUrl('/admin/authentication/sa/login'));
<span class="ln">165</span> }
<span class="ln">166</span>
<span class="ln">167</span> }
<span class="ln">168</span>
<span class="error"><span class="ln error-ln">169</span> return parent::run($action);
</span><span class="ln">170</span> }
<span class="ln">171</span>
<span class="ln">172</span> /**
<span class="ln">173</span> * Routes all the actions to their respective places
<span class="ln">174</span> *
</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>
C:\limesurvey_test\framework\web\CWebApplication.php(276): <strong>AdminController</strong>-><strong>run</strong>("export") </div>
<div class="code"><pre><span class="ln">271</span> {
<span class="ln">272</span> list($controller,$actionID)=$ca;
<span class="ln">273</span> $oldController=$this->_controller;
<span class="ln">274</span> $this->_controller=$controller;
<span class="ln">275</span> $controller->init();
<span class="error"><span class="ln error-ln">276</span> $controller->run($actionID);
</span><span class="ln">277</span> $this->_controller=$oldController;
<span class="ln">278</span> }
<span class="ln">279</span> else
<span class="ln">280</span> throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".',
<span class="ln">281</span> array('{route}'=>$route===''?$this->defaultController:$route)));
</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>
C:\limesurvey_test\framework\web\CWebApplication.php(135): <strong>CWebApplication</strong>-><strong>runController</strong>("admin/export/sa/exportresults") </div>
<div class="code"><pre><span class="ln">130</span> foreach(array_splice($this->catchAllRequest,1) as $name=>$value)
<span class="ln">131</span> $_GET[$name]=$value;
<span class="ln">132</span> }
<span class="ln">133</span> else
<span class="ln">134</span> $route=$this->getUrlManager()->parseUrl($this->getRequest());
<span class="error"><span class="ln error-ln">135</span> $this->runController($route);
</span><span class="ln">136</span> }
<span class="ln">137</span>
<span class="ln">138</span> /**
<span class="ln">139</span> * Registers the core application components.
<span class="ln">140</span> * This method overrides the parent implementation by registering additional core components.
</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>
C:\limesurvey_test\framework\base\CApplication.php(162): <strong>CWebApplication</strong>-><strong>processRequest</strong>() </div>
<div class="code"><pre><span class="ln">157</span> */
<span class="ln">158</span> public function run()
<span class="ln">159</span> {
<span class="ln">160</span> if($this->hasEventHandler('onBeginRequest'))
<span class="ln">161</span> $this->onBeginRequest(new CEvent($this));
<span class="error"><span class="ln error-ln">162</span> $this->processRequest();
</span><span class="ln">163</span> if($this->hasEventHandler('onEndRequest'))
<span class="ln">164</span> $this->onEndRequest(new CEvent($this));
<span class="ln">165</span> }
<span class="ln">166</span>
<span class="ln">167</span> /**
</pre></div> </td>
</tr>
<tr class="trace app collapsed">
<td class="number">
#14 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">�</div>
C:\limesurvey_test\index.php(178): <strong>CApplication</strong>-><strong>run</strong>() </div>
<div class="code"><pre><span class="ln">173</span> *
<span class="ln">174</span> */
<span class="ln">175</span> require_once BASEPATH . 'yii' . EXT;
<span class="ln">176</span> require_once APPPATH . 'core/LSYii_Application' . EXT;
<span class="ln">177</span>
<span class="error"><span class="ln error-ln">178</span> Yii::createApplication('LSYii_Application', APPPATH . 'config/config' . EXT)->run();
</span><span class="ln">179</span>
<span class="ln">180</span> /* End of file index.php */
<span class="ln">181</span> /* Location: ./index.php */
</pre></div> </td>
</tr>
</table>
</div>
<div class="version">
2012-12-14 15:33:15 Microsoft-IIS/7.5 <a href="http://www.yiiframework.com/">Yii Framework</a>/1.1.10 </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>
</body>
</html>
<script type="text/javascript">
/*<![CDATA[*/
if(typeof(console)=='object')
{
console.group("Application Log");
console.log("[15:33:15.186][trace][system.db.CDbConnection] Opening DB connection");
console.log("[15:33:15.191][trace][system.db.CDbCommand] Querying SQL: \t\tSELECT k.column_name field_name\n\t\t\tFROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k\n\t\t LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c\n\t\t ON k.table_name = c.table_name\n\t\t AND k.constraint_name = c.constraint_name\n\t\t WHERE c.constraint_type =\'PRIMARY KEY\'\n\t\t \t AND k.table_name = :table\n\t\t\t\tAND k.table_schema = :schema. Bound with :table=\'settings_global\', :schema=\'dbo\'");
console.log("[15:33:15.196][trace][system.db.CDbCommand] Querying SQL: \t\tSELECT\n\t\t KCU1.CONSTRAINT_NAME AS \'FK_CONSTRAINT_NAME\'\n\t\t , KCU1.TABLE_NAME AS \'FK_TABLE_NAME\'\n\t\t , KCU1.COLUMN_NAME AS \'FK_COLUMN_NAME\'\n\t\t , KCU1.ORDINAL_POSITION AS \'FK_ORDINAL_POSITION\'\n\t\t , KCU2.CONSTRAINT_NAME AS \'UQ_CONSTRAINT_NAME\'\n\t\t , KCU2.TABLE_NAME AS \'UQ_TABLE_NAME\'\n\t\t , KCU2.COLUMN_NAME AS \'UQ_COLUMN_NAME\'\n\t\t , KCU2.ORDINAL_POSITION AS \'UQ_ORDINAL_POSITION\'\n\t\tFROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC\n\t\tJOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1\n\t\tON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG\n\t\t AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA\n\t\t AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME\n\t\tJOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2\n\t\tON KCU2.CONSTRAINT_CATALOG =\n\t\tRC.UNIQUE_CONSTRAINT_CATALOG\n\t\t AND KCU2.CONSTRAINT_SCHEMA =\n\t\tRC.UNIQUE_CONSTRAINT_SCHEMA\n\t\t AND KCU2.CONSTRAINT_NAME =\n\t\tRC.UNIQUE_CONSTRAINT_NAME\n\t\t AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION\n\t\tWHERE KCU1.TABLE_NAME = :table. Bound with :table=\'settings_global\'");
console.log("[15:33:15.197][trace][system.db.CDbCommand] Querying SQL: SELECT *, columnproperty(object_id(table_schema+\'.\'+table_name), column_name, \'IsIdentity\') as IsIdentity FROM [INFORMATION_SCHEMA].[COLUMNS] WHERE TABLE_NAME=\'settings_global\' AND TABLE_SCHEMA=\'dbo\'");
console.log("[15:33:15.199][trace][system.db.ar.CActiveRecord] Settings_global.findAll()");
console.log("[15:33:15.202][trace][system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[settings_global] [t]");
console.log("[15:33:15.244][trace][system.db.ar.CActiveRecord] Settings_global.findByPk()");
console.log("[15:33:15.244][trace][system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[settings_global] [t] WHERE [t].[stg_name]=\'updatelastcheck\'");
console.log("[15:33:15.248][trace][system.db.CDbCommand] Querying SQL: \t\tSELECT k.column_name field_name\n\t\t\tFROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k\n\t\t LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c\n\t\t ON k.table_name = c.table_name\n\t\t AND k.constraint_name = c.constraint_name\n\t\t WHERE c.constraint_type =\'PRIMARY KEY\'\n\t\t \t AND k.table_name = :table\n\t\t\t\tAND k.table_schema = :schema. Bound with :table=\'surveys\', :schema=\'dbo\'");
console.log("[15:33:15.252][trace][system.db.CDbCommand] Querying SQL: \t\tSELECT\n\t\t KCU1.CONSTRAINT_NAME AS \'FK_CONSTRAINT_NAME\'\n\t\t , KCU1.TABLE_NAME AS \'FK_TABLE_NAME\'\n\t\t , KCU1.COLUMN_NAME AS \'FK_COLUMN_NAME\'\n\t\t , KCU1.ORDINAL_POSITION AS \'FK_ORDINAL_POSITION\'\n\t\t , KCU2.CONSTRAINT_NAME AS \'UQ_CONSTRAINT_NAME\'\n\t\t , KCU2.TABLE_NAME AS \'UQ_TABLE_NAME\'\n\t\t , KCU2.COLUMN_NAME AS \'UQ_COLUMN_NAME\'\n\t\t , KCU2.ORDINAL_POSITION AS \'UQ_ORDINAL_POSITION\'\n\t\tFROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC\n\t\tJOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1\n\t\tON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG\n\t\t AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA\n\t\t AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME\n\t\tJOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2\n\t\tON KCU2.CONSTRAINT_CATALOG =\n\t\tRC.UNIQUE_CONSTRAINT_CATALOG\n\t\t AND KCU2.CONSTRAINT_SCHEMA =\n\t\tRC.UNIQUE_CONSTRAINT_SCHEMA\n\t\t AND KCU2.CONSTRAINT_NAME =\n\t\tRC.UNIQUE_CONSTRAINT_NAME\n\t\t AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION\n\t\tWHERE KCU1.TABLE_NAME = :table. Bound with :table=\'surveys\'");
console.log("[15:33:15.253][trace][system.db.CDbCommand] Querying SQL: SELECT *, columnproperty(object_id(table_schema+\'.\'+table_name), column_name, \'IsIdentity\') as IsIdentity FROM [INFORMATION_SCHEMA].[COLUMNS] WHERE TABLE_NAME=\'surveys\' AND TABLE_SCHEMA=\'dbo\'");
console.log("[15:33:15.261][trace][system.db.ar.CActiveRecord] Settings_global.findByPk()");
console.log("[15:33:15.261][trace][system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[settings_global] [t] WHERE [t].[stg_name]=\'DBVersion\'");
console.log("[15:33:15.262][trace][system.db.ar.CActiveRecord] Settings_global.findByPk()");
console.log("[15:33:15.262][trace][system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[settings_global] [t] WHERE [t].[stg_name]=\'SessionName\'");
console.log("[15:33:15.274][trace][system.db.ar.CActiveRecord] Survey.findByPk()");
console.log("[15:33:15.274][trace][system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[surveys] [t] WHERE [t].[sid]=489924");
console.log("[15:33:15.276][trace][system.db.CDbCommand] Querying SQL: \t\tSELECT k.column_name field_name\n\t\t\tFROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k\n\t\t LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c\n\t\t ON k.table_name = c.table_name\n\t\t AND k.constraint_name = c.constraint_name\n\t\t WHERE c.constraint_type =\'PRIMARY KEY\'\n\t\t \t AND k.table_name = :table\n\t\t\t\tAND k.table_schema = :schema. Bound with :table=\'surveys_languagesettings\', :schema=\'dbo\'");
console.log("[15:33:15.280][trace][system.db.CDbCommand] Querying SQL: \t\tSELECT\n\t\t KCU1.CONSTRAINT_NAME AS \'FK_CONSTRAINT_NAME\'\n\t\t , KCU1.TABLE_NAME AS \'FK_TABLE_NAME\'\n\t\t , KCU1.COLUMN_NAME AS \'FK_COLUMN_NAME\'\n\t\t , KCU1.ORDINAL_POSITION AS \'FK_ORDINAL_POSITION\'\n\t\t , KCU2.CONSTRAINT_NAME AS \'UQ_CONSTRAINT_NAME\'\n\t\t , KCU2.TABLE_NAME AS \'UQ_TABLE_NAME\'\n\t\t , KCU2.COLUMN_NAME AS \'UQ_COLUMN_NAME\'\n\t\t , KCU2.ORDINAL_POSITION AS \'UQ_ORDINAL_POSITION\'\n\t\tFROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC\n\t\tJOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1\n\t\tON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG\n\t\t AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA\n\t\t AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME\n\t\tJOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2\n\t\tON KCU2.CONSTRAINT_CATALOG =\n\t\tRC.UNIQUE_CONSTRAINT_CATALOG\n\t\t AND KCU2.CONSTRAINT_SCHEMA =\n\t\tRC.UNIQUE_CONSTRAINT_SCHEMA\n\t\t AND KCU2.CONSTRAINT_NAME =\n\t\tRC.UNIQUE_CONSTRAINT_NAME\n\t\t AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION\n\t\tWHERE KCU1.TABLE_NAME = :table. Bound with :table=\'surveys_languagesettings\'");
console.log("[15:33:15.282][trace][system.db.CDbCommand] Querying SQL: SELECT *, columnproperty(object_id(table_schema+\'.\'+table_name), column_name, \'IsIdentity\') as IsIdentity FROM [INFORMATION_SCHEMA].[COLUMNS] WHERE TABLE_NAME=\'surveys_languagesettings\' AND TABLE_SCHEMA=\'dbo\'");
console.log("[15:33:15.285][trace][system.db.ar.CActiveRecord] Surveys_languagesettings.findAllByAttributes()");
console.log("[15:33:15.289][trace][system.db.CDbCommand] Querying SQL: SELECT [t].[surveyls_survey_id] AS [t0_c0], [t].[surveyls_language] AS [t0_c1], [t].[surveyls_title] AS [t0_c2], [t].[surveyls_description] AS [t0_c3], [t].[surveyls_welcometext] AS [t0_c4], [t].[surveyls_endtext] AS [t0_c5], [t].[surveyls_url] AS [t0_c6], [t].[surveyls_urldescription] AS [t0_c7], [t].[surveyls_email_invite_subj] AS [t0_c8], [t].[surveyls_email_invite] AS [t0_c9], [t].[surveyls_email_remind_subj] AS [t0_c10], [t].[surveyls_email_remind] AS [t0_c11], [t].[surveyls_email_register_subj] AS [t0_c12], [t].[surveyls_email_register] AS [t0_c13], [t].[surveyls_email_confirm_subj] AS [t0_c14], [t].[surveyls_email_confirm] AS [t0_c15], [t].[surveyls_dateformat] AS [t0_c16], [t].[surveyls_attributecaptions] AS [t0_c17], [t].[email_admin_notification_subj] AS [t0_c18], [t].[email_admin_notification] AS [t0_c19], [t].[email_admin_responses_subj] AS [t0_c20], [t].[email_admin_responses] AS [t0_c21], [t].[surveyls_numberformat] AS [t0_c22], [survey].[sid] AS [t1_c0], [survey].[owner_id] AS [t1_c1], [survey].[admin] AS [t1_c2], [survey].[active] AS [t1_c3], [survey].[expires] AS [t1_c4], [survey].[startdate] AS [t1_c5], [survey].[adminemail] AS [t1_c6], [survey].[anonymized] AS [t1_c7], [survey].[faxto] AS [t1_c8], [survey].[format] AS [t1_c9], [survey].[savetimings] AS [t1_c10], [survey].[template] AS [t1_c11], [survey].[language] AS [t1_c12], [survey].[additional_languages] AS [t1_c13], [survey].[datestamp] AS [t1_c14], [survey].[usecookie] AS [t1_c15], [survey].[allowregister] AS [t1_c16], [survey].[allowsave] AS [t1_c17], [survey].[autonumber_start] AS [t1_c18], [survey].[autoredirect] AS [t1_c19], [survey].[allowprev] AS [t1_c20], [survey].[printanswers] AS [t1_c21], [survey].[ipaddr] AS [t1_c22], [survey].[refurl] AS [t1_c23], [survey].[datecreated] AS [t1_c24], [survey].[publicstatistics] AS [t1_c25], [survey].[publicgraphs] AS [t1_c26], [survey].[listpublic] AS [t1_c27], [survey].[htmlemail] AS [t1_c28], [survey].[sendconfirmation] AS [t1_c29], [survey].[tokenanswerspersistence] AS [t1_c30], [survey].[assessments] AS [t1_c31], [survey].[usecaptcha] AS [t1_c32], [survey].[usetokens] AS [t1_c33], [survey].[bounce_email] AS [t1_c34], [survey].[attributedescriptions] AS [t1_c35], [survey].[emailresponseto] AS [t1_c36], [survey].[emailnotificationto] AS [t1_c37], [survey].[tokenlength] AS [t1_c38], [survey].[showxquestions] AS [t1_c39], [survey].[showgroupinfo] AS [t1_c40], [survey].[shownoanswer] AS [t1_c41], [survey].[showqnumcode] AS [t1_c42], [survey].[bouncetime] AS [t1_c43], [survey].[bounceprocessing] AS [t1_c44], [survey].[bounceaccounttype] AS [t1_c45], [survey].[bounceaccounthost] AS [t1_c46], [survey].[bounceaccountpass] AS [t1_c47], [survey].[bounceaccountencryption] AS [t1_c48], [survey].[bounceaccountuser] AS [t1_c49], [survey].[showwelcome] AS [t1_c50], [survey].[showprogress] AS [t1_c51], [survey].[allowjumps] AS [t1_c52], [survey].[navigationdelay] AS [t1_c53], [survey].[nokeyboard] AS [t1_c54], [survey].[alloweditaftercompletion] AS [t1_c55], [survey].[googleanalyticsstyle] AS [t1_c56], [survey].[googleanalyticsapikey] AS [t1_c57] FROM [dbo].[surveys_languagesettings] [t] LEFT OUTER JOIN [dbo].[surveys] [survey] ON (t.surveyls_survey_id = survey.sid) WHERE ([t].[surveyls_survey_id]=:yp0 AND [t].[surveyls_language]=:yp1). Bound with :yp0=\'489924\', :yp1=\'en\'");
console.log("[15:33:15.294][trace][system.db.CDbCommand] Querying SQL: SELECT TABLE_NAME, TABLE_SCHEMA FROM [INFORMATION_SCHEMA].[TABLES]\nWHERE TABLE_SCHEMA=:schema AND TABLE_TYPE in (\'BASE TABLE\',\'VIEW\'). Bound with :schema=\'dbo\'");
console.log("[15:33:15.297][trace][system.db.CDbCommand] Querying SQL: \t\tSELECT k.column_name field_name\n\t\t\tFROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k\n\t\t LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c\n\t\t ON k.table_name = c.table_name\n\t\t AND k.constraint_name = c.constraint_name\n\t\t WHERE c.constraint_type =\'PRIMARY KEY\'\n\t\t \t AND k.table_name = :table\n\t\t\t\tAND k.table_schema = :schema. Bound with :table=\'tokens_489924\', :schema=\'dbo\'");
console.log("[15:33:15.301][trace][system.db.CDbCommand] Querying SQL: \t\tSELECT\n\t\t KCU1.CONSTRAINT_NAME AS \'FK_CONSTRAINT_NAME\'\n\t\t , KCU1.TABLE_NAME AS \'FK_TABLE_NAME\'\n\t\t , KCU1.COLUMN_NAME AS \'FK_COLUMN_NAME\'\n\t\t , KCU1.ORDINAL_POSITION AS \'FK_ORDINAL_POSITION\'\n\t\t , KCU2.CONSTRAINT_NAME AS \'UQ_CONSTRAINT_NAME\'\n\t\t , KCU2.TABLE_NAME AS \'UQ_TABLE_NAME\'\n\t\t , KCU2.COLUMN_NAME AS \'UQ_COLUMN_NAME\'\n\t\t , KCU2.ORDINAL_POSITION AS \'UQ_ORDINAL_POSITION\'\n\t\tFROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC\n\t\tJOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1\n\t\tON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG\n\t\t AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA\n\t\t AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME\n\t\tJOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2\n\t\tON KCU2.CONSTRAINT_CATALOG =\n\t\tRC.UNIQUE_CONSTRAINT_CATALOG\n\t\t AND KCU2.CONSTRAINT_SCHEMA =\n\t\tRC.UNIQUE_CONSTRAINT_SCHEMA\n\t\t AND KCU2.CONSTRAINT_NAME =\n\t\tRC.UNIQUE_CONSTRAINT_NAME\n\t\t AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION\n\t\tWHERE KCU1.TABLE_NAME = :table. Bound with :table=\'tokens_489924\'");
console.log("[15:33:15.302][trace][system.db.CDbCommand] Querying SQL: SELECT *, columnproperty(object_id(table_schema+\'.\'+table_name), column_name, \'IsIdentity\') as IsIdentity FROM [INFORMATION_SCHEMA].[COLUMNS] WHERE TABLE_NAME=\'tokens_489924\' AND TABLE_SCHEMA=\'dbo\'");
console.log("[15:33:15.305][trace][system.db.ar.CActiveRecord] Surveys_languagesettings.findAllByAttributes()");
console.log("[15:33:15.306][trace][system.db.CDbCommand] Querying SQL: SELECT [t].[surveyls_survey_id] AS [t0_c0], [t].[surveyls_language] AS [t0_c1], [t].[surveyls_title] AS [t0_c2], [t].[surveyls_description] AS [t0_c3], [t].[surveyls_welcometext] AS [t0_c4], [t].[surveyls_endtext] AS [t0_c5], [t].[surveyls_url] AS [t0_c6], [t].[surveyls_urldescription] AS [t0_c7], [t].[surveyls_email_invite_subj] AS [t0_c8], [t].[surveyls_email_invite] AS [t0_c9], [t].[surveyls_email_remind_subj] AS [t0_c10], [t].[surveyls_email_remind] AS [t0_c11], [t].[surveyls_email_register_subj] AS [t0_c12], [t].[surveyls_email_register] AS [t0_c13], [t].[surveyls_email_confirm_subj] AS [t0_c14], [t].[surveyls_email_confirm] AS [t0_c15], [t].[surveyls_dateformat] AS [t0_c16], [t].[surveyls_attributecaptions] AS [t0_c17], [t].[email_admin_notification_subj] AS [t0_c18], [t].[email_admin_notification] AS [t0_c19], [t].[email_admin_responses_subj] AS [t0_c20], [t].[email_admin_responses] AS [t0_c21], [t].[surveyls_numberformat] AS [t0_c22], [survey].[sid] AS [t1_c0], [survey].[owner_id] AS [t1_c1], [survey].[admin] AS [t1_c2], [survey].[active] AS [t1_c3], [survey].[expires] AS [t1_c4], [survey].[startdate] AS [t1_c5], [survey].[adminemail] AS [t1_c6], [survey].[anonymized] AS [t1_c7], [survey].[faxto] AS [t1_c8], [survey].[format] AS [t1_c9], [survey].[savetimings] AS [t1_c10], [survey].[template] AS [t1_c11], [survey].[language] AS [t1_c12], [survey].[additional_languages] AS [t1_c13], [survey].[datestamp] AS [t1_c14], [survey].[usecookie] AS [t1_c15], [survey].[allowregister] AS [t1_c16], [survey].[allowsave] AS [t1_c17], [survey].[autonumber_start] AS [t1_c18], [survey].[autoredirect] AS [t1_c19], [survey].[allowprev] AS [t1_c20], [survey].[printanswers] AS [t1_c21], [survey].[ipaddr] AS [t1_c22], [survey].[refurl] AS [t1_c23], [survey].[datecreated] AS [t1_c24], [survey].[publicstatistics] AS [t1_c25], [survey].[publicgraphs] AS [t1_c26], [survey].[listpublic] AS [t1_c27], [survey].[htmlemail] AS [t1_c28], [survey].[sendconfirmation] AS [t1_c29], [survey].[tokenanswerspersistence] AS [t1_c30], [survey].[assessments] AS [t1_c31], [survey].[usecaptcha] AS [t1_c32], [survey].[usetokens] AS [t1_c33], [survey].[bounce_email] AS [t1_c34], [survey].[attributedescriptions] AS [t1_c35], [survey].[emailresponseto] AS [t1_c36], [survey].[emailnotificationto] AS [t1_c37], [survey].[tokenlength] AS [t1_c38], [survey].[showxquestions] AS [t1_c39], [survey].[showgroupinfo] AS [t1_c40], [survey].[shownoanswer] AS [t1_c41], [survey].[showqnumcode] AS [t1_c42], [survey].[bouncetime] AS [t1_c43], [survey].[bounceprocessing] AS [t1_c44], [survey].[bounceaccounttype] AS [t1_c45], [survey].[bounceaccounthost] AS [t1_c46], [survey].[bounceaccountpass] AS [t1_c47], [survey].[bounceaccountencryption] AS [t1_c48], [survey].[bounceaccountuser] AS [t1_c49], [survey].[showwelcome] AS [t1_c50], [survey].[showprogress] AS [t1_c51], [survey].[allowjumps] AS [t1_c52], [survey].[navigationdelay] AS [t1_c53], [survey].[nokeyboard] AS [t1_c54], [survey].[alloweditaftercompletion] AS [t1_c55], [survey].[googleanalyticsstyle] AS [t1_c56], [survey].[googleanalyticsapikey] AS [t1_c57] FROM [dbo].[surveys_languagesettings] [t] LEFT OUTER JOIN [dbo].[surveys] [survey] ON (t.surveyls_survey_id = survey.sid) WHERE ([t].[surveyls_survey_id]=:yp0 AND [t].[surveyls_language]=:yp1). Bound with :yp0=\'489924\', :yp1=\'en\'");
console.log("[15:33:15.311][trace][system.db.CDbCommand] Querying SQL: SELECT g.* FROM groups AS g WHERE g.sid = 489924 ORDER BY g.group_order;");
console.log("[15:33:15.312][trace][system.db.CDbCommand] Querying SQL: SELECT q.* FROM questions AS q JOIN groups AS g ON q.gid = g.gid WHERE q.sid = 489924 AND q.language = \'en\' ORDER BY g.group_order, q.question_order;");
console.log("[15:33:15.315][trace][system.db.CDbCommand] Querying SQL: SELECT DISTINCT a.* FROM answers AS a JOIN questions AS q ON a.qid = q.qid WHERE q.sid = 489924 AND a.language = \'en\' ORDER BY a.qid, a.sortorder;");
console.log("[15:33:15.321][trace][system.db.CDbCommand] Querying SQL: SELECT t.* FROM tokens_489924 AS t;");
console.log("[15:33:15.438][trace][system.db.CDbCommand] Querying SQL: SELECT * FROM surveys_languagesettings WHERE surveyls_survey_id = 489924;");
console.log("[15:33:15.440][trace][system.db.CDbCommand] Querying SQL: \t\tSELECT k.column_name field_name\n\t\t\tFROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k\n\t\t LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c\n\t\t ON k.table_name = c.table_name\n\t\t AND k.constraint_name = c.constraint_name\n\t\t WHERE c.constraint_type =\'PRIMARY KEY\'\n\t\t \t AND k.table_name = :table\n\t\t\t\tAND k.table_schema = :schema. Bound with :table=\'survey_489924\', :schema=\'dbo\'");
console.log("[15:33:15.445][trace][system.db.CDbCommand] Querying SQL: \t\tSELECT\n\t\t KCU1.CONSTRAINT_NAME AS \'FK_CONSTRAINT_NAME\'\n\t\t , KCU1.TABLE_NAME AS \'FK_TABLE_NAME\'\n\t\t , KCU1.COLUMN_NAME AS \'FK_COLUMN_NAME\'\n\t\t , KCU1.ORDINAL_POSITION AS \'FK_ORDINAL_POSITION\'\n\t\t , KCU2.CONSTRAINT_NAME AS \'UQ_CONSTRAINT_NAME\'\n\t\t , KCU2.TABLE_NAME AS \'UQ_TABLE_NAME\'\n\t\t , KCU2.COLUMN_NAME AS \'UQ_COLUMN_NAME\'\n\t\t , KCU2.ORDINAL_POSITION AS \'UQ_ORDINAL_POSITION\'\n\t\tFROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC\n\t\tJOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1\n\t\tON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG\n\t\t AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA\n\t\t AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME\n\t\tJOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2\n\t\tON KCU2.CONSTRAINT_CATALOG =\n\t\tRC.UNIQUE_CONSTRAINT_CATALOG\n\t\t AND KCU2.CONSTRAINT_SCHEMA =\n\t\tRC.UNIQUE_CONSTRAINT_SCHEMA\n\t\t AND KCU2.CONSTRAINT_NAME =\n\t\tRC.UNIQUE_CONSTRAINT_NAME\n\t\t AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION\n\t\tWHERE KCU1.TABLE_NAME = :table. Bound with :table=\'survey_489924\'");
console.log("[15:33:15.446][trace][system.db.CDbCommand] Querying SQL: SELECT *, columnproperty(object_id(table_schema+\'.\'+table_name), column_name, \'IsIdentity\') as IsIdentity FROM [INFORMATION_SCHEMA].[COLUMNS] WHERE TABLE_NAME=\'survey_489924\' AND TABLE_SCHEMA=\'dbo\'");
console.log("[15:33:15.454][trace][system.db.CDbCommand] Querying SQL: SELECT TOP 100 *\nFROM [survey_489924]\nLEFT JOIN [tokens_489924] ON tokens_489924.token=survey_489924.token\nLEFT JOIN [survey_489924_timings] [survey_timings] ON survey_489924.id = survey_timings.id\nORDER BY [survey_489924].[id]");
console.log("[15:33:15.619][trace][system.db.CDbCommand] Querying SQL: SELECT * FROM (SELECT TOP 100 * FROM (SELECT TOP 200 *\nFROM [survey_489924]\nLEFT JOIN [tokens_489924] ON tokens_489924.token=survey_489924.token\nLEFT JOIN [survey_489924_timings] [survey_timings] ON survey_489924.id = survey_timings.id\nORDER BY [survey_489924].[id]) as [__inner__] ORDER BY [__inner__].[id] DESC) as [__outer__] ORDER BY [__outer__].[id] ASC");
console.groupEnd();
}
/*]]>*/
</script> | ||||
| Bug heat | 6 | ||||
| Complete LimeSurvey version number (& build) | 121211 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | IE8 | ||||
| Database type & version | SQL Express 2012 | ||||
| Server OS (if known) | Server 2008 | ||||
| Webserver software & version (if known) | IIS 7 | ||||
| PHP Version | 5.4.8 | ||||
 |
This is more or less the same issue, pagination on mssql is crappy in yii. |
 |
I don't know enough about yii to comment but the issue is with two tables in the nested select having a column with the same name and a select * being used. This isn't very elegant but would work: SELECT FROM |
 |
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=11074 |
|
|
Fix committed to 2.1 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=11087 |
|
|
2.00+ Build 130108 released. |
|
LimeSurvey: master 59a8b390 2013-01-05 15:41:08 Details Diff |
Fixed issue 07083: CDbException when using the Show Next / Show Last buttons in the response browser using tokens and MSSQL |
Affected Issues 07083 |
|
| mod - application/models/Survey_dynamic.php | Diff File | ||
|
LimeSurvey: 2.1 8acdf7cc 2013-01-05 15:41:08 Details Diff |
Fixed issue 07083: CDbException when using the Show Next / Show Last buttons in the response browser using tokens and MSSQL |
Affected Issues 07083 |
|
| mod - application/models/Survey_dynamic.php | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-12-14 13:25 | pfpDave | New Issue | |
| 2012-12-14 13:25 | pfpDave | File Added: CDbException.htm | |
| 2012-12-14 14:06 | mdekker | Relationship added | related to 07024 |
| 2012-12-14 14:06 | mdekker | Relationship deleted | related to 07024 |
| 2012-12-14 14:07 | mdekker | Relationship added | related to 07027 |
| 2012-12-14 14:07 | mdekker | Note Added: 23242 | |
| 2012-12-14 14:32 | pfpDave | Note Added: 23244 | |
| 2012-12-14 16:37 | pfpDave | File Added: CSVExportError.htm | |
| 2013-01-03 16:39 | c_schmitz | Relationship added | related to 07127 |
| 2013-01-05 15:44 | c_schmitz | Assigned To | => c_schmitz |
| 2013-01-05 15:44 | c_schmitz | Status | new => assigned |
| 2013-01-05 16:41 | c_schmitz | Changeset attached | => LimeSurvey master 59a8b390 |
| 2013-01-05 16:41 | c_schmitz | Note Added: 23476 | |
| 2013-01-05 16:41 | c_schmitz | Resolution | open => fixed |
| 2013-01-05 16:41 | c_schmitz | Status | assigned => resolved |
| 2013-01-05 16:41 | c_schmitz | Fixed in Version | => 2.00+ |
| 2013-01-05 18:24 | c_schmitz | Changeset attached | => LimeSurvey 2.1 8acdf7cc |
| 2013-01-05 18:24 | c_schmitz | Note Added: 23488 | |
| 2013-01-08 22:32 | c_schmitz | Note Added: 23560 | |
| 2013-01-08 22:32 | c_schmitz | Status | resolved => closed |
