View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 8
IDProjectCategoryView StatusDate SubmittedLast Update
13634Bug reportsUser / Groups / Rolespublic2018-04-25 11:092018-05-25 11:30
ReporterBZHNedr Assigned ToDenisChenu  
PrioritynoneSeverityfeature 
Status closedResolutionfixed 
Product Version3.7.x 
Fixed in Version3.7.x 
Summary13634: Internal Server Error CDbCommand failed to execute the SQL command: SQLSTATE [42000]: Syntax error or access violation: 1064
Description

Hello,
I just passed a LimeSurvey 2.0.5 in 3.7.0, I created the account of the manager, with which he created 3 accounts with only the rights on "Questionnaires" and when he wants to "Edit" one of these three user, he has the following message, in return:

Internal Server Error
CDbCommand failed to execute the SQL command: SQLSTATE [42000]: Syntax error or access violation: 1064 check the manual that fits your MariaDB server version for the right syntax to use near ')' at line 1
An internal error occurred when the web server was processing your request. Please contact the webmaster to report this problem.
Thank you.

Thinking that he did something wrong, I created a test account, through which I created the same user rights and got the same error message.

Steps To Reproduce
  • In admin, create a user with the rights of the screenshot number 3.
  • Creation of a user who can only post, with the account previously created, having the rights of the screenshot number 4.
  • Connect with the 1st account.
  • Open "Managed questionnaire administrators"
  • Click on the icon "Edit this user" of the second created account, see screenshot number 1.
  • We get the error message, screenshot number 2.
Additional Information

I can very well edit all users with my admin accounts

TagsNo tags attached.
Attached Files
LimeSurvey 3.7 bug 1.jpg (142,614 bytes)
LimeSurvey 3.7 bug 2.jpg (116,311 bytes)
LimeSurvey 3.7 bug 3.jpg (303,582 bytes)
LimeSurvey 3.7 bug 4.jpg (296,555 bytes)
Bug heat8
Complete LimeSurvey version number (& build)3.7.0+180418
I will donate to the project if issue is resolvedNo
BrowserFireFox 52.4.1 (32bits)
Database type & versionMariaDB
Server OS (if known)DEBIAN 8
Webserver software & version (if known)Apache 2.4
PHP Version5.6

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2018-04-25 14:45

developer   ~47519

Ok,

Sorry to didn't put this in formum can you activate debug mode : http://manual.limesurvey.org/Debug_Mode just before “Click on the icon "Edit this user"”

And then you can directly upload the HTML file produced. We have the file where this error happen and the line :)
guest

guest

2018-04-26 08:50

viewer   ~47537

Hello,
Here is the debug file.
Thank you.

CDbException.htm (22,644 bytes)    
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>CDbException</title>

<style type="text/css">
/*<![CDATA[*/
html,body,div,span,applet,object,iframe,h1,h2,h3,h4,h5,h6,p,blockquote,pre,a,abbr,acronym,address,big,cite,code,del,dfn,em,font,img,ins,kbd,q,s,samp,small,strike,strong,sub,sup,tt,var,b,u,i,center,dl,dt,dd,ol,ul,li,fieldset,form,label,legend,table,caption,tbody,tfoot,thead,tr,th,td{border:0;outline:0;font-size:100%;vertical-align:baseline;background:transparent;margin:0;padding:0;}
body{line-height:1;}
ol,ul{list-style:none;}
blockquote,q{quotes:none;}
blockquote:before,blockquote:after,q:before,q:after{content:none;}
:focus{outline:0;}
ins{text-decoration:none;}
del{text-decoration:line-through;}
table{border-collapse:collapse;border-spacing:0;}

body {
	font: normal 9pt "Verdana";
	color: #000;
	background: #fff;
}

h1 {
	font: normal 18pt "Verdana";
	color: #f00;
	margin-bottom: .5em;
}

h2 {
	font: normal 14pt "Verdana";
	color: #800000;
	margin-bottom: .5em;
}

h3 {
	font: bold 11pt "Verdana";
}

pre {
	font: normal 11pt Menlo, Consolas, "Lucida Console", Monospace;
}

pre span.error {
	display: block;
	background: #fce3e3;
}

pre span.ln {
	color: #999;
	padding-right: 0.5em;
	border-right: 1px solid #ccc;
}

pre span.error-ln {
	font-weight: bold;
}

.container {
	margin: 1em 4em;
}

.version {
	color: gray;
	font-size: 8pt;
	border-top: 1px solid #aaa;
	padding-top: 1em;
	margin-bottom: 1em;
}

.message {
	color: #000;
	padding: 1em;
	font-size: 11pt;
	background: #f3f3f3;
	-webkit-border-radius: 10px;
	-moz-border-radius: 10px;
	border-radius: 10px;
	margin-bottom: 1em;
	line-height: 160%;
}

.source {
	margin-bottom: 1em;
}

.code pre {
	background-color: #ffe;
	margin: 0.5em 0;
	padding: 0.5em;
	line-height: 125%;
	border: 1px solid #eee;
}

.source .file {
	margin-bottom: 1em;
	font-weight: bold;
}

.traces {
	margin: 2em 0;
}

.trace {
	margin: 0.5em 0;
	padding: 0.5em;
}

.trace.app {
	border: 1px dashed #c00;
}

.trace .number {
	text-align: right;
	width: 2em;
	padding: 0.5em;
}

.trace .content {
	padding: 0.5em;
}

.trace .plus,
.trace .minus {
	display:inline;
	vertical-align:middle;
	text-align:center;
	border:1px solid #000;
	color:#000;
	font-size:10px;
	line-height:10px;
	margin:0;
	padding:0 1px;
	width:10px;
	height:10px;
}

.trace.collapsed .minus,
.trace.expanded .plus,
.trace.collapsed pre {
	display: none;
}

.trace-file {
	cursor: pointer;
	padding: 0.2em;
}

.trace-file:hover {
	background: #f0ffff;
}
/*]]>*/
</style>
</head>

<body>
<div class="container">
	<h1>CDbException</h1>

	<p class="message">
		CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[42000]: 
Syntax error or access violation: 1064 You have an error in your SQL 
syntax; check the manual that corresponds to your MariaDB server version
 for the right syntax to use near ')' at line 1. The SQL statement 
executed was: SELECT COUNT(*) FROM `lime_users` `t` WHERE uid=:uid AND 
parent_id=:parent_id)	</p>

	<div class="source">
		<p class="file">/var/www/sondagesen/htmlpublic/framework/db/CDbCommand.php(543)</p>
		<div class="code"><pre><span class="ln">531</span>         {
<span class="ln">532</span>             if($this-&gt;_connection-&gt;enableProfiling)
<span class="ln">533</span>                 Yii::endProfile('system.db.CDbCommand.query('.$this-&gt;getText().$par.')','system.db.CDbCommand.query');
<span class="ln">534</span> 
<span class="ln">535</span>             $errorInfo=$e instanceof PDOException ? $e-&gt;errorInfo : null;
<span class="ln">536</span>             $message=$e-&gt;getMessage();
<span class="ln">537</span>             Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',
<span class="ln">538</span>                 array('{method}'=&gt;$method, '{error}'=&gt;$message, '{sql}'=&gt;$this-&gt;getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
<span class="ln">539</span> 
<span class="ln">540</span>             if(YII_DEBUG)
<span class="ln">541</span>                 $message.='. The SQL statement executed was: '.$this-&gt;getText().$par;
<span class="ln">542</span> 
<span class="error"><span class="ln error-ln">543</span>             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
</span><span class="ln">544</span>                 array('{error}'=&gt;$message)),(int)$e-&gt;getCode(),$errorInfo);
<span class="ln">545</span>         }
<span class="ln">546</span>     }
<span class="ln">547</span> 
<span class="ln">548</span>     /**
<span class="ln">549</span>      * Builds a SQL SELECT statement from the given query specification.
<span class="ln">550</span>      * @param array $query the query specification in name-value pairs. The following
<span class="ln">551</span>      * query options are supported: {@link select}, {@link distinct}, {@link from},
<span class="ln">552</span>      * {@link where}, {@link join}, {@link group}, {@link having}, {@link order},
<span class="ln">553</span>      * {@link limit}, {@link offset} and {@link union}.
<span class="ln">554</span>      * @throws CDbException if "from" key is not present in given query parameter
<span class="ln">555</span>      * @return string the SQL statement
</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">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/var/www/sondagesen/htmlpublic/framework/db/CDbCommand.php(433): <strong>CDbCommand</strong>-&gt;<strong>queryInternal</strong>("fetchColumn", 0, array())				</div>

				<div class="code"><pre><span class="ln">428</span>      * @return mixed the value of the first column in the first row of the query result. False is returned if there is no value.
<span class="ln">429</span>      * @throws CException execution failed
<span class="ln">430</span>      */
<span class="ln">431</span>     public function queryScalar($params=array())
<span class="ln">432</span>     {
<span class="error"><span class="ln error-ln">433</span>         $result=$this-&gt;queryInternal('fetchColumn',0,$params);
</span><span class="ln">434</span>         if(is_resource($result) &amp;&amp; get_resource_type($result)==='stream')
<span class="ln">435</span>             return stream_get_contents($result);
<span class="ln">436</span>         else
<span class="ln">437</span>             return $result;
<span class="ln">438</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>
										&nbsp;/var/www/sondagesen/htmlpublic/framework/db/ar/CActiveRecord.php(1609): <strong>CDbCommand</strong>-&gt;<strong>queryScalar</strong>()				</div>

				<div class="code"><pre><span class="ln">1604</span>         $builder=$this-&gt;getCommandBuilder();
<span class="ln">1605</span>         $criteria=$builder-&gt;createCriteria($condition,$params);
<span class="ln">1606</span>         $this-&gt;applyScopes($criteria);
<span class="ln">1607</span> 
<span class="ln">1608</span>         if(empty($criteria-&gt;with))
<span class="error"><span class="ln error-ln">1609</span>             return $builder-&gt;createCountCommand($this-&gt;getTableSchema(),$criteria)-&gt;queryScalar();
</span><span class="ln">1610</span>         else
<span class="ln">1611</span>         {
<span class="ln">1612</span>             $finder=$this-&gt;getActiveFinder($criteria-&gt;with);
<span class="ln">1613</span>             return $finder-&gt;count($criteria);
<span class="ln">1614</span>         }
</pre></div>			</td>
		</tr>
						<tr class="trace app expanded">
			<td class="number">
				#2			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/var/www/sondagesen/htmlpublic/application/controllers/admin/useraction.php(324): <strong>CActiveRecord</strong>-&gt;<strong>count</strong>("uid=:uid AND parent_id=:parent_id)", array(":uid" =&gt; 17, "parent_id" =&gt; 16))				</div>

				<div class="code"><pre><span class="ln">319</span>         if (Yii::app()-&gt;request-&gt;getParam('uid') != '') {
<span class="ln">320</span>             $postuserid = (int) Yii::app()-&gt;request-&gt;getParam("uid");
<span class="ln">321</span>             if (
<span class="ln">322</span>                 Permission::model()-&gt;hasGlobalPermission('superadmin', 'read') // Super admin have all right on user
<span class="ln">323</span>                 || Yii::app()-&gt;session['loginID'] == $postuserid // User can edit himself
<span class="error"><span class="ln error-ln">324</span>                 || (Permission::model()-&gt;hasGlobalPermission('users', 'update') &amp;&amp; User::model()-&gt;count("uid=:uid AND parent_id=:parent_id)", array(':uid' =&gt; $postuserid, 'parent_id' =&gt; Yii::app()-&gt;session['loginID']))) // User with users update can only update own Users
</span><span class="ln">325</span>             ) {
<span class="ln">326</span>                 $oUser = User::model()-&gt;findByPk($postuserid);
<span class="ln">327</span>                 $aData = array();
<span class="ln">328</span>                 $aData['oUser'] = $oUser;
<span class="ln">329</span> 
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#3			</td>
			<td class="content">
				<div class="trace-file">
										&nbsp;unknown(0): <strong>UserAction</strong>-&gt;<strong>modifyuser</strong>()				</div>

							</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#4			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/var/www/sondagesen/htmlpublic/framework/web/actions/CAction.php(109): <strong>ReflectionMethod</strong>-&gt;<strong>invokeArgs</strong>(UserAction, array())				</div>

				<div class="code"><pre><span class="ln">104</span>             elseif($param-&gt;isDefaultValueAvailable())
<span class="ln">105</span>                 $ps[]=$param-&gt;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-&gt;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">
				#5			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/var/www/sondagesen/htmlpublic/application/core/Survey_Common_Action.php(83): <strong>CAction</strong>-&gt;<strong>runWithParamsInternal</strong>(UserAction, ReflectionMethod, array("sa" =&gt; "modifyuser"))				</div>

				<div class="code"><pre><span class="ln">78</span>             $oMethod = new ReflectionMethod($this, $sDefault);
<span class="ln">79</span>         }
<span class="ln">80</span> 
<span class="ln">81</span>         // We're all good to go, let's execute it
<span class="ln">82</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">83</span>         return parent::runWithParamsInternal($this, $oMethod, $params);
</span><span class="ln">84</span>     }
<span class="ln">85</span> 
<span class="ln">86</span>     /**
<span class="ln">87</span>      * Some functions have different parameters, which are just an alias of the
<span class="ln">88</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">
				#6			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/var/www/sondagesen/htmlpublic/framework/web/CController.php(308): <strong>Survey_Common_Action</strong>-&gt;<strong>runWithParams</strong>(array("sa" =&gt; "modifyuser"))				</div>

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

				<div class="code"><pre><span class="ln">281</span>      * @see runAction
<span class="ln">282</span>      */
<span class="ln">283</span>     public function runActionWithFilters($action,$filters)
<span class="ln">284</span>     {
<span class="ln">285</span>         if(empty($filters))
<span class="error"><span class="ln error-ln">286</span>             $this-&gt;runAction($action);
</span><span class="ln">287</span>         else
<span class="ln">288</span>         {
<span class="ln">289</span>             $priorAction=$this-&gt;_action;
<span class="ln">290</span>             $this-&gt;_action=$action;
<span class="ln">291</span>             CFilterChain::create($this,$action,$filters)-&gt;run();
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#8			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/var/www/sondagesen/htmlpublic/framework/web/CController.php(265): <strong>CController</strong>-&gt;<strong>runActionWithFilters</strong>(UserAction, array())				</div>

				<div class="code"><pre><span class="ln">260</span>         {
<span class="ln">261</span>             if(($parent=$this-&gt;getModule())===null)
<span class="ln">262</span>                 $parent=Yii::app();
<span class="ln">263</span>             if($parent-&gt;beforeControllerAction($this,$action))
<span class="ln">264</span>             {
<span class="error"><span class="ln error-ln">265</span>                 $this-&gt;runActionWithFilters($action,$this-&gt;filters());
</span><span class="ln">266</span>                 $parent-&gt;afterControllerAction($this,$action);
<span class="ln">267</span>             }
<span class="ln">268</span>         }
<span class="ln">269</span>         else
<span class="ln">270</span>             $this-&gt;missingAction($actionID);
</pre></div>			</td>
		</tr>
						<tr class="trace app expanded">
			<td class="number">
				#9			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/var/www/sondagesen/htmlpublic/application/controllers/AdminController.php(158): <strong>CController</strong>-&gt;<strong>run</strong>("user")				</div>

				<div class="code"><pre><span class="ln">153</span>                     $this-&gt;redirect(array('/admin/authentication/sa/login'));
<span class="ln">154</span>                 }
<span class="ln">155</span>             }
<span class="ln">156</span>         }
<span class="ln">157</span> 
<span class="error"><span class="ln error-ln">158</span>         return parent::run($action);
</span><span class="ln">159</span>     }
<span class="ln">160</span> 
<span class="ln">161</span>     /**
<span class="ln">162</span>      * Routes all the actions to their respective places
<span class="ln">163</span>      *
</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>
										&nbsp;/var/www/sondagesen/htmlpublic/framework/web/CWebApplication.php(282): <strong>AdminController</strong>-&gt;<strong>run</strong>("user")				</div>

				<div class="code"><pre><span class="ln">277</span>         {
<span class="ln">278</span>             list($controller,$actionID)=$ca;
<span class="ln">279</span>             $oldController=$this-&gt;_controller;
<span class="ln">280</span>             $this-&gt;_controller=$controller;
<span class="ln">281</span>             $controller-&gt;init();
<span class="error"><span class="ln error-ln">282</span>             $controller-&gt;run($actionID);
</span><span class="ln">283</span>             $this-&gt;_controller=$oldController;
<span class="ln">284</span>         }
<span class="ln">285</span>         else
<span class="ln">286</span>             throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".',
<span class="ln">287</span>                 array('{route}'=&gt;$route===''?$this-&gt;defaultController:$route)));
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#11			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/var/www/sondagesen/htmlpublic/framework/web/CWebApplication.php(141): <strong>CWebApplication</strong>-&gt;<strong>runController</strong>("admin/user/sa/modifyuser")				</div>

				<div class="code"><pre><span class="ln">136</span>             foreach(array_splice($this-&gt;catchAllRequest,1) as $name=&gt;$value)
<span class="ln">137</span>                 $_GET[$name]=$value;
<span class="ln">138</span>         }
<span class="ln">139</span>         else
<span class="ln">140</span>             $route=$this-&gt;getUrlManager()-&gt;parseUrl($this-&gt;getRequest());
<span class="error"><span class="ln error-ln">141</span>         $this-&gt;runController($route);
</span><span class="ln">142</span>     }
<span class="ln">143</span> 
<span class="ln">144</span>     /**
<span class="ln">145</span>      * Registers the core application components.
<span class="ln">146</span>      * This method overrides the parent implementation by registering additional core components.
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#12			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/var/www/sondagesen/htmlpublic/framework/base/CApplication.php(185): <strong>CWebApplication</strong>-&gt;<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-&gt;hasEventHandler('onBeginRequest'))
<span class="ln">183</span>             $this-&gt;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-&gt;processRequest();
</span><span class="ln">186</span>         if($this-&gt;hasEventHandler('onEndRequest'))
<span class="ln">187</span>             $this-&gt;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 collapsed">
			<td class="number">
				#13			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/var/www/sondagesen/htmlpublic/index.php(194): <strong>CApplication</strong>-&gt;<strong>run</strong>()				</div>

				<div class="code"><pre><span class="ln">189</span> require_once APPPATH . 'core/LSYii_Application' . EXT;
<span class="ln">190</span> 
<span class="ln">191</span> $config = require_once(APPPATH . 'config/internal' . EXT);
<span class="ln">192</span> 
<span class="ln">193</span> Yii::$enableIncludePath = false;
<span class="error"><span class="ln error-ln">194</span> Yii::createApplication('LSYii_Application', $config)-&gt;run();
</span><span class="ln">195</span> 
<span class="ln">196</span> /* End of file index.php */
<span class="ln">197</span> /* Location: ./index.php */
</pre></div>			</td>
		</tr>
				</tbody></table>
	</div>

	<div class="version">
		2018-04-26 08:46:09 Apache <a href="http://www.yiiframework.com/">Yii Framework</a>/1.1.18	</div>
</div>

<script type="text/javascript">
/*<![CDATA[*/
var traceReg = new RegExp("(^|\\s)trace-file(\\s|$)");
var collapsedReg = new RegExp("(^|\\s)collapsed(\\s|$)");

var e = document.getElementsByTagName("div");
for(var j=0,len=e.length;j<len;j++){
	if(traceReg.test(e[j].className)){
		e[j].onclick = function(){
			var trace = this.parentNode.parentNode;
			if(collapsedReg.test(trace.className))
				trace.className = trace.className.replace("collapsed", "expanded");
			else
				trace.className = trace.className.replace("expanded", "collapsed");
		}
	}
}
/*]]>*/
</script>



</body></html>
CDbException.htm (22,644 bytes)   
DenisChenu

DenisChenu

2018-04-26 17:47

developer   ~47546

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

DenisChenu

2018-04-26 17:47

developer   ~47547

Thanks for this excellent bug report
BZHNedr

BZHNedr

2018-04-27 09:04

reporter   ~47548

Thank you, for the quick resolution.
c_schmitz

c_schmitz

2018-05-25 11:30

administrator   ~47838

Version 3.8.1+180524 released

Related Changesets

LimeSurvey: master a2fcabb3

2018-04-26 19:46

DenisChenu


Details Diff		 Fixed issue 13634: Internal Server Error on CDbCommand when edit user
Dev: just remove this uneeded )		 Affected Issues
13634
mod - application/controllers/admin/useraction.php Diff File

Issue History

Date Modified Username Field Change
2018-04-25 11:09 BZHNedr New Issue
2018-04-25 11:09 BZHNedr File Added: LimeSurvey 3.7 bug 1.jpg
2018-04-25 11:09 BZHNedr File Added: LimeSurvey 3.7 bug 2.jpg
2018-04-25 11:09 BZHNedr File Added: LimeSurvey 3.7 bug 3.jpg
2018-04-25 11:09 BZHNedr File Added: LimeSurvey 3.7 bug 4.jpg
2018-04-25 14:45 DenisChenu Note Added: 47519
2018-04-26 08:50 guest File Added: CDbException.htm
2018-04-26 08:50 guest Note Added: 47537
2018-04-26 09:42 DenisChenu Assigned To => DenisChenu
2018-04-26 09:42 DenisChenu Status new => assigned
2018-04-26 17:47 DenisChenu Changeset attached => LimeSurvey master a2fcabb3
2018-04-26 17:47 DenisChenu Note Added: 47546
2018-04-26 17:47 DenisChenu Resolution open => fixed
2018-04-26 17:47 DenisChenu Status assigned => resolved
2018-04-26 17:47 DenisChenu Fixed in Version => 3.7.x
2018-04-26 17:47 DenisChenu Note Added: 47547
2018-04-27 09:04 BZHNedr Note Added: 47548
2018-05-25 11:30 c_schmitz Note Added: 47838
2018-05-25 11:30 c_schmitz Status resolved => closed
2019-11-01 17:26 c_schmitz Category User/User groups => User / Groups / Roles