[mythtv] Duplicate check error, not yet broadcasted shows marked as already recorded
Oscar Carlsson
webmaster at trekotor.se
Wed Feb 8 13:42:26 UTC 2006
ons 2006-02-08 klockan 13:41 +0100 skrev Rickard Borgmäster:
>
> And if we narrow it down further for readability:
>
> mysql> select subtitle, seriesid, syndicatedepisodenumber, programid
> from program where title="Floor Filler";
> +------------------+----------+-------------------------+-----------+
> | subtitle | seriesid | syndicatedepisodenumber | programid |
> +------------------+----------+-------------------------+-----------+
> | Del 4 säsong 2 | 1922 | E4S2 | EP1922 |
> | Del 5 säsong 2 | 1922 | E5S2 | EP1922 |
> | Del 6 säsong 2 | 1922 | E6S2 | EP1922 |
> | Del 7 säsong 2 | 1922 | E7S2 | EP1922 |
> | Del 9 säsong 2 | 1922 | E9S2 | EP1922 |
Please have a look at the length and type of seriesid,
syndicatedepisodenumber and programid in your database. They should be
varchar(12), varchar(20) and varchar(20). I doubt yours are.
/O
More information about the mythtv-dev
mailing list