[mythtv-users] MythTV-0.19 and MySQL 5.0.18 Won't play nicely

John Johnson johnatl at mac.com
Sat Feb 25 21:31:43 UTC 2006


Hello All,

MythTV has been working well for me for a good while. I seem to have 
partially hosed it when I installed MySQL 5 for another application. I 
found out that I needed MythTV 0.19 (I was running 0.18), so I've 
installed the requisite packages. There is one problem I've found, and 
that has to do with my People Searches.

To paraphrase (complete text below):
Unknown column 'program.chanid' in 'on clause'


Which is odd, since I see it is part of the SELECT statement. I'm not 
to fluent on INNER JOINs and the like. Any ideas greatly appreciated!

Regards,
   JJ

uname -a
Linux me.example.com 2.6.12-1.1381_FC3smp #1 SMP Fri Oct 21 04:03:26 
EDT 2005 i686 i686 i386 GNU/Linux

Clipped from /var/log/myth/mythbackend.log (repeats 154 times, once for 
each person search)

2006-02-25 16:13:37.930 DB Error (UpdateMatches):
Query was:
INSERT INTO recordmatch (recordid, chanid, starttime, manualid) SELECT 
record.recordid, program.chanid, program.starttime,  IF(search = 5, 
recordid, 0) FROM record, program , people, credits INNER JOIN channel 
ON (channel.chanid = program.chanid) WHERE record.recordid = '6865' AND 
program.manualid = 0 AND people.name LIKE 'john johnson' AND 
credits.person = people.person AND program.chanid = credits.chanid AND 
program.starttime = credits.starttime AND channel.visible = 1 AND 
((record.type = 4 OR record.type = 6 OR record.type = 9 OR record.type 
= 10)  OR  ((record.station = channel.callsign)   AND   ((record.type = 
3)    OR   ((TIME_TO_SEC(record.starttime) = 
TIME_TO_SEC(program.starttime))     AND     ((record.type = 2)      OR  
    ((DAYOFWEEK(record.startdate) = DAYOFWEEK(program.starttime)       
AND       ((record.type = 5)        OR       
((TO_DAYS(record.startdate) = TO_DAYS(program.starttime))         )     
   )      )     )    )   )  ) ))
Driver error was [2/1054]:
QMYSQL3: Unable to execute query
Database error was:
Unknown column 'program.chanid' in 'on clause'

yum list installed | grep myth

libmyth.i386                             0.19-122.rhfc3.at      
installed
mythbrowser.i386                         0.19-120.rhfc3.at      
installed
mythcontrols.i386                        0.19-120.rhfc3.at      
installed
mythdvd.i386                             0.19-120.rhfc3.at      
installed
mythflix.i386                            0.19-120.rhfc3.at      
installed
mythgallery.i386                         0.19-120.rhfc3.at      
installed
mythgame.i386                            0.19-120.rhfc3.at      
installed
mythmkmovie.i386                         1.1.4-4.rhfc3.at       
installed
mythmusic.i386                           0.19-120.rhfc3.at      
installed
mythnews.i386                            0.19-120.rhfc3.at      
installed
mythphone.i386                           0.19-120.rhfc3.at      
installed
mythplugins.i386                         0.19-120.rhfc3.at      
installed
myththemes.noarch                        0.19-105.at            
installed
mythtv.i386                              0.19-122.rhfc3.at      
installed
mythtv-backend.i386                      0.19-122.rhfc3.at      
installed
mythtv-frontend.i386                     0.19-122.rhfc3.at      
installed
mythtv-setup.i386                        0.19-122.rhfc3.at      
installed
mythtv-suite.i386                        0.18.1-55.at           
installed
mythtv-theme-MediaCenter.noarch          0.17-4.at              
installed
mythtv-theme-MythCenter.noarch           0.17-1.at              
installed
mythtv-theme-abstract.noarch             0.20040910-2.at        
installed
mythtv-theme-isthmus.noarch              0.20040804-1.at        
installed
mythtv-theme-photo.noarch                4-6.at                 
installed
mythtv-theme-purplegalaxy.noarch         0.20031214-3.at        
installed
mythtv-theme-sleek.noarch                0.35-2.at              
installed
mythtv-theme-visor.noarch                1:0.16.2-5.at          
installed
mythtv-themes.i386                       0.19-122.rhfc3.at      
installed
mythvideo.i386                           0.19-120.rhfc3.at      
installed
mythweather.i386                         0.19-120.rhfc3.at      
installed
mythweb.noarch                           0.19-71.at             
installed

mysqladmin version

mysqladmin  Ver 8.41 Distrib 5.0.18, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version          5.0.18-standard-log
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /tmp/mysql.sock
Uptime:                 6 hours 4 min 57 sec

Threads: 11  Questions: 338605  Slow queries: 0  Opens: 0  Flush 
tables: 1  Open tables: 55  Queries per second avg: 15.464





---
Help everyone. If you can't do that, then at least be nice.



More information about the mythtv-users mailing list