[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