[mythtv-users] Scheduler mysql problems

[Paul Wootton]

On 30 Mar 2013, at 20:06, David Engel <david at istwok.net> wrote:

> On Fri, Mar 29, 2013 at 10:35:57PM +0000, Paul Wootton wrote:
>> 
>> On 29 Mar 2013, at 22:23, David Engel <david at istwok.net> wrote:
>> 
>>> On Fri, Mar 29, 2013 at 08:40:26PM +0000, Paul Wootton wrote:
>>>> I've started seeing the following sql error messages in my backend logs...
>>>> 
>>>> Mar 23 20:57:10 boswell mythlogserver: mythbackend[8485]: E Scheduler mythdbcon.cpp:837 (prepare) Error preparing query: REPLACE INTO recordmatch (recordid, chanid, starttime, manualid,                           oldrecduplicate, findid) SELECT record.recordid, program.chanid, program.starttime,  IF(search = 5, record.recordid, 0), (CASE   WHEN record.type IN (1, 7, 8) THEN  0   WHEN record.type IN (6, 9, 10) THEN  -1   ELSE (program.generic - 1)  END) , (CASE record.type   WHEN 6    THEN record.findid   WHEN 9    THEN to_days(date_sub(convert_tz(program.starttime, 'UTC', 'SYSTEM'),             interval time_format(record.findtime, '%H:%i') hour_minute))   WHEN 10    THEN floor((to_days(date_sub(convert_tz(program.starttime, 'UTC',             'SYSTEM'), interval time_format(record.findtime, '%H:%i')             hour_minute)) - record.findday)/7) * 7 + record.findday   WHEN 7    THEN record.findid   ELSE 0  END) FROM (record, program INNER JOIN channel       ON channel.ch
> an
>> i
>>> d 
>>>> = program.chanid)  WHERE record.recordid = :NR0RECID AND program.manualid = 0 AND ( title like '%rhod gilbert%' ) AND channel.visible = 1  AND program.endtime > (NOW() - INTERVAL 480 MINUTE) AND (((record.filter & 1) = 0) OR (program.previouslyshown = 0)) AND (((record.filter & 2) = 0) OR (program.generic = 0)) AND (((record.filter & 4) = 0) OR (program.first > 0)) AND (((record.filter & 8) = 0) OR (HOUR(CONVERT_TZ(program.starttime, 'UTC', 'SYSTEM')) >= 19 AND HOUR(CONVERT_TZ(program.starttime, 'UTC', 'SYSTEM')) < 22)) AND (((record.filter & 16) = 0) OR (channel.commmethod = -2)) AND (((record.filter & 32) = 0) OR (program.hdtv > 0)) AND (((record.filter & 64) = 0) OR ((record.programid <> '' AND program.programid = record.programid) OR (record.programid = '' AND program.subtitle = record.subtitle AND program.description = record.description))) AND (((record.filter & 128) = 0) OR ((record.seriesid <> '' AND program.seriesid = record.seriesid))) AND ((record.type = 4 OR 
> re
>>> co
>>>> rd.type = 6 OR record.type = 9 OR record.type
>>>> Mar 23 20:57:10 boswell mythlogserver: mythbackend[8485]: E Scheduler mythdbcon.cpp:839 (prepare) Driver error was [2/1052]:#012QMYSQL3: Unable to prepare statement#012Database error was:#012Column 'title' in where clause is ambiguous
>>>> 
>>>> I've done a check and repair in mythweb, and also restarted the backend, but I'm still seeing the messages.
>>>> 
>>>> Are they serious, and what can I do to help diagnose/fix them?
>>> 
>>> "title like '%rhod gilbert%'" is the problem.  Did you recently create
>>> a power or other type of search with the SQL phrase?
>>> 
>>> David
>>> -- 
>>> David Engel
>>> david at istwok.net
>>> _______________________________________________
>>> mythtv-users mailing list
>>> mythtv-users at mythtv.org
>>> http://www.mythtv.org/mailman/listinfo/mythtv-users
>> 
>> Bingo!  I was trying to amalgamate a few recording rules, and I managed to create this one.  Should be program.title... shouldn't it.  No sorted, 
> 
> Yes, use "program.title".
> 
> David
> -- 
> David Engel
> david at istwok.net
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users

'no sorted' should have read now sorted :-)
And it's hit on a radio4 extra recording for next Saturday - That's part of my taste in comedy revealed

-- Paul --