[mythtv] [mythtv-users] Important Stuff
Al McIntosh
junkmail at allanmcintosh.com
Thu Mar 9 17:30:35 UTC 2006
Al McIntosh wrote:
>Brian Wood wrote:
>
>
>
>>Ok, enough of this foolishness about disk space, satellite receivers,
>>and system operation, let's get down to the really important things:
>>
>>How com "Dilbert" never seems to work with MythNews ???
>>
>>
>>
>>
>>
>>
>
>
>
>
>I have the same problem, Dilbert and Fark no longer work. At a quick
>glance, I see neither has been downloaded:
>
>
>mysql> SELECT name, url, updated FROM newssites where name = 'Dilbert'
>or name = 'Fark';
>+---------+---------------------------------------------------+---------+
>| name |
>url | updated |
>+---------+---------------------------------------------------+---------+
>| Dilbert | http://dwlt.net/tapestry/dilbert.rdf | NULL |
>| Fark | http://www.pluck.com/rss/fark.rss | NULL |
>+---------+---------------------------------------------------+---------+
>2 rows in set (0.00 sec)
>
>
>Lets investigate:
>
>
>------------------------------ Dilbert
>--------------------------------------------------------
>$ wget http://dwlt.net/tapestry/dilbert.rdf
>--09:08:15-- http://dwlt.net/tapestry/dilbert.rdf
> => `dilbert.rdf'
>Resolving dwlt.net... 217.163.9.108
>Connecting to dwlt.net|217.163.9.108|:80... connected.
>HTTP request sent, awaiting response... 301 Moved Permanently
>Location: http://www.tapestrycomics.com/dilbert.xml [following]
>--09:08:19-- http://www.tapestrycomics.com/dilbert.xml
> => `dilbert.xml'
>Resolving www.tapestrycomics.com... 66.29.14.120
>Connecting to www.tapestrycomics.com|66.29.14.120|:80... connected.
>HTTP request sent, awaiting response... 302 Found
>Location: http://feeds.feedburner.com/tapestrydilbert [following]
>--09:08:23-- http://feeds.feedburner.com/tapestrydilbert
> => `tapestrydilbert'
>Resolving feeds.feedburner.com... 66.150.96.111
>Connecting to feeds.feedburner.com|66.150.96.111|:80... connected.
>HTTP request sent, awaiting response... 200 OK
>Length: 2,838 (2.8K) [application/xml]
>
>100%[====================================================================================>]
>2,838 --.--K/s
>
>09:08:24 (723.63 KB/s) - `tapestrydilbert' saved [2838/2838]
>
>
>------------------------------ Fark
>--------------------------------------------------------
>
>]$ wget http://www.pluck.com/rss/fark.rss
>--09:08:36-- http://www.pluck.com/rss/fark.rss
> => `fark.rss'
>Resolving www.pluck.com... 66.179.81.250
>Connecting to www.pluck.com|66.179.81.250|:80... connected.
>HTTP request sent, awaiting response... 301 Moved Permanently
>Location: http://feeds.feedburner.com/fark/HifS [following]
>--09:08:38-- http://feeds.feedburner.com/fark/HifS
> => `HifS'
>Resolving feeds.feedburner.com... 66.150.96.111
>Connecting to feeds.feedburner.com|66.150.96.111|:80... connected.
>HTTP request sent, awaiting response... 200 OK
>Length: unspecified [text/xml]
>
> [
><=>
>] 22,342 40.26K/s
>
>09:08:39 (40.21 KB/s) - `HifS' saved [22342]
>
>
>
>The links work but the initial http response does not equal '200' which
>makes me *suspect* the download mechanism does not handle redirects.
>Looks like they both require an update.
>
>Lets update the urls using the redirect target:
>
>mysql> UPDATE newssites SET url =
>'http://feeds.feedburner.com/tapestrydilbert' where name = 'Dilbert';
>Query OK, 1 row affected (0.03 sec)
>Rows matched: 1 Changed: 1 Warnings: 0
>
>
>
>mysql> UPDATE newssites SET url =
>'http://feeds.feedburner.com/fark/HifS' where name = 'Fark';
>Query OK, 1 row affected (0.00 sec)
>Rows matched: 1 Changed: 1 Warnings: 0
>
>
>Go to mythfrontend and check it out, hey it worked.
>
>mysql> SELECT name, url, updated FROM newssites where name = 'Dilbert'
>or name = 'Fark';
>+---------+---------------------------------------------------------+------------+
>| name | url
> |updated |
>+---------+---------------------------------------------------------+------------+
>| Dilbert | http://feeds.feedburner.com/tapestrydilbert | 1141918951 |
>| Fark | http://feeds.feedburner.com/fark/HifS | 1141918952 |
>+---------+---------------------------------------------------------+------------+
>2 rows in set (0.00 sec)
>
>
>
>In the case of Dilbert under Settings->Information->News when you select
>Humor -> Dilbert the following sql needs to be updated:
>
>INSERT INTO newssites (name,category,url,ico) VALUES( 'Dilbert',
>'Humor', 'http://dwlt.net/tapestry/dilbert.rdf', '' );
>
>
>
I attached a more permanent solution.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: news-sites.xml.patch
Type: text/x-patch
Size: 806 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-dev/attachments/20060309/d449b4cd/attachment.bin
More information about the mythtv-dev
mailing list