View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 10984 | Bug reports | Survey editing | public | 2016-04-19 18:12 | 2016-04-20 09:47 |
| Reporter | aesteban | Assigned To | c_schmitz | ||
| Priority | none | Severity | block | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 2.50.x | ||||
| Fixed in Version | 2.50.x | ||||
| Summary | 10984: Crash when accessing general settings | ||||
| Description | Crash when accessing general settings | ||||
| Steps To Reproduce | 1.- Enter a survey LS crashes (see attached PHP notice) | ||||
| Tags | No tags attached. | ||||
| Attached Files | PHP notice.html (50,891 bytes)
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!-- saved from url=(0090)http://localhost/lsurveymaster/index.php/admin/survey/sa/editlocalsettings/surveyid/821877 -->
<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">
Undefined variable: iSurveyId </p>
<div class="source">
<p class="file">/usr/share/nginx/html/lsurveymaster/application/controllers/admin/surveyadmin.php(1058)</p>
<div class="code"><pre><span class="ln">1046</span>
<span class="ln">1047</span> $aData['questions'] = $oResult;
<span class="ln">1048</span> $aData['display']['menu_bars']['surveysummary'] = "editsurveysettings";
<span class="ln">1049</span> $tempData = $aData;
<span class="ln">1050</span> $aData['settings_data'] = $tempData;
<span class="ln">1051</span>
<span class="ln">1052</span> $aData['sidemenu']['state'] = false;
<span class="ln">1053</span> $surveyinfo = Survey::model()->findByPk($iSurveyID)->surveyinfo;
<span class="ln">1054</span> $aData['title_bar']['title'] = $surveyinfo['surveyls_title']."(".gT("ID").":".$iSurveyID.")";
<span class="ln">1055</span>
<span class="ln">1056</span> $aData['surveybar']['savebutton']['form'] = 'globalsetting';
<span class="ln">1057</span> $aData['surveybar']['savebutton']['useformid'] = 'true';
<span class="error"><span class="ln error-ln">1058</span> if (Permission::model()->hasSurveyPermission($iSurveyId, 'surveycontent', 'update'))
</span><span class="ln">1059</span> {
<span class="ln">1060</span> $aData['surveybar']['saveandclosebutton']['form'] = true;
<span class="ln">1061</span> }
<span class="ln">1062</span> else
<span class="ln">1063</span> {
<span class="ln">1064</span> unset($aData['surveybar']['savebutton']['form']);
<span class="ln">1065</span> }
<span class="ln">1066</span>
<span class="ln">1067</span> $aData['surveybar']['closebutton']['url'] = 'admin/survey/sa/view/surveyid/'.$iSurveyID; // Close button
<span class="ln">1068</span>
<span class="ln">1069</span> $aViewUrls[] = 'editLocalSettings_main_view';
<span class="ln">1070</span> }
</pre></div> </div>
<div class="traces">
<h2>Stack Trace</h2>
<table style="width:100%;">
<tbody><tr class="trace core collapsed">
<td class="number">
#0 </td>
<td class="content">
<div class="trace-file">
unknown(0): <strong>SurveyAdmin</strong>-><strong>editlocalsettings</strong>("821877") </div>
</td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#1 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/usr/share/nginx/html/lsurveymaster/framework/web/actions/CAction.php(109): <strong>ReflectionMethod</strong>-><strong>invokeArgs</strong>(SurveyAdmin, array("821877")) </div>
<div class="code"><pre><span class="ln">104</span> elseif($param->isDefaultValueAvailable())
<span class="ln">105</span> $ps[]=$param->getDefaultValue();
<span class="ln">106</span> else
<span class="ln">107</span> return false;
<span class="ln">108</span> }
<span class="error"><span class="ln error-ln">109</span> $method->invokeArgs($object,$ps);
</span><span class="ln">110</span> return true;
<span class="ln">111</span> }
<span class="ln">112</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>
/usr/share/nginx/html/lsurveymaster/application/core/Survey_Common_Action.php(101): <strong>CAction</strong>-><strong>runWithParamsInternal</strong>(SurveyAdmin, ReflectionMethod, array("q" => "/lsurveymaster/index.php/admin/survey/sa/editlocalsettings/surve...", "surveyid" => "821877", "sa" => "editlocalsettings", "iSurveyId" => "821877", ...)) </div>
<div class="code"><pre><span class="ln">096</span> $oMethod = new ReflectionMethod($this, $sDefault);
<span class="ln">097</span> }
<span class="ln">098</span>
<span class="ln">099</span> // We're all good to go, let's execute it
<span class="ln">100</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">101</span> return parent::runWithParamsInternal($this, $oMethod, $params);
</span><span class="ln">102</span> }
<span class="ln">103</span>
<span class="ln">104</span> /**
<span class="ln">105</span> * Some functions have different parameters, which are just an alias of the
<span class="ln">106</span> * usual parameters we're getting in the url. This function just populates
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#3 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/usr/share/nginx/html/lsurveymaster/framework/web/CController.php(308): <strong>Survey_Common_Action</strong>-><strong>runWithParams</strong>(array("q" => "/lsurveymaster/index.php/admin/survey/sa/editlocalsettings/surve...", "surveyid" => "821877", "sa" => "editlocalsettings")) </div>
<div class="code"><pre><span class="ln">303</span> {
<span class="ln">304</span> $priorAction=$this->_action;
<span class="ln">305</span> $this->_action=$action;
<span class="ln">306</span> if($this->beforeAction($action))
<span class="ln">307</span> {
<span class="error"><span class="ln error-ln">308</span> if($action->runWithParams($this->getActionParams())===false)
</span><span class="ln">309</span> $this->invalidActionParams($action);
<span class="ln">310</span> else
<span class="ln">311</span> $this->afterAction($action);
<span class="ln">312</span> }
<span class="ln">313</span> $this->_action=$priorAction;
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#4 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/usr/share/nginx/html/lsurveymaster/framework/web/CController.php(286): <strong>CController</strong>-><strong>runAction</strong>(SurveyAdmin) </div>
<div class="code"><pre><span class="ln">281</span> * @see runAction
<span class="ln">282</span> */
<span class="ln">283</span> public function runActionWithFilters($action,$filters)
<span class="ln">284</span> {
<span class="ln">285</span> if(empty($filters))
<span class="error"><span class="ln error-ln">286</span> $this->runAction($action);
</span><span class="ln">287</span> else
<span class="ln">288</span> {
<span class="ln">289</span> $priorAction=$this->_action;
<span class="ln">290</span> $this->_action=$action;
<span class="ln">291</span> CFilterChain::create($this,$action,$filters)->run();
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#5 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/usr/share/nginx/html/lsurveymaster/framework/web/CController.php(265): <strong>CController</strong>-><strong>runActionWithFilters</strong>(SurveyAdmin, array()) </div>
<div class="code"><pre><span class="ln">260</span> {
<span class="ln">261</span> if(($parent=$this->getModule())===null)
<span class="ln">262</span> $parent=Yii::app();
<span class="ln">263</span> if($parent->beforeControllerAction($this,$action))
<span class="ln">264</span> {
<span class="error"><span class="ln error-ln">265</span> $this->runActionWithFilters($action,$this->filters());
</span><span class="ln">266</span> $parent->afterControllerAction($this,$action);
<span class="ln">267</span> }
<span class="ln">268</span> }
<span class="ln">269</span> else
<span class="ln">270</span> $this->missingAction($actionID);
</pre></div> </td>
</tr>
<tr class="trace app expanded">
<td class="number">
#6 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/usr/share/nginx/html/lsurveymaster/application/controllers/AdminController.php(161): <strong>CController</strong>-><strong>run</strong>("survey") </div>
<div class="code"><pre><span class="ln">156</span> $this->redirect(array('/admin/authentication/sa/login'));
<span class="ln">157</span> }
<span class="ln">158</span>
<span class="ln">159</span> }
<span class="ln">160</span>
<span class="error"><span class="ln error-ln">161</span> return parent::run($action);
</span><span class="ln">162</span> }
<span class="ln">163</span>
<span class="ln">164</span> /**
<span class="ln">165</span> * Routes all the actions to their respective places
<span class="ln">166</span> *
</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>
/usr/share/nginx/html/lsurveymaster/framework/web/CWebApplication.php(282): <strong>AdminController</strong>-><strong>run</strong>("survey") </div>
<div class="code"><pre><span class="ln">277</span> {
<span class="ln">278</span> list($controller,$actionID)=$ca;
<span class="ln">279</span> $oldController=$this->_controller;
<span class="ln">280</span> $this->_controller=$controller;
<span class="ln">281</span> $controller->init();
<span class="error"><span class="ln error-ln">282</span> $controller->run($actionID);
</span><span class="ln">283</span> $this->_controller=$oldController;
<span class="ln">284</span> }
<span class="ln">285</span> else
<span class="ln">286</span> throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".',
<span class="ln">287</span> array('{route}'=>$route===''?$this->defaultController:$route)));
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#8 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/usr/share/nginx/html/lsurveymaster/framework/web/CWebApplication.php(141): <strong>CWebApplication</strong>-><strong>runController</strong>("admin/survey/sa/editlocalsettings") </div>
<div class="code"><pre><span class="ln">136</span> foreach(array_splice($this->catchAllRequest,1) as $name=>$value)
<span class="ln">137</span> $_GET[$name]=$value;
<span class="ln">138</span> }
<span class="ln">139</span> else
<span class="ln">140</span> $route=$this->getUrlManager()->parseUrl($this->getRequest());
<span class="error"><span class="ln error-ln">141</span> $this->runController($route);
</span><span class="ln">142</span> }
<span class="ln">143</span>
<span class="ln">144</span> /**
<span class="ln">145</span> * Registers the core application components.
<span class="ln">146</span> * This method overrides the parent implementation by registering additional core components.
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#9 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/usr/share/nginx/html/lsurveymaster/framework/base/CApplication.php(185): <strong>CWebApplication</strong>-><strong>processRequest</strong>() </div>
<div class="code"><pre><span class="ln">180</span> public function run()
<span class="ln">181</span> {
<span class="ln">182</span> if($this->hasEventHandler('onBeginRequest'))
<span class="ln">183</span> $this->onBeginRequest(new CEvent($this));
<span class="ln">184</span> register_shutdown_function(array($this,'end'),0,false);
<span class="error"><span class="ln error-ln">185</span> $this->processRequest();
</span><span class="ln">186</span> if($this->hasEventHandler('onEndRequest'))
<span class="ln">187</span> $this->onEndRequest(new CEvent($this));
<span class="ln">188</span> }
<span class="ln">189</span>
<span class="ln">190</span> /**
</pre></div> </td>
</tr>
<tr class="trace app expanded">
<td class="number">
#10 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/usr/share/nginx/html/lsurveymaster/index.php(211): <strong>CApplication</strong>-><strong>run</strong>() </div>
<div class="code"><pre><span class="ln">206</span> die (sprintf('%s should be writable by the webserver (766 or 776).', $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)->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">
2016-04-19 18:07:17 nginx/1.4.6 <a href="http://www.yiiframework.com/">Yii Framework</a>/1.1.17 </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
(Time: 0.31795s,
Memory: 5,242KB)
</th>
</tr>
<tr style="background-color: #ccc;">
<th>Procedure</th>
<th>Count</th>
<th>Total (s)</th>
<th>Avg. (s)</th>
<th>Min. (s)</th>
<th>Max. (s)</th>
</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 > 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='surveys', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00270</td>
<td align="center">0.00270</td>
<td align="center">0.00270</td>
<td align="center">0.00270</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 > 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='settings_global', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00263</td>
<td align="center">0.00263</td>
<td align="center">0.00263</td>
<td align="center">0.00263</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT "questions".*, "q"."qid" AS "sqid", "q"."title" AS "sqtitle", "q"."question" AS "sqquestion", "groups".*
FROM "questions"
LEFT JOIN "questions" "q" ON q.parent_qid = questions.qid AND q.language = questions.language
JOIN "groups" ON groups.gid = questions.gid AND questions.language = groups.language
WHERE (questions.sid = :iSurveyID AND questions.language = :sLanguage AND questions.parent_qid = 0) AND (questions.type = 'T' OR questions.type = 'Q' OR questions.type = 'T' OR questions.type = 'S'). Bound with :iSurveyID='821877', :sLanguage='en')</td>
<td align="center">1</td>
<td align="center">0.00253</td>
<td align="center">0.00253</td>
<td align="center">0.00253</td>
<td align="center">0.00253</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='surveys_languagesettings', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00249</td>
<td align="center">0.00249</td>
<td align="center">0.00249</td>
<td align="center">0.00249</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='templates', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00234</td>
<td align="center">0.00234</td>
<td align="center">0.00234</td>
<td align="center">0.00234</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='permissions', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00234</td>
<td align="center">0.00234</td>
<td align="center">0.00234</td>
<td align="center">0.00234</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='surveys', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00232</td>
<td align="center">0.00232</td>
<td align="center">0.00232</td>
<td align="center">0.00232</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='plugins', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00229</td>
<td align="center">0.00229</td>
<td align="center">0.00229</td>
<td align="center">0.00229</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='questions', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00229</td>
<td align="center">0.00229</td>
<td align="center">0.00229</td>
<td align="center">0.00229</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='plugin_settings', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00225</td>
<td align="center">0.00225</td>
<td align="center">0.00225</td>
<td align="center">0.00225</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='settings_global', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00203</td>
<td align="center">0.00203</td>
<td align="center">0.00203</td>
<td align="center">0.00203</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 > 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='surveys_languagesettings', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00196</td>
<td align="center">0.00196</td>
<td align="center">0.00196</td>
<td align="center">0.00196</td>
</tr> <tr style="background:#FFFFFF">
<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 "surveys_languagesettings" "t" LEFT OUTER JOIN "surveys" "survey" ON (t.surveyls_survey_id = survey.sid) WHERE ("t"."surveyls_survey_id"=821877 AND "t"."surveyls_language"='en'))</td>
<td align="center">1</td>
<td align="center">0.00187</td>
<td align="center">0.00187</td>
<td align="center">0.00187</td>
<td align="center">0.00187</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 > 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='questions', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00175</td>
<td align="center">0.00175</td>
<td align="center">0.00175</td>
<td align="center">0.00175</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 > 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='permissions', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00157</td>
<td align="center">0.00157</td>
<td align="center">0.00157</td>
<td align="center">0.00157</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 > 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='plugins', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00154</td>
<td align="center">0.00154</td>
<td align="center">0.00154</td>
<td align="center">0.00154</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 > 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='templates', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00152</td>
<td align="center">0.00152</td>
<td align="center">0.00152</td>
<td align="center">0.00152</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 > 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='plugin_settings', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00140</td>
<td align="center">0.00140</td>
<td align="center">0.00140</td>
<td align="center">0.00140</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT "t"."sid" AS "t0_c0", "t"."owner_id" AS "t0_c1", "t"."admin" AS "t0_c2", "t"."active" AS "t0_c3", "t"."expires" AS "t0_c4", "t"."startdate" AS "t0_c5", "t"."adminemail" AS "t0_c6", "t"."anonymized" AS "t0_c7", "t"."faxto" AS "t0_c8", "t"."format" AS "t0_c9", "t"."savetimings" AS "t0_c10", "t"."template" AS "t0_c11", "t"."language" AS "t0_c12", "t"."additional_languages" AS "t0_c13", "t"."datestamp" AS "t0_c14", "t"."usecookie" AS "t0_c15", "t"."allowregister" AS "t0_c16", "t"."allowsave" AS "t0_c17", "t"."autonumber_start" AS "t0_c18", "t"."autoredirect" AS "t0_c19", "t"."allowprev" AS "t0_c20", "t"."printanswers" AS "t0_c21", "t"."ipaddr" AS "t0_c22", "t"."refurl" AS "t0_c23", "t"."datecreated" AS "t0_c24", "t"."publicstatistics" AS "t0_c25", "t"."publicgraphs" AS "t0_c26", "t"."listpublic" AS "t0_c27", "t"."htmlemail" AS "t0_c28", "t"."sendconfirmation" AS "t0_c29", "t"."tokenanswerspersistence" AS "t0_c30", "t"."assessments" AS "t0_c31", "t"."usecaptcha" AS "t0_c32", "t"."usetokens" AS "t0_c33", "t"."bounce_email" AS "t0_c34", "t"."attributedescriptions" AS "t0_c35", "t"."emailresponseto" AS "t0_c36", "t"."emailnotificationto" AS "t0_c37", "t"."tokenlength" AS "t0_c38", "t"."showxquestions" AS "t0_c39", "t"."showgroupinfo" AS "t0_c40", "t"."shownoanswer" AS "t0_c41", "t"."showqnumcode" AS "t0_c42", "t"."bouncetime" AS "t0_c43", "t"."bounceprocessing" AS "t0_c44", "t"."bounceaccounttype" AS "t0_c45", "t"."bounceaccounthost" AS "t0_c46", "t"."bounceaccountpass" AS "t0_c47", "t"."bounceaccountencryption" AS "t0_c48", "t"."bounceaccountuser" AS "t0_c49", "t"."showwelcome" AS "t0_c50", "t"."showprogress" AS "t0_c51", "t"."questionindex" AS "t0_c52", "t"."navigationdelay" AS "t0_c53", "t"."nokeyboard" AS "t0_c54", "t"."alloweditaftercompletion" AS "t0_c55", "t"."googleanalyticsstyle" AS "t0_c56", "t"."googleanalyticsapikey" AS "t0_c57", "languagesettings"."surveyls_survey_id" AS "t1_c0", "languagesettings"."surveyls_language" AS "t1_c1", "languagesettings"."surveyls_title" AS "t1_c2", "languagesettings"."surveyls_description" AS "t1_c3", "languagesettings"."surveyls_welcometext" AS "t1_c4", "languagesettings"."surveyls_endtext" AS "t1_c5", "languagesettings"."surveyls_url" AS "t1_c6", "languagesettings"."surveyls_urldescription" AS "t1_c7", "languagesettings"."surveyls_email_invite_subj" AS "t1_c8", "languagesettings"."surveyls_email_invite" AS "t1_c9", "languagesettings"."surveyls_email_remind_subj" AS "t1_c10", "languagesettings"."surveyls_email_remind" AS "t1_c11", "languagesettings"."surveyls_email_register_subj" AS "t1_c12", "languagesettings"."surveyls_email_register" AS "t1_c13", "languagesettings"."surveyls_email_confirm_subj" AS "t1_c14", "languagesettings"."surveyls_email_confirm" AS "t1_c15", "languagesettings"."surveyls_dateformat" AS "t1_c16", "languagesettings"."surveyls_attributecaptions" AS "t1_c17", "languagesettings"."email_admin_notification_subj" AS "t1_c18", "languagesettings"."email_admin_notification" AS "t1_c19", "languagesettings"."email_admin_responses_subj" AS "t1_c20", "languagesettings"."email_admin_responses" AS "t1_c21", "languagesettings"."surveyls_numberformat" AS "t1_c22", "languagesettings"."attachments" AS "t1_c23" FROM "surveys" "t" LEFT OUTER JOIN "surveys_languagesettings" "languagesettings" ON ("languagesettings"."surveyls_survey_id"="t"."sid") WHERE (sid = :surveyid) AND (surveyls_language=language). Bound with :surveyid=821877)</td>
<td align="center">1</td>
<td align="center">0.00139</td>
<td align="center">0.00139</td>
<td align="center">0.00139</td>
<td align="center">0.00139</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT * FROM "surveys" "t" WHERE "t"."sid"=821877 LIMIT 1)</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 * FROM "permissions" "t" WHERE "t"."entity_id"=:yp0 AND "t"."entity"=:yp1 AND "t"."uid"=:yp2 AND "t"."permission"=:yp3 LIMIT 1. Bound with :yp0=0, :yp1='global', :yp2=1, :yp3='superadmin')</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:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT * FROM users ORDER BY uid)</td>
<td align="center">1</td>
<td align="center">0.00112</td>
<td align="center">0.00112</td>
<td align="center">0.00112</td>
<td align="center">0.00112</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT * FROM "surveys_languagesettings" "t" WHERE "t"."surveyls_survey_id"=821877 AND "t"."surveyls_language"='en' LIMIT 1)</td>
<td align="center">1</td>
<td align="center">0.00098</td>
<td align="center">0.00098</td>
<td align="center">0.00098</td>
<td align="center">0.00098</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT * FROM "settings_global" "t")</td>
<td align="center">1</td>
<td align="center">0.00085</td>
<td align="center">0.00085</td>
<td align="center">0.00085</td>
<td align="center">0.00085</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, 2). Bound with :table='surveys_languagesettings', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00079</td>
<td align="center">0.00079</td>
<td align="center">0.00079</td>
<td align="center">0.00079</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT "defaultlanguage"."surveyls_survey_id" AS "t1_c0", "defaultlanguage"."surveyls_language" AS "t1_c1", "defaultlanguage"."surveyls_title" AS "t1_c2", "defaultlanguage"."surveyls_description" AS "t1_c3", "defaultlanguage"."surveyls_welcometext" AS "t1_c4", "defaultlanguage"."surveyls_endtext" AS "t1_c5", "defaultlanguage"."surveyls_url" AS "t1_c6", "defaultlanguage"."surveyls_urldescription" AS "t1_c7", "defaultlanguage"."surveyls_email_invite_subj" AS "t1_c8", "defaultlanguage"."surveyls_email_invite" AS "t1_c9", "defaultlanguage"."surveyls_email_remind_subj" AS "t1_c10", "defaultlanguage"."surveyls_email_remind" AS "t1_c11", "defaultlanguage"."surveyls_email_register_subj" AS "t1_c12", "defaultlanguage"."surveyls_email_register" AS "t1_c13", "defaultlanguage"."surveyls_email_confirm_subj" AS "t1_c14", "defaultlanguage"."surveyls_email_confirm" AS "t1_c15", "defaultlanguage"."surveyls_dateformat" AS "t1_c16", "defaultlanguage"."surveyls_attributecaptions" AS "t1_c17", "defaultlanguage"."email_admin_notification_subj" AS "t1_c18", "defaultlanguage"."email_admin_notification" AS "t1_c19", "defaultlanguage"."email_admin_responses_subj" AS "t1_c20", "defaultlanguage"."email_admin_responses" AS "t1_c21", "defaultlanguage"."surveyls_numberformat" AS "t1_c22", "defaultlanguage"."attachments" AS "t1_c23" FROM "surveys_languagesettings" "defaultlanguage" WHERE ("defaultlanguage"."surveyls_language"=:ypl0) AND ("defaultlanguage"."surveyls_survey_id"=:ypl1). Bound with :ypl0='en', :ypl1=821877)</td>
<td align="center">1</td>
<td align="center">0.00074</td>
<td align="center">0.00074</td>
<td align="center">0.00074</td>
<td align="center">0.00074</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, 13). Bound with :table='questions', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00074</td>
<td align="center">0.00074</td>
<td align="center">0.00074</td>
<td align="center">0.00074</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT * FROM "plugin_settings" "t" WHERE "t"."plugin_id"=:yp0 AND "t"."model"=:yp1 AND "t"."model_id"=:yp2 AND "t"."key"=:yp3. Bound with :yp0=2, :yp1='Survey', :yp2='821877', :yp3='auditing')</td>
<td align="center">1</td>
<td align="center">0.00069</td>
<td align="center">0.00069</td>
<td align="center">0.00069</td>
<td align="center">0.00069</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='permissions', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00068</td>
<td align="center">0.00068</td>
<td align="center">0.00068</td>
<td align="center">0.00068</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='plugins', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00065</td>
<td align="center">0.00065</td>
<td align="center">0.00065</td>
<td align="center">0.00065</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='plugin_settings', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00061</td>
<td align="center">0.00061</td>
<td align="center">0.00061</td>
<td align="center">0.00061</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='surveys', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00059</td>
<td align="center">0.00059</td>
<td align="center">0.00059</td>
<td align="center">0.00059</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='templates', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00059</td>
<td align="center">0.00059</td>
<td align="center">0.00059</td>
<td align="center">0.00059</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT * FROM "plugins" "t" WHERE "t"."active"=:yp0. Bound with :yp0=1)</td>
<td align="center">1</td>
<td align="center">0.00058</td>
<td align="center">0.00058</td>
<td align="center">0.00058</td>
<td align="center">0.00058</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='settings_global', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00043</td>
<td align="center">0.00043</td>
<td align="center">0.00043</td>
<td align="center">0.00043</td>
</tr></tbody></table>
<!-- end of profiling summary --></body></html> | ||||
| Bug heat | 2 | ||||
| Complete LimeSurvey version number (& build) | bc83888f74acfca03d8a77a67161 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | NA | ||||
| Database type & version | postgresql 9.3 | ||||
| Server OS (if known) | Ubuntu 14.04 | ||||
| Webserver software & version (if known) | nginx 1.4.6 | ||||
| PHP Version | 5.5.9 | ||||
| Git branch / Pull Request URL | |||||
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=18649 |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-04-19 18:12 | aesteban | New Issue | |
| 2016-04-19 18:12 | aesteban | File Added: PHP notice.html | |
| 2016-04-20 09:47 | c_schmitz | Changeset attached | => LimeSurvey master bc49cb81 |
| 2016-04-20 09:47 | c_schmitz | Note Added: 37570 | |
| 2016-04-20 09:47 | c_schmitz | Assigned To | => c_schmitz |
| 2016-04-20 09:47 | c_schmitz | Resolution | open => fixed |
| 2016-04-20 09:47 | c_schmitz | Status | new => closed |
| 2016-04-20 09:47 | c_schmitz | Fixed in Version | => 2.5 |
| 2019-11-01 17:25 | c_schmitz | Category | Survey design => Survey editing |