I've applied this patch to my install to make the "Filter by Podcast
Name" box work when not all files have a podcast name:

--- /usr/share/mythtv/mythexport/rss.cgi.orig   2010-11-01 13:51:42.611370959 
+0000
+++ /usr/share/mythtv/mythexport/rss.cgi        2010-11-01 13:52:03.023371905 
+0000
@@ -28,7 +28,7 @@
 my $script = "<script type=\"text/javascript\" 
src=\"includes/ajax.js\"></script>";
 
 # find all podcast names
-my $query = "SELECT distinct(podcastName) FROM mythexport";
+my $query = "SELECT distinct(podcastName) FROM mythexport WHERE podcastName is 
not NULL";
 my $query_handle = $connect->prepare($query);
 $query_handle->execute()  || die "Unable to query mythexport table";

-- 
mythexport podcast name feature does not work
https://bugs.launchpad.net/bugs/663314
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to