CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column '191564X42X1331' in 'field list'. The SQL statement executed was: UPDATE survey_191564 SET `lastpage`=1, `datestamp`='2018-09-27 17:47:39', `191564X43X1357`=NULL, `191564X43X1359SQ001`=NULL, `191564X43X1359SQ002`=NULL, `191564X43X1359SQ003`=NULL, `191564X43X1359SQ004`=NULL, `191564X43X1359SQ005`=NULL, `191564X43X1359SQ006`=NULL, `191564X43X1359other`=NULL, `191564X43X1360`=NULL, `191564X43X1361`=NULL, `191564X43X1362`=NULL, `191564X43X1363`=NULL, `191564X43X1364`=NULL, `191564X43X1365`=NULL, `191564X43X1366`=NULL, `191564X43X1367`=NULL, `191564X42X1331`='Hidden' WHERE ID=2

/home/illuceo/public_html/ls/framework/db/CDbCommand.php(543)

531         {
532             if($this->_connection->enableProfiling)
533                 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query');
534 
535             $errorInfo=$e instanceof PDOException ? $e->errorInfo : null;
536             $message=$e->getMessage();
537             Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',
538                 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
539 
540             if(YII_DEBUG)
541                 $message.='. The SQL statement executed was: '.$this->getText().$par;
542 
543             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
544                 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
545         }
546     }
547 
548     /**
549      * Builds a SQL SELECT statement from the given query specification.
550      * @param array $query the query specification in name-value pairs. The following
551      * query options are supported: {@link select}, {@link distinct}, {@link from},
552      * {@link where}, {@link join}, {@link group}, {@link having}, {@link order},
553      * {@link limit}, {@link offset} and {@link union}.
554      * @throws CDbException if "from" key is not present in given query parameter
555      * @return string the SQL statement

Stack Trace

#1
+
 /home/illuceo/public_html/ls/application/helpers/expressions/em_manager_helper.php(5591): CDbCommand->query()
5586 
5587                     //If the responses already have been submitted once they are marked as completed already, so they shouldn't be changed.
5588                     $oSurveyResponse = SurveyDynamic::model($this->sid)->findByAttributes(['id' => $_SESSION[$this->sessid]['srid']]);
5589                     $result = true;
5590                     if ($oSurveyResponse->submitdate == null || Survey::model()->findByPk($this->sid)->alloweditaftercompletion == 'Y') {
5591                         $result = !Yii::app()->db->createCommand($query)->query();
5592                         //$result = !dbExecuteAssoc($query);
5593                     }
5594 
5595                     if ($result)
5596                     {
#2
+
 /home/illuceo/public_html/ls/application/helpers/expressions/em_manager_helper.php(5316): LimeExpressionManager->_UpdateValuesInDatabase()
5311                             continue;
5312                         }
5313                         else
5314                         {
5315                             // display new group
5316                             $message .= $LEM->_UpdateValuesInDatabase();
5317                             $LEM->runtimeTimings[] = array(__METHOD__,(microtime(true) - $now));
5318                             $LEM->lastMoveResult = array(
5319                                 'finished'=>false,
5320                                 'message'=>$message,
5321                                 'gseq'=>$LEM->currentGroupSeq,
#3
+
 /home/illuceo/public_html/ls/application/helpers/SurveyRuntimeHelper.php(838): LimeExpressionManager::NavigateForwards()
833                     $this->aMoveResult = false; // so display welcome page again
834                 }
835             }
836 
837             if ($this->sMove == "movenext") {
838                 $this->aMoveResult = LimeExpressionManager::NavigateForwards();
839             }
840 
841             if (($this->sMove == 'movesubmit')) {
842                 if ($this->sSurveyMode == 'survey') {
843                     $this->aMoveResult = LimeExpressionManager::NavigateForwards();
2018-09-27 17:47:39 Apache Yii Framework/1.1.19