diff options
author | diosmosis <diosmosis@users.noreply.github.com> | 2020-11-18 06:23:46 +0300 |
---|---|---|
committer | GitHub <noreply@github.com> | 2020-11-18 06:23:46 +0300 |
commit | b01ce3bb4ec6e350b44ceef93899ab4cf4946ebe (patch) | |
tree | dc5de9bc310d783b4dbcc00465dc4819702197c4 | |
parent | 7c3d9f1f1c054687c59171e6c68b217bd4966d55 (diff) |
query tweaks for setting/unsetting ts_started in invalidation table (#16737)
-rw-r--r-- | core/DataAccess/Model.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/core/DataAccess/Model.php b/core/DataAccess/Model.php index 30a804440b..d6d2de787e 100644 --- a/core/DataAccess/Model.php +++ b/core/DataAccess/Model.php @@ -632,7 +632,7 @@ class Model $table = Common::prefixTable('archive_invalidations'); // set archive value to in progress if not set already - $statement = Db::query("UPDATE `$table` SET `status` = ? AND ts_started = NOW() WHERE idinvalidation = ? AND status = ?", [ + $statement = Db::query("UPDATE `$table` SET `status` = ?, ts_started = NOW() WHERE idinvalidation = ? AND status = ?", [ ArchiveInvalidator::INVALIDATION_STATUS_IN_PROGRESS, $invalidation['idinvalidation'], ArchiveInvalidator::INVALIDATION_STATUS_QUEUED, @@ -864,7 +864,7 @@ class Model public function releaseInProgressInvalidation($idinvalidation) { $table = Common::prefixTable('archive_invalidations'); - $sql = "UPDATE $table SET status = " . ArchiveInvalidator::INVALIDATION_STATUS_QUEUED . " WHERE idinvalidation = ?"; + $sql = "UPDATE $table SET status = " . ArchiveInvalidator::INVALIDATION_STATUS_QUEUED . ", ts_started = NULL WHERE idinvalidation = ?"; Db::query($sql, [$idinvalidation]); } |