CDbException

CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[42883]: Undefined function: 7 ERREUR: l'opérateur n'existe pas : text = integer
LINE 1: ... "t" WHERE "t"."qid"=69 AND (attribute='hidden' AND value=1)
^
HINT: Aucun opérateur ne correspond au nom donné et aux types d'arguments.
Vous devez ajouter des conversions explicites de type.. The SQL statement executed was: SELECT COUNT(*) FROM "lime_question_attributes" "t" WHERE "t"."qid"=69 AND (attribute=:attribute AND value=:value)

/data/webdev/pgsql/third_party/yiisoft/yii/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

#2
+
 /data/webdev/pgsql/application/helpers/frontend_helper.php(1868): CActiveRecord->countByAttributes()
1863 
1864             // Condition to count quota :
1865             // Answers are the same in quota + an answer is submitted at this time (bPostedField)
1866             //  OR all questions is hidden (bAllHidden)
1867             $bAllHidden = QuestionAttribute::model()
1868                 ->countByAttributes(array('qid' => $aQuotaQid), 'attribute=:attribute AND value=:value', array(':attribute' => 'hidden',':value' => 1)) == count($aQuotaQid);
1869 
1870             if ($iMatchedAnswers == count($aQuotaFields) && ($bPostedField || $bAllHidden)) {
1871                 if ($oQuota->qlimit == 0) {
1872                     // Always add the quota if qlimit==0
1873                     $aMatchedQuotas[] = $oQuota->viewArray;
#3
+
 /data/webdev/pgsql/application/helpers/expressions/em_manager_helper.php(5198): checkCompletedQuota()
5193                     }
5194                 } elseif ($this->surveyOptions['allowsave'] && isset($_SESSION[$this->sessid]['scid'])) {
5195                     SavedControl::model()->updateByPk($_SESSION[$this->sessid]['scid'], ['saved_thisstep' => $_SESSION[$this->sessid]['step']]);
5196                 }
5197                 // Check Quotas
5198                 $aQuotas = checkCompletedQuota($this->sid, true);
5199                 if ($aQuotas && !empty($aQuotas)) {
5200                     checkCompletedQuota($this->sid);  // will create a page and quit: why not use it directly ?
5201                 } else {
5202                     if ($finished && ($oResponse->submitdate == null || Survey::model()->findByPk($this->sid)->alloweditaftercompletion == 'Y')) {
5203                         /* Less update : just do what you need to to */
#4
+
 /data/webdev/pgsql/application/helpers/expressions/em_manager_helper.php(4899): LimeExpressionManager->_UpdateValuesInDatabase()
4894                     if (!$result['relevant'] || $result['hidden']) {
4895                         // then skip this group
4896                         continue;
4897                     } else {
4898                         // display new group
4899                         $message .= $LEM->_UpdateValuesInDatabase();
4900                         $LEM->runtimeTimings[] = [__METHOD__, (microtime(true) - $now)];
4901                         $LEM->lastMoveResult = [
4902                             'finished'      => false,
4903                             'message'       => $message,
4904                             'gseq'          => $LEM->currentGroupSeq,
2022-10-19 09:51:17 nginx/1.18.0 Yii Framework/1.1.26