[mythtv] Commercial flagging go bye-bye
Curtis Stanford
curtis at stanfordcomputing.com
Fri Dec 17 02:18:03 UTC 2004
OK, I'll answer my own question, in programinfo.cpp there is a query
which can't work (to my eyes anyway):
SELECT recorded.chanid,starttime,endtime,title,
subtitle,description,channel.channum,
channel.callsign,channel.name,channel.commfree,
channel.outputfilters,seriesid,programid,filesize,
lastmodified,stars,previouslyshown,originalairdate,
category_type, hostname
FROM recorded
LEFT JOIN channel
ON recorded.chanid = channel.chanid
WHERE recorded.chanid = %1
AND starttime = %2;
The category_type field was added in the last CVS version but there is
no category_type field in either the recorded or channel tables. HUH?
Curtis
On Dec 16, 2004, at 7:06 PM, Curtis Stanford wrote:
> More info on this. I've looked at the jobqueue table and the comment
> field says 'Unable to retrieve Program Info from database' for all the
> jobs. Now that I think of it, this started happening after the last db
> schema upgrade.
>
> On Dec 16, 2004, at 11:31 AM, Curtis Stanford wrote:
>
>> None at all. I haven't changed anything from when it worked before
>> (except the CVS code, of course). I've turned on verbose commflag and
>> I'll see what happens next time I record something.
>>
>> On Dec 16, 2004, at 10:59 AM, Asher Schaffer wrote:
>>
>>> Is there any mention of commercial flagging in the backend log? I
>>> had
>>> this problem a while ago until I realized it was cause /usr/local/bin
>>> wasn't part of the path that the backend was running under. I made a
>>> sym link for the commflag exec to /usr/bin and now it works fine.
>>>
>>>
>>> On Thu, 16 Dec 2004 10:18:55 -0700, Curtis Stanford
>>> <curtis at stanfordcomputing.com> wrote:
>>>> The CVS version of mythtv seems to have lost its commercial flagging
>>>> ability in the last few days. New shows are not commercial flagged
>>>> and
>>>> a manual invocation of commercial flagging does nothing. Nothing
>>>> shows
>>>> up in the job queue. I don't see any messages coming from the back
>>>> or
>>>> frontend.
>>>>
>>>> Curtis
>>>>
>>>>
>>>> _______________________________________________
>>>> mythtv-dev mailing list
>>>> mythtv-dev at mythtv.org
>>>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
>>>>
>>>>
>>>>
>>> _______________________________________________
>>> mythtv-dev mailing list
>>> mythtv-dev at mythtv.org
>>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
>>
>> _______________________________________________
>> mythtv-dev mailing list
>> mythtv-dev at mythtv.org
>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
>
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
More information about the mythtv-dev
mailing list