[dw-free] Better query for counting jobs in queue.

[mark]

[commit: http://hg.dwscoalition.org/dw-free/rev/069e1278fc1a]

Better query for counting jobs in queue.

Patch by mark.

Files modified:

• cgi-bin/LJ/Widget/ImportQueueStatus.pm

--------------------------------------------------------------------------------
diff -r eb68f7d738f0 -r 069e1278fc1a cgi-bin/LJ/Widget/ImportQueueStatus.pm
--- a/cgi-bin/LJ/Widget/ImportQueueStatus.pm	Fri May 01 07:42:43 2009 +0000
+++ b/cgi-bin/LJ/Widget/ImportQueueStatus.pm	Fri May 01 07:47:59 2009 +0000
@@ -47,7 +47,7 @@ sub render_body {
             my $ct = $dbr->selectrow_array(
                 q{SELECT COUNT(*) FROM job
                   WHERE funcid = ?
-                    AND ( run_after IS NULL OR run_after < UNIX_TIMESTAMP() )},
+                    AND run_after < UNIX_TIMESTAMP()},
                 undef, $tmpmap->{$map}
             )+0;
 
--------------------------------------------------------------------------------