From b1779f28a5f15f7ad39855e07a27fcda19b8d3f1 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Fr=C3=A9d=C3=A9ric=20Buclin?= Date: Tue, 17 Apr 2012 02:13:34 +0200 Subject: [PATCH] Bug 745080: Voting extension causes database deadlocks r=glob a=LpSolit --- extensions/Voting/Extension.pm | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/extensions/Voting/Extension.pm b/extensions/Voting/Extension.pm index 43c5821a7e..b4352fa2f2 100644 --- a/extensions/Voting/Extension.pm +++ b/extensions/Voting/Extension.pm @@ -467,7 +467,10 @@ sub _page_user { } } - $dbh->do('DELETE FROM votes WHERE vote_count <= 0'); + if ($canedit && $bug) { + $dbh->do('DELETE FROM votes WHERE vote_count = 0 AND who = ?', + undef, $who->id); + } $dbh->bz_commit_transaction(); $vars->{'canedit'} = $canedit; -- 2.47.2