[mythtv-users] Problems with Listing Descriptions

Bret Clark bac52266 at gmail.com
Sat Aug 22 16:54:42 UTC 2015


I'm having a strange problem where Schedules Direct is sending the right 
information, but my database is not populating correctly. For example 
when I check raw data at Schedules Direct, I see the right information

<program id='EP000027100247'>
<series>EP00002710</series>
<title>M*A*S*H</title>
<subtitle>Bottoms Up</subtitle>
<showType>Series</showType>
<originalAirDate>1981-03-02</originalAirDate>
<syndicatedEpisodeNumber>Z415</syndicatedEpisodeNumber>
*<description>Hawkeye becomes a villain after his practical joke on 
Charles goes awry.</description>*
</program>

Yet when I query the DB the description is completely different

 > SELECT `title`, `subtitle`, `description`, `starttime`, `endtime`, 
`category` FROM `mythconverg`.`program` AS `program` WHERE `subtitle` = 
'Bottoms Up';
+---------+------------+------------------------------------------------------------------------------------------------------------------------------------------+---------------------+---------------------+----------+
| title   | subtitle   | description | starttime           | 
endtime             | category |
+---------+------------+------------------------------------------------------------------------------------------------------------------------------------------+---------------------+---------------------+----------+
| M*A*S*H | Bottoms Up | *Sound of Drums: When Indian poachers move onto 
his land, a man refuses to move them off and stands alone in the fight 
for their freedom. *| 2015-08-27 23:00:00 | 2015-08-27 23:30:00 | Sitcom   |

It doesn't happen with every listing, but a good number of them. I tried 
truncating the program table to clear it, but same problem still 
happens.  The Title & Subtitle seem to be okay, just the description is 
foo on a number of listings.

Any suggestions?

Thanks
Bret


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20150822/3569fb11/attachment.html>


More information about the mythtv-users mailing list