View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
09674Bug reportsSurvey takingpublic2015-06-10 00:402015-06-18 10:46
Reporteraesteban Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.06RC 
Target Version2.06RCFixed in Version2.06+ 
Summary09674: [debug == 2] Error when trying to reload saved answers
Description

Imposible to reload saved answers

Steps To Reproduce

1.- Set debug = 2 in config file
2.- Create a survey and enable save and reload answers (see attached survey)
3.- Take first pages of survey
4.- Save answers
5.- Close browser
6.- Open browser
7.- Reload answers

Result: Error raises (see PHP notice attached)

TagsNo tags attached.
Attached Files
survey_archive_993657.lsa (3,280 bytes)
bug_reload_saved_survey.html (51,455 bytes)    
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!-- saved from url=(0044)http://localhost/limesurvey/index.php/993657 -->
<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>PHP notice</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>PHP notice</h1>

	<p class="message">
		Trying to get property of non-object	</p>

	<div class="source">
		<p class="file">/usr/share/nginx/html/limesurvey/application/helpers/frontend_helper.php(78)</p>
		<div class="code"><pre><span class="ln">66</span>     }
<span class="ln">67</span>     else
<span class="ln">68</span>     {
<span class="ln">69</span>         //A match has been found. Let's load the values!
<span class="ln">70</span>         //If this is from an email, build surveysession first
<span class="ln">71</span>         $_SESSION['survey_'.$surveyid]['LEMtokenResume']=true;
<span class="ln">72</span> 
<span class="ln">73</span>         // If survey come from reload (GET or POST); some value need to be found on saved_control, not on survey
<span class="ln">74</span>         if (Yii::app()-&gt;request-&gt;getParam('loadall') == "reload")
<span class="ln">75</span>         {
<span class="ln">76</span>             $oSavedSurvey=SavedControl::model()-&gt;find("identifier=:identifier AND access_code=:access_code",array(":identifier"=&gt;$sLoadName,":access_code"=&gt;md5($sLoadPass)));
<span class="ln">77</span>             // We don't need to control if we have one, because we do the test before
<span class="error"><span class="ln error-ln">78</span>             $_SESSION['survey_'.$surveyid]['scid'] = $oSavedSurvey-&gt;scid;
</span><span class="ln">79</span>             $_SESSION['survey_'.$surveyid]['step'] = ($oSavedSurvey-&gt;saved_thisstep&gt;1)?$oSavedSurvey-&gt;saved_thisstep:1;
<span class="ln">80</span>             $thisstep=$_SESSION['survey_'.$surveyid]['step']-1;// deprecated ?
<span class="ln">81</span>             $_SESSION['survey_'.$surveyid]['srid'] = $oSavedSurvey-&gt;srid;// Seems OK without
<span class="ln">82</span>             $_SESSION['survey_'.$surveyid]['refurl'] = $oSavedSurvey-&gt;refurl;
<span class="ln">83</span>         }
<span class="ln">84</span> 
<span class="ln">85</span>         // Get if survey is been answered
<span class="ln">86</span>         $submitdate=$oResponses-&gt;submitdate;
<span class="ln">87</span>         $aRow=$oResponses-&gt;attributes;
<span class="ln">88</span>         foreach ($aRow as $column =&gt; $value)
<span class="ln">89</span>         {
<span class="ln">90</span>             if ($column == "token")
</pre></div>	</div>

	<div class="traces">
		<h2>Stack Trace</h2>
				<table style="width:100%;">
						<tbody><tr class="trace app expanded">
			<td class="number">
				#0			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/usr/share/nginx/html/limesurvey/application/controllers/survey/index.php(318): <strong>loadanswers</strong>()				</div>

				<div class="code"><pre><span class="ln">313</span>             }
<span class="ln">314</span> 
<span class="ln">315</span>             if ($errormsg == "") {
<span class="ln">316</span>                 LimeExpressionManager::SetDirtyFlag();
<span class="ln">317</span>                 buildsurveysession($surveyid);
<span class="error"><span class="ln error-ln">318</span>                 if (loadanswers()){
</span><span class="ln">319</span>                     Yii::app()-&gt;setConfig('move','reload');
<span class="ln">320</span>                     $move = "reload";// veyRunTimeHelper use $move in $arg
<span class="ln">321</span>                 } else {
<span class="ln">322</span>                     $errormsg .= gT("There is no matching saved survey");
<span class="ln">323</span>                 }
</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;/usr/share/nginx/html/limesurvey/application/controllers/survey/index.php(46): <strong>index</strong>-&gt;<strong>action</strong>()				</div>

				<div class="code"><pre><span class="ln">41</span>             App()-&gt;getClientScript()-&gt;render($buffer);
<span class="ln">42</span>             App()-&gt;getClientScript()-&gt;reset();
<span class="ln">43</span>             return $buffer;
<span class="ln">44</span>         });
<span class="ln">45</span>         ob_implicit_flush(false);
<span class="error"><span class="ln error-ln">46</span>         $this-&gt;action();
</span><span class="ln">47</span>         ob_flush();
<span class="ln">48</span>     }
<span class="ln">49</span> 
<span class="ln">50</span>     function action()
<span class="ln">51</span>     {
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#2			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/usr/share/nginx/html/limesurvey/framework/web/actions/CAction.php(76): <strong>index</strong>-&gt;<strong>run</strong>()				</div>

				<div class="code"><pre><span class="ln">71</span>     {
<span class="ln">72</span>         $method=new ReflectionMethod($this, 'run');
<span class="ln">73</span>         if($method-&gt;getNumberOfParameters()&gt;0)
<span class="ln">74</span>             return $this-&gt;runWithParamsInternal($this, $method, $params);
<span class="ln">75</span>         else
<span class="error"><span class="ln error-ln">76</span>             return $this-&gt;run();
</span><span class="ln">77</span>     }
<span class="ln">78</span> 
<span class="ln">79</span>     /**
<span class="ln">80</span>      * Executes a method of an object with the supplied named parameters.
<span class="ln">81</span>      * This method is internally used.
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#3			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/usr/share/nginx/html/limesurvey/framework/web/CController.php(308): <strong>CAction</strong>-&gt;<strong>runWithParams</strong>(array("q" =&gt; "/limesurvey/index.php/993657", "sid" =&gt; "993657"))				</div>

				<div class="code"><pre><span class="ln">303</span>     {
<span class="ln">304</span>         $priorAction=$this-&gt;_action;
<span class="ln">305</span>         $this-&gt;_action=$action;
<span class="ln">306</span>         if($this-&gt;beforeAction($action))
<span class="ln">307</span>         {
<span class="error"><span class="ln error-ln">308</span>             if($action-&gt;runWithParams($this-&gt;getActionParams())===false)
</span><span class="ln">309</span>                 $this-&gt;invalidActionParams($action);
<span class="ln">310</span>             else
<span class="ln">311</span>                 $this-&gt;afterAction($action);
<span class="ln">312</span>         }
<span class="ln">313</span>         $this-&gt;_action=$priorAction;
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#4			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/usr/share/nginx/html/limesurvey/framework/web/CController.php(286): <strong>CController</strong>-&gt;<strong>runAction</strong>(index)				</div>

				<div class="code"><pre><span class="ln">281</span>      * @see runAction
<span class="ln">282</span>      */
<span class="ln">283</span>     public function runActionWithFilters($action,$filters)
<span class="ln">284</span>     {
<span class="ln">285</span>         if(empty($filters))
<span class="error"><span class="ln error-ln">286</span>             $this-&gt;runAction($action);
</span><span class="ln">287</span>         else
<span class="ln">288</span>         {
<span class="ln">289</span>             $priorAction=$this-&gt;_action;
<span class="ln">290</span>             $this-&gt;_action=$action;
<span class="ln">291</span>             CFilterChain::create($this,$action,$filters)-&gt;run();
</pre></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;/usr/share/nginx/html/limesurvey/framework/web/CController.php(265): <strong>CController</strong>-&gt;<strong>runActionWithFilters</strong>(index, array())				</div>

				<div class="code"><pre><span class="ln">260</span>         {
<span class="ln">261</span>             if(($parent=$this-&gt;getModule())===null)
<span class="ln">262</span>                 $parent=Yii::app();
<span class="ln">263</span>             if($parent-&gt;beforeControllerAction($this,$action))
<span class="ln">264</span>             {
<span class="error"><span class="ln error-ln">265</span>                 $this-&gt;runActionWithFilters($action,$this-&gt;filters());
</span><span class="ln">266</span>                 $parent-&gt;afterControllerAction($this,$action);
<span class="ln">267</span>             }
<span class="ln">268</span>         }
<span class="ln">269</span>         else
<span class="ln">270</span>             $this-&gt;missingAction($actionID);
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#6			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/usr/share/nginx/html/limesurvey/framework/web/CWebApplication.php(282): <strong>CController</strong>-&gt;<strong>run</strong>("index")				</div>

				<div class="code"><pre><span class="ln">277</span>         {
<span class="ln">278</span>             list($controller,$actionID)=$ca;
<span class="ln">279</span>             $oldController=$this-&gt;_controller;
<span class="ln">280</span>             $this-&gt;_controller=$controller;
<span class="ln">281</span>             $controller-&gt;init();
<span class="error"><span class="ln error-ln">282</span>             $controller-&gt;run($actionID);
</span><span class="ln">283</span>             $this-&gt;_controller=$oldController;
<span class="ln">284</span>         }
<span class="ln">285</span>         else
<span class="ln">286</span>             throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".',
<span class="ln">287</span>                 array('{route}'=&gt;$route===''?$this-&gt;defaultController:$route)));
</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;/usr/share/nginx/html/limesurvey/framework/web/CWebApplication.php(141): <strong>CWebApplication</strong>-&gt;<strong>runController</strong>("survey/index/sid/993657")				</div>

				<div class="code"><pre><span class="ln">136</span>             foreach(array_splice($this-&gt;catchAllRequest,1) as $name=&gt;$value)
<span class="ln">137</span>                 $_GET[$name]=$value;
<span class="ln">138</span>         }
<span class="ln">139</span>         else
<span class="ln">140</span>             $route=$this-&gt;getUrlManager()-&gt;parseUrl($this-&gt;getRequest());
<span class="error"><span class="ln error-ln">141</span>         $this-&gt;runController($route);
</span><span class="ln">142</span>     }
<span class="ln">143</span> 
<span class="ln">144</span>     /**
<span class="ln">145</span>      * Registers the core application components.
<span class="ln">146</span>      * This method overrides the parent implementation by registering additional core components.
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#8			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/usr/share/nginx/html/limesurvey/framework/base/CApplication.php(180): <strong>CWebApplication</strong>-&gt;<strong>processRequest</strong>()				</div>

				<div class="code"><pre><span class="ln">175</span>     public function run()
<span class="ln">176</span>     {
<span class="ln">177</span>         if($this-&gt;hasEventHandler('onBeginRequest'))
<span class="ln">178</span>             $this-&gt;onBeginRequest(new CEvent($this));
<span class="ln">179</span>         register_shutdown_function(array($this,'end'),0,false);
<span class="error"><span class="ln error-ln">180</span>         $this-&gt;processRequest();
</span><span class="ln">181</span>         if($this-&gt;hasEventHandler('onEndRequest'))
<span class="ln">182</span>             $this-&gt;onEndRequest(new CEvent($this));
<span class="ln">183</span>     }
<span class="ln">184</span> 
<span class="ln">185</span>     /**
</pre></div>			</td>
		</tr>
						<tr class="trace app expanded">
			<td class="number">
				#9			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/usr/share/nginx/html/limesurvey/index.php(211): <strong>CApplication</strong>-&gt;<strong>run</strong>()				</div>

				<div class="code"><pre><span class="ln">206</span>         die (sprintf('%s should be writable by the webserver (755 or 775).', $runtimePath));
<span class="ln">207</span>     }
<span class="ln">208</span> }
<span class="ln">209</span> 
<span class="ln">210</span> Yii::$enableIncludePath = false;
<span class="error"><span class="ln error-ln">211</span> Yii::createApplication('LSYii_Application', $config)-&gt;run();
</span><span class="ln">212</span> 
<span class="ln">213</span> /* End of file index.php */
<span class="ln">214</span> /* Location: ./index.php */
</pre></div>			</td>
		</tr>
				</tbody></table>
	</div>

	<div class="version">
		2015-06-10 00:34:49 nginx/1.4.6 <a href="http://www.yiiframework.com/">Yii Framework</a>/1.1.15	</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>



<!-- start profiling summary -->
<table class="yiiLog" width="100%" cellpadding="2" style="border-spacing:1px;font:11px Verdana, Arial, Helvetica, sans-serif;background:#EEEEEE;color:#666666;">
	<tbody><tr>
		<th style="background:black;color:white;" colspan="6">
			Profiling Summary Report
			(Tiempo: 1.32795s,
			Memoria: 5,343KB)
		</th>
	</tr>
	<tr style="background-color: #ccc;">
	    <th>Procedimiento</th>
		<th>Cuenta</th>
		<th>Total (es)</th>
		<th>Promedio (s)</th>
		<th>Min. (s)</th>
		<th>Máx. (s)</th>
	</tr>
	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT table_name, table_schema FROM information_schema.tables
WHERE table_schema=:schema AND table_type='BASE TABLE'. Bound with :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00955</td>
		<td align="center">0.00955</td>
		<td align="center">0.00955</td>
		<td align="center">0.00955</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attnum &gt; 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema))
ORDER BY a.attnum. Bound with :table='lime_surveys', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00531</td>
		<td align="center">0.00531</td>
		<td align="center">0.00531</td>
		<td align="center">0.00531</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM (
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with :table='lime_settings_global', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00519</td>
		<td align="center">0.00519</td>
		<td align="center">0.00519</td>
		<td align="center">0.00519</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM (
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with :table='lime_surveys', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00471</td>
		<td align="center">0.00471</td>
		<td align="center">0.00471</td>
		<td align="center">0.00471</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM (
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with :table='lime_survey_993657', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00464</td>
		<td align="center">0.00464</td>
		<td align="center">0.00464</td>
		<td align="center">0.00464</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM (
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with :table='lime_plugins', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00452</td>
		<td align="center">0.00452</td>
		<td align="center">0.00452</td>
		<td align="center">0.00452</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attnum &gt; 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema))
ORDER BY a.attnum. Bound with :table='lime_settings_global', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00430</td>
		<td align="center">0.00430</td>
		<td align="center">0.00430</td>
		<td align="center">0.00430</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(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", "t"."attachments" AS "t0_c23", "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"."questionindex" 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 "lime_surveys_languagesettings" "t"  LEFT OUTER JOIN "lime_surveys" "survey" ON (t.surveyls_survey_id = survey.sid)  WHERE ("t"."surveyls_survey_id"=993657 AND "t"."surveyls_language"='es'))</td>
		<td align="center">1</td>
		<td align="center">0.00403</td>
		<td align="center">0.00403</td>
		<td align="center">0.00403</td>
		<td align="center">0.00403</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM (
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with :table='lime_surveys_languagesettings', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00400</td>
		<td align="center">0.00400</td>
		<td align="center">0.00400</td>
		<td align="center">0.00400</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM (
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with :table='lime_saved_control', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00379</td>
		<td align="center">0.00379</td>
		<td align="center">0.00379</td>
		<td align="center">0.00379</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM (
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with :table='lime_survey_url_parameters', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00378</td>
		<td align="center">0.00378</td>
		<td align="center">0.00378</td>
		<td align="center">0.00378</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attnum &gt; 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema))
ORDER BY a.attnum. Bound with :table='lime_surveys_languagesettings', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00364</td>
		<td align="center">0.00364</td>
		<td align="center">0.00364</td>
		<td align="center">0.00364</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM (
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with :table='lime_groups', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00318</td>
		<td align="center">0.00318</td>
		<td align="center">0.00318</td>
		<td align="center">0.00318</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM (
	SELECT
		conname,
		CASE WHEN contype='f' THEN
			pg_catalog.pg_get_constraintdef(oid)
		ELSE
			'CHECK (' || consrc || ')'
		END AS consrc,
		contype,
		conrelid AS relid,
		NULL AS indkey
	FROM
		pg_catalog.pg_constraint
	WHERE
		contype IN ('f', 'c')
	UNION ALL
	SELECT
		pc.relname,
		NULL,
		CASE WHEN indisprimary THEN
				'p'
		ELSE
				'u'
		END,
		pi.indrelid,
		indkey
	FROM
		pg_catalog.pg_class pc,
		pg_catalog.pg_index pi
	WHERE
		pc.oid=pi.indexrelid
		AND EXISTS (
			SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
			ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
			WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
	)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
	AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
	WHERE nspname=:schema)). Bound with :table='lime_permissions', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00318</td>
		<td align="center">0.00318</td>
		<td align="center">0.00318</td>
		<td align="center">0.00318</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attnum &gt; 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema))
ORDER BY a.attnum. Bound with :table='lime_saved_control', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00312</td>
		<td align="center">0.00312</td>
		<td align="center">0.00312</td>
		<td align="center">0.00312</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT "t"."id", "t"."token", "t"."submitdate", "t"."lastpage", "t"."startlanguage", "t"."993657X10X37", "t"."993657X11X38" FROM "lime_survey_993657" "t" LEFT JOIN lime_saved_control ON t.id=lime_saved_control.srid WHERE ((lime_saved_control.sid=:sid) AND (lime_saved_control.identifier=:identifier)) AND ((lime_saved_control.access_code=:md5_code OR lime_saved_control.access_code=:sha256_code)) LIMIT 1. Bound with :sid='993657', :identifier='alfredo', :md5_code='b1b79eb0bc0a6569bf58dfb2458f6d03', :sha256_code='563803ed2de926fb4ff44cf9307a68a13dfff381a4e3d5ecae4a2d21e3a2829c')</td>
		<td align="center">1</td>
		<td align="center">0.00283</td>
		<td align="center">0.00283</td>
		<td align="center">0.00283</td>
		<td align="center">0.00283</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attnum &gt; 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema))
ORDER BY a.attnum. Bound with :table='lime_plugins', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00271</td>
		<td align="center">0.00271</td>
		<td align="center">0.00271</td>
		<td align="center">0.00271</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attnum &gt; 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema))
ORDER BY a.attnum. Bound with :table='lime_survey_993657', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00262</td>
		<td align="center">0.00262</td>
		<td align="center">0.00262</td>
		<td align="center">0.00262</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attnum &gt; 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema))
ORDER BY a.attnum. Bound with :table='lime_groups', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00235</td>
		<td align="center">0.00235</td>
		<td align="center">0.00235</td>
		<td align="center">0.00235</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT a.qid, a.sqid, a.scale_id, a.specialtype, a.defaultvalue FROM lime_defaultvalues as a, lime_questions as b WHERE a.qid = b.qid AND a.language = b.language AND a.language = 'es' AND b.same_default=0 AND b.sid = 993657)</td>
		<td align="center">1</td>
		<td align="center">0.00233</td>
		<td align="center">0.00233</td>
		<td align="center">0.00233</td>
		<td align="center">0.00233</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attnum &gt; 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema))
ORDER BY a.attnum. Bound with :table='lime_survey_url_parameters', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00218</td>
		<td align="center">0.00218</td>
		<td align="center">0.00218</td>
		<td align="center">0.00218</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT * FROM lime_groups WHERE sid=993657 AND language='es' ORDER BY group_order)</td>
		<td align="center">1</td>
		<td align="center">0.00217</td>
		<td align="center">0.00217</td>
		<td align="center">0.00217</td>
		<td align="center">0.00217</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT *  FROM lime_questions as questions, lime_groups as groups WHERE questions.gid=groups.gid AND  questions.sid=993657 AND  questions.language='es' AND  questions.parent_qid=0 AND  groups.language='es'  ORDER BY group_order, question_order)</td>
		<td align="center">1</td>
		<td align="center">0.00214</td>
		<td align="center">0.00214</td>
		<td align="center">0.00214</td>
		<td align="center">0.00214</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef,
	pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attnum &gt; 0 AND NOT a.attisdropped
	AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
		AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema))
ORDER BY a.attnum. Bound with :table='lime_permissions', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00206</td>
		<td align="center">0.00206</td>
		<td align="center">0.00206</td>
		<td align="center">0.00206</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT * FROM "lime_surveys" "t" WHERE "t"."sid"=993657 LIMIT 1)</td>
		<td align="center">1</td>
		<td align="center">0.00182</td>
		<td align="center">0.00182</td>
		<td align="center">0.00182</td>
		<td align="center">0.00182</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT count(*)
 FROM lime_groups INNER JOIN lime_questions ON lime_groups.gid = lime_questions.gid
 WHERE lime_questions.sid=993657
 AND lime_groups.language='es'
 AND lime_questions.language='es'
 AND lime_questions.parent_qid=0
)</td>
		<td align="center">1</td>
		<td align="center">0.00171</td>
		<td align="center">0.00171</td>
		<td align="center">0.00171</td>
		<td align="center">0.00171</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT attr.qid, value FROM lime_question_attributes as attr right join lime_questions as quests on attr.qid=quests.qid WHERE attribute='random_group' and value &lt;&gt; '' and sid=993657 GROUP BY attr.qid, value)</td>
		<td align="center">1</td>
		<td align="center">0.00160</td>
		<td align="center">0.00160</td>
		<td align="center">0.00160</td>
		<td align="center">0.00160</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT count(*)
 FROM lime_questions WHERE type in ('X','*')
 AND sid=993657 AND language='es' AND parent_qid=0)</td>
		<td align="center">1</td>
		<td align="center">0.00130</td>
		<td align="center">0.00130</td>
		<td align="center">0.00130</td>
		<td align="center">0.00130</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1). Bound with :table='lime_plugins', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00128</td>
		<td align="center">0.00128</td>
		<td align="center">0.00128</td>
		<td align="center">0.00128</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(select '' as act, up.*,q.title, sq.title as sqtitle, q.question, sq.question as sqquestion from lime_survey_url_parameters up
                left join lime_questions q on q.qid=up.targetqid
                left join lime_questions sq on q.qid=up.targetsqid
            where up.sid=:surveyid. Bound with :surveyid='993657')</td>
		<td align="center">1</td>
		<td align="center">0.00127</td>
		<td align="center">0.00127</td>
		<td align="center">0.00127</td>
		<td align="center">0.00127</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT a.qid, a.sqid, a.scale_id, a.specialtype, a.defaultvalue FROM lime_defaultvalues as a, lime_questions as b WHERE a.qid = b.qid AND a.language = b.language AND a.language = 'es' AND b.same_default=1 AND b.sid = 993657)</td>
		<td align="center">1</td>
		<td align="center">0.00126</td>
		<td align="center">0.00126</td>
		<td align="center">0.00126</td>
		<td align="center">0.00126</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1, 2). Bound with :table='lime_surveys_languagesettings', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00124</td>
		<td align="center">0.00124</td>
		<td align="center">0.00124</td>
		<td align="center">0.00124</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1). Bound with :table='lime_survey_993657', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00121</td>
		<td align="center">0.00121</td>
		<td align="center">0.00121</td>
		<td align="center">0.00121</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT * FROM "lime_settings_global" "t")</td>
		<td align="center">1</td>
		<td align="center">0.00119</td>
		<td align="center">0.00119</td>
		<td align="center">0.00119</td>
		<td align="center">0.00119</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1). Bound with :table='lime_permissions', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00117</td>
		<td align="center">0.00117</td>
		<td align="center">0.00117</td>
		<td align="center">0.00117</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1). Bound with :table='lime_surveys', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00116</td>
		<td align="center">0.00116</td>
		<td align="center">0.00116</td>
		<td align="center">0.00116</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT * FROM "lime_groups" "t" WHERE (sid=:ycp0 AND language=:ycp1) AND (randomization_group != ''). Bound with :ycp0='993657', :ycp1='es')</td>
		<td align="center">1</td>
		<td align="center">0.00111</td>
		<td align="center">0.00111</td>
		<td align="center">0.00111</td>
		<td align="center">0.00111</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT * FROM "lime_plugins" "t" WHERE "t"."active"=:yp0. Bound with :yp0=1)</td>
		<td align="center">1</td>
		<td align="center">0.00109</td>
		<td align="center">0.00109</td>
		<td align="center">0.00109</td>
		<td align="center">0.00109</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(select count(*) from lime_groups 
        left join lime_questions on  lime_groups.gid=lime_questions.gid 
        where qid is null)</td>
		<td align="center">1</td>
		<td align="center">0.00108</td>
		<td align="center">0.00108</td>
		<td align="center">0.00108</td>
		<td align="center">0.00108</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1). Bound with :table='lime_survey_url_parameters', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00106</td>
		<td align="center">0.00106</td>
		<td align="center">0.00106</td>
		<td align="center">0.00106</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1). Bound with :table='lime_saved_control', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00100</td>
		<td align="center">0.00100</td>
		<td align="center">0.00100</td>
		<td align="center">0.00100</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1, 6). Bound with :table='lime_groups', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00095</td>
		<td align="center">0.00095</td>
		<td align="center">0.00095</td>
		<td align="center">0.00095</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
	attrelid=(
		SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=(
			SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
		)
	)
	AND attnum IN (1). Bound with :table='lime_settings_global', :schema='public')</td>
		<td align="center">1</td>
		<td align="center">0.00089</td>
		<td align="center">0.00089</td>
		<td align="center">0.00089</td>
		<td align="center">0.00089</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT * FROM "lime_saved_control" "t" WHERE identifier=:identifier AND access_code=:access_code LIMIT 1. Bound with :identifier='alfredo', :access_code='b1b79eb0bc0a6569bf58dfb2458f6d03')</td>
		<td align="center">1</td>
		<td align="center">0.00067</td>
		<td align="center">0.00067</td>
		<td align="center">0.00067</td>
		<td align="center">0.00067</td>
	</tr></tbody></table>
<!-- end of profiling summary --></body></html>
bug_reload_saved_survey.html (51,455 bytes)   
Bug heat4
Complete LimeSurvey version number (& build)88c14fc12aa9a32c146c08ce1264
I will donate to the project if issue is resolvedNo
BrowserChromium
Database type & versionPostgresql 9.3
Server OS (if known)Ubuntu 14.04
Webserver software & version (if known)Nginx 1.4.6
PHP Version5.5.9

Relationships

Relationship GraphDependency Graph
related to 09452 closedaesteban [only if debug == 2] Crash when submitting a survey that was saved and reloaded 

Users monitoring this issue

DenisChenu

Activities

c_schmitz

c_schmitz

2015-06-12 13:47

administrator   ~32332

Fix committed to develop branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=15415
c_schmitz

c_schmitz

2015-06-12 13:47

administrator   ~32333

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

c_schmitz

2015-06-18 10:46

administrator   ~32420

Version 2.06+ Build 150618 released

Related Changesets

LimeSurvey: develop 9bbfed3d

2015-06-12 11:44:56

c_schmitz

Details Diff 		Fixed issue 09674: Error when trying to reload saved answers Affected Issues
09674
mod - application/helpers/frontend_helper.php Diff File

LimeSurvey: master 7aee8c3f

2015-06-12 11:44:56

c_schmitz

Details Diff 		Fixed issue 09674: Error when trying to reload saved answers Affected Issues
09674
mod - application/helpers/frontend_helper.php Diff File

Issue History

Date Modified Username Field Change
2015-06-10 00:40 aesteban New Issue
2015-06-10 00:40 aesteban File Added: survey_archive_993657.lsa
2015-06-10 00:42 aesteban File Added: bug_reload_saved_survey.html
2015-06-10 00:42 aesteban Relationship added related to 09452
2015-06-10 08:13 DenisChenu Issue Monitored: DenisChenu
2015-06-12 13:47 c_schmitz Changeset attached => LimeSurvey develop 9bbfed3d
2015-06-12 13:47 c_schmitz Note Added: 32332
2015-06-12 13:47 c_schmitz Assigned To => c_schmitz
2015-06-12 13:47 c_schmitz Resolution open => fixed
2015-06-12 13:47 c_schmitz Changeset attached => LimeSurvey master 7aee8c3f
2015-06-12 13:47 c_schmitz Note Added: 32333
2015-06-12 13:47 c_schmitz Status new => resolved
2015-06-12 13:47 c_schmitz Fixed in Version => 2.06+
2015-06-18 10:46 c_schmitz Note Added: 32420
2015-06-18 10:46 c_schmitz Status resolved => closed
2021-08-02 23:30 guest Bug heat 2 => 4