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;
--------------------------------------------------------------------------------

Post a comment in response:

This account has disabled anonymous posting.
If you don't have an account you can create one now.
No Subject Icon Selected
More info about formatting

If you are unable to use this captcha for any reason, please contact us by email at support@dreamwidth.org