debug mode on 2
CDbException
CDbCommand faalde tijdens het uitvoeren van volgend SQL statement: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xE2\x86\x94 5=...' for column `limesurv_test`.`lime_question_l10ns`.`help` at row 839. The SQL statement executed was: INSERT INTO lime_question_l10ns (qid, question, help, language) select qid, question, help, language from lime_questions
/home/limesurv/public_html/test/framework/db/CDbCommand.php(358)
346 {
347 if($this->_connection->enableProfiling)
348 Yii::endProfile('system.db.CDbCommand.execute('.$this->getText().$par.')','system.db.CDbCommand.execute');
349
350 $errorInfo=$e instanceof PDOException ? $e->errorInfo : null;
351 $message=$e->getMessage();
352 Yii::log(Yii::t('yii','CDbCommand::execute() failed: {error}. The SQL statement executed was: {sql}.',
353 array('{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
354
355 if(YII_DEBUG)
356 $message.='. The SQL statement executed was: '.$this->getText().$par;
357
358 throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
359 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
360 }
361 }
362
363 /**
364 * Executes the SQL statement and returns query result.
365 * This method is for executing an SQL query that returns result set.
366 * @param array $params input parameters (name=>value) for the SQL execution. This is an alternative
367 * to {@link bindParam} and {@link bindValue}. If you have multiple input parameters, passing
368 * them in this way can improve the performance. Note that if you pass parameters in this way,
369 * you cannot bind parameters or values using {@link bindParam} or {@link bindValue}, and vice versa.
370 * Please also note that all values are treated as strings in this case, if you need them to be handled as
Stack Trace
#0
– /home/limesurv/public_html/test/application/helpers/update/updatedb_helper.php(2451): CDbCommand->execute()
2446 'question' => "text NOT NULL",
2447 'help' => "text",
2448 'language' => "string(20) NOT NULL"
2449 ), $options);
2450 $oDB->createCommand()->createIndex('{{idx1_question_l10ns}}', '{{question_l10ns}}', , true);
2451 $oDB->createCommand("INSERT INTO {{question_l10ns}} (qid, question, help, language) select qid, question, help, language from {{questions}}")->execute();
2452 /* questions by rename/insert */
2453 if(Yii::app()->db->schema->getTable('{{questions_update400}}')){
2454 $oDB->createCommand()->dropTable('{{questions_update400}}');
2455 }
2456 $oDB->createCommand()->renameTable('{{questions}}', '{{questions_update400}}');
#1
– /home/limesurv/public_html/test/application/helpers/update/update_helper.php(31): db_upgrade_all(359)
26 Yii::app()->loadHelper('update/updatedb');
27 if (isset($subaction) && $subaction == "yes") {
28 $header = Yii::app()->getController()->_getAdminHeader(false, true);
29 $header = preg_replace('/<###begin###>/', '', $header);
30 echo $header;
31 $result = db_upgrade_all(intval($currentDBVersion));
32 if ($result) {
33 $data =
34 '<div class="jumbotron message-box">'.
35 '<h2 class="">'.gT('Success').'</h2>'.
36 '<p class="lead">'.
#2
– /home/limesurv/public_html/test/application/controllers/admin/databaseupdate.php(40): CheckForDBUpgrades("yes")
35 public function db($continue = null)
36 {
37 Yii::app()->loadHelper("update/update");
38 $aData = $aViewUrls = [];
39 if (isset($continue) && $continue == "yes") {
40 $aViewUrls = CheckForDBUpgrades($continue);
41 $aData = false;
42 } else {
43 $aData = true;
44 $aViewUrls = CheckForDBUpgrades();
45 }
#3
unknown(0): databaseupdate->db("yes")
#4
+ /home/limesurv/public_html/test/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(databaseupdate, array("yes"))
#5
+ /home/limesurv/public_html/test/application/core/Survey_Common_Action.php(86): CAction->runWithParamsInternal(databaseupdate, ReflectionMethod, array("continue" => "yes", "sa" => "db"))
#6
+ /home/limesurv/public_html/test/framework/web/CController.php(308): Survey_Common_Action->runWithParams(array("continue" => "yes", "sa" => "db"))
#7
+ /home/limesurv/public_html/test/framework/web/CController.php(286): CController->runAction(databaseupdate)
#8
+ /home/limesurv/public_html/test/framework/web/CController.php(265): CController->runActionWithFilters(databaseupdate, array())
#9
+ /home/limesurv/public_html/test/application/controllers/AdminController.php(165): CController->run("databaseupdate")
#10
+ /home/limesurv/public_html/test/framework/web/CWebApplication.php(282): AdminController->run("databaseupdate")
#11
+ /home/limesurv/public_html/test/framework/web/CWebApplication.php(141): CWebApplication->runController("admin/databaseupdate/sa/db")
#12
+ /home/limesurv/public_html/test/framework/base/CApplication.php(185): CWebApplication->processRequest()
#13
+ /home/limesurv/public_html/test/index.php(195): CApplication->run()
Topic Author
