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 |
---|