[patch] /usr/local/portage/www-apps/bacula-web/files/bacula-web-1.38.5-nulldate.patch

bacula-web-1.38.5-nulldate.patch (text/plain), 1.90 KB, created by John M. Drescher on 2006-03-18 20:31:10 UTC

--- classes.old.inc	2006-03-12 00:38:33.000000000 -0500
+++ classes.inc	2006-03-12 00:39:17.000000000 -0500
@@ -124,9 +124,9 @@
                 $res = $this->link->query("SELECT Name FROM Pool");
                 while ( $tmp =& $res->fetchRow() ) {
                         if ($this->driver == "mysql" )
-                                $result = $this->link->query("select Media.VolumeName, Media.VolBytes,Media.VolStatus,Pool.Name,Media.MediaType,Media.LastWritten,FROM_UNIXTIME(UNIX_TIMESTAMP(Media.LastWritten)+Media.VolRetention ) as expire from Pool LEFT JOIN Media ON Media.PoolId=Pool.PoolId where Name='$tmp[0]' order by Media.VolumeName");
+                                $result = $this->link->query("select Media.VolumeName, Media.VolBytes,Media.VolStatus,Pool.Name,Media.MediaType,Media.LastWritten,FROM_UNIXTIME(UNIX_TIMESTAMP(Media.LastWritten)+Media.VolRetention ) as expire from Pool LEFT JOIN Media ON Media.PoolId=Pool.PoolId where Name='$tmp[0]' AND Media.LastWritten IS NOT NULL order by Media.VolumeName");
                         else if ($this->driver == "pgsql")
-				$result = $this->link->query("select Media.VolumeName, Media.VolBytes,Media.VolStatus,Pool.Name,Media.MediaType,Media.LastWritten, Media.LastWritten + Media.VolRetention * interval '1 second' as expire from Pool LEFT JOIN Media ON Media.PoolId=Pool.PoolId where Name='$tmp[0]' order by Media.VolumeName");
+				$result = $this->link->query("select Media.VolumeName, Media.VolBytes,Media.VolStatus,Pool.Name,Media.MediaType,Media.LastWritten, Media.LastWritten + Media.VolRetention * interval '1 second' as expire from Pool LEFT JOIN Media ON Media.PoolId=Pool.PoolId where Name='$tmp[0]' AND Media.LastWritten IS NOT NULL order by Media.VolumeName");
                         while ( $tmp1 = $result->fetchRow() ) {
                                 $pos = array_key_exists($tmp[0],$volume);
                                 if ($pos != FALSE)