Changes between Initial Version and Version 1 of Ticket #6976


Ignore:
Timestamp:
Sep 4, 2009, 5:25:16 AM (15 years ago)
Author:
sphery
Comment:

The episode was identified as a duplicate due to invalid programid's, likely caused by database schema corruption, as shown at ​http://mythtv.org/pipermail/mythtv-users/2009-September/263475.html

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #6976

    • Property Status changed from new to closed
    • Property Resolution changed from to invalid

  • Ticket #6976 – Description

    initial v1  
    22
    33mythbackend print
    4 
     4{{{
    55--- print list start ---
    66Title - Subtitle                Ch Station Day Start  End   S C I  T N   Pri
    77City Homicide - "The Confessio    6 PRIME C 07 20:30-21:35  1 0 0  d P   0/0
    8 
     8}}}
    99Found this entry in the "program" table:
     10{{{
    1011mysql> SELECT starttime,title, subtitle, programid,syndicatedepisodenumber,programid  FROM program WHERE title LIKE "City Homicide%" and subtitle = "The Confession";
    1112+---------------------+---------------+----------------+-------------+-------------------------+-------------+
    … …  
    1415| 2009-09-07 20:30:00 | City Homicide | The Confession | EP341898163 | E6S3                    | EP341898163 |
    1516+---------------------+---------------+----------------+-------------+-------------------------+-------------+
     17}}}