10984: Crash when accessing general settings - LimeSurvey bugs and feature requests

This bug affects 1 person(s).

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 2.- Click on "Survey Properties" -> "General Settings" 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> PHP notice.html (50,891 bytes)

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

User List	There are no users monitoring this issue.

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

LimeSurvey: master bc49cb81 2016-04-20 09:47 c_schmitz Details Diff	Dev Fixes 10984: Crash when accessing general settings		Affected Issues 10984
	mod - application/controllers/admin/surveyadmin.php		Diff File

View Issue Details

Users monitoring this issue

Activities

Related Changesets

Issue History

c_schmitz 2016-04-20 09:47 administrator ~37570	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=18649