View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
06143Bug reportsOtherpublic2012-06-20 14:05
Reporteruser19960Assigned Tojcleeland  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00RC2 
Fixed in Version2.00RC3 
Summary06143: Participant panel - display participants
Description

display participants crash

should replace "en" with 'en' in
<<WHERE lime_participant_attribute_names_lang.lang = "en">>

Steps To Reproduce

Go to Participant panel - display participants (with no survey in database)

Additional Information

CDbException
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'en'.. The SQL statement executed was: SELECT [lime_participant_attribute_names]., [lime_participant_attribute_names_lang].
FROM [lime_participant_attribute_names]
JOIN [lime_participant_attribute_names_lang] ON lime_participant_attribute_names_lang.attribute_id = lime_participant_attribute_names.attribute_id
WHERE lime_participant_attribute_names_lang.lang = "en"
ORDER BY [lime_participant_attribute_names].[attribute_id]

C:\inetpub\wwwroot\limesurvey2\framework\db\CDbCommand.php(525)

513 return $result;
514 }
515 catch(Exception $e)
516 {
517 if($this->_connection->enableProfiling)
518 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query');
519 $errorInfo = $e instanceof PDOException ? $e->errorInfo : null;
520 $message = $e->getMessage();
521 Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',
522 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
523 if(YII_DEBUG)
524 $message .= '. The SQL statement executed was: '.$this->getText().$par;
525 throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
526 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
527 }
528 }
529
530 /
531 Builds a SQL SELECT statement from the given query specification.
532
@param array $query the query specification in name-value pairs. The following
533 query options are supported: {@link select}, {@link distinct}, {@link from},
534
{@link where}, {@link join}, {@link group}, {@link having}, {@link order},
535 {@link limit}, {@link offset} and {@link union}.
536
@return string the SQL statement
537 @since 1.1.6
Stack Trace
#0 +

C:\inetpub\wwwroot\limesurvey2\framework\db\CDbCommand.php(387): CDbCommand->queryInternal("fetchAll", array(2), array())
382
An empty array is returned if the query results in nothing.
383 @throws CException execution failed
384
/
385 public function queryAll($fetchAssociative=true,$params=array())
386 {
387 return $this->queryInternal('fetchAll',$fetchAssociative ? $this->_fetchMode : PDO::FETCH_NUM, $params);
388 }
389
390 /

391 Executes the SQL statement and returns the first row of the result.
392
This is a convenient method of {@link query} when only the first row of data is needed.

#1 +
– C:\inetpub\wwwroot\limesurvey2\application\models\ParticipantAttributeNames.php(118): CDbCommand->queryAll()
113 return Yii::app()->db->createCommand()->select('{{participant_attribute_names}}.,{{participant_attribute_names}}_lang.')
114 ->from('{{participant_attribute_names}}')
115 ->order('{{participant_attribute_names}}.attribute_id', 'desc')
116 ->join('{{participant_attribute_names}}_lang', '{{participant_attribute_names}}_lang.attribute_id = {{participant_attribute_names}}.attribute_id')
117 ->where('{{participant_attribute_names}}_lang.lang = "'.Yii::app()->session['adminlang'].'"')
118 ->queryAll();
119 }
120
121 function getAllAttributesValues()
122 {
123 return Yii::app()->db->createCommand()->select('*')->from('{{participant_attribute_values}}')->queryAll();

#2 +
– C:\inetpub\wwwroot\limesurvey2\application\controllers\admin\participantsaction.php(133): ParticipantAttributeNames->getAllAttributes()
128
129 // data to be passed to view
130 $aData = array(
131 'names' => User::model()->findAll(),
132 'attributes' => ParticipantAttributeNames::getVisibleAttributes(),
133 'allattributes' => ParticipantAttributeNames::getAllAttributes(),
134 'attributeValues' => ParticipantAttributeNames::getAllAttributesValues(),
135 'surveynames' => $aSurveyNames,
136 'tokensurveynames' => $tSurveyNames
137 );
138

#3 unknown(0): participantsaction->displayParticipants()
#4 +

C:\inetpub\wwwroot\limesurvey2\framework\web\actions\CAction.php(107): ReflectionMethod->invokeArgs(participantsaction, array())
102 else if($param->isDefaultValueAvailable())
103 $ps[]=$param->getDefaultValue();
104 else
105 return false;
106 }
107 $method->invokeArgs($object,$ps);
108 return true;
109 }
110 }

#5 +
– C:\inetpub\wwwroot\limesurvey2\application\core\Survey_Common_Action.php(82): CAction->runWithParamsInternal(participantsaction, ReflectionMethod, array("sa" => "displayParticipants"))
77 $oMethod = new ReflectionMethod($this, $sDefault);
78 }
79
80 // We're all good to go, let's execute it
81 // runWithParamsInternal would automatically get the parameters of the method and populate them as required with the params
82 return parent::runWithParamsInternal($this, $oMethod, $params);
83 }
84
85 /*
86
Some functions have different parameters, which are just an alias of the
87 * usual parameters we're getting in the url. This function just populates

#6 +

C:\inetpub\wwwroot\limesurvey2\framework\web\CController.php(309): Survey_Common_Action->runWithParams(array("sa" => "displayParticipants"))
304 {
305 $priorAction=$this->_action;
306 $this->_action=$action;
307 if($this->beforeAction($action))
308 {
309 if($action->runWithParams($this->getActionParams())===false)
310 $this->invalidActionParams($action);
311 else
312 $this->afterAction($action);
313 }
314 $this->_action=$priorAction;

#7 +

C:\inetpub\wwwroot\limesurvey2\framework\web\CController.php(287): CController->runAction(participantsaction)
282 @see runAction
283
/
284 public function runActionWithFilters($action,$filters)
285 {
286 if(empty($filters))
287 $this->runAction($action);
288 else
289 {
290 $priorAction=$this->_action;
291 $this->_action=$action;
292 CFilterChain::create($this,$action,$filters)->run();

#8 +

C:\inetpub\wwwroot\limesurvey2\framework\web\CController.php(266): CController->runActionWithFilters(participantsaction, array())
261 {
262 if(($parent=$this->getModule())===null)
263 $parent=Yii::app();
264 if($parent->beforeControllerAction($this,$action))
265 {
266 $this->runActionWithFilters($action,$this->filters());
267 $parent->afterControllerAction($this,$action);
268 }
269 }
270 else
271 $this->missingAction($actionID);

#9 +

C:\inetpub\wwwroot\limesurvey2\application\controllers\AdminController.php(158): CController->run("participants")
153 Yii::app()->session['redirectopage'] = Yii::app()->request->requestUri;
154
155 $this->redirect($this->createUrl('/admin/authentication/login'));
156 }
157
158 return parent::run($action);
159 }
160
161 /*
162
Routes all the actions to their respective places
163 *

#10 +

C:\inetpub\wwwroot\limesurvey2\framework\web\CWebApplication.php(276): AdminController->run("participants")
271 {
272 list($controller,$actionID)=$ca;
273 $oldController=$this->_controller;
274 $this->_controller=$controller;
275 $controller->init();
276 $controller->run($actionID);
277 $this->_controller=$oldController;
278 }
279 else
280 throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".',
281 array('{route}'=>$route===''?$this->defaultController:$route)));

#11 +

C:\inetpub\wwwroot\limesurvey2\framework\web\CWebApplication.php(135): CWebApplication->runController("admin/participants/sa/displayParticipants")
130 foreach(array_splice($this->catchAllRequest,1) as $name=>$value)
131 $_GET[$name]=$value;
132 }
133 else
134 $route=$this->getUrlManager()->parseUrl($this->getRequest());
135 $this->runController($route);
136 }
137
138 /*
139
Registers the core application components.
140 * This method overrides the parent implementation by registering additional core components.

#12 +

C:\inetpub\wwwroot\limesurvey2\framework\base\CApplication.php(162): CWebApplication->processRequest()
157 */
158 public function run()
159 {
160 if($this->hasEventHandler('onBeginRequest'))
161 $this->onBeginRequest(new CEvent($this));
162 $this->processRequest();
163 if($this->hasEventHandler('onEndRequest'))
164 $this->onEndRequest(new CEvent($this));
165 }
166
167 /**

#13 +

C:\inetpub\wwwroot\limesurvey2\index.php(171): CApplication->run()
166
167
/
168 require_once BASEPATH . 'yii' . EXT;
169 require_once APPPATH . 'core/LSYii_Application' . EXT;
170
171 Yii::createApplication('LSYii_Application', APPPATH . 'config/config' . EXT)->run();
172
173 / End of file index.php /
174 / Location: ./index.php /

2012-05-28 20:47:00 Microsoft-IIS/7.0 Yii Framework/1.1.10

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)120528
I will donate to the project if issue is resolvedNo
BrowserIE8
Database type & versionms sql server 2008
Server OS (if known)win 2008
Webserver software & version (if known)IIS7
PHP Versionphp 5.3.13 + Microsoft Drivers 3.0 for PHP 4 SQL Server (v 3.0.1,published: 4/18/2012)

Users monitoring this issue

There are no users monitoring this issue.

Activities

jcleeland

jcleeland

2012-05-29 08:34

reporter   ~18985

Done

c_schmitz

c_schmitz

2012-06-20 14:05

administrator   ~19380

2.0RC3 released

Issue History

Date Modified Username Field Change
2012-05-28 18:51 user19960 New Issue
2012-05-28 18:51 user19960 Issue Monitored: user19960
2012-05-28 18:52 c_schmitz Assigned To => jcleeland
2012-05-28 18:52 c_schmitz Status new => assigned
2012-05-29 08:34 jcleeland Note Added: 18985
2012-05-29 08:34 jcleeland Status assigned => closed
2012-05-29 08:34 jcleeland Resolution open => fixed
2012-05-29 08:34 jcleeland Fixed in Version => 2.00RC3
2012-05-29 08:35 c_schmitz Status closed => resolved
2012-06-20 14:05 c_schmitz Note Added: 19380
2012-06-20 14:05 c_schmitz Status resolved => closed