[mythtv-users] MythTV-0.19 and MySQL 5.0.18 Won't play nicely
John Johnson
johnatl at mac.com
Sat Feb 25 22:27:24 UTC 2006
Thanks for the reply Kevin. Everything seems to be intact in the
program table. The schema for the tables involved are attached below.
All the other recording types seem to be working okay. The People
Search ones are the only ones it is complaining about.
Thanks again!
Regards,
JJ
dell john 17:26 mythtv $ mysql -e "show columns from program"
+-------------------------+------------------+------+-----
+---------------------+-------+
| Field | Type | Null | Key | Default
| Extra |
+-------------------------+------------------+------+-----
+---------------------+-------+
| chanid | int(10) unsigned | NO | PRI | 0
| |
| starttime | datetime | NO | PRI | 0000-00-00
00:00:00 | |
| endtime | datetime | NO | MUL | 0000-00-00
00:00:00 | |
| title | varchar(128) | NO | MUL |
| |
| subtitle | varchar(128) | NO | |
| |
| description | text | NO | |
| |
| category | varchar(64) | NO | |
| |
| category_type | varchar(64) | NO | |
| |
| airdate | year(4) | NO | | 0000
| |
| stars | float | NO | | 0
| |
| previouslyshown | tinyint(4) | NO | | 0
| |
| title_pronounce | varchar(128) | NO | MUL |
| |
| stereo | tinyint(1) | NO | | 0
| |
| subtitled | tinyint(1) | NO | | 0
| |
| hdtv | tinyint(1) | NO | | 0
| |
| closecaptioned | tinyint(1) | NO | | 0
| |
| partnumber | int(11) | NO | | 0
| |
| parttotal | int(11) | NO | | 0
| |
| seriesid | varchar(12) | NO | MUL |
| |
| originalairdate | date | YES | | NULL
| |
| showtype | varchar(30) | NO | |
| |
| colorcode | varchar(20) | NO | |
| |
| syndicatedepisodenumber | varchar(20) | NO | |
| |
| programid | varchar(20) | NO | MUL |
| |
| manualid | int(10) unsigned | NO | PRI | 0
| |
| generic | tinyint(1) | YES | | 0
| |
+-------------------------+------------------+------+-----
+---------------------+-------+
dell john 17:24 mythtv $ mysql -e "show columns from record"
+---------------+------------------+------+-----+------------
+----------------+
| Field | Type | Null | Key | Default | Extra
|
+---------------+------------------+------+-----+------------
+----------------+
| recordid | int(10) unsigned | NO | PRI | NULL |
auto_increment |
| type | int(10) unsigned | NO | | 0 |
|
| chanid | int(10) unsigned | YES | MUL | NULL |
|
| starttime | time | NO | | 00:00:00 |
|
| startdate | date | NO | | 0000-00-00 |
|
| endtime | time | NO | | 00:00:00 |
|
| enddate | date | NO | | 0000-00-00 |
|
| title | varchar(128) | NO | MUL | |
|
| subtitle | varchar(128) | NO | | |
|
| description | text | NO | | |
|
| category | varchar(64) | NO | | |
|
| profile | varchar(128) | NO | | Default |
|
| recpriority | int(10) | NO | | 0 |
|
| autoexpire | int(11) | NO | | 0 |
|
| maxepisodes | int(11) | NO | | 0 |
|
| maxnewest | int(11) | NO | | 0 |
|
| startoffset | int(11) | NO | | 0 |
|
| endoffset | int(11) | NO | | 0 |
|
| recgroup | varchar(32) | NO | | Default |
|
| dupmethod | int(11) | NO | | 6 |
|
| dupin | int(11) | NO | | 15 |
|
| station | varchar(20) | NO | | |
|
| seriesid | varchar(12) | NO | MUL | |
|
| programid | varchar(20) | NO | MUL | |
|
| search | int(10) unsigned | NO | | 0 |
|
| autotranscode | tinyint(1) | NO | | 0 |
|
| autocommflag | tinyint(1) | NO | | 0 |
|
| autouserjob1 | tinyint(1) | NO | | 0 |
|
| autouserjob2 | tinyint(1) | NO | | 0 |
|
| autouserjob3 | tinyint(1) | NO | | 0 |
|
| autouserjob4 | tinyint(1) | NO | | 0 |
|
| findday | tinyint(4) | NO | | 0 |
|
| findtime | time | NO | | 00:00:00 |
|
| findid | int(11) | NO | | 0 |
|
| inactive | tinyint(1) | NO | | 0 |
|
| parentid | int(11) | NO | | 0 |
|
| transcoder | int(11) | NO | | 0 |
|
| tsdefault | float | NO | | 1 |
|
| playgroup | varchar(32) | NO | | Default |
|
+---------------+------------------+------+-----+------------
+----------------+
dell john 17:25 mythtv $ mysql -e "show columns from people"
+--------+-----------------------+------+-----+---------
+----------------+
| Field | Type | Null | Key | Default | Extra
|
+--------+-----------------------+------+-----+---------
+----------------+
| person | mediumint(8) unsigned | NO | PRI | NULL |
auto_increment |
| name | char(128) | NO | UNI | |
|
+--------+-----------------------+------+-----+---------
+----------------+
dell john 17:25 mythtv $ mysql -e "show columns from credits"
+-----------
+-----------------------------------------------------------------------
-----------------------------------------------------------+------
+-----+---------------------+-------+
| Field | Type
| Null | Key | Default | Extra |
+-----------
+-----------------------------------------------------------------------
-----------------------------------------------------------+------
+-----+---------------------+-------+
| person | mediumint(8) unsigned
| NO | PRI | 0 | |
| chanid | int(10) unsigned
| NO | PRI | 0 | |
| starttime | datetime
| NO | PRI | 0000-00-00 00:00:00 | |
| role |
set('actor','director','producer','executive_producer','writer','guest_s
tar','host','adapter','presenter','commentator','guest') | NO | PRI |
| |
+-----------
+-----------------------------------------------------------------------
-----------------------------------------------------------+------
+-----+---------------------+-------+
dell john 17:26 mythtv $ mysql -e "show columns from recordmatch"
+-----------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+-------+
| recordid | int(10) unsigned | YES | MUL | NULL | |
| chanid | int(10) unsigned | YES | | NULL | |
| starttime | datetime | YES | | NULL | |
| manualid | int(10) unsigned | YES | | NULL | |
+-----------+------------------+------+-----+---------+-------+
On 25-Feb-2006, at 16:39, Kevin Kuphal wrote:
> John Johnson wrote:
>> 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'
>>
>>
> What does your program table look like? It should have a chanid column
> in it and it appears it might be missing
>
> Kevin
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
---
Help everyone. If you can't do that, then at least be nice.
More information about the mythtv-users
mailing list