CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lime.lime_survey_717464_timings' doesn't exist. The SQL statement executed was: INSERT INTO `lime_survey_717464_timings` (`id`) VALUES (:id)

/Library/WebServer/Documents/limesurvey/framework/db/CDbCommand.php(354)

342             return $n;
343         }
344         catch(Exception $e)
345         {
346             if($this->_connection->enableProfiling)
347                 Yii::endProfile('system.db.CDbCommand.execute('.$this->getText().')','system.db.CDbCommand.execute');
348             $errorInfo = $e instanceof PDOException ? $e->errorInfo : null;
349             $message = $e->getMessage();
350             Yii::log(Yii::t('yii','CDbCommand::execute() failed: {error}. The SQL statement executed was: {sql}.',
351                 array('{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
352             if(YII_DEBUG)
353                 $message .= '. The SQL statement executed was: '.$this->getText().$par;
354             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
355                 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
356         }
357     }
358 
359     /**
360      * Executes the SQL statement and returns query result.
361      * This method is for executing an SQL query that returns result set.
362      * @param array $params input parameters (name=>value) for the SQL execution. This is an alternative
363      * to {@link bindParam} and {@link bindValue}. If you have multiple input parameters, passing
364      * them in this way can improve the performance. Note that if you pass parameters in this way,
365      * you cannot bind parameters or values using {@link bindParam} or {@link bindValue}, and vice versa.
366      * binding methods and  the input parameters this way can improve the performance.

Stack Trace

#1
+
 /Library/WebServer/Documents/limesurvey/application/helpers/expressions/em_manager_helper.php(3280): CDbCommand->insert("{{survey_717464_timings}}", array("id" => "3"))
3275                     $tdata = array(
3276                     'id'=>$srid,
3277                     'interviewtime'=>0
3278                     );
3279                     $tdata = array_filter($tdata);
3280                     if (Yii::app()->db->createCommand()->insert($this->surveyOptions['tablename_timings'],$tdata))  // Checked
3281                     {
3282                         $trid = Yii::app()->db->getLastInsertID();
3283                     }
3284                     else
3285                     {
#2
+
 /Library/WebServer/Documents/limesurvey/application/helpers/expressions/em_manager_helper.php(3206): LimeExpressionManager->_UpdateValuesInDatabase(array("717464X5X45" => array("type" => "L", "value" => null)), false)
3201                             continue;
3202                         }
3203                         else
3204                         {
3205                             // display new question
3206                             $message .= $LEM->_UpdateValuesInDatabase($updatedValues,false);
3207                             $LEM->runtimeTimings[] = array(__METHOD__,(microtime(true) - $now));
3208                             $LEM->lastMoveResult = array(
3209                             'finished'=>false,
3210                             'message'=>$message,
3211                             'qseq'=>$LEM->currentQuestionSeq,
#3
+
 /Library/WebServer/Documents/limesurvey/application/helpers/SurveyRuntimeHelper.php(178): LimeExpressionManager::NavigateForwards()
173                         $moveResult = LimeExpressionManager::JumpTo($_SESSION[$LEMsessid]['step'], false, false);   // if late in the survey, will re-validate contents, which may be overkill
174                         unset($_SESSION[$LEMsessid]['LEMreload']);
175                     }
176                     else
177                     {
178                         $moveResult = LimeExpressionManager::NavigateForwards();
179                     }
180                 }
181                 if (isset($move) && ($move == 'movesubmit'))
182                 {
183                     if ($surveyMode == 'survey')
2012-04-30 12:01:58 Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8r DAV/2 PHP/5.3.8 Yii Framework/1.1.10