mythbuntu-bugs team mailing list archive

[Malcolm Parsons <663314@xxxxxxxxxxxxxxxxxx>]

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 Mythbuntu
Bug Team, which is subscribed to mythexport in ubuntu.

Status in “mythexport” package in Ubuntu: Fix Committed

Bug description:
Binary package hint: mythexport

$ apt-cache policy mythexport 
mythexport:
  Installed: 2.2.2-0ubuntu1~ppa8
  Candidate: 2.2.2-0ubuntu1~ppa8
  Version table:
 *** 2.2.2-0ubuntu1~ppa8 0
        500 http://ppa.launchpad.net/mythbuntu/testing/ubuntu/ lucid/main Packages
        100 /var/lib/dpkg/status
     2.1.5-0ubuntu1 0
        500 http://gb.archive.ubuntu.com/ubuntu/ lucid/universe Packages

Observed: All exported files have a blank podcast name.
Expected: Exported files have the supplied podcast name.

setupsave.cgi creates userjobs with deleteperiod and podcastname arguments to mythexport_addjob.

e.g.
"mythexport_addjob starttime=%STARTTIME% chanid=%CHANID% config=MP3
deleteperiod=14 podcastname=MP3"

The mythexport_addjob script doesn't have deleteperiod or podcastname arguments.