View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
07127Bug reportsImport/Exportpublic2013-01-02 12:162013-01-08 22:32
ReporterpfpDave Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary07127: Can't export full response set to CSV in MS SQL (Linked to issue 07083)
Description

Same issue discussed in bug 07083 ... part way through the CSV Export the export stops and displays the following:

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 *
FROM [survey_489924]
LEFT JOIN [tokens_489924] ON tokens_489924.token=survey_489924.token
LEFT JOIN [survey_489924_timings] [survey_timings] ON survey_489924.id = survey_timings.id
ORDER BY [survey_489924].[id]) as [inner] ORDER BY [inner].[id] DESC) as [outer] ORDER BY [outer].[id] ASC

Full exception text saved as html and attached

TagsNo tags attached.
Attached Files
Export Error.htm (39,177 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 &#039;token&#039; was specified multiple times for &#039;__inner__&#039;.. 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_train\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-&gt;_connection-&gt;enableProfiling)
<span class="ln">521</span>                 Yii::endProfile(&#039;system.db.CDbCommand.query(&#039;.$this-&gt;getText().$par.&#039;)&#039;,&#039;system.db.CDbCommand.query&#039;);
<span class="ln">522</span>             $errorInfo = $e instanceof PDOException ? $e-&gt;errorInfo : null;
<span class="ln">523</span>             $message = $e-&gt;getMessage();
<span class="ln">524</span>             Yii::log(Yii::t(&#039;yii&#039;,&#039;CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.&#039;,
<span class="ln">525</span>                 array(&#039;{method}&#039;=&gt;$method, &#039;{error}&#039;=&gt;$message, &#039;{sql}&#039;=&gt;$this-&gt;getText().$par)),CLogger::LEVEL_ERROR,&#039;system.db.CDbCommand&#039;);
<span class="ln">526</span>             if(YII_DEBUG)
<span class="ln">527</span>                 $message .= &#039;. The SQL statement executed was: &#039;.$this-&gt;getText().$par;
<span class="error"><span class="ln error-ln">528</span>             throw new CDbException(Yii::t(&#039;yii&#039;,&#039;CDbCommand failed to execute the SQL statement: {error}&#039;,
</span><span class="ln">529</span>                 array(&#039;{error}&#039;=&gt;$message)),(int)$e-&gt;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>
										&nbsp;C:\limesurvey_train\framework\db\CDbCommand.php(372): <strong>CDbCommand</strong>-><strong>queryInternal</strong>(&quot;&quot;, 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-&gt;queryInternal(&#039;&#039;,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>
										&nbsp;C:\limesurvey_train\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&gt;$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-&gt;responses=$oRecordSet-&gt;order(&#039;{{survey_&#039; . $survey-&gt;id . &#039;}}.id&#039;)-&gt;limit($iLimit, $iOffset)-&gt;query()-&gt;readAll();
</span><span class="ln">327</span> 
<span class="ln">328</span>         return count($survey-&gt;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>
										&nbsp;C:\limesurvey_train\application\helpers\admin\exportresults_helper.php(108): <strong>SurveyDao</strong>-><strong>loadSurveyResults</strong>(SurveyObj, 100, 100, &quot;994&quot;, ...)				</div>

				<div class="code"><pre><span class="ln">103</span> 
<span class="ln">104</span>         $iBatchSize=100; $iCurrentRecord=$oOptions-&gt;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-&gt;loadSurveyResults($survey, $iBatchSize, $iCurrentRecord, $oOptions-&gt;responseMaxRecord, $sFilter);
</span><span class="ln">109</span>             $iCurrentRecord+=$iExported;
<span class="ln">110</span>             $writer-&gt;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>
										&nbsp;C:\limesurvey_train\application\controllers\admin\export.php(270): <strong>ExportSurveyResultsService</strong>-><strong>exportSurvey</strong>(&quot;489924&quot;, &quot;en&quot;, &quot;csv&quot;, FormattingOptions, ...)				</div>

				<div class="code"><pre><span class="ln">265</span>         else
<span class="ln">266</span>         {
<span class="ln">267</span>             $sFilter=&#039;&#039;;
<span class="ln">268</span>         }
<span class="ln">269</span>         $resultsService = new ExportSurveyResultsService();
<span class="error"><span class="ln error-ln">270</span>         $resultsService-&gt;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">
										&nbsp;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>
										&nbsp;C:\limesurvey_train\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-&gt;isDefaultValueAvailable())
<span class="ln">103</span>                 $ps[]=$param-&gt;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-&gt;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>
										&nbsp;C:\limesurvey_train\application\core\Survey_Common_Action.php(89): <strong>CAction</strong>-><strong>runWithParamsInternal</strong>(export, ReflectionMethod, array(&quot;r&quot; =&gt; &quot;admin/export/sa/exportresults/surveyid/489924&quot;, &quot;sa&quot; =&gt; &quot;exportresults&quot;, &quot;surveyid&quot; =&gt; &quot;489924&quot;, &quot;iSurveyId&quot; =&gt; &quot;489924&quot;, ...))				</div>

				<div class="code"><pre><span class="ln">84</span>             $oMethod = new ReflectionMethod($this, $sDefault);
<span class="ln">85</span>         }
<span class="ln">86</span> 
<span class="ln">87</span>         // We&#039;re all good to go, let&#039;s execute it
<span class="ln">88</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">89</span>         return parent::runWithParamsInternal($this, $oMethod, $params);
</span><span class="ln">90</span>     }
<span class="ln">91</span> 
<span class="ln">92</span>     /**
<span class="ln">93</span>     * Some functions have different parameters, which are just an alias of the
<span class="ln">94</span>     * usual parameters we&#039;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>
										&nbsp;C:\limesurvey_train\framework\web\CController.php(309): <strong>Survey_Common_Action</strong>-><strong>runWithParams</strong>(array(&quot;r&quot; =&gt; &quot;admin/export/sa/exportresults/surveyid/489924&quot;, &quot;sa&quot; =&gt; &quot;exportresults&quot;, &quot;surveyid&quot; =&gt; &quot;489924&quot;))				</div>

				<div class="code"><pre><span class="ln">304</span>     {
<span class="ln">305</span>         $priorAction=$this-&gt;_action;
<span class="ln">306</span>         $this-&gt;_action=$action;
<span class="ln">307</span>         if($this-&gt;beforeAction($action))
<span class="ln">308</span>         {
<span class="error"><span class="ln error-ln">309</span>             if($action-&gt;runWithParams($this-&gt;getActionParams())===false)
</span><span class="ln">310</span>                 $this-&gt;invalidActionParams($action);
<span class="ln">311</span>             else
<span class="ln">312</span>                 $this-&gt;afterAction($action);
<span class="ln">313</span>         }
<span class="ln">314</span>         $this-&gt;_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>
										&nbsp;C:\limesurvey_train\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-&gt;runAction($action);
</span><span class="ln">288</span>         else
<span class="ln">289</span>         {
<span class="ln">290</span>             $priorAction=$this-&gt;_action;
<span class="ln">291</span>             $this-&gt;_action=$action;
<span class="ln">292</span>             CFilterChain::create($this,$action,$filters)-&gt;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>
										&nbsp;C:\limesurvey_train\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-&gt;getModule())===null)
<span class="ln">263</span>                 $parent=Yii::app();
<span class="ln">264</span>             if($parent-&gt;beforeControllerAction($this,$action))
<span class="ln">265</span>             {
<span class="error"><span class="ln error-ln">266</span>                 $this-&gt;runActionWithFilters($action,$this-&gt;filters());
</span><span class="ln">267</span>                 $parent-&gt;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-&gt;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>
										&nbsp;C:\limesurvey_train\application\controllers\AdminController.php(169): <strong>CController</strong>-><strong>run</strong>(&quot;export&quot;)				</div>

				<div class="code"><pre><span class="ln">164</span>                     $this-&gt;redirect($this-&gt;createUrl(&#039;/admin/authentication/sa/login&#039;));
<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>
										&nbsp;C:\limesurvey_train\framework\web\CWebApplication.php(276): <strong>AdminController</strong>-><strong>run</strong>(&quot;export&quot;)				</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-&gt;_controller;
<span class="ln">274</span>             $this-&gt;_controller=$controller;
<span class="ln">275</span>             $controller-&gt;init();
<span class="error"><span class="ln error-ln">276</span>             $controller-&gt;run($actionID);
</span><span class="ln">277</span>             $this-&gt;_controller=$oldController;
<span class="ln">278</span>         }
<span class="ln">279</span>         else
<span class="ln">280</span>             throw new CHttpException(404,Yii::t(&#039;yii&#039;,&#039;Unable to resolve the request &quot;{route}&quot;.&#039;,
<span class="ln">281</span>                 array(&#039;{route}&#039;=&gt;$route===&#039;&#039;?$this-&gt;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>
										&nbsp;C:\limesurvey_train\framework\web\CWebApplication.php(135): <strong>CWebApplication</strong>-><strong>runController</strong>(&quot;admin/export/sa/exportresults/surveyid/489924&quot;)				</div>

				<div class="code"><pre><span class="ln">130</span>             foreach(array_splice($this-&gt;catchAllRequest,1) as $name=&gt;$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-&gt;getUrlManager()-&gt;parseUrl($this-&gt;getRequest());
<span class="error"><span class="ln error-ln">135</span>         $this-&gt;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>
										&nbsp;C:\limesurvey_train\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-&gt;hasEventHandler(&#039;onBeginRequest&#039;))
<span class="ln">161</span>             $this-&gt;onBeginRequest(new CEvent($this));
<span class="error"><span class="ln error-ln">162</span>         $this-&gt;processRequest();
</span><span class="ln">163</span>         if($this-&gt;hasEventHandler(&#039;onEndRequest&#039;))
<span class="ln">164</span>             $this-&gt;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>
										&nbsp;C:\limesurvey_train\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 . &#039;yii&#039; . EXT;
<span class="ln">176</span> require_once APPPATH . &#039;core/LSYii_Application&#039; . EXT;
<span class="ln">177</span> 
<span class="error"><span class="ln error-ln">178</span> Yii::createApplication(&#039;LSYii_Application&#039;, APPPATH . &#039;config/config&#039; . EXT)-&gt;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">
		2013-01-02 11:10:35 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("[11:10:35.374][trace][system.db.CDbConnection] Opening DB connection");
	console.log("[11:10:35.378][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("[11:10:35.383][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("[11:10:35.384][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("[11:10:35.386][trace][system.db.ar.CActiveRecord] Settings_global.findAll()");
	console.log("[11:10:35.389][trace][system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[settings_global] [t]");
	console.log("[11:10:35.434][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("[11:10:35.438][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("[11:10:35.439][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("[11:10:35.459][trace][system.db.ar.CActiveRecord] Survey.findByPk()");
	console.log("[11:10:35.459][trace][system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[surveys] [t] WHERE [t].[sid]=489924");
	console.log("[11:10:35.460][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("[11:10:35.464][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("[11:10:35.466][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("[11:10:35.469][trace][system.db.ar.CActiveRecord] Surveys_languagesettings.findByPk()");
	console.log("[11:10:35.473][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]=489924 AND [t].[surveyls_language]=\'en\')");
	console.log("[11:10:35.477][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("[11:10:35.480][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("[11:10:35.483][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("[11:10:35.485][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("[11:10:35.491][trace][system.db.CDbCommand] Querying SQL: SELECT g.* FROM groups AS g WHERE g.sid = 489924 ORDER BY g.group_order;");
	console.log("[11:10:35.494][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("[11:10:35.501][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("[11:10:35.565][trace][system.db.CDbCommand] Querying SQL: SELECT t.* FROM tokens_489924 AS t;");
	console.log("[11:10:35.681][trace][system.db.CDbCommand] Querying SQL: SELECT * FROM surveys_languagesettings WHERE surveyls_survey_id = 489924;");
	console.log("[11:10:35.684][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("[11:10:35.688][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("[11:10:35.690][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("[11:10:35.698][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("[11:10:35.976][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>
Export Error.htm (39,177 bytes)   
Bug heat4
Complete LimeSurvey version number (& build)121231
I will donate to the project if issue is resolvedNo
BrowserIE8
Database type & versionSQL Express 2012
Server OS (if known)Server 2008
Webserver software & version (if known)IIS 7
PHP Version5.4.8

Relationships

Relationship GraphDependency Graph
related to 07083 closedc_schmitz CDbException error when using the Show Next / Show Last buttons in the response browser 

Users monitoring this issue

There are no users monitoring this issue.

Activities

pfpDave

pfpDave

2013-01-02 12:44

reporter   ~23399

A quick and dirty work around for anyone struggling with this same issue until a proper fix is found is to change line 104 of \application\helpers\admin\exportresults_helper.php to change the export batch size to a value that is greater than the number of results in your survey, eg to change to 5000:

    $iBatchSize=5000; $iCurrentRecord=$oOptions->responseMinRecord-1;

NB: This is likely set to prevent server timeouts during export so bear this in mind.
c_schmitz

c_schmitz

2013-01-03 22:31

administrator   ~23448

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=11065
c_schmitz

c_schmitz

2013-01-05 18:17

administrator   ~23482

Fix committed to 2.1 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=11080
c_schmitz

c_schmitz

2013-01-08 22:32

administrator   ~23561

2.00+ Build 130108 released.

Related Changesets

LimeSurvey: master 08ac8742

2013-01-03 22:29

c_schmitz


Details Diff		 Fixed issue 07127: Can't export full response set to CSV in MS SQL Affected Issues
07127
mod - application/helpers/admin/exportresults_helper.php Diff File

LimeSurvey: 2.1 10623a09

2013-01-03 22:29

c_schmitz


Details Diff		 Fixed issue 07127: Can't export full response set to CSV in MS SQL Affected Issues
07127
mod - application/helpers/admin/exportresults_helper.php Diff File

Issue History

Date Modified Username Field Change
2013-01-02 12:16 pfpDave New Issue
2013-01-02 12:16 pfpDave File Added: Export Error.htm
2013-01-02 12:44 pfpDave Note Added: 23399
2013-01-03 16:39 c_schmitz Relationship added related to 07083
2013-01-03 22:29 c_schmitz Assigned To => c_schmitz
2013-01-03 22:29 c_schmitz Status new => assigned
2013-01-03 22:30 c_schmitz Status assigned => resolved
2013-01-03 22:30 c_schmitz Fixed in Version => 2.00+
2013-01-03 22:30 c_schmitz Resolution open => fixed
2013-01-03 22:31 c_schmitz Changeset attached => LimeSurvey master 08ac8742
2013-01-03 22:31 c_schmitz Note Added: 23448
2013-01-05 18:17 c_schmitz Changeset attached => LimeSurvey 2.1 10623a09
2013-01-05 18:17 c_schmitz Note Added: 23482
2013-01-08 22:32 c_schmitz Note Added: 23561
2013-01-08 22:32 c_schmitz Status resolved => closed