CDbException

CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[42883]: Undefined function: 7 ERREUR: la fonction lower(integer) n'existe pas
LINE 1: ...t_qid=368 and scale_id=0) AND (LOWER("t"."title")=LOWER(9128...
^
HINT: Aucune fonction ne correspond au nom donné et aux types d'arguments.
Vous devez ajouter des conversions explicites de type.. The SQL statement executed was: SELECT 1 FROM "lime_questions" "t" WHERE (language=:language AND sid=:sid AND parent_qid=:parent_qid and scale_id=:scale_id) AND (LOWER("t"."title")=LOWER(:ycp13)) LIMIT 1

/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/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

#6
+
 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/admin/database.php(496): CActiveRecord->save()
491                             // Let's give a new to code to the answer to save it, so user entries are not lost
492                             $bAnswerSave = false;
493 
494                             while (!$bAnswerSave) {
495                                 $oSubQuestion->title = rand(11111, 99999); // If the random code already exist (very low probablilty), answer will not be save and a new code will be generated
496                                 if ($oSubQuestion->save()) {
497                                     $sError = '<strong>'.sprintf(gT('A code has been updated to %s.'), $oSubQuestion->title).'</strong><br/>';
498                                     Yii::app()->setFlashMessage($sError, 'error');
499                                     $bAnswerSave = true;
500                                 }
501                             }
#7
+
 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/controllers/admin/database.php(124): database->actionSubQuestions(716875)
119         }
120         if ($sAction == "updateansweroptions" && Permission::model()->hasSurveyPermission($this->iSurveyID, 'surveycontent', 'update')) {
121             $this->actionUpdateAnswerOptions($this->iSurveyID);
122         }
123         if ($sAction == "updatesubquestions" && Permission::model()->hasSurveyPermission($this->iSurveyID, 'surveycontent', 'update')) {
124             $this->actionSubQuestions($this->iSurveyID);
125         }
126         if (in_array($sAction, array('insertquestion', 'copyquestion')) && Permission::model()->hasSurveyPermission($this->iSurveyID, 'surveycontent', 'create')) {
127             $this->actionInsertCopyQuestion($this->iSurveyID);
128         }
129         if ($sAction == "updatequestion" && Permission::model()->hasSurveyPermission($this->iSurveyID, 'surveycontent', 'update')) {
#10
+
 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_PG/application/core/Survey_Common_Action.php(83): CAction->runWithParamsInternal(database, ReflectionMethod, array())
78             $oMethod = new ReflectionMethod($this, $sDefault);
79         }
80 
81         // We're all good to go, let's execute it
82         // runWithParamsInternal would automatically get the parameters of the method and populate them as required with the params
83         return parent::runWithParamsInternal($this, $oMethod, $params);
84     }
85 
86     /**
87      * Some functions have different parameters, which are just an alias of the
88      * usual parameters we're getting in the url. This function just populates
2019-02-04 17:52:00 Apache/2.2.22 (Debian) Yii Framework/1.1.20