View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 09503 | Bug reports | Plugins | public | 2015-02-08 05:17 | 2015-02-11 15:57 |
| Reporter | aesteban | Assigned To | sammousa | ||
| Priority | normal | Severity | block | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 2.06+ | ||||
| Target Version | 2.06+ | ||||
| Summary | 09503: Crash when entering plugins list [degug = 2] | ||||
| Description | Crash when entering plugins list | ||||
| Steps To Reproduce | Click on plugin button from main administration menu Result: Application crashes | ||||
| Additional Information | Undefined variable (see attached file) | ||||
| Tags | No tags attached. | ||||
| Attached Files | PHP notice-error comentario incompleto.html (60,097 bytes)
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!-- saved from url=(0045)http://localhost/limesurvey/index.php/plugins -->
<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: cacheKey </p>
<div class="source">
<p class="file">/usr/share/nginx/html/limesurvey/application/libraries/PluginManager/PluginManager.php(228)</p>
<div class="code"><pre><span class="ln">216</span> // Check if the base plugin file exists.
<span class="ln">217</span> // Directory name Example most contain file ExamplePlugin.php.
<span class="ln">218</span> $pluginName = $fileInfo->getFilename();
<span class="ln">219</span> $file = Yii::getPathOfAlias($pluginDir . ".$pluginName.{$pluginName}") . ".php";
<span class="ln">220</span> if (file_exists($file))
<span class="ln">221</span> {
<span class="ln">222</span> $result[$pluginName] = $this->getPluginInfo($pluginName, $pluginDir);
<span class="ln">223</span> }
<span class="ln">224</span> }
<span class="ln">225</span>
<span class="ln">226</span> }
<span class="ln">227</span> }
<span class="error"><span class="ln error-ln">228</span> \Yii::app()->cache->set($cacheKey, $plugins, 3600);
</span><span class="ln">229</span> }
<span class="ln">230</span>
<span class="ln">231</span> return $result;
<span class="ln">232</span> }
<span class="ln">233</span>
<span class="ln">234</span> /**
<span class="ln">235</span> * Gets the description of a plugin. The description is accessed via a
<span class="ln">236</span> * static function inside the plugin file.
<span class="ln">237</span> *
<span class="ln">238</span> * @param string $pluginClass The classname of the plugin
<span class="ln">239</span> */
<span class="ln">240</span> public function getPluginInfo($pluginClass, $pluginDir = null)
</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>
/usr/share/nginx/html/limesurvey/application/controllers/PluginsController.php(168): <strong>ls\pluginmanager\PluginManager</strong>-><strong>scanPlugins</strong>() </div>
<div class="code"><pre><span class="ln">163</span> public function actionIndex()
<span class="ln">164</span> {
<span class="ln">165</span> $oPluginManager = App()->getPluginManager();
<span class="ln">166</span>
<span class="ln">167</span> // Scan the plugins folder.
<span class="error"><span class="ln error-ln">168</span> $aDiscoveredPlugins = $oPluginManager->scanPlugins();
</span><span class="ln">169</span> $aInstalledPlugins = $oPluginManager->getInstalledPlugins();
<span class="ln">170</span> $aInstalledNames = array_map(function ($installedPlugin) {
<span class="ln">171</span> return $installedPlugin->name;
<span class="ln">172</span> }, $aInstalledPlugins);
<span class="ln">173</span>
</pre></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/limesurvey/framework/web/actions/CInlineAction.php(49): <strong>PluginsController</strong>-><strong>actionIndex</strong>() </div>
<div class="code"><pre><span class="ln">44</span> $controller=$this->getController();
<span class="ln">45</span> $method=new ReflectionMethod($controller, $methodName);
<span class="ln">46</span> if($method->getNumberOfParameters()>0)
<span class="ln">47</span> return $this->runWithParamsInternal($controller, $method, $params);
<span class="ln">48</span> else
<span class="error"><span class="ln error-ln">49</span> return $controller->$methodName();
</span><span class="ln">50</span> }
<span class="ln">51</span>
<span class="ln">52</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>
/usr/share/nginx/html/limesurvey/framework/web/CController.php(308): <strong>CInlineAction</strong>-><strong>runWithParams</strong>(array("q" => "/limesurvey/index.php/plugins")) </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">
#3 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/usr/share/nginx/html/limesurvey/framework/web/filters/CFilterChain.php(133): <strong>CController</strong>-><strong>runAction</strong>(CInlineAction) </div>
<div class="code"><pre><span class="ln">128</span> $filter=$this->itemAt($this->filterIndex++);
<span class="ln">129</span> Yii::trace('Running filter '.($filter instanceof CInlineFilter ? get_class($this->controller).'.filter'.$filter->name.'()':get_class($filter).'.filter()'),'system.web.filters.CFilterChain');
<span class="ln">130</span> $filter->filter($this);
<span class="ln">131</span> }
<span class="ln">132</span> else
<span class="error"><span class="ln error-ln">133</span> $this->controller->runAction($this->action);
</span><span class="ln">134</span> }
<span class="ln">135</span> }</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/limesurvey/framework/web/filters/CFilter.php(40): <strong>CFilterChain</strong>-><strong>run</strong>() </div>
<div class="code"><pre><span class="ln">35</span> */
<span class="ln">36</span> public function filter($filterChain)
<span class="ln">37</span> {
<span class="ln">38</span> if($this->preFilter($filterChain))
<span class="ln">39</span> {
<span class="error"><span class="ln error-ln">40</span> $filterChain->run();
</span><span class="ln">41</span> $this->postFilter($filterChain);
<span class="ln">42</span> }
<span class="ln">43</span> }
<span class="ln">44</span>
<span class="ln">45</span> /**
</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/limesurvey/framework/web/CController.php(1145): <strong>CFilter</strong>-><strong>filter</strong>(CFilterChain) </div>
<div class="code"><pre><span class="ln">1140</span> */
<span class="ln">1141</span> public function filterAccessControl($filterChain)
<span class="ln">1142</span> {
<span class="ln">1143</span> $filter=new CAccessControlFilter;
<span class="ln">1144</span> $filter->setRules($this->accessRules());
<span class="error"><span class="ln error-ln">1145</span> $filter->filter($filterChain);
</span><span class="ln">1146</span> }
<span class="ln">1147</span>
<span class="ln">1148</span> /**
<span class="ln">1149</span> * Returns a persistent page state value.
<span class="ln">1150</span> * A page state is a variable that is persistent across POST requests of the same page.
</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>
/usr/share/nginx/html/limesurvey/framework/web/filters/CInlineFilter.php(58): <strong>CController</strong>-><strong>filterAccessControl</strong>(CFilterChain) </div>
<div class="code"><pre><span class="ln">53</span> * @param CFilterChain $filterChain the filter chain that the filter is on.
<span class="ln">54</span> */
<span class="ln">55</span> public function filter($filterChain)
<span class="ln">56</span> {
<span class="ln">57</span> $method='filter'.$this->name;
<span class="error"><span class="ln error-ln">58</span> $filterChain->controller->$method($filterChain);
</span><span class="ln">59</span> }
<span class="ln">60</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/limesurvey/framework/web/filters/CFilterChain.php(130): <strong>CInlineFilter</strong>-><strong>filter</strong>(CFilterChain) </div>
<div class="code"><pre><span class="ln">125</span> {
<span class="ln">126</span> if($this->offsetExists($this->filterIndex))
<span class="ln">127</span> {
<span class="ln">128</span> $filter=$this->itemAt($this->filterIndex++);
<span class="ln">129</span> Yii::trace('Running filter '.($filter instanceof CInlineFilter ? get_class($this->controller).'.filter'.$filter->name.'()':get_class($filter).'.filter()'),'system.web.filters.CFilterChain');
<span class="error"><span class="ln error-ln">130</span> $filter->filter($this);
</span><span class="ln">131</span> }
<span class="ln">132</span> else
<span class="ln">133</span> $this->controller->runAction($this->action);
<span class="ln">134</span> }
<span class="ln">135</span> }</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/limesurvey/framework/web/CController.php(291): <strong>CFilterChain</strong>-><strong>run</strong>() </div>
<div class="code"><pre><span class="ln">286</span> $this->runAction($action);
<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="error"><span class="ln error-ln">291</span> CFilterChain::create($this,$action,$filters)->run();
</span><span class="ln">292</span> $this->_action=$priorAction;
<span class="ln">293</span> }
<span class="ln">294</span> }
<span class="ln">295</span>
<span class="ln">296</span> /**
</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/limesurvey/framework/web/CController.php(265): <strong>CController</strong>-><strong>runActionWithFilters</strong>(CInlineAction, array("accessControl")) </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 core collapsed">
<td class="number">
#10 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/usr/share/nginx/html/limesurvey/framework/web/CWebApplication.php(282): <strong>CController</strong>-><strong>run</strong>("") </div>
<div class="code"><pre><span class="ln">277</span> {
<span class="ln">278</span> list($controller,$actionID)=$ca;
<span class="ln">279</span> $oldController=$this->_controller;
<span class="ln">280</span> $this->_controller=$controller;
<span class="ln">281</span> $controller->init();
<span class="error"><span class="ln error-ln">282</span> $controller->run($actionID);
</span><span class="ln">283</span> $this->_controller=$oldController;
<span class="ln">284</span> }
<span class="ln">285</span> else
<span class="ln">286</span> throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".',
<span class="ln">287</span> array('{route}'=>$route===''?$this->defaultController:$route)));
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#11 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/usr/share/nginx/html/limesurvey/framework/web/CWebApplication.php(141): <strong>CWebApplication</strong>-><strong>runController</strong>("plugins") </div>
<div class="code"><pre><span class="ln">136</span> foreach(array_splice($this->catchAllRequest,1) as $name=>$value)
<span class="ln">137</span> $_GET[$name]=$value;
<span class="ln">138</span> }
<span class="ln">139</span> else
<span class="ln">140</span> $route=$this->getUrlManager()->parseUrl($this->getRequest());
<span class="error"><span class="ln error-ln">141</span> $this->runController($route);
</span><span class="ln">142</span> }
<span class="ln">143</span>
<span class="ln">144</span> /**
<span class="ln">145</span> * Registers the core application components.
<span class="ln">146</span> * This method overrides the parent implementation by registering additional core components.
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#12 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/usr/share/nginx/html/limesurvey/framework/base/CApplication.php(180): <strong>CWebApplication</strong>-><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->hasEventHandler('onBeginRequest'))
<span class="ln">178</span> $this->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->processRequest();
</span><span class="ln">181</span> if($this->hasEventHandler('onEndRequest'))
<span class="ln">182</span> $this->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">
#13 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/usr/share/nginx/html/limesurvey/index.php(208): <strong>CApplication</strong>-><strong>run</strong>() </div>
<div class="code"><pre><span class="ln">203</span> die (sprintf('%s should be writable by the webserver (755 or 775).', $runtimePath));
<span class="ln">204</span> }
<span class="ln">205</span> }
<span class="ln">206</span>
<span class="ln">207</span>
<span class="error"><span class="ln error-ln">208</span> Yii::createApplication('LSYii_Application', $config)->run();
</span><span class="ln">209</span>
<span class="ln">210</span> /* End of file index.php */
<span class="ln">211</span> /* Location: ./index.php */
</pre></div> </td>
</tr>
</tbody></table>
</div>
<div class="version">
2015-02-08 05:08:04 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 log messages -->
<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="5">
Application Log
</th>
</tr>
<tr style="background-color: #ccc;">
<th style="width:120px">Timestamp</th>
<th>Level</th>
<th>Category</th>
<th>Message</th>
</tr>
<tr style="background:#FFFFFF">
<td align="center">05:08:04.138859</td>
<td>trace</td>
<td>system.CModule</td>
<td><pre>Loading "log" application component</pre></td>
</tr> <tr style="background:#F5F5F5">
<td align="center">05:08:04.140333</td>
<td>trace</td>
<td>system.CModule</td>
<td><pre>Loading "request" application component</pre></td>
</tr> <tr style="background:#FFFFFF">
<td align="center">05:08:04.144978</td>
<td>trace</td>
<td>system.CModule</td>
<td><pre>Loading "assetManager" application component</pre></td>
</tr> <tr style="background:#F5F5F5">
<td align="center">05:08:04.146481</td>
<td>trace</td>
<td>system.CModule</td>
<td><pre>Loading "urlManager" application component</pre></td>
</tr> <tr style="background:#FFFFFF">
<td align="center">05:08:04.146970</td>
<td>trace</td>
<td>system.CModule</td>
<td><pre>Loading "cache" application component</pre></td>
</tr> <tr style="background:#F5F5F5">
<td align="center">05:08:04.163578</td>
<td>trace</td>
<td>system.CModule</td>
<td><pre>Loading "session" application component</pre></td>
</tr> <tr style="background:#FFFFFF">
<td align="center">05:08:04.165750</td>
<td>trace</td>
<td>system.CModule</td>
<td><pre>Loading "db" application component</pre></td>
</tr> <tr style="background:#F5F5F5">
<td align="center">05:08:04.166285</td>
<td>trace</td>
<td>system.db.CDbConnection</td>
<td><pre>Opening DB connection</pre></td>
</tr> <tr style="background:#FFFFFF">
<td align="center">05:08:04.190495</td>
<td>trace</td>
<td>system.db.CDbCommand</td>
<td><pre>Querying SQL: 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='lime_settings_global',
:schema='public'</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.190577</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>begin: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='lime_settings_global',
:schema='public')</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.196615</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>end: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='lime_settings_global',
:schema='public')</pre></td>
</tr> <tr style="background:#F5F5F5">
<td align="center">05:08:04.198664</td>
<td>trace</td>
<td>system.db.CDbCommand</td>
<td><pre>Querying SQL: 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'</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.198760</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>begin: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')</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.202632</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>end: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')</pre></td>
</tr> <tr style="background:#FFFFFF">
<td align="center">05:08:04.203656</td>
<td>trace</td>
<td>system.db.CDbCommand</td>
<td><pre>Querying SQL: 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'</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.203766</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>begin: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')</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.205034</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>end: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')</pre></td>
</tr> <tr style="background:#F5F5F5">
<td align="center">05:08:04.213937</td>
<td>trace</td>
<td>system.db.ar.CActiveRecord</td>
<td><pre>SettingGlobal.findAll()</pre></td>
</tr> <tr style="background:#FFFFFF">
<td align="center">05:08:04.216587</td>
<td>trace</td>
<td>system.db.CDbCommand</td>
<td><pre>Querying SQL: SELECT * FROM "lime_settings_global" "t"</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.216659</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>begin:system.db.CDbCommand.query(SELECT * FROM "lime_settings_global" "t")</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.217608</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>end:system.db.CDbCommand.query(SELECT * FROM "lime_settings_global" "t")</pre></td>
</tr> <tr style="background:#F5F5F5">
<td align="center">05:08:04.329250</td>
<td>trace</td>
<td>system.CModule</td>
<td><pre>Loading "bootstrap" application component</pre></td>
</tr> <tr style="background:#FFFFFF">
<td align="center">05:08:04.329921</td>
<td>trace</td>
<td>system.CModule</td>
<td><pre>Loading "clientScript" application component</pre></td>
</tr> <tr style="background:#F5F5F5">
<td align="center">05:08:04.360784</td>
<td>trace</td>
<td>system.web.filters.CFilterChain</td>
<td><pre>Running filter PluginsController.filteraccessControl()</pre></td>
</tr> <tr style="background:#FFFFFF">
<td align="center">05:08:04.366609</td>
<td>trace</td>
<td>system.CModule</td>
<td><pre>Loading "user" application component</pre></td>
</tr> <tr style="background:#F5F5F5">
<td align="center">05:08:04.368565</td>
<td>trace</td>
<td>system.CModule</td>
<td><pre>Loading "messages" application component</pre></td>
</tr> <tr style="background:#FFFFFF">
<td align="center">05:08:04.370666</td>
<td>trace</td>
<td>system.db.CDbCommand</td>
<td><pre>Querying SQL: 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='lime_permissions', :schema='public'</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.370734</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>begin: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='lime_permissions', :schema='public')</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.374066</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>end: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='lime_permissions', :schema='public')</pre></td>
</tr> <tr style="background:#F5F5F5">
<td align="center">05:08:04.377079</td>
<td>trace</td>
<td>system.db.CDbCommand</td>
<td><pre>Querying SQL: 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'</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.377155</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>begin: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')</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.381748</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>end: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')</pre></td>
</tr> <tr style="background:#FFFFFF">
<td align="center">05:08:04.382252</td>
<td>trace</td>
<td>system.db.CDbCommand</td>
<td><pre>Querying SQL: 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'</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.382328</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>begin: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')</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.383656</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>end: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')</pre></td>
</tr> <tr style="background:#F5F5F5">
<td align="center">05:08:04.386487</td>
<td>trace</td>
<td>system.CModule</td>
<td><pre>Loading "pluginManager" application component</pre></td>
</tr> <tr style="background:#FFFFFF">
<td align="center">05:08:04.387881</td>
<td>trace</td>
<td>system.db.ar.CActiveRecord</td>
<td><pre>Plugin.findAllByAttributes()</pre></td>
</tr> <tr style="background:#F5F5F5">
<td align="center">05:08:04.389589</td>
<td>trace</td>
<td>system.db.CDbCommand</td>
<td><pre>Querying SQL: 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='lime_plugins', :schema='public'</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.389719</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>begin: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='lime_plugins', :schema='public')</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.392539</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>end: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='lime_plugins', :schema='public')</pre></td>
</tr> <tr style="background:#FFFFFF">
<td align="center">05:08:04.394867</td>
<td>trace</td>
<td>system.db.CDbCommand</td>
<td><pre>Querying SQL: 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'</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.394993</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>begin: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')</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.399656</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>end: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')</pre></td>
</tr> <tr style="background:#F5F5F5">
<td align="center">05:08:04.400624</td>
<td>trace</td>
<td>system.db.CDbCommand</td>
<td><pre>Querying SQL: 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'</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.400749</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>begin: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')</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.402339</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>end: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')</pre></td>
</tr> <tr style="background:#FFFFFF">
<td align="center">05:08:04.404736</td>
<td>trace</td>
<td>system.db.CDbCommand</td>
<td><pre>Querying SQL: SELECT * FROM "lime_plugins" "t" WHERE "t"."active"=:yp0.
Bound with :yp0=1</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.404848</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>begin:system.db.CDbCommand.query(SELECT * FROM "lime_plugins" "t" WHERE
"t"."active"=:yp0. Bound with :yp0=1)</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.406088</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>end:system.db.CDbCommand.query(SELECT * FROM "lime_plugins" "t" WHERE
"t"."active"=:yp0. Bound with :yp0=1)</pre></td>
</tr> <tr style="background:#F5F5F5">
<td align="center">05:08:04.409722</td>
<td>trace</td>
<td>system.db.ar.CActiveRecord</td>
<td><pre>Permission.findByAttributes()</pre></td>
</tr> <tr style="background:#FFFFFF">
<td align="center">05:08:04.411518</td>
<td>trace</td>
<td>system.db.CDbCommand</td>
<td><pre>Querying SQL: SELECT * FROM "lime_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'</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.411597</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>begin:system.db.CDbCommand.query(SELECT * FROM "lime_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')</pre></td>
</tr> <tr style="background:#DFFFE0">
<td align="center">05:08:04.413904</td>
<td>profile</td>
<td>system.db.CDbCommand.query</td>
<td><pre>end:system.db.CDbCommand.query(SELECT * FROM "lime_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')</pre></td>
</tr> <tr style="background:#FFC0CB">
<td align="center">05:08:04.432420</td>
<td>error</td>
<td>php</td>
<td><pre>Undefined variable: cacheKey
(/usr/share/nginx/html/limesurvey/application/libraries/PluginManager/PluginManager.php:228)
Stack trace:
#0 /usr/share/nginx/html/limesurvey/framework/web/CController.php(308):
CInlineAction->runWithParams()
#1
/usr/share/nginx/html/limesurvey/framework/web/filters/CFilterChain.php(133):
PluginsController->runAction()
#2 /usr/share/nginx/html/limesurvey/framework/web/filters/CFilter.php(40):
CFilterChain->run()
#3 /usr/share/nginx/html/limesurvey/framework/web/CController.php(1145):
CAccessControlFilter->filter()
#4
/usr/share/nginx/html/limesurvey/framework/web/filters/CInlineFilter.php(58):
PluginsController->filterAccessControl()
#5
/usr/share/nginx/html/limesurvey/framework/web/filters/CFilterChain.php(130):
CInlineFilter->filter()
#6 /usr/share/nginx/html/limesurvey/framework/web/CController.php(291):
CFilterChain->run()
#7 /usr/share/nginx/html/limesurvey/framework/web/CController.php(265):
PluginsController->runActionWithFilters()
#8 /usr/share/nginx/html/limesurvey/framework/web/CWebApplication.php(282):
PluginsController->run()
#9 /usr/share/nginx/html/limesurvey/framework/web/CWebApplication.php(141):
LSYii_Application->runController()
#10 /usr/share/nginx/html/limesurvey/framework/base/CApplication.php(180):
LSYii_Application->processRequest()
#11 /usr/share/nginx/html/limesurvey/index.php(208):
LSYii_Application->run()
REQUEST_URI=/limesurvey/index.php/plugins</pre></td>
</tr> <tr style="background:#FFFFFF">
<td align="center">05:08:04.444602</td>
<td>trace</td>
<td>system.CModule</td>
<td><pre>Loading "errorHandler" application component</pre></td>
</tr></tbody></table>
<!-- end of log messages --><!-- 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: 0.36152s,
Memoria: 3,346KB)
</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 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='lime_settings_global', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00604</td>
<td align="center">0.00604</td>
<td align="center">0.00604</td>
<td align="center">0.00604</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.00466</td>
<td align="center">0.00466</td>
<td align="center">0.00466</td>
<td align="center">0.00466</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_permissions', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00459</td>
<td align="center">0.00459</td>
<td align="center">0.00459</td>
<td align="center">0.00459</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_settings_global', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00387</td>
<td align="center">0.00387</td>
<td align="center">0.00387</td>
<td align="center">0.00387</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='lime_permissions', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00333</td>
<td align="center">0.00333</td>
<td align="center">0.00333</td>
<td align="center">0.00333</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='lime_plugins', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00282</td>
<td align="center">0.00282</td>
<td align="center">0.00282</td>
<td align="center">0.00282</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT * FROM "lime_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.00231</td>
<td align="center">0.00231</td>
<td align="center">0.00231</td>
<td align="center">0.00231</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_plugins', :schema='public')</td>
<td align="center">1</td>
<td align="center">0.00159</td>
<td align="center">0.00159</td>
<td align="center">0.00159</td>
<td align="center">0.00159</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.00133</td>
<td align="center">0.00133</td>
<td align="center">0.00133</td>
<td align="center">0.00133</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_settings_global', :schema='public')</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 "lime_plugins" "t" WHERE "t"."active"=:yp0. Bound with :yp0=1)</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:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT * FROM "lime_settings_global" "t")</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></tbody></table>
<!-- end of profiling summary --></body></html> | ||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 2436a157dcfb92d302768ede1d65 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | not relevant | ||||
| Database type & version | not relevant | ||||
| Server OS (if known) | not relevant | ||||
| Webserver software & version (if known) | not relevant | ||||
| PHP Version | not relevant | ||||
|
Fix committed to 2.06 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=14918 |
|
|
commit b9593b6d2dc542f283de57d1b50345284c376990 |
|
|
Version 2.05 Build 150211 released |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-02-08 05:17 | aesteban | New Issue | |
| 2015-02-08 05:17 | aesteban | Status | new => assigned |
| 2015-02-08 05:17 | aesteban | Assigned To | => sammousa |
| 2015-02-08 05:17 | aesteban | File Added: PHP notice-error comentario incompleto.html | |
| 2015-02-08 05:26 | aesteban | Additional Information Updated | |
| 2015-02-08 05:53 | aesteban | Summary | Crash when entering plugins list => Crash when entering plugins list [degug = 2] |
| 2015-02-09 08:48 | sammousa | Changeset attached | => LimeSurvey 2.06 b9593b6d |
| 2015-02-09 08:48 | sammousa | Note Added: 31643 | |
| 2015-02-09 08:48 | sammousa | Resolution | open => fixed |
| 2015-02-09 08:48 | sammousa | Note Added: 31644 | |
| 2015-02-09 08:48 | sammousa | Status | assigned => resolved |
| 2015-02-11 15:57 | c_schmitz | Note Added: 31654 | |
| 2015-02-11 15:57 | c_schmitz | Status | resolved => closed |