diff options
| author | Greg Roach <fisharebest@gmail.com> | 2015-10-05 21:22:07 +0100 |
|---|---|---|
| committer | Greg Roach <fisharebest@gmail.com> | 2015-10-05 21:22:07 +0100 |
| commit | 1bd0d052313c2053708c84258fdd3c9ffd04c273 (patch) | |
| tree | edf29e237bdbfa6733e4b6749f57b0ac3a470625 /editnews.php | |
| parent | 912f537ada097d00b52a4e9cb8209cc2a9c85e97 (diff) | |
| download | webtrees-1bd0d052313c2053708c84258fdd3c9ffd04c273.tar.gz webtrees-1bd0d052313c2053708c84258fdd3c9ffd04c273.tar.bz2 webtrees-1bd0d052313c2053708c84258fdd3c9ffd04c273.zip | |
Do not rely on DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
Diffstat (limited to 'editnews.php')
| -rw-r--r-- | editnews.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/editnews.php b/editnews.php index 278a71629f..e495f7952e 100644 --- a/editnews.php +++ b/editnews.php @@ -79,7 +79,7 @@ case 'save': if ($news_id) { Database::prepare("UPDATE `##news` SET subject=?, body=?, updated=FROM_UNIXTIME(?) WHERE news_id=?")->execute(array($title, $text, $date, $news_id)); } else { - Database::prepare("INSERT INTO `##news` (user_id, gedcom_id, subject, body) VALUES (NULLIF(?, ''), NULLIF(?, '') ,? ,?)")->execute(array($user_id, $gedcom_id, $title, $text)); + Database::prepare("INSERT INTO `##news` (user_id, gedcom_id, subject, body, updated) VALUES (NULLIF(?, ''), NULLIF(?, '') ,? ,?, CURRENT_TIMESTAMP)")->execute(array($user_id, $gedcom_id, $title, $text)); } $controller->addInlineJavascript('window.opener.location.reload();window.close();'); |