CDbException

La relation « responses » définie dans la classe active record « TokenDynamic » a une clef étrangère « token » invalide. Cette colonne n'existe pas dans la table « survey_717329 ».

/limeservice/instances/2/limesurvey/framework/db/ar/CActiveFinder.php(1103)

1091         $joins=array();
1092         if(is_string($fks))
1093             $fks=preg_split('/\s*,\s*/',$fks,-1,PREG_SPLIT_NO_EMPTY);
1094         foreach($fks as $i=>$fk)
1095         {
1096             if(!is_int($i))
1097             {
1098                 $pk=$fk;
1099                 $fk=$i;
1100             }
1101 
1102             if(!isset($fke->_table->columns[$fk]))
1103                 throw new CDbException(Yii::t('yii','The relation "{relation}" in active record class "{class}" is specified with an invalid foreign key "{key}". There is no such column in the table "{table}".',
1104                     array('{class}'=>get_class($parent->model), '{relation}'=>$this->relation->name, '{key}'=>$fk, '{table}'=>$fke->_table->name)));
1105 
1106             if(is_int($i))
1107             {
1108                 if(isset($fke->_table->foreignKeys[$fk]) && $schema->compareTableNames($pke->_table->rawName, $fke->_table->foreignKeys[$fk][0]))
1109                     $pk=$fke->_table->foreignKeys[$fk][1];
1110                 else // FK constraints undefined
1111                 {
1112                     if(is_array($pke->_table->primaryKey)) // composite PK
1113                         $pk=$pke->_table->primaryKey[$i];
1114                     else
1115                         $pk=$pke->_table->primaryKey;

Stack Trace

#6
+
 /limeservice/instances/2/limesurvey/application/models/LSActiveRecord.php(77): CActiveRecord->query(CDbCriteria, true)
72      * @since 1.1.7
73      */
74     protected function query($criteria, $all = false, $asAR = true)
75     {
76         if ($asAR === true) {
77             return parent::query($criteria, $all);
78         } else {
79             $this->beforeFind();
80             $this->applyScopes($criteria);
81             if (!$all) {
82                 $criteria->limit = 1;
#8
+
 /limeservice/instances/2/limesurvey/application/models/TokenDynamic.php(211): CActiveRecord->findAll(CDbCriteria)
206             $command->limit = $iMaxEmails;
207         }
208 
209         $command->order = 'tid';
210 
211         $oResult = $this->findAll($command);
212         foreach ($oResult as $key => $result) {
213             $oResult[$key] = $result->decrypt();
214         }
215 
216         $cpdbBlacklisted = Participant::model()->getBlacklistedParticipantIds();
#9
+
 /limeservice/instances/2/limesurvey/application/controllers/admin/Tokens.php(1406): TokenDynamic->findUninvited(array("1", "2", "3", "4", ...), 0, false, "emailstatus = 'OK'", ...)
1401                         'condition' => 'responses.submitdate IS NULL',
1402                     ],
1403                 ]);
1404             }
1405 
1406             $ctresult = $tokenDynamic->findUninvited($aTokenIds, 0, $bIsInvitation, $SQLemailstatuscondition, $SQLremindercountcondition, $SQLreminderdelaycondition);
1407             $ctcount = count($ctresult);
1408 
1409             $emresult = array_slice($ctresult, 0, $iMaxEmails);
1410             $emcount = count($emresult);
1411 
2022-08-24 17:28:40 nginx/1.14.0 Yii Framework/1.1.24-dev