[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