I discovered another differen GoComics RSS feed URL: http://www.gocomics.com/foxtrotclassics/rss.pxml
Converting it to feedburner worked.
Search found 37 matches
- 24 Jan 2017, 21:57
- Forum: Themes and plugins
- Topic: Make GoComics work again plugin
- Replies: 33
- Views: 10385
- 28 Dec 2016, 13:09
- Forum: Development
- Topic: PHPMailer Vulnerability CVE-2016-10033
- Replies: 13
- Views: 3747
Re: PHPMailer Vulnerability CVE-2016-10033
I guess the problem only exists, if SMTP_SERVER is empty (so that mail is sent via system MTA).
- 03 Aug 2016, 07:50
- Forum: Support
- Topic: SSL Issue: 60 SSL certificate problem: unable to get local issuer certificate
- Replies: 3
- Views: 3023
Re: SSL Issue: 60 SSL certificate problem: unable to get local issuer certificate
Update the ssl library. I had same problem in Debian. It was caused by site having multiple certificates and SHA1 signed one not being trusted anymore. Las ssl update fixed the issue (Debian 8.5 stable upgrade) - "use alternate trust chains" fix.
- 05 Jul 2016, 11:01
- Forum: Unsupported platforms
- Topic: btrfs raid56 hard disk broken
- Replies: 11
- Views: 6037
Re: btrfs raid56 hard disk broken
etu wrote:Dude, you... really used btrfs raid5/6 and not like mdadm-raid or LVM or something in the bottom? I wouldn't do that... just yet... if ever...
Just in case original poster is confused - even then btrfs would not kill actual hard drive. It was going to fail anyway.
- 10 Nov 2015, 11:01
- Forum: Support
- Topic: feedtree: don't hide feeds with errors
- Replies: 3
- Views: 6023
Re: feedtree: don't hide feeds with errors
Well, good thing about using git is, that you can have your installed version in separate branch, where that commit is reverted. That's what I did. Although there is a danger of merge conflict in future.
- 23 Sep 2015, 12:25
- Forum: Unsupported platforms
- Topic: Unsupported Platforms: what are the disadvantages?
- Replies: 7
- Views: 7417
Re: Unsupported Platforms: what are the disadvantages?
It depends of type of unsupported system. In many cases it is much harder to get diagnostics information, because you have much less control over the system. And that's the reason they are unsupported.
- 15 Jul 2015, 13:09
- Forum: Support
- Topic: Performance Regression (article purge)
- Replies: 8
- Views: 3950
Re: Performance Regression (article purge)
It seems, that mysql does not support table aliases in DELETE. DELETE FROM ttrss_entries WHERE NOT EXISTS (SELECT ref_id FROM ttrss_user_entries WHERE ref_id = id) seems to work. But I have no idea, why rows would be different. Because COUNT() = 0 should be when there is no record. I'm probably miss...
- 15 Jul 2015, 12:33
- Forum: Support
- Topic: Performance Regression (article purge)
- Replies: 8
- Views: 3950
Re: Performance Regression (article purge)
I don't know much of PostgreSQL, but in Firebird NOT IN query is one of the worst things to do (because IN is run for every record in main table). But looking at the original query, you probably could get rid of COUNT by making it NOT EXISTS query instead of NOT IN. So original: DELETE FROM ttrss_en...
- 18 May 2015, 21:57
- Forum: Support
- Topic: feedbrowser (popularfeeds etc..) issue - resolved
- Replies: 32
- Views: 15808
Re: feedbrowser (popularfeeds etc..) issue
I suggest this rewrite, but only for performance and clarity. The original query is already giving correct results here, I don't know why the OP is not getting the list of more feeds. SELECT feed_url, site_url, title, COUNT(id) AS subscribers FROM ttrss_feeds WHERE feed_url NOT IN ( SELECT distinct...
- 18 May 2015, 21:50
- Forum: Support
- Topic: feedbrowser (popularfeeds etc..) issue - resolved
- Replies: 32
- Views: 15808
Re: feedbrowser (popularfeeds etc..) issue
I tried that query just right now and causes 2 issues one it returns nothing however if you replace the '' with NULL the query works. This is apparently due to a difference between postgress, oracle and mysql. No, it is not. Those fields are auth_login and auth_pass are varchar fields with NOT NULL...
- 18 May 2015, 20:18
- Forum: Support
- Topic: feedbrowser (popularfeeds etc..) issue - resolved
- Replies: 32
- Views: 15808
Re: feedbrowser (popularfeeds etc..) issue
Is either auth_login or auth_pass NULL? Because that would expain the problem (field being empty, not having value of empty string). But that cannot be true, because those fields are NOT NULL. So only way that query can give any results is, if you are not telling truth about values of those 4 field...
- 18 May 2015, 20:04
- Forum: Support
- Topic: feedbrowser (popularfeeds etc..) issue - resolved
- Replies: 32
- Views: 15808
Re: feedbrowser (popularfeeds etc..) issue
hi, I just ran SELECT * FROM ttrss_feeds WHERE (private IS TRUE OR auth_login != '' OR auth_pass != '' OR feed_url LIKE '%:%@%/%') the result is 28 feeds (non unique). (i know because i crefully entered all feeds and carefgully verified that none are private, auith or pwd (also dumped the database)...
- 18 May 2015, 18:28
- Forum: Support
- Topic: feedbrowser (popularfeeds etc..) issue - resolved
- Replies: 32
- Views: 15808
Re: feedbrowser (popularfeeds etc..) issue
And that "private" is "Hide from popular feeds" checkbox.
- 18 May 2015, 18:18
- Forum: Support
- Topic: feedbrowser (popularfeeds etc..) issue - resolved
- Replies: 32
- Views: 15808
Re: feedbrowser (popularfeeds etc..) issue
Just run following query on yout database and check the values of private, auth_login, auth_pass and feed_url fields in result. SELECT * FROM ttrss_feeds WHERE (private IS TRUE OR auth_login != '' OR auth_pass != '' OR feed_url LIKE '%:%@%/%') Second question why do you want to list 2 the same feeds...
- 18 May 2015, 16:54
- Forum: Support
- Topic: feedbrowser (popularfeeds etc..) issue - resolved
- Replies: 32
- Views: 15808
Re: feedbrowser (popularfeeds etc..) issue
#SELECT DISTINCT title, feed_url, site_url, COUNT(id) AS subscribers FROM ttrss_feeds #WHERE (private IS TRUE OR auth_login != '' OR auth_pass != '' OR feed_url LIKE '%:%@%/%') #GROUP BY title, feed_url, site_url #ORDER BY subscribers DESC LIMIT 1000; It is opposite of original. Even my version wou...