Since 09cb61a (schema: Remove invalid default values for TEXT columns,
2017-04-15) the PackageRequests.ClosureComment field no longer has a
default value.

Signed-off-by: Johannes Löthberg <johan...@kyriasis.com>
---
 web/lib/pkgreqfuncs.inc.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/web/lib/pkgreqfuncs.inc.php b/web/lib/pkgreqfuncs.inc.php
index b8be7e5..079df38 100644
--- a/web/lib/pkgreqfuncs.inc.php
+++ b/web/lib/pkgreqfuncs.inc.php
@@ -165,10 +165,10 @@ function pkgreq_file($ids, $type, $merge_into, $comments) 
{
 
        $q = "INSERT INTO PackageRequests ";
        $q.= "(ReqTypeID, PackageBaseID, PackageBaseName, MergeBaseName, ";
-       $q.= "UsersID, Comments, RequestTS) VALUES (" . $type_id . ", ";
+       $q.= "UsersID, Comments, ClosureComment, RequestTS) VALUES (" . 
$type_id . ", ";
        $q.= $base_id . ", " .  $dbh->quote($pkgbase_name) . ", ";
        $q.= $dbh->quote($merge_into) . ", " . $uid . ", ";
-       $q.= $dbh->quote($comments) . ", " . strval(time()) . ")";
+       $q.= $dbh->quote($comments) . ", '', " . strval(time()) . ")";
        $dbh->exec($q);
        $request_id = $dbh->lastInsertId();
 
-- 
2.22.0

Reply via email to