<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
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 <br>
<br>
<program id='EP000027100247'><br>
<series>EP00002710</series><br>
<title>M*A*S*H</title><br>
<subtitle>Bottoms Up</subtitle><br>
<showType>Series</showType><br>
<originalAirDate>1981-03-02</originalAirDate><br>
<syndicatedEpisodeNumber>Z415</syndicatedEpisodeNumber><br>
<b><description>Hawkeye becomes a villain after his practical
joke on Charles goes awry.</description></b><br>
</program><br>
<br>
Yet when I query the DB the description is completely different<br>
<br>
> SELECT `title`, `subtitle`, `description`, `starttime`,
`endtime`, `category` FROM `mythconverg`.`program` AS `program`
WHERE `subtitle` = 'Bottoms Up';<br>
+---------+------------+------------------------------------------------------------------------------------------------------------------------------------------+---------------------+---------------------+----------+<br>
| title | subtitle |
description
| starttime | endtime | category |<br>
+---------+------------+------------------------------------------------------------------------------------------------------------------------------------------+---------------------+---------------------+----------+<br>
| M*A*S*H | Bottoms Up | <b>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. </b>| 2015-08-27 23:00:00 |
2015-08-27 23:30:00 | Sitcom |<br>
<br>
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.<br>
<br>
Any suggestions? <br>
<br>
Thanks<br>
Bret<br>
<br>
<br>
</body>
</html>