TDbCommand failed to execute the SQL statement "UPDATE `figure` SET `link` = :link, `link_type` = :link_type, `slug` = :slug, `jan` = :jan, `category` = :category, `classification` = :classification, `origin` = :origin, `name` = :name, `title` = :title, `version` = :version, `company` = :company, `artist` = :artist, `scale` = :scale, `height` = :height, `material` = :material, `price` = :price, `release_date_text` = :release_date_text, `release_date` = :release_date, `release_history` = :release_history, `release_total_times` = :release_total_times, `info` = :info, `is_prize` = :is_prize, `is_castoff` = :is_castoff, `is_18` = :is_18, `is_nsfw` = :is_nsfw, `have_photo_safe` = :have_photo_safe, `have_photo_360` = :have_photo_360, `no_photo_percent` = :no_photo_percent, `rf_rate_value` = :rf_rate_value, `rf_rate_count` = :rf_rate_count, `rf_wished` = :rf_wished, `rf_ordered` = :rf_ordered, `rf_owned` = :rf_owned, `world_rate_value` = :world_rate_value, `world_rate_count` = :world_rate_count, `world_wished` = :world_wished, `world_ordered` = :world_ordered, `world_owned` = :world_owned, `world_listed` = :world_listed, `top_owned` = :top_owned, `top_ordered` = :top_ordered, `top_wished` = :top_wished, `top_rated` = :top_rated, `top_score` = :top_score, `top_score_detail` = :top_score_detail, `buy_price` = :buy_price, `sell_price` = :sell_price, `sell_status_item` = :sell_status_item, `sell_status_box` = :sell_status_box, `sell_desc` = :sell_desc, `can_curl` = :can_curl, `curl_error` = :curl_error, `date_created` = :date_created, `created_by` = :created_by, `date_last_curl` = :date_last_curl, `last_curl_by` = :last_curl_by, `date_last_requested` = :date_last_requested, `total_view` = :total_view, `date_last_viewed` = :date_last_viewed, `has_duplicate` = :has_duplicate, `is_duplicate` = :is_duplicate, `is_cancel` = :is_cancel, `is_deleted` = :is_deleted WHERE `id` = :id": SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect date value: '0000-00-00' for column 'release_date' at row 1 (Error Code: 0)
${PradoFramework}/Data/TDbCommand.php (195)
0184: {
0185: try {
0186: // Do not trace because it will remain even in Performance mode
0187: // Prado::trace('Execute Command: '.$this->getDebugStatementText(), TDbCommand::class);
0188: if ($this->_statement instanceof PDOStatement) {
0189: $this->_statement->execute();
0190: return $this->_statement->rowCount();
0191: } else {
0192: return $this->getConnection()->getPdoInstance()->exec($this->getText());
0193: }
0194: } catch (Exception $e) {
0195: throw new TDbException('dbcommand_execute_failed', $e->getMessage(), $this->getDebugStatementText());
0196: }
0197: }
0198:
0199: /**
0200: * @return string prepared SQL text for debugging purposes.
0201: */
0202: public function getDebugStatementText()
0203: {
0204: //if(Prado::getApplication()->getMode() === TApplicationMode::Debug)
0205: return $this->_statement instanceof PDOStatement ?
0206: $this->_statement->queryString
0207: : $this->getText();
#0 ${PradoFramework}/Data/DataGateway/TDataGatewayCommand.php(100): Prado\Data\TDbCommand->execute()
#1 ${PradoFramework}/Data/DataGateway/TDataGatewayCommand.php(110): Prado\Data\DataGateway\TDataGatewayCommand->update()
#2 ${PradoFramework}/Data/ActiveRecord/TActiveRecordGateway.php(371): Prado\Data\DataGateway\TDataGatewayCommand->updateByPk()
#3 ${PradoFramework}/Data/ActiveRecord/TActiveRecord.php(445): Prado\Data\ActiveRecord\TActiveRecordGateway->update()
#4 ${DocumentRoot}/protected/class/models/modelFigure.php(791): Prado\Data\ActiveRecord\TActiveRecord->save()
#5 ${DocumentRoot}/protected/pages/item.php(34): modelFigure->updateFigure()
#6 ${PradoFramework}/Web/UI/TControl.php(1376): item->onLoad()
#7 ${PradoFramework}/Web/UI/TPage.php(242): Prado\Web\UI\TControl->loadRecursive()
#8 ${PradoFramework}/Web/UI/TPage.php(222): Prado\Web\UI\TPage->processNormalRequest()
#9 ${PradoFramework}/Web/Services/TPageService.php(536): Prado\Web\UI\TPage->run()
#10 ${PradoFramework}/Web/Services/TPageService.php(454): Prado\Web\Services\TPageService->runPage()
#11 ${PradoFramework}/TApplication.php(1329): Prado\Web\Services\TPageService->run()
#12 ${PradoFramework}/TApplication.php(410): Prado\TApplication->runService()
#13 ${DocumentRoot}/index.php(33): Prado\TApplication->run()
#14 {main}