[mythtv] db wierdness in recordedprogram.category_type and airdate

Torbjörn Jansson torbjorn.jansson at mbox200.swipnet.se
Sun Jul 8 19:18:35 UTC 2007


I've noticed something strange in the database and i'm not sure if this is
how it's supposed to be or not.

As i understand it recordedprogram should be a copy of the relevant row from
program table.
In my recordedprogram the category_type filed contains years, looks like the
data that should have been in airdate column

Here is an example:
mysql> select category_type, airdate from recordedprogram limit 5;
+---------------+---------+
| category_type | airdate |
+---------------+---------+
| 2005          |    0000 |
| 2005          |    0000 |
| 2005          |    0000 |
| 2005          |    0000 |
| 2005          |    0000 |
+---------------+---------+

Shoudnt category_type be something like movie, series, sports or tvshow ?
Any ideas?

I'm using:
Library API version: 0.20.20060828-3
Source code version: 13205M
Options compiled in:
 linux debug using_lmsensors using_v4l using_oss using_alsa using_arts
using_ivtv using_dbox2 using_hdhr using_ip_rec using_freebox using_live
using_joystick_menu using_dvb using_x11 using_xv using_xrandr using_frontend
using_backend



More information about the mythtv-dev mailing list