torbjorn.jansson at mbox200
Jul 10, 2007, 7:08 AM
Post #2 of 2
(301 views)
Permalink
|
|
Re: db wierdness in recordedprogram.category_type and airdate
[In reply to]
|
|
I suspect there is a probelm in ProgramInfo::StartedRecording or how mysql
runs the REPLACE INTO recordedprogram query in that function.
If i run the query manualy and turn on the mysql warnings this is what i
get:
------
Show warnings enabled.
-> SELECT *
-> FROM program
-> where chanid=3130 and starttime = '2007-07-10 15:30:00';
Query OK, 2 rows affected, 1 warning (0.00 sec)
Records: 1 Duplicates: 1 Warnings: 0
Warning (Code 1366): Incorrect integer value: 'series' for column
'previouslyshown' at row 1
------
So thats where the category_type field is.
This is with mysql 5.0.22
I'm going to do some more testing on this later today and possibly make a
patch for it.
Maybe someone else chan check their recordedprogram table and see if they
have the same problem as i do.
mythtv-dev-bounces [at] mythtv <> wrote:
> 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
>
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev [at] mythtv
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
>
>
> !DSPAM:469138dd65231222944467!
_______________________________________________
mythtv-dev mailing list
mythtv-dev [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
|
