[mythtv-users] SchedulesDirect Changes

[Robert Kulagowski]

On Fri, Sep 26, 2014 at 12:16 PM, Brian J. Murrell
<brian at interlinx.bc.ca> wrote:
> On Fri, 2014-09-26 at 11:20 -0500, Robert Kulagowski wrote:
>> Which sourceid do you want to extract:>1
>
> How do I know what are valid sourceids?  I tried 1, 2, 3, etc. and
> always seem to get:
>
> PHP Fatal error:  Call to a member function prepare() on a non-object in /net/linux/src/mfdb-json/sd-utility.php on line 1730

The only way that I can see that happening is if the $dbh isn't valid
by the time that routine gets called. If you run another git pull and
you're on API-20140530, I've added code to handle that earlier in the
startup phase, and to dump what the actual error is if we can't get
the $dbh.

You can also do this:

mysql -umythtv -pmythtv mythconverg -e 'select sourceid,name,lineupid
from videosource order by sourceid;'

That will dump out the sourceid's and the names, but we'd need to
determine why you're not getting a db handle first.

> Is there some amount of sd-utility.php that I need to run to get to a
> point of being able to extract this existing clearqam data from my
> current MythTV database?  If so how much can I run without mucking up my
> existing installation?

That's what we're trying to establish; the minimum baseline.

Since this is only peripherally related to MythTV we can move this to
email, or to the Schedules Direct forums.