Mythexport fails to find recording for export

[Steve Switzer]

Binary package hint: mythexport

Around line # 235, just after creating a mysql dump the following line is called:

export("starttime=$currentstarttime&chanid=currentchanid&config=$block&otg=true");

This should be changed to:

export("starttime=$currentstarttime&chanid=$currentchanid&config=$block&otg=true");

Without this fix, the following occurs, making it appear like an ffmpeg issue. However, notice that chanid is set to text name of the variable part way through, instead of the contents of the variable:

September 25 18:40:33 Typhoon /usr/bin/mythexport-daemon[1431]: Starting Processing: 1285454433
September 25 18:40:33 Typhoon /usr/bin/mythexport-daemon[1431]: query = select id, type, param from mythexport_job_queue order by id at line 569 in /usr/bin/mythexport-daemon
September 25 18:40:33 Typhoon /usr/bin/mythexport-daemon[1431]: exportdir = /srv/raid/mythexport at line 143 in /usr/bin/mythexport-daemon
September 25 18:40:33 Typhoon /usr/bin/mythexport-daemon[1431]: starttime = 2010-09-23 20:59:00 at line 144 in /usr/bin/mythexport-daemon
September 25 18:40:33 Typhoon /usr/bin/mythexport-daemon[1431]: chanid = 1311 at line 145 in /usr/bin/mythexport-daemon
September 25 18:40:33 Typhoon /usr/bin/mythexport-daemon[1431]: config = Steve_Podcast at line 146 in /usr/bin/mythexport-daemon
September 25 18:40:33 Typhoon /usr/bin/mythexport-daemon[1431]: query = SELECT rec.title, rec.subtitle, rec.description, pg.syndicatedepisodenumber, pg.showtype, rec.programid, rec.basename, rec.chanid, rec.starttime
        FROM recorded rec LEFT JOIN program pg ON pg.starttime = rec.starttime AND pg.chanid = rec.chanid WHERE (rec.chanid='1311' and rec.starttime='2010-09-23 20:59:00') at line 174 in /usr/bin/mythexport-daemon
September 25 18:40:33 Typhoon /usr/bin/mythexport-daemon[1431]: Creating xml file
September 25 18:40:33 Typhoon /usr/bin/mythexport-daemon[1431]: Creating mysql dump
September 25 18:40:33 Typhoon /usr/bin/mythexport-daemon[1431]: exportdir = /srv/raid/mythexport at line 366 in /usr/bin/mythexport-daemon
September 25 18:40:33 Typhoon /usr/bin/mythexport-daemon[1431]: starttime = 20100923205900 at line 367 in /usr/bin/mythexport-daemon
September 25 18:40:33 Typhoon /usr/bin/mythexport-daemon[1431]: chanid = currentchanid at line 368 in /usr/bin/mythexport-daemon
September 25 18:40:33 Typhoon /usr/bin/mythexport-daemon[1431]: config = true at line 369 in /usr/bin/mythexport-daemon
September 25 18:40:33 Typhoon /usr/bin/mythexport-daemon[1431]: query = SELECT rec.title, rec.subtitle, rec.description, pg.syndicatedepisodenumber, pg.showtype, rec.programid, rec.basename, rec.starttime
    FROM recorded rec LEFT JOIN program pg ON pg.starttime = rec.starttime AND pg.chanid = rec.chanid
    WHERE rec.chanid=? AND rec.starttime=? at line 379 in /usr/bin/mythexport-daemon
September 25 18:40:33 Typhoon /usr/bin/mythexport-daemon[1431]: Going into new mode
 at line 396 in /usr/bin/mythexport-daemon
September 25 18:40:33 Typhoon /usr/bin/mythexport-daemon[1431]: query = SELECT callsign FROM channel WHERE chanid=? at line 404 in /usr/bin/mythexport-daemon
September 25 18:40:33 Typhoon /usr/bin/mythexport-daemon[1431]: ERROR: No resulting file from ffmpeg, most likely your ffmpeg failed. Enable debugging and test by hand. at line 533 in /usr/bin/mythexport-daemon

[Steve Switzer (steve-switzer)]

NOTE: my line numbers are estimates, since I added several "logdebug" lines while tracking this down.

[Steve Switzer (steve-switzer)]

--- /usr/bin/mythexport-daemon 2010-04-14 21:20:42.000000000 -0400
+++ /usr/bin/mythexport-daemon.647911 2010-09-26 02:21:35.152487952 -0400
@@ -231,7 +231,7 @@
         $writer->endTag("item");

         $log->notice("Creating mysql dump");
- export("starttime=$currentstarttime&chanid=currentchanid&config=$block&otg=true");
+ export("starttime=$currentstarttime&chanid=$currentchanid&config=$block&otg=true");
     }
     $writer->endTag("channel");
     $writer->end();