fu: Close-up of Fu, bringing a scoop of water to her mouth (Default)
fu ([personal profile] fu) wrote in [site community profile] changelog2010-05-27 07:08 am

[dw-free] Remove repeated WHERE

[commit: http://hg.dwscoalition.org/dw-free/rev/9cec2ef5ae1a]

http://bugs.dwscoalition.org/show_bug.cgi?id=2628

Fix deletion of comment metadata when the comment is deleted.

Patch from LiveJournal.

Files modified:
  • cgi-bin/ljlib.pl
--------------------------------------------------------------------------------
diff -r 2611214434c0 -r 9cec2ef5ae1a cgi-bin/ljlib.pl
--- a/cgi-bin/ljlib.pl	Wed May 26 19:56:58 2010 +0800
+++ b/cgi-bin/ljlib.pl	Thu May 27 15:13:59 2010 +0800
@@ -1782,7 +1782,7 @@ sub delete_comments {
 
     if ($num > 0) {
         $u->do("UPDATE talktext2 SET subject=NULL, body=NULL $where");
-        $u->do("DELETE FROM talkprop2 WHERE $where");
+        $u->do("DELETE FROM talkprop2 $where");
     }
 
     my @jobs;
--------------------------------------------------------------------------------