View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 18
IDProjectCategoryView StatusDate SubmittedLast Update
12855Bug reportsSurvey editingpublic2017-10-31 12:142018-01-15 10:35
ReporterDenisChenu Assigned Toollehar  
PrioritynoneSeveritypartial_block 
Status closedResolutionfixed 
Product Version3.0.0-rc.x 
Summary12855: Primary key on group.gid diable multilingual survey
Description

Can not create a multilingual survey : group.gid is unique key, must be [gid,language]

Steps To Reproduce

Import included survey, or try to add a language on an existing survey

Additional Information

When trying adding new language : we must look at console : i think it was fixed ?

I didn't look at question and answer, but same key [id,language]

TagsNo tags attached.
Attached Files
limesurvey_survey_85678.lss (352,886 bytes)
Capture du 2017-10-31 12-11-22.png (97,839 bytes)   
Capture du 2017-10-31 12-11-22.png (97,839 bytes)   
CDbException.text (6,218 bytes)    
CDbException

CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3' for key 'PRIMARY'. The SQL statement executed was: INSERT INTO `lime_groups` (`sid`, `group_name`, `group_order`, `randomization_group`, `description`, `language`, `gid`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6)

/home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/framework/db/CDbCommand.php(358)

346         {
347             if($this->_connection->enableProfiling)
348                 Yii::endProfile('system.db.CDbCommand.execute('.$this->getText().$par.')','system.db.CDbCommand.execute');
349 
350             $errorInfo=$e instanceof PDOException ? $e->errorInfo : null;
351             $message=$e->getMessage();
352             Yii::log(Yii::t('yii','CDbCommand::execute() failed: {error}. The SQL statement executed was: {sql}.',
353                 array('{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
354 
355             if(YII_DEBUG)
356                 $message.='. The SQL statement executed was: '.$this->getText().$par;
357 
358             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
359                 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
360         }
361     }
362 
363     /**
364      * Executes the SQL statement and returns query result.
365      * This method is for executing an SQL query that returns result set.
366      * @param array $params input parameters (name=>value) for the SQL execution. This is an alternative
367      * to {@link bindParam} and {@link bindValue}. If you have multiple input parameters, passing
368      * them in this way can improve the performance. Note that if you pass parameters in this way,
369      * you cannot bind parameters or values using {@link bindParam} or {@link bindValue}, and vice versa.
370      * Please also note that all values are treated as strings in this case, if you need them to be handled as

Stack Trace
#0 	
+
 /home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/framework/db/ar/CActiveRecord.php(1083): CDbCommand->execute()
#1 	
+
 /home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/framework/db/ar/CActiveRecord.php(811): CActiveRecord->insert(null)
#2 	
–
 /home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/application/models/QuestionGroup.php(143): CActiveRecord->save()

138     {
139         $group = new self;
140         foreach ($data as $k => $v){
141             $group->$k = $v;
142         }
143         if  (!$group->save()){
144             return false;
145         }
146         else {
147             return $group->gid;
148         }

#3 	
–
 /home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/application/helpers/admin/import_helper.php(922): QuestionGroup->insertRecords(array("sid" => "657185", "group_name" => "Question de type texte", "group_order" => "0", "description" => "Ceci est la description du groupe de questions de type texte.", ...))

917             if (isset($aGIDReplacements[$oldgid])){
918                 switchMSSQLIdentityInsert('groups',true);
919                 $insertdata['gid']=$aGIDReplacements[$oldgid];
920             }
921 
922             $newgid = QuestionGroup::model()->insertRecords($insertdata) or safeDie(gT("Error").": Failed to insert data [3]<br />");
923             if (!isset($aGIDReplacements[$oldgid])){
924                 $aGIDReplacements[$oldgid]=$newgid; // add old and new qid to the mapping array
925                 $results['groups']++;
926             }else{
927                 switchMSSQLIdentityInsert('groups',false);

#4 	
–
 /home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/application/helpers/admin/import_helper.php(658): XMLImportSurvey("/home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/tmp/nsk...", null, null, null, ...)

653     }else{
654         $sExtension = "";
655     }
656 
657     if ($sExtension == 'lss'){
658         return XMLImportSurvey($sFullFilePath, null, $sNewSurveyName, $DestSurveyID, $bTranslateLinksFields);
659     }elseif ($sExtension == 'txt' || $sExtension == 'tsv'){
660         return TSVImportSurvey($sFullFilePath);
661     }elseif ($sExtension == 'lsa'){
662           // Import a survey archive
663         Yii::import("application.libraries.admin.pclzip.pclzip", true);

#5 	
+
 /home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/application/controllers/admin/surveyadmin.php(1308): importSurveyFile("/home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/tmp/nsk...", true)
#6 	
 unknown(0): SurveyAdmin->copy()
#7 	
+
 /home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(SurveyAdmin, array())
#8 	
+
 /home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/application/core/Survey_Common_Action.php(87): CAction->runWithParamsInternal(SurveyAdmin, ReflectionMethod, array("sa" => "copy"))
#9 	
+
 /home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/framework/web/CController.php(308): Survey_Common_Action->runWithParams(array("sa" => "copy"))
#10 	
+
 /home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/framework/web/CController.php(286): CController->runAction(SurveyAdmin)
#11 	
+
 /home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/framework/web/CController.php(265): CController->runActionWithFilters(SurveyAdmin, array())
#12 	
+
 /home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/application/controllers/AdminController.php(176): CController->run("survey")
#13 	
+
 /home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/framework/web/CWebApplication.php(282): AdminController->run("survey")
#14 	
+
 /home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/framework/web/CWebApplication.php(141): CWebApplication->runController("admin/survey/sa/copy")
#15 	
+
 /home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/framework/base/CApplication.php(185): CWebApplication->processRequest()
#16 	
+
 /home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/index.php(195): CApplication->run()
2017-10-31 12:12:22 Apache/2.2.22 (Debian) Yii Framework/1.1.18
CDbException.text (6,218 bytes)   
CDbException.html (26,054 bytes)    
<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[23000]: Integrity constraint violation: 1062 Duplicate entry '3' for key 'PRIMARY'. The SQL statement executed was: INSERT INTO `lime_groups` (`sid`, `group_name`, `group_order`, `randomization_group`, `description`, `language`, `gid`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6)	</p>

	<div class="source">
		<p class="file">/home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/framework/db/CDbCommand.php(358)</p>
		<div class="code"><pre><span class="ln">346</span>         {
<span class="ln">347</span>             if($this-&gt;_connection-&gt;enableProfiling)
<span class="ln">348</span>                 Yii::endProfile('system.db.CDbCommand.execute('.$this-&gt;getText().$par.')','system.db.CDbCommand.execute');
<span class="ln">349</span> 
<span class="ln">350</span>             $errorInfo=$e instanceof PDOException ? $e-&gt;errorInfo : null;
<span class="ln">351</span>             $message=$e-&gt;getMessage();
<span class="ln">352</span>             Yii::log(Yii::t('yii','CDbCommand::execute() failed: {error}. The SQL statement executed was: {sql}.',
<span class="ln">353</span>                 array('{error}'=&gt;$message, '{sql}'=&gt;$this-&gt;getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
<span class="ln">354</span> 
<span class="ln">355</span>             if(YII_DEBUG)
<span class="ln">356</span>                 $message.='. The SQL statement executed was: '.$this-&gt;getText().$par;
<span class="ln">357</span> 
<span class="error"><span class="ln error-ln">358</span>             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
</span><span class="ln">359</span>                 array('{error}'=&gt;$message)),(int)$e-&gt;getCode(),$errorInfo);
<span class="ln">360</span>         }
<span class="ln">361</span>     }
<span class="ln">362</span> 
<span class="ln">363</span>     /**
<span class="ln">364</span>      * Executes the SQL statement and returns query result.
<span class="ln">365</span>      * This method is for executing an SQL query that returns result set.
<span class="ln">366</span>      * @param array $params input parameters (name=&gt;value) for the SQL execution. This is an alternative
<span class="ln">367</span>      * to {@link bindParam} and {@link bindValue}. If you have multiple input parameters, passing
<span class="ln">368</span>      * them in this way can improve the performance. Note that if you pass parameters in this way,
<span class="ln">369</span>      * you cannot bind parameters or values using {@link bindParam} or {@link bindValue}, and vice versa.
<span class="ln">370</span>      * Please also note that all values are treated as strings in this case, if you need them to be handled as
</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;/home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/framework/db/ar/CActiveRecord.php(1083): <strong>CDbCommand</strong>-&gt;<strong>execute</strong>()				</div>

				<div class="code"><pre><span class="ln">1078</span>         {
<span class="ln">1079</span>             Yii::trace(get_class($this).'.insert()','system.db.ar.CActiveRecord');
<span class="ln">1080</span>             $builder=$this-&gt;getCommandBuilder();
<span class="ln">1081</span>             $table=$this-&gt;getTableSchema();
<span class="ln">1082</span>             $command=$builder-&gt;createInsertCommand($table,$this-&gt;getAttributes($attributes));
<span class="error"><span class="ln error-ln">1083</span>             if($command-&gt;execute())
</span><span class="ln">1084</span>             {
<span class="ln">1085</span>                 $primaryKey=$table-&gt;primaryKey;
<span class="ln">1086</span>                 if($table-&gt;sequenceName!==null)
<span class="ln">1087</span>                 {
<span class="ln">1088</span>                     if(is_string($primaryKey) &amp;&amp; $this-&gt;$primaryKey===null)
</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;/home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/framework/db/ar/CActiveRecord.php(811): <strong>CActiveRecord</strong>-&gt;<strong>insert</strong>(null)				</div>

				<div class="code"><pre><span class="ln">806</span>      * @return boolean whether the saving succeeds
<span class="ln">807</span>      */
<span class="ln">808</span>     public function save($runValidation=true,$attributes=null)
<span class="ln">809</span>     {
<span class="ln">810</span>         if(!$runValidation || $this-&gt;validate($attributes))
<span class="error"><span class="ln error-ln">811</span>             return $this-&gt;getIsNewRecord() ? $this-&gt;insert($attributes) : $this-&gt;update($attributes);
</span><span class="ln">812</span>         else
<span class="ln">813</span>             return false;
<span class="ln">814</span>     }
<span class="ln">815</span> 
<span class="ln">816</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;/home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/application/models/QuestionGroup.php(143): <strong>CActiveRecord</strong>-&gt;<strong>save</strong>()				</div>

				<div class="code"><pre><span class="ln">138</span>     {
<span class="ln">139</span>         $group = new self;
<span class="ln">140</span>         foreach ($data as $k =&gt; $v){
<span class="ln">141</span>             $group-&gt;$k = $v;
<span class="ln">142</span>         }
<span class="error"><span class="ln error-ln">143</span>         if  (!$group-&gt;save()){
</span><span class="ln">144</span>             return false;
<span class="ln">145</span>         }
<span class="ln">146</span>         else {
<span class="ln">147</span>             return $group-&gt;gid;
<span class="ln">148</span>         }
</pre></div>			</td>
		</tr>
						<tr class="trace app expanded">
			<td class="number">
				#3			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/application/helpers/admin/import_helper.php(922): <strong>QuestionGroup</strong>-&gt;<strong>insertRecords</strong>(array("sid" =&gt; "657185", "group_name" =&gt; "Question de type texte", "group_order" =&gt; "0", "description" =&gt; "Ceci est la description du groupe de questions de type texte.", ...))				</div>

				<div class="code"><pre><span class="ln">917</span>             if (isset($aGIDReplacements[$oldgid])){
<span class="ln">918</span>                 switchMSSQLIdentityInsert('groups',true);
<span class="ln">919</span>                 $insertdata['gid']=$aGIDReplacements[$oldgid];
<span class="ln">920</span>             }
<span class="ln">921</span> 
<span class="error"><span class="ln error-ln">922</span>             $newgid = QuestionGroup::model()-&gt;insertRecords($insertdata) or safeDie(gT("Error").": Failed to insert data [3]&lt;br /&gt;");
</span><span class="ln">923</span>             if (!isset($aGIDReplacements[$oldgid])){
<span class="ln">924</span>                 $aGIDReplacements[$oldgid]=$newgid; // add old and new qid to the mapping array
<span class="ln">925</span>                 $results['groups']++;
<span class="ln">926</span>             }else{
<span class="ln">927</span>                 switchMSSQLIdentityInsert('groups',false);
</pre></div>			</td>
		</tr>
						<tr class="trace app expanded">
			<td class="number">
				#4			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/application/helpers/admin/import_helper.php(658): <strong>XMLImportSurvey</strong>("/home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/tmp/nsk...", null, null, null, ...)				</div>

				<div class="code"><pre><span class="ln">653</span>     }else{
<span class="ln">654</span>         $sExtension = "";
<span class="ln">655</span>     }
<span class="ln">656</span> 
<span class="ln">657</span>     if ($sExtension == 'lss'){
<span class="error"><span class="ln error-ln">658</span>         return XMLImportSurvey($sFullFilePath, null, $sNewSurveyName, $DestSurveyID, $bTranslateLinksFields);
</span><span class="ln">659</span>     }elseif ($sExtension == 'txt' || $sExtension == 'tsv'){
<span class="ln">660</span>         return TSVImportSurvey($sFullFilePath);
<span class="ln">661</span>     }elseif ($sExtension == 'lsa'){
<span class="ln">662</span>           // Import a survey archive
<span class="ln">663</span>         Yii::import("application.libraries.admin.pclzip.pclzip", true);
</pre></div>			</td>
		</tr>
						<tr class="trace app collapsed">
			<td class="number">
				#5			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/application/controllers/admin/surveyadmin.php(1308): <strong>importSurveyFile</strong>("/home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/tmp/nsk...", true)				</div>

				<div class="code"><pre><span class="ln">1303</span> 
<span class="ln">1304</span>             // Now, we have the survey : start importing
<span class="ln">1305</span>             Yii::app()-&gt;loadHelper('admin/import');
<span class="ln">1306</span> 
<span class="ln">1307</span>             if ($action == 'importsurvey' &amp;&amp; !$aData['bFailed']){
<span class="error"><span class="ln error-ln">1308</span>                 $aImportResults=importSurveyFile($sFullFilepath,(Yii::app()-&gt;request-&gt;getPost('translinksfields')=='1'));
</span><span class="ln">1309</span>                 if (is_null($aImportResults)){
<span class="ln">1310</span>                     $aImportResults=array(
<span class="ln">1311</span>                         'error'=&gt;gT("Unknown error while reading the file, no survey created.")
<span class="ln">1312</span>                     );
<span class="ln">1313</span>                 }
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#6			</td>
			<td class="content">
				<div class="trace-file">
										&nbsp;unknown(0): <strong>SurveyAdmin</strong>-&gt;<strong>copy</strong>()				</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;/home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/framework/web/actions/CAction.php(109): <strong>ReflectionMethod</strong>-&gt;<strong>invokeArgs</strong>(SurveyAdmin, 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 collapsed">
			<td class="number">
				#8			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/application/core/Survey_Common_Action.php(87): <strong>CAction</strong>-&gt;<strong>runWithParamsInternal</strong>(SurveyAdmin, ReflectionMethod, array("sa" =&gt; "copy"))				</div>

				<div class="code"><pre><span class="ln">82</span>             $oMethod = new ReflectionMethod($this, $sDefault);
<span class="ln">83</span>         }
<span class="ln">84</span> 
<span class="ln">85</span>         // We're all good to go, let's execute it
<span class="ln">86</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">87</span>         return parent::runWithParamsInternal($this, $oMethod, $params);
</span><span class="ln">88</span>     }
<span class="ln">89</span> 
<span class="ln">90</span>     /**
<span class="ln">91</span>      * Some functions have different parameters, which are just an alias of the
<span class="ln">92</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">
				#9			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/framework/web/CController.php(308): <strong>Survey_Common_Action</strong>-&gt;<strong>runWithParams</strong>(array("sa" =&gt; "copy"))				</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">
				#10			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/framework/web/CController.php(286): <strong>CController</strong>-&gt;<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-&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">
				#11			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/framework/web/CController.php(265): <strong>CController</strong>-&gt;<strong>runActionWithFilters</strong>(SurveyAdmin, 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 collapsed">
			<td class="number">
				#12			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/application/controllers/AdminController.php(176): <strong>CController</strong>-&gt;<strong>run</strong>("survey")				</div>

				<div class="code"><pre><span class="ln">171</span>                     $this-&gt;redirect(array('/admin/authentication/sa/login'));
<span class="ln">172</span>                 }
<span class="ln">173</span>             }
<span class="ln">174</span>         }
<span class="ln">175</span> 
<span class="error"><span class="ln error-ln">176</span>         return parent::run($action);
</span><span class="ln">177</span>     }
<span class="ln">178</span> 
<span class="ln">179</span>     /**
<span class="ln">180</span>     * Routes all the actions to their respective places
<span class="ln">181</span>     *
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#13			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/framework/web/CWebApplication.php(282): <strong>AdminController</strong>-&gt;<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-&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">
				#14			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/framework/web/CWebApplication.php(141): <strong>CWebApplication</strong>-&gt;<strong>runController</strong>("admin/survey/sa/copy")				</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">
				#15			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/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">
				#16			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/home/sondages.pro/htdocs/limesurvey_GIT/testing/develop/index.php(195): <strong>CApplication</strong>-&gt;<strong>run</strong>()				</div>

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

	<div class="version">
		2017-10-31 12:12:22 Apache/2.2.22 (Debian) <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.html (26,054 bytes)   
Bug heat18
Complete LimeSurvey version number (& build)20171031
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionnot relevant
Server OS (if known)not relevant
Webserver software & version (if known)not relevant
PHP Versionnot relevant

Relationships

Relationship GraphDependency Graph
has duplicate 12868 closedLouisGac Updating to 3.0xx 

Users monitoring this issue

There are no users monitoring this issue.

Activities

ollehar

ollehar

2017-11-01 11:22

administrator   ~44916

Cannot reproduce with latest develop pull. More info?
ollehar

ollehar

2017-11-01 11:22

administrator   ~44917

Do I need a clean install?
DenisChenu

DenisChenu

2017-11-01 22:56

developer   ~44930

Surely : install done just 2 day ago.
Issue (for group) is here : https://github.com/LimeSurvey/LimeSurvey/blob/910830c9c93c6e2d6e34e10f7905a25c4e3a6e81/installer/create-database.php#L123

gid is not pk, it's auto incremented but not pk
ollehar

ollehar

2017-11-02 09:32

administrator   ~44932

OK, will fix.
c_schmitz

c_schmitz

2018-01-15 10:35

administrator   ~45633

Version 3.0.3 released.

Issue History

Date Modified Username Field Change
2017-10-31 12:14 DenisChenu New Issue
2017-10-31 12:14 DenisChenu Status new => assigned
2017-10-31 12:14 DenisChenu Assigned To => ollehar
2017-10-31 12:14 DenisChenu File Added: CDbException.html
2017-10-31 12:14 DenisChenu File Added: limesurvey_survey_85678.lss
2017-10-31 12:14 DenisChenu File Added: Capture du 2017-10-31 12-11-22.png
2017-10-31 12:15 DenisChenu File Deleted: CDbException.html
2017-10-31 12:15 DenisChenu File Added: CDbException.html
2017-10-31 12:15 DenisChenu File Deleted: CDbException.html
2017-10-31 12:17 DenisChenu File Added: CDbException.text
2017-10-31 12:32 DenisChenu File Added: CDbException.html
2017-11-01 11:22 ollehar Note Added: 44916
2017-11-01 11:22 ollehar Note Added: 44917
2017-11-01 22:56 DenisChenu Note Added: 44930
2017-11-02 09:32 ollehar Note Added: 44932
2017-11-06 10:31 LouisGac Relationship added has duplicate 12868
2017-11-10 14:00 ollehar Status assigned => resolved
2017-11-10 14:00 ollehar Resolution open => fixed
2018-01-15 10:35 c_schmitz Note Added: 45633
2018-01-15 10:35 c_schmitz Status resolved => closed
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing