r4339 commitReplaceFile(): reset thumbnail on update

replaceFile(): dissmiss local UPDATE statement

diff --git a/wwwroot/inc/database.php b/wwwroot/inc/database.php
index 4ba9dfb9f0688b362580445a53b3da7db39eb93a..36cf4f2462cad1c2c1cb1180e6a8c91c80594d85 100644 (file)
--- a/wwwroot/inc/database.php
+++ b/wwwroot/inc/database.php
@@ -3592,7 +3592,7 @@ function commitAddFile ($name, $type, $contents, $comment)
 function commitReplaceFile ($file_id = 0, $contents)
 {
        global $dbxlink;
-       $query = $dbxlink->prepare('UPDATE File SET mtime = NOW(), contents = ?, size = LENGTH(contents) WHERE id = ?');
+       $query = $dbxlink->prepare('UPDATE File SET mtime = NOW(), contents = ?, size = LENGTH(contents), thumbnail = NULL WHERE id = ?');
        $query->bindParam(1, $contents, PDO::PARAM_LOB);
        $query->bindParam(2, $file_id);
 

diff --git a/wwwroot/inc/ophandlers.php b/wwwroot/inc/ophandlers.php
index a287c8fa076f87b4eb73c66cea3f18be86b9c8f7..253be49151adeef55dfa5851a4d60bc939e0d4a8 100644 (file)
--- a/wwwroot/inc/ophandlers.php
+++ b/wwwroot/inc/ophandlers.php
@@ -2171,12 +2171,6 @@ function replaceFile ()
        if (FALSE === commitReplaceFile ($sic['file_id'], $fp))
                return buildRedirectURL (__FUNCTION__, 'ERR3');
 
-       usePreparedExecuteBlade
-       (
-               'UPDATE File SET thumbnail = NULL WHERE id = ?',
-               $sic['file_id']
-       );
-
        return buildRedirectURL (__FUNCTION__, 'OK', array (htmlspecialchars ($shortInfo['name'])));
 }