diff --git a/db/archives.go b/db/archives.go
index <HASH>..<HASH> 100644
--- a/db/archives.go
+++ b/db/archives.go
@@ -228,10 +228,7 @@ func (db *DB) PurgeArchive(id uuid.UUID) error {
 		return fmt.Errorf("Invalid attempt to purge a 'valid' archive detected")
 	}
 
-	err = db.Exec(`UPDATE archives SET purge_reason =
-                       (SELECT status FROM archives WHERE uuid = ?)
-                       WHERE uuid = ?
-                  `, id.String(), id.String())
+	err = db.Exec(`UPDATE archives SET purge_reason = status WHERE uuid = ?`, id.String())
 	if err != nil {
 		return err
 	}
Simplify purge_reason update SQL

It should now work on PostgreSQL and MySQL (as well as SQLite tests)